Java to DB connection exceptions

Question

We are developing web application our tomcat server and mysql server runs on two different servers and we are getting the errors

org.hibernate.TransactionException: JDBC begin transaction failed: 

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 86,402,200 milliseconds ago.

java.net.SocketException: Broken pipe

org.hibernate.exception.JDBCConnectionException:

need help to solve the issue

have tried the solutions from these links

Hibernate Session Could not open for transaction

First Login: HTTP Status 500 - Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:

There is a problem in your MySql connection. Which URL are you using to connect the mysql? — Rahul, Mar 30 '15 at 10:50
Inside my db.property file i have this entry db.connection.url=jdbc:mysql://dbServerIp:3306/dbname — DnA, Mar 30 '15 at 11:13
have you given network access to your db? You can verify your network access to your db by connection your local mySql client as below: `mysql -h dbServerIp -u -p` — Rahul, Mar 30 '15 at 11:34
Yes i did actually we process about 14000 file but after around 6000 or 8000 files processed we are getting this exception — DnA, Mar 30 '15 at 12:39

score 0 · Accepted Answer · answered Mar 31 '15 at 07:26

0

Actually the project is very big and multiple threads are running we were getting this error because we were exceeding the maximum number of connections that can be handled by the mysql server in our case 300.

answered Mar 31 '15 at 07:26

DnA

727
3
10
28

Java to DB connection exceptions

1 Answers1