在jsp里报的一个关于oracle的异常

Janot 2005-06-20 09:23:38

Error 500--Internal Server Error
com.cnoocrc.sharing.SharingException: java.sql.SQLException: Cannot obtain connection: driverURL = jdbc:weblogic:pool:MyJDBC Connection Pool, props = {enableTwoPhaseCommit=false, jdbcTxDataSource=true, connectionPoolID=MyJDBC Connection Pool, dataSourceName=MyJDBC Data Source}.
Nested Exception: java.lang.RuntimeException: Failed to setAutoCommit to true for pool connection.
at weblogic.jdbc.wrapper.PoolConnection.init(PoolConnection.java:47)
at weblogic.jdbc.pool.Driver.allocateConnection(Driver.java:254)
at weblogic.jdbc.pool.Driver.connect(Driver.java:164)
at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:507)
at weblogic.jdbc.jts.Driver.connect(Driver.java:139)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:305)
at com.cnoocrc.sharing.Database.connectJNDIImpl(Database.java:169)
at com.cnoocrc.sharing.Database.getSharingConn(Database.java:129)
at com.cnoocrc.pm.ResearchDesign.wf.queryList.ListQuery(queryList.java:25)
at jsp_servlet._basecomponent._buildpage.__report_list._jspService(report_list.jsp:73)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:996)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at com.epc.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:105)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6458)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3661)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2630)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)

at com.cnoocrc.sharing.Database.getSharingConn(Database.java:143)
at com.cnoocrc.pm.ResearchDesign.wf.queryList.ListQuery(queryList.java:25)
at jsp_servlet._basecomponent._buildpage.__report_list._jspService(report_list.jsp:73)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:996)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at com.epc.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:105)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6458)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3661)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2630)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
Caused by: java.sql.SQLException: Cannot obtain connection: driverURL = jdbc:weblogic:pool:MyJDBC Connection Pool, props = {enableTwoPhaseCommit=false, jdbcTxDataSource=true, connectionPoolID=MyJDBC Connection Pool, dataSourceName=MyJDBC Data Source}.
Nested Exception: java.lang.RuntimeException: Failed to setAutoCommit to true for pool connection.
at weblogic.jdbc.wrapper.PoolConnection.init(PoolConnection.java:47)
at weblogic.jdbc.pool.Driver.allocateConnection(Driver.java:254)
at weblogic.jdbc.pool.Driver.connect(Driver.java:164)
at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:507)
at weblogic.jdbc.jts.Driver.connect(Driver.java:139)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:305)
at com.cnoocrc.sharing.Database.connectJNDIImpl(Database.java:169)
at com.cnoocrc.sharing.Database.getSharingConn(Database.java:129)
at com.cnoocrc.pm.ResearchDesign.wf.queryList.ListQuery(queryList.java:25)
at jsp_servlet._basecomponent._buildpage.__report_list._jspService(report_list.jsp:73)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:996)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at com.epc.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:105)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6458)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3661)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2630)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)

at weblogic.jdbc.jts.Driver.wrapAndThrowSQLException(Driver.java:458)
at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:511)
at weblogic.jdbc.jts.Driver.connect(Driver.java:139)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:305)
at com.cnoocrc.sharing.Database.connectJNDIImpl(Database.java:169)
at com.cnoocrc.sharing.Database.getSharingConn(Database.java:129)
... 16 more

------------------------------------------------------------------------------
有人知道这应该怎么解决吗?

...全文