 |
Java开发网 |
|
注册 |
登录 |
帮助 |
搜索 |
排行榜 |
发帖统计
|
| 您没有登录 |
» Java开发网 » Database/JDBC/SQL/JDO/Hibernate
» MS SQL
 打印话题
寄给朋友
订阅主题
|
    
|
| 作者 | 跪求高手指点MS SQL的连接问题 |
comma
 
发贴: 9 积分: 0 
|
 于 2005-09-17 12:39
    
我在启动weblogic的时候当weblogic启动时读到config.xml的连接池测试时提示: <2005-9-17 上午11时05分58秒 CST> <Error> <JDBC> <BEA-001112> <Test "SELECT COUNT(*) FROM sysobjects" set up for pool "DS_Pools" failed with exception: "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]拒绝了对对象 'sysobjects'（数据库 'commachen'，所有者 'dbo'）的 SELECT 权限。".> <2005-9-17 上午11时05分58秒 CST> <Error> <JDBC> <BEA-001112> <Test "SELECT COUNT(*) FROM sysobjects" set up for pool "DS_Pools" failed with exception: "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]拒绝了对对象 'sysobjects'（数据库 'commachen'，所有者 'dbo'）的 SELECT 权限。".> <2005-9-17 上午11时05分58秒 CST> <Error> <JDBC> <BEA-001111> <Unable to verify the test "SELECT COUNT(*) FROM sysobjects" set up for pool "DS_Pools". Connections will not be tested.> <2005-9-17 上午11时06分06秒 CST> <Notice> <WebLogicServer> <BEA-000331> <Started WebLogic Admin Server "myserver" for domain "mydomain" running in Development Mode> 其中:数据库连接池和数据源配置都测试成功,数据库 'commachen'为我自建数据库.我也为这个数据库新建了用户,并为这个用户分配了权限. 启动完后,系统运行到查询数据库的时候又提示: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'GG_CZYB' 无效。 at com.microsoft.jdbc.base.BaseExceptions.createException(Ljava.lang.String;Ljava.lang.String;I)Ljava.sql.SQLException;(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Ljava.sql.SQLException;II[Ljava.lang.String;Ljava.lang.String;I)Ljava.sql.SQLException;(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken()V(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(BLcom.microsoft.jdbc.base.BaseWarnings;)Z(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(BLcom.microsoft.jdbc.base.BaseWarnings;)Z(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Lcom.microsoft.jdbc.base.BaseWarnings;)V(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Lcom.microsoft.jdbc.base.BaseWarnings;)V(Unknown Source) at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute()V(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.commonExecute()V(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal()Ljava.sql.ResultSet;(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.executeQuery(Ljava.lang.String;)Ljava.sql.ResultSet;(Unknown Source) at weblogic.jdbc.wrapper.Statement.executeQuery(Ljava.lang.String;)Ljava.sql.ResultSet;(Statement.java:345) at com.zzxy.model.dao.SingleTableDAO.exeSelectExact(Ljava.lang.StringBuffer;)Ljava.util.List;(SingleTableDAO.java:529) at com.zzxy.model.dao.SingleTableDAO.selectExact(Ljava.lang.StringBuffer;)Ljava.util.List;(SingleTableDAO.java:469) at com.zzxy.model.entity.Public_EntityBean.queryExact(Ljava.lang.Object;Ljava.lang.StringBuffer;)Ljava.util.List;(Public_EntityBean.java:134) at com.zzxy.model.Public_FacadeBean.queryExact(Ljava.lang.Object;Ljava.lang.StringBuffer;)Ljava.util.List;(Public_FacadeBean.java:260) at com.zzxy.model.Public_Facade_ur04kw_EOImpl.queryExact(Ljava.lang.Object;Ljava.lang.StringBuffer;)Ljava.util.List;(Public_Facade_ur04kw_EOImpl.java:929) at com.zzxy.model.Public_Facade_ur04kw_EOImpl_WLSkel.invoke(I[Ljava.lang.Object;Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source) at weblogic.rmi.internal.ServerRequest.sendReceive()Lweblogic.rmi.spi.InboundResponse;(ServerRequest.java:166) at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(Lweblogic.rmi.extensions.server.RemoteReference;Lweblogic.rmi.extensions.server.RuntimeMethodDescriptor;[Ljava.lang.Object;Ljava.lang.reflect.Method;)Ljava.lang.Object;(ReplicaAwareRemoteRef.java:284) at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(Ljava.rmi.Remote;Lweblogic.rmi.extensions.server.RuntimeMethodDescriptor;[Ljava.lang.Object;Ljava.lang.reflect.Method;)Ljava.lang.Object;(ReplicaAwareRemoteRef.java:244) at com.zzxy.model.Public_Facade_ur04kw_EOImpl_813_WLStub.queryExact(Ljava.lang.Object;Ljava.lang.StringBuffer;)Ljava.util.List;(Unknown Source) at com.zzxy.model.Public_Helper.queryExact(Ljava.lang.Object;Ljava.lang.StringBuffer;)Ljava.util.List;(Public_Helper.java:171) at com.zzxy.model.wh.czqx.WH_CZQX_LOGIN_Agent.getLoginInfor(Ljavax.servlet.http.HttpServletRequest;)V(WH_CZQX_LOGIN_Agent.java:365) at com.zzxy.model.wh.czqx.WH_CZQX_LOGIN_Agent.execute(Ljava.lang.String;Ljava.lang.String;Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(WH_CZQX_LOGIN_Agent.java:56) at com.zzxy.model.BusinessAgent.service(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(BusinessAgent.java:89) at javax.servlet.http.HttpServlet.service(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run()Ljava.lang.Object;(ServletStubImpl.java:996) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Lweblogic.servlet.internal.FilterChainImpl;)V(ServletStubImpl.java:419) at weblogic.servlet.internal.TailFilter.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.FilterChain;)V(TailFilter.java:28) at weblogic.servlet.internal.FilterChainImpl.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(FilterChainImpl.java:27) at com.zzxy.control.SetCharacterEncodingFilter.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.FilterChain;)V(SetCharacterEncodingFilter.java:53) ; nested exception is: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'GG_CZYB' 无效。
why edited on 2005-09-17 19:34
|
| 话题树型展开 |
| 人气 | 标题 | 作者 | 字数 | 发贴时间 |
| 16915 |
跪求高手指点MS SQL的连接问题
| comma | 5974 | 2005-09-17 12:39 |
| 13876 |
Re:跪求高手指点MS SQL的连接问题
| comma | 166 | 2005-09-18 20:27 |
| 13714 |
Re:跪求高手指点MS SQL的连接问题
| why | 566 | 2005-09-18 21:08 |
| 13616 |
Re:跪求高手指点MS SQL的连接问题
| why | 576 | 2005-09-22 23:30 |
| 14253 |
JAVA与mssql的数据转换问题
| cxy123884 | 47 | 2005-09-23 15:32 |
| 13774 |
Re:跪求高手指点MS SQL的连接问题
| why | 337 | 2005-09-17 19:43 |
| 13900 |
Re:跪求高手指点MS SQL的连接问题
| comma | 299 | 2005-09-17 20:04 |
| 13782 |
Re:跪求高手指点MS SQL的连接问题
| comma | 187 | 2005-09-17 23:54 |
| 13734 |
Re:跪求高手指点MS SQL的连接问题
| why | 308 | 2005-09-18 01:56 |
| 13721 |
Re:跪求高手指点MS SQL的连接问题
| comma | 60 | 2005-09-18 10:30 |
| 13662 |
Re:跪求高手指点MS SQL的连接问题
| why | 395 | 2005-09-18 10:38 |
| 13764 |
Re:跪求高手指点MS SQL的连接问题
| comma | 297 | 2005-09-18 12:04 |
| 14143 |
Re:跪求高手指点MS SQL的连接问题
| comma | 8580 | 2005-09-18 12:08 |
| 13672 |
Re:跪求高手指点MS SQL的连接问题
| why | 165 | 2005-09-18 12:38 |
| 13731 |
Re:跪求高手指点MS SQL的连接问题
| comma | 26 | 2005-09-18 12:51 |
| 13788 |
Re:跪求高手指点MS SQL的连接问题
| comma | 542 | 2005-09-19 20:08 |
| 13851 |
MS SQL的连接问题
| cxy123884 | 2407 | 2005-09-22 15:00 |
|
|
已读帖子 新的帖子 被删除的帖子 |
|
 |
Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1 客服电话 18559299278 客服信箱 714923@qq.com 客服QQ 714923 |