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(C3P0PooledConnectionPool.java: > 529) > at > com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java: > 128) > at > org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java: > 78) > at > org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(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.java: > 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(WebServerSetupAgent.java: > 160) > at > com.callidus.agents.local.WebServerSetupAgent.configureHttpServer(WebServerSetupAgent.java: > 39) > at > com.callidus.agents.local.WebServerSetupAgent.execute(WebServerSetupAgent.java: > 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(BasicResourcePool.java: > 1319) > at > com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java: > 557) > at > com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java: > 477) > at > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.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(C3P0PooledConnectionPool.java: > 529) > at > com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java: > 128) > at > org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java: > 78) > at > org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(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.java: > 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(WebServerSetupAgent.java: > 160) > at > com.callidus.agents.local.WebServerSetupAgent.configureHttpServer(WebServerSetupAgent.java: > 39) > at > com.callidus.agents.local.WebServerSetupAgent.execute(WebServerSetupAgent.java: > 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(BasicResourcePool.java: > 1319) > at > com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java: > 557) > at > com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java: > 477) > at > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.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(SQLStateConverter.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.java: > 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.java: > 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(WebServerSetupAgent.java: > 160) > at > com.callidus.agents.local.WebServerSetupAgent.configureHttpServer(WebServerSetupAgent.java: > 39) > at > com.callidus.agents.local.WebServerSetupAgent.execute(WebServerSetupAgent.java: > 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(C3P0PooledConnectionPool.java: > 529) > at > com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java: > 128) > at > org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.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(BasicResourcePool.java: > 1319) > at > com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java: > 557) > at > com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java: > 477) > at > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.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.
