AnsweredAssumed Answered

Cannot create PoolableConnectionFactory Exception

Question asked by rohit_l on Jun 26, 2006
Latest reply on Jun 26, 2006 by rohit_l
Hello All,

I'm new to Alfresco. I installed installed MySQL separately (v. 5.0.22). Next I downloaded the MySQL JDBC driver jar file (mysql-connector-java-3.1.13.jar) and made it available in my system classpath. To verify if it is working, I wrote a short java program to see if the driver is loaded and confirmed that it works.

Next I downloaded Alfresco bundled with Tomcat ( and installed it. So far so good. My MySQL installation seems to run fine. However, when I run Alfresco, it returns a huge exception trace before finally saying that the server has started. Sure enough, the Tomcat default website is available through http://localhost:8080 , but when I try to access Alfresco, through http://localhost:8080/afresco it says the requested resource "/alfresco" is not available. The exception trace is given below. Help needed badly.

09:48:05,125 ERROR [org.hibernate.util.JDBCExceptionReporter] Cannot create PoolableConnectionFactory (Communications link failure due to underlying exception:

MESSAGE: Connection refused: connect

STACKTRACE: Connection refused: connect
   at com.mysql.jdbc.StandardSocketFactory.connect(
   at com.mysql.jdbc.MysqlIO.<init>(
   at com.mysql.jdbc.Connection.createNewIO(
   at com.mysql.jdbc.Connection.<init>(
   at com.mysql.jdbc.NonRegisteringDriver.connect(
   at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(
   at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(
   at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(
   at org.apache.commons.dbcp.BasicDataSource.getConnection(
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(
   at org.hibernate.cfg.SettingsFactory.buildSettings(
   at org.hibernate.cfg.Configuration.buildSettings(
   at org.hibernate.cfg.Configuration.buildSessionFactory(
   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(