[2011]: JDBCExceptionReporter - SQL Error: 0, SQLState: null

[dtouzeau]

Dear

I cannot login to the openemm console
under the openemm.log there is these errors :

Code: Select all

2011-07-26 23:42:54,137: WARN  [main] net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/home/openemm/webapps/openemm/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
2011-07-26 23:42:56,051: WARN  [http-8080-1] org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2011-07-26 23:42:56,052: ERROR [http-8080-1] org.hibernate.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
2011-07-26 23:42:56,052: WARN  [http-8080-1] org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2011-07-26 23:42:56,052: ERROR [http-8080-1] org.hibernate.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
2011-07-26 23:42:56,090: WARN  [http-8080-1] org.springframework.jdbc.support.SQLErrorCodesFactory - Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

How can i resolve it ?

best regards

[dtouzeau]

success by changing the right mysql informations in webapps/openemm/WEB-INF/classes/emm.properties