topic Problem connecting to MySQL 5.0 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-connecting-to-mysql-5-0/m-p/45324#M25186 <HTML><HEAD></HEAD><BODY><SPAN>I am getting the following exception when I try to deploy the alfresco.war file under Tomcat 5.1.&nbsp; I am using MySQL 5.&nbsp; The alfresco user has been created and also the alfresco database.&nbsp; </SPAN><BR /><BR /><SPAN>16:10:30,478 ERROR [org.hibernate.util.JDBCExceptionReporter] Connections could not be acquired from the underlying database!</SPAN><BR /><SPAN>16:10:49,936 ERROR [org.hibernate.util.JDBCExceptionReporter] Connections could not be acquired from the underlying database!</SPAN><BR /><SPAN>16:10:49,936 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] could not get database metadata</SPAN><BR /><SPAN>java.sql.SQLException: Connections could not be acquired from the underlying database!</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:352)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:120)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.c3p0.ComboPooledDataSource.getConnection(ComboPooledDataSource.java:601)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionFactoryImpl.&lt;init&gt;(SessionFactoryImpl.java:296)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:800)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:726)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1059)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1013)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:824)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:345)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1013)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:824)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:345)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1013)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:824)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:345)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:203)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:614)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.registerListeners(AbstractApplicationContext.java:496)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:317)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4183)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1112)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:450)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:551)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)</SPAN><BR /><SPAN>Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1002)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:293)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:348)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 66 more</SPAN></BODY></HTML> Tue, 15 Aug 2006 20:48:20 GMT sastry 2006-08-15T20:48:20Z Problem connecting to MySQL 5.0 https://connect.hyland.com/t5/alfresco-archive/problem-connecting-to-mysql-5-0/m-p/45324#M25186 I am getting the following exception when I try to deploy the alfresco.war file under Tomcat 5.1.&nbsp; I am using MySQL 5.&nbsp; The alfresco user has been created and also the alfresco database.&nbsp; 16:10:30,478 ERROR [org.hibernate.util.JDBCExceptionReporter] Connections could not be acquired from the underly Tue, 15 Aug 2006 20:48:20 GMT https://connect.hyland.com/t5/alfresco-archive/problem-connecting-to-mysql-5-0/m-p/45324#M25186 sastry 2006-08-15T20:48:20Z Re: Problem connecting to MySQL 5.0 https://connect.hyland.com/t5/alfresco-archive/problem-connecting-to-mysql-5-0/m-p/45325#M25187 <HTML><HEAD></HEAD><BODY><SPAN>hi,</SPAN><BR /><BR /><SPAN>did you resolve your problem ?</SPAN></BODY></HTML> Wed, 30 Aug 2006 22:18:12 GMT https://connect.hyland.com/t5/alfresco-archive/problem-connecting-to-mysql-5-0/m-p/45325#M25187 yroffin 2006-08-30T22:18:12Z Re: Problem connecting to MySQL 5.0 https://connect.hyland.com/t5/alfresco-archive/problem-connecting-to-mysql-5-0/m-p/45326#M25188 <HTML><HEAD></HEAD><BODY><SPAN>hi, i think you have a problem in your tomcat/shared/classes/alfresco/extension/custom-repository.properties</SPAN><BR /><BR /><SPAN>i correct the socket port, and it work … for a while and i obtain a DEADLOCK problem ;(</SPAN></BODY></HTML> Fri, 01 Sep 2006 21:09:44 GMT https://connect.hyland.com/t5/alfresco-archive/problem-connecting-to-mysql-5-0/m-p/45326#M25188 yroffin 2006-09-01T21:09:44Z