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…