Friday 13 May 2016

SQL Error: 0, SQLState: null, Cannot create PoolableConnectionFactory (Communications link failure)



2016-05-12 20:37:03,434 [http-bio-8080-exec-3] WARN  (SqlExceptionHelper.java:144) - SQL Error: 0, SQLState: null
2016-05-12 20:37:03,435 [http-bio-8080-exec-3] ERROR (SqlExceptionHelper.java:146) - 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.)
2016-05-12 20:37:03,445 [http-bio-8080-exec-3] ERROR (BaseService.java:41) - org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:544)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:457)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)
Here is solution worked for me. provide relevant/correct db credentials and ip address. ex :
DB URL : jdbc:mysql://127.0.0.1:3306/voicedb
username : voice
password : voice

No comments:

Post a Comment