Hmmm, interesting. Is there perhaps an error message earlier on in the log? I ask because I can't see a root cause belonging to H2 anywhere in that stacktrace.
On Mon, Oct 31, 2011 at 18:42, Elton (GMAIL) <[email protected]> wrote: > Hi Noel, > Thank you for replying. It is not an issue related to the DB connection > string. I must add here that using the previous x.x.160 version works and > only when I replace the jar with vx.x.161 do I run into this problem. > > Regards > Elton Kent > > -----Original Message----- > From: Noel Grandin [mailto:[email protected]] > Sent: Monday, October 31, 2011 5:51 PM > To: [email protected] > Cc: steve > Subject: Re: Issue with c3p0 when using h2-1.3.161. > > you probably haven't specified the database URL properly. > > see http://www.h2database.com/html/tutorial.html#connecting_using_jdbc > > steve wrote: >> Hello >> Firstly , thank you for this awesome database. I've upgraded to the >> current release and noticed that the application wasn't functioning as >> expected. Turns out a database connection could be established by >> hibernate. >> >> I've attached a stacktrace. >> >> >> java.sql.SQLException: Connections could not be acquired from the >> underlying database! >> at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) >> at >> > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C > 3P0PooledConnectionPool.java: >> 529) >> at >> > com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(Abstract > PoolBackedDataSource.java: >> 128) >> at >> > org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0Connection > Provider.java: >> 78) >> at >> > org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepar > e(SuppliedConnectionProviderConnectionHelper.java: >> 51) >> at > org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java: >> 168) >> at >> org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java: >> 375) >> at >> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java: >> 1872) >> at >> > com.callidus.db.HibernateSessionFactory.<clinit>(HibernateSessionFactory.jav > a: >> 68) >> at com.callidus.db.dao.BaseDAO.getSession(BaseDAO.java:12) >> at >> > com.callidus.db.dao.EmbeddedAppsDAO.getAllActiveApplications(EmbeddedAppsDAO > .java: >> 16) >> at >> > com.callidus.agents.local.WebServerSetupAgent.getAllHandlers(WebServerSetupA > gent.java: >> 160) >> at >> > com.callidus.agents.local.WebServerSetupAgent.configureHttpServer(WebServerS > etupAgent.java: >> 39) >> at >> > com.callidus.agents.local.WebServerSetupAgent.execute(WebServerSetupAgent.ja > va: >> 63) >> at com.callidus.agents.CallidusAgent.call(CallidusAgent.java:27) >> at com.callidus.agents.CallidusAgent.runAgent(CallidusAgent.java:79) >> at com.callidus.server.Server.startUpServer(Server.java:143) >> at com.callidus.Callidus.main(Callidus.java:18) >> Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: >> A ResourcePool could not acquire a resource from its primary factory >> or source. >> at >> > com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePo > ol.java: >> 1319) >> at >> > com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicRe > sourcePool.java: >> 557) >> at >> > com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResource > Pool.java: >> 477) >> at >> > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C > 3P0PooledConnectionPool.java: >> 525) >> ... 16 more >> 61949 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - could not >> complete schema update >> java.sql.SQLException: Connections could not be acquired from the >> underlying database! >> at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) >> at >> > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C > 3P0PooledConnectionPool.java: >> 529) >> at >> > com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(Abstract > PoolBackedDataSource.java: >> 128) >> at >> > org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0Connection > Provider.java: >> 78) >> at >> > org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepar > e(SuppliedConnectionProviderConnectionHelper.java: >> 51) >> at > org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java: >> 168) >> at >> org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java: >> 375) >> at >> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java: >> 1872) >> at >> > com.callidus.db.HibernateSessionFactory.<clinit>(HibernateSessionFactory.jav > a: >> 68) >> at com.callidus.db.dao.BaseDAO.getSession(BaseDAO.java:12) >> at >> > com.callidus.db.dao.EmbeddedAppsDAO.getAllActiveApplications(EmbeddedAppsDAO > .java: >> 16) >> at >> > com.callidus.agents.local.WebServerSetupAgent.getAllHandlers(WebServerSetupA > gent.java: >> 160) >> at >> > com.callidus.agents.local.WebServerSetupAgent.configureHttpServer(WebServerS > etupAgent.java: >> 39) >> at >> > com.callidus.agents.local.WebServerSetupAgent.execute(WebServerSetupAgent.ja > va: >> 63) >> at com.callidus.agents.CallidusAgent.call(CallidusAgent.java:27) >> at com.callidus.agents.CallidusAgent.runAgent(CallidusAgent.java:79) >> at com.callidus.server.Server.startUpServer(Server.java:143) >> at com.callidus.Callidus.main(Callidus.java:18) >> Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: >> A ResourcePool could not acquire a resource from its primary factory >> or source. >> at >> > com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePo > ol.java: >> 1319) >> at >> > com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicRe > sourcePool.java: >> 557) >> at >> > com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResource > Pool.java: >> 477) >> at >> > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C > 3P0PooledConnectionPool.java: >> 525) >> ... 16 more >> 106118 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL >> Error: 0, SQLState: null >> 106118 [main] ERROR org.hibernate.util.JDBCExceptionReporter - >> Connections could not be acquired from the underlying database! >> Exception in thread "main" >> org.hibernate.exception.GenericJDBCException: Cannot open connection >> at >> > org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLSta > teConverter.java: >> 140) >> at >> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java: >> 128) >> at >> > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java > : >> 66) >> at >> > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java > : >> 52) >> at >> > org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java: >> 449) >> at >> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java: >> 167) >> at >> > org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.jav > a: >> 161) >> at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java: >> 1700) >> at org.hibernate.loader.Loader.doQuery(Loader.java:801) >> at >> > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.ja > va: >> 274) >> at org.hibernate.loader.Loader.doList(Loader.java:2542) >> at > org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) >> at org.hibernate.loader.Loader.list(Loader.java:2271) >> at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459) >> at >> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java: >> 365) >> at >> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java: >> 196) >> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) >> at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) >> at >> > com.callidus.db.dao.EmbeddedAppsDAO.getAllActiveApplications(EmbeddedAppsDAO > .java: >> 19) >> at >> > com.callidus.agents.local.WebServerSetupAgent.getAllHandlers(WebServerSetupA > gent.java: >> 160) >> at >> > com.callidus.agents.local.WebServerSetupAgent.configureHttpServer(WebServerS > etupAgent.java: >> 39) >> at >> > com.callidus.agents.local.WebServerSetupAgent.execute(WebServerSetupAgent.ja > va: >> 63) >> at com.callidus.agents.CallidusAgent.call(CallidusAgent.java:27) >> at com.callidus.agents.CallidusAgent.runAgent(CallidusAgent.java:79) >> at com.callidus.server.Server.startUpServer(Server.java:143) >> at com.callidus.Callidus.main(Callidus.java:18) >> Caused by: java.sql.SQLException: Connections could not be acquired >> from the underlying database! >> at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) >> at >> > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C > 3P0PooledConnectionPool.java: >> 529) >> at >> > com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(Abstract > PoolBackedDataSource.java: >> 128) >> at >> > org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0Connection > Provider.java: >> 78) >> at >> > org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java: >> 446) >> ... 21 more >> Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: >> A ResourcePool could not acquire a resource from its primary factory >> or source. >> at >> > com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePo > ol.java: >> 1319) >> at >> > com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicRe > sourcePool.java: >> 557) >> at >> > com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResource > Pool.java: >> 477) >> at >> > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C > 3P0PooledConnectionPool.java: >> 525) >> > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
