BonitaBPMCommunity-7.3.3-Tomcat-7.0.67 and Mysql connection error when not in use for long time?

1
0
-1

I change configuration for BonitaBPMCommunity-7.3.3-Tomcat-7.0.67 to connect with mysql it is work fine but when the application idle there is no work on it give me error you must add 'autoReconnect=true' so I add it in the url:

**url="jdbc:mysql://localhost:3306/business_data2?autoReconnect=true&useSSL=false&dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8"/>
**
but it is give me another error like this:

Caused by: org.springframework.transaction.TransactionSystemException: Could not roll back JDBC transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

so to avoid this i need to restart the server.

Can anyone help me please,,

Regards..

Comments

Submitted by Lionel Palacin on Thu, 02/09/2017 - 20:09

Does that help if you add testOnBorrow="true" option in the datasource configuration?

No answers yet.
Testing
Notifications