1 Reply Latest reply on Oct 31, 2007 6:00 AM by Ryan Rutan

    ClearspaceX 1.7.0 -> CommunityNotFoundException-> java.sql.SQLException: Attempt to use a closed handle

    Ryan Rutan

      Getting some weird errors  when starting up ClearspaceX after upgrading ot ClearspacX 1.7.0 on OC4J 10.1.3.3.  These communities do exist in the system

       

      Any help is appreciated.

       

       

       

       

      Entries from jive.debug.long

       

       

       

       

      2007.10.30 14:43:51 Community 100 could not be loaded.

      com.jivesoftware.community.CommunityNotFoundException: Community 100 could not be loaded.

      at com.jivesoftware.community.impl.DbCommunityManager.getCommunityBean(DbCommunityManager.java:694)

      at com.jivesoftware.community.impl.DbCommunityManager.getCommunity(DbCommunityManager.java:171)

      at com.jivesoftware.community.impl.DatabaseObjectLoader$3.loadObject(DatabaseObjectLoader.java:128)

      at com.jivesoftware.community.impl.DatabaseObjectLoader$3.loadObject(DatabaseObjectLoader.java:125)

      at com.jivesoftware.community.impl.DatabaseObjectLoader.getJiveObject(DatabaseObjectLoader.java:90)

      at com.jivesoftware.community.impl.DatabaseObjectIterator.getNextElement(DatabaseObjectIterator.java:174)

      at com.jivesoftware.community.impl.DatabaseObjectIterator.hasNext(DatabaseObjectIterator.java:115)

      at com.jivesoftware.community.impl.DbActivityManager.initialize(DbActivityManager.java:106)

      at com.jivesoftware.community.lifecycle.JiveApplication$ManagerHandler.registerManager(JiveApplication.java:177)

      at com.jivesoftware.community.lifecycle.JiveApplicationLifeCycle.initManagers(JiveApplicationLifeCycle.java:615)

      at com.jivesoftware.community.lifecycle.JiveApplicationLifeCycle.initialize(JiveApplicationLifeCycle.java:209)

      at com.jivesoftware.community.lifecycle.JiveApplication.initialize(JiveApplication.java:80)

      at com.jivesoftware.community.web.webwork.LifeCycleListener.contextInitialized(LifeCycleListener.java:43)

      at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1141)

      at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:741)

      at com.evermind.server.ApplicationStateRunning.getHttpApplication(ApplicationStateRunning.java:414)

      at com.evermind.server.Application.getHttpApplication(Application.java:570)

      at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.createHttpApplicationFromReference(HttpSite.java:1987)

      at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.<init>(HttpSite.java:1906)

      at com.evermind.server.http.HttpSite.addHttpApplication(HttpSite.java:1603)

      at oracle.oc4j.admin.internal.WebApplicationBinder.bindWebApp(WebApplicationBinder.java:238)

      at oracle.oc4j.admin.internal.WebApplicationBinder.bindWebApp(WebApplicationBinder.java:99)

      at oracle.oc4j.admin.internal.ApplicationDeployer.bindWebApp(ApplicationDeployer.java:547)

      at oracle.oc4j.admin.internal.ApplicationDeployer.doDeploy(ApplicationDeployer.java:202)

      at oracle.oc4j.admin.internal.DeployerBase.execute(DeployerBase.java:93)

      at oracle.oc4j.admin.jmx.server.mbeans.deploy.OC4JDeployerRunnable.doRun(OC4JDeployerRunnable.java:52)

      at oracle.oc4j.admin.jmx.server.mbeans.deploy.DeployerRunnable.run(DeployerRunnable.java:81)

      at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:298)

      at java.lang.Thread.run(Thread.java:595)

      Caused by: com.jivesoftware.base.database.dao.DAOException: Community 100 could not be loaded.

      at com.jivesoftware.community.impl.dao.DbCommunityDAO.getByCommunityID(DbCommunityDAO.java:654)

      at com.jivesoftware.community.impl.DbCommunityManager.getCommunityBean(DbCommunityManager.java:687)

      ... 28 more

      Caused by: java.sql.SQLException: Attempt to use a closed handle : 'oracle_jdbc_driver_LogicalConnection_Proxy@1acba06'.

      at oracle.oc4j.sql.spi.ConnectionHandle.oc4j_intercept(ConnectionHandle.java:283)

      at oracle_jdbc_driver_LogicalConnection_Proxy.prepareStatement()

      at com.jivesoftware.community.impl.dao.DbCommunityDAO.getByCommunityID(DbCommunityDAO.java:613)

      ... 29 more

      2007.10.30 14:43:51 Community 10 could not be loaded.

      com.jivesoftware.community.CommunityNotFoundException: Community 10 could not be loaded.

      at com.jivesoftware.community.impl.DbCommunityManager.getCommunityBean(DbCommunityManager.java:694)

      at com.jivesoftware.community.impl.DbCommunityManager.getCommunity(DbCommunit

       

       

       

       

       

       

       

       

       

       

      Entries from jive.error.log

       

       

       

       

      2007.10.30 14:43:53 error PreparedStatementCallback; uncategorized SQLException for SQL ; SQL state null ; error code 0; Attempt to use a closed handle

      : 'oracle_jdbc_driver_LogicalConnection_Proxy@24faf1'.; nested exception is java.sql.SQLException: Attempt to use a closed handle : 'oracle_jdbc_driver_Logical

      Connection_Proxy@24faf1'.

      org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL -; SQL state null; error code 0; Attempt

      to use a closed handle : 'oracle_jdbc_driver_LogicalConnection_Proxy@24faf1'.; nested exception is java.sql.SQLException: Attempt to use a closed handle : 'or

      acle_jdbc_driver_LogicalConnection_Proxy@24faf1'.

      Caused by: java.sql.SQLException: Attempt to use a closed handle : 'oracle_jdbc_driver_LogicalConnection_Proxy@24faf1'.

      at oracle.oc4j.sql.spi.ConnectionHandle.oc4j_intercept(ConnectionHandle.java:283)

      at oracle_jdbc_driver_LogicalConnection_Proxy.prepareStatement()

      at com.jivesoftware.base.database.ConnectionManager.createScrollablePreparedStatement(ConnectionManager.java:476)

      at com.jivesoftware.base.database.dao.SpringJdbcDAOContext$ScrollablePreparedStatementCreator.createPreparedStatement(SpringJdbcDAOContext.java:223)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:531)

      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:587)

      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:612)

      at com.jivesoftware.base.database.dao.SpringJdbcDAOContext.queryScrollable(SpringJdbcDAOContext.java:72)

      at com.jivesoftware.community.impl.dao.ActivityDAOImpl.getPopularityByContainer(ActivityDAOImpl.java:211)

      at com.jivesoftware.community.impl.DbActivityManager$PopularityDeterminationWorker.populateCommunityPopularity(DbActivityManager.java:730)

      at com.jivesoftware.community.impl.DbActivityManager$PopularityDeterminationWorker.run(DbActivityManager.java:646)

      at java.lang.Thread.run(Thread.java:595)

      2007.10.30 14:43:53 error Failed to initialize Acitivy and Popularity:

      org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL -; SQL state null; error code 0; Attempt

      to use a closed handle : 'oracle_jdbc_driver_LogicalConnection_Proxy@1acba06'.; nested exception is java.sql.SQLException: Attempt to use a closed handle : 'o

      racle_jdbc_driver_LogicalConnection_Proxy@1acba06'.

      Caused by: java.sql.SQLException: Attempt to use a closed handle : 'oracle_jdbc_driver_LogicalConnection_Proxy@1acba06'.

      at oracle.oc4j.sql.spi.ConnectionHandle.oc4j_intercept(ConnectionHandle.java:283)

      at oracle_jdbc_driver_LogicalConnection_Proxy.prepareStatement()

      at com.jivesoftware.base.database.ConnectionManager.createScrollablePreparedStatement(ConnectionManager.java:476)

      at com.jivesoftware.base.database.dao.SpringJdbcDAOContext$ScrollablePreparedStatementCreator.createPreparedStatement(SpringJdbcDAOContext.java:223)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:531)

      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:587)

      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:612)

      at com.jivesoftware.base.database.dao.SpringJdbcDAOContext.queryScrollable(SpringJdbcDAOContext.java:72)

      at com.jivesoftware.community.impl.dao.ActivityDAOImpl.getRecentActivityContainer(ActivityDAOImpl.java:122)

      at com.jivesoftware.community.impl.DbActivityManager.initialize(DbActivityManager.java:107)

      at com.jivesoftware.community.lifecycle.JiveApplication$ManagerHandler.registerManager(JiveApplication.java:177)

      at com.jivesoftware.community.lifecycle.JiveApplicationLifeCycle.initManagers(JiveApplicationLifeCycle.java:615)

      at com.jivesoftware.community.lifecycle.JiveApplicationLifeCycle.initialize(JiveApplicationLifeCycle.java:209)

      at com.jivesoftware.community.lifecycle.JiveApplication.initialize(JiveApplication.java:80)

      at com.jivesoftware.community.web.webwork.LifeCycleListener.contextInitialized(LifeCycleListener.java:43)

      at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1141)

      at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:741)

      at com.evermind.server.ApplicationStateRunning.getHttpApplication(ApplicationStateRunning.java:414)

      at com.evermind.server.Application.getHttpApplication(Application.java:570)

      at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.createHttpApplicationFromReference(HttpSite.java:1987)

      at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.<init>(HttpSite.java:1906)

      at com.evermind.server.http.HttpSite.addHttpApplication(HttpSite.java:1603)

      at oracle.oc4j.admin.internal.WebApplicationBinder.bindWebApp(WebApplicationBinder.java:238)

      at oracle.oc4j.admin.internal.WebApplicationBinder.bindWebApp(WebApplicationBinder.java:99)

      at oracle.oc4j.admin.internal.ApplicationDeployer.bindWebApp(ApplicationDeployer.java:547)