[opencms-dev] Problems with DB connections
Oksanen, Miikka
Miikka.Oksanen at satama.com
Wed Mar 9 17:36:03 CET 2005
Hi,
I'm running OpenCms 6 beta 1 on BEA WLS 8.1 SP3 and with Oracle 9.2.0.4.0.
OpenCms seems to work okay, but when I switched on JDBC logging on BEA WLS,
the following stuff comes to the log when OpenCms initializes:
<SNIP>
-------------------------------------------------------------
JDBC log stream started at Wed Mar 09 18:27:54 EET 2005
-------------------------------------------------------------
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver:
driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDr
iver at 1128ee5]
registerDriver:
driver[className=org.apache.commons.dbcp.PoolingDriver,org.apache.commons.db
cp.PoolingDriver at 1286180]
DriverManager.getConnection("jdbc:apache:commons:dbcp:opencms:default")
trying
driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDr
iver at 1128ee5]
trying
driver[className=org.apache.commons.dbcp.PoolingDriver,org.apache.commons.db
cp.PoolingDriver at 1286180]
DriverManager.getConnection("jdbc:oracle:thin:@xxx.yyy.com:1521:wwwww")
trying
driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDr
iver at 1128ee5]
skipping:
driver[className=org.apache.commons.dbcp.PoolingDriver,org.apache.commons.db
cp.PoolingDriver at 1286180]
Oracle Jdbc tracing is not avaliable in a non-debug zip/jar file
getConnection returning
driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDr
iver at 1128ee5]
getConnection returning
driver[className=org.apache.commons.dbcp.PoolingDriver,org.apache.commons.db
cp.PoolingDriver at 1286180]
java.sql.SQLException: Already closed
at
org.apache.commons.dbcp.PoolablePreparedStatement.close(PoolablePreparedStat
ement.java:75)
at
org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:1
65)
at
org.opencms.db.generic.CmsSqlManager.closeAll(CmsSqlManager.java:190)
at
org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:392)
at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:532)
at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4526
)
at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:422)
at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2251)
at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)
at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1077)
at org.opencms.main.OpenCmsCore.initContext(OpenCmsCore.java:1228)
at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1440)
at org.opencms.main.OpenCmsServlet.init(OpenCmsServlet.java:220)
at
weblogic.servlet.internal.ServletStubImpl$ServletInitAction.run(ServletStubI
mpl.java:993)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubjec
t.java:317)
at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at
weblogic.servlet.internal.ServletStubImpl.createServlet(ServletStubImpl.java
:869)
at
weblogic.servlet.internal.ServletStubImpl.createInstances(ServletStubImpl.ja
va:848)
at
weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.jav
a:787)
at
weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletC
ontext.java:3252)
at
weblogic.servlet.internal.WebAppServletContext.preloadServlets(WebAppServlet
Context.java:3197)
at
weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServle
tContext.java:3174)
at
weblogic.servlet.internal.HttpServer.preloadResources(HttpServer.java:688)
at
weblogic.servlet.internal.WebService.preloadResources(WebService.java:483)
at
weblogic.servlet.internal.ServletInitService.resume(ServletInitService.java:
30)
at
weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
at weblogic.Server.main(Server.java:32)
DriverManager.getConnection("jdbc:apache:commons:dbcp:opencms:default")
trying
driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDr
iver at 1128ee5]
trying
driver[className=org.apache.commons.dbcp.PoolingDriver,org.apache.commons.db
cp.PoolingDriver at 1286180]
getConnection returning
driver[className=org.apache.commons.dbcp.PoolingDriver,org.apache.commons.db
cp.PoolingDriver at 1286180]
java.sql.SQLException: Already closed
at
org.apache.commons.dbcp.PoolablePreparedStatement.close(PoolablePreparedStat
ement.java:75)
at
org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:1
65)
at
org.opencms.db.generic.CmsSqlManager.closeAll(CmsSqlManager.java:190)
at
org.opencms.db.generic.CmsProjectDriver.readProject(CmsProjectDriver.java:15
12)
at
org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:3
44)
at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:3932)
at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:444)
at org.opencms.main.OpenCmsCore.initContext(OpenCmsCore.java:1228)
at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1440)
at org.opencms.main.OpenCmsServlet.init(OpenCmsServlet.java:220)
at
weblogic.servlet.internal.ServletStubImpl$ServletInitAction.run(ServletStubI
mpl.java:993)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubjec
t.java:317)
at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at
weblogic.servlet.internal.ServletStubImpl.createServlet(ServletStubImpl.java
:869)
at
weblogic.servlet.internal.ServletStubImpl.createInstances(ServletStubImpl.ja
va:848)
at
weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.jav
a:787)
at
weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletC
ontext.java:3252)
at
weblogic.servlet.internal.WebAppServletContext.preloadServlets(WebAppServlet
Context.java:3197)
at
weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServle
tContext.java:3174)
at
weblogic.servlet.internal.HttpServer.preloadResources(HttpServer.java:688)
at
weblogic.servlet.internal.WebService.preloadResources(WebService.java:483)
at
weblogic.servlet.internal.ServletInitService.resume(ServletInitService.java:
30)
at
weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
at weblogic.Server.main(Server.java:32)
DriverManager.getConnection("jdbc:apache:commons:dbcp:opencms:default")
trying
driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDr
iver at 1128ee5]
trying
driver[className=org.apache.commons.dbcp.PoolingDriver,org.apache.commons.db
cp.PoolingDriver at 1286180]
getConnection returning
driver[className=org.apache.commons.dbcp.PoolingDriver,org.apache.commons.db
cp.PoolingDriver at 1286180]
java.sql.SQLException: Already closed
at
org.apache.commons.dbcp.PoolablePreparedStatement.close(PoolablePreparedStat
ement.java:75)
at
org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:1
65)
at
org.opencms.db.generic.CmsSqlManager.closeAll(CmsSqlManager.java:190)
...
</SNIP>
Any ideas from where those "Already closed" exceptions occur, as the WLS
instance was just restarted and the connections should be there?
Same kind of exceptions occur also on every DB action, like editing the
content or retrieving content.
Best regards,
Miikka Oksanen
More information about the opencms-dev
mailing list