Showing posts with label Connection. Show all posts
Showing posts with label Connection. Show all posts

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

Sunday, 17 April 2016

AWS jenkins tomcat "ConnectException: Connection timed out"


AWS jenkins tomcat "ConnectException: Connection timed out"

Error 1.
ERROR: Build step failed with exception
org.codehaus.cargo.container.ContainerException: Failed to redeploy
Caused by: java.net.ConnectException: Connection timed out

error 2.
This site can’t be reached
xx.xxx.xx.xxx took too long to respond.
ERR_CONNECTION_TIMED_OUT

solution :

go to network and setting --> click on "deafault" name
edit indound rule.
add "cunstom tcp rule" add the custom port that you want to listen ex:8090 or 3000
save.