Java开发网 - Re:跪求高手指点MS SQL的连接问题

Java开发网

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate » MS SQL

打印话题 寄给朋友 订阅主题

作者

Re:跪求高手指点MS SQL的连接问题 [Re:comma]

comma

发贴: 9
积分: 0

于 2005-09-18 12:08

問題兒童老师!!!最新的后台信息是:
***************************************************
<2005-9-18 上午10时58分38秒 CST> <Info> <WebLogicServer> <BEA-000377> <Starting WebLogic Server with BEA WebLogic JRockit(TM) 1.4.2_04 JVM Version ari-31788-20040616-1132-win-ia32 from BEA Systems, Inc.>
<2005-9-18 上午10时58分39秒 CST> <Info> <Configuration Management> <BEA-150016> <This server is being started as the administration server.>
<2005-9-18 上午10时58分39秒 CST> <Info> <Management> <BEA-141107> <Version: WebLogic Server 8.1 SP3 Tue Jun 29 23:11:19 PDT 2004 404973
WebLogic XMLX Module 8.1 SP3 Tue Jun 29 23:11:19 PDT 2004 404973 >
<2005-9-18 上午10时58分39秒 CST> <Notice> <Management> <BEA-140005> <Loading domain configuration from configuration repository at e:\bea\user_projects\domains\mydomain\.\config.xml.>
<2005-9-18 上午10时58分44秒 CST> <Notice> <Log Management> <BEA-170019> <The server log file E:\bea\user_projects\domains\mydomain\myserver\myserver.log is opened. All server side log events will be written to this file.>
<2005-9-18 上午10时58分48秒 CST> <Notice> <Security> <BEA-090082> <Security initializing using security realm myrealm.>
<2005-9-18 上午10时58分49秒 CST> <Notice> <WebLogicServer> <BEA-000327> <Starting WebLogic Admin Server "myserver" for domain "mydomain">
<2005-9-18 上午10时59分12秒 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'（数据库 '
<2005-9-18 上午10时59分13秒 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'（数据库 '
<2005-9-18 上午10时59分13秒 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-18 上午10时59分27秒 CST> <Notice> <WebLogicServer> <BEA-000331> <Started WebLogic Admin Server "myserver" for domain "mydomain" running in Development Mode>
<2005-9-18 上午10时59分27秒 CST> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>
<2005-9-18 上午10时59分27秒 CST> <Notice> <WebLogicServer> <BEA-000355> <Thread "ListenThread.Default" listening on port 7001, ip address *.*>
-----------------[#document: null]
WebRoot:
Config.xml: CTIAPP_dbdriver: null
Config.xml: CTIAPP_url: jdbc:microsoft:sqlserver://localhost:1433
Config.xml: CTIAPP_User: zzxy
Config.xml: CTIAPP_Password: 99999999
Config.xml: CTIAPP_Maxlimit: 20
Config.xml: CTIAPP_Minlimit: 15
DBconnecter初始化1!jdbc:microsoft:sqlserver://localhost:1433
DBconnecter初始化2!==={CTIAPP_url=jdbc:microsoft:sqlserver://localhost:1433, CTIAPP_dbdriver=null, CTIAPP_Minlimit=15, CTIAPP_Maxlimit=20, CTIAPP_User=zzxy, CTIAPP_Password=99999999}
Config.xml: CTIAPP_IP: http://localhost:7001/docroot/misdoc/report/rls
Config.xml: CTIAPP_Port: 21
Config.xml: CTIAPP_User: 1,2,8,0
Config.xml: CTIAPP_Password: report
Config.xml: 4
获得了strRequestID：V0hfQ1pRWF9MT0dJTl9nZXRMb2dpbkluZm9y
获得了DispatchTarget：/WH/WH_CZQX_LOGIN_Agent
获得了strResponseURI：/default.jsp
!!!!!!!!!!= where hostname= 'localhost' order by jdr DESC
selectExact: SELECT GG_CZYB.BMBH,GG_CZYB.ID,GG_CZYB.MC,GG_CZYB.MM,GG_CZYB.DH,GG_CZYB.FJ,GG_CZYB.SJ,GG_CZYB.JTDH,GG_CZYB.XX,GG_CZYB.SR,GG_CZYB.JDR,GG_CZYB.ZXR,GG_CZYB.CZLB,GG_CZYB.DLFS,GG_CZYB.ZXBZ,GG_CZYB.ZTBZ,GG_CZYB.XB,GG_CZYB.ZP,GG_CZYB.GW,GG_CZYB.BZ,GG_CZYB.CS
erroinfo=Unexpected exception in com.zzxy.model.Public_FacadeBean.queryExact():
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]拒绝了对对象 'GG_CZYB'（数据库 'commachen'，所有者 'dbo'）的 SELECT 权限。
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'（数据库 'commachen'，所有者 'dbo'）的 SELECT 权限。

why edited on 2005-09-18 12:27

话题树型展开

人气	标题	作者	字数	发贴时间
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
14144	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
13789	Re:跪求高手指点MS SQL的连接问题	comma	542	2005-09-19 20:08
13851	MS SQL的连接问题	cxy123884	2407	2005-09-22 15:00

已读帖子

新的帖子

被删除的帖子