DevTest 10.3 VSM -Use Connection Pool in SQL Database connection step looses DB connection

Document ID : KB000119995
Last Modified Date : 06/11/2018
Show Technical Document Details
When I was using Devtest version 9.2. in VSM for SQL Database Connect I was using "keep open connection" But when migrated to 10.3 the Model was throwing an error and then going offline until I enabled the "Use connection pool" feature. Still its unstable. Connection keep going offline. 
DevTest 10.3 and up
Customer is using the same DB for Registry and for VSM 
Vse logs shows : 
 ERROR   - Unable to invoke request: ; nested exception is: Read timed out
 faultCode: {}Server.userException
 faultString: Read timed out
      {} Read timed out
      at Method)
       Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException  Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 33,270,970 milliseconds ago.  The last packet sent successfully to the server was 33,270,970 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.  Error Code: 0  Call: SELECT ACL_USER_ID, MISC_INFO, USER_NAME, USER_PASSWORD, USER_UNIQUE_ID FROM ACL_USERS WHERE (LOWER(USER_UNIQUE_ID) = LOWER(?))              bind => [1 parameter bound]  Query: ReadAllQuery(referenceClass=DbUser sql="SELECT ACL_USER_ID, MISC_INFO, USER_NAME, USER_PASSWORD, USER_UNIQUE_ID FROM ACL_USERS WHERE (LOWER(USER_UNIQUE_ID) = LOWER(?))"). 
Try the below options:

If you are using common pool for ACL


First option  is 

lisadb.pool.common.preferredTestQuery=SELECT 1

more c3p0 configuration can be found at

If the above doesn’t work then they can try