MyBatis closed db connection

aitor — Mon, 03 Mar 2014 08:25:57 GMT

Hello!!!Every morning I see a DB connection error trace in my logs before doing any operation.After doing some operation the error disappears (MyBatis reestablishes the connection).Everything works fine, but there are many traces of error in my logs.How I can avoid this? This is my ProcessEngine con

Re: MyBatis closed db connection

jbarrez — Mon, 10 Mar 2014 10:00:38 GMT

Seems like you would need a keepalive/ping on the connections.

Following settings are available on the ProcessEngineConfiguration:

protected int jdbcMaxActiveConnections;
protected int jdbcMaxIdleConnections;
protected int jdbcMaxCheckoutTime;
protected int jdbcMaxWaitTime;
protected boolean jdbcPingEnabled = false;
protected String jdbcPingQuery = null;
protected int jdbcPingConnectionNotUsedFor;
protected int jdbcDefaultTransactionIsolationLevel;

topic MyBatis closed db connection in Alfresco Archive

MyBatis closed db connection

Re: MyBatis closed db connection