Hi,
We have patch IS_8.0_SP1_Core_Fix18 installed and we are still getting the same error:

“2012-04-26 08:18:50 EST [CommonLib.MWS.0002W] DB Server disconnected. Will try to reconnect
[wm-cjdbc40-0034][SQLServer JDBC Driver]Object has been closed.java.sql.SQLException: [wm-cjdbc40-0034][SQLServer JDBC Driver]Object has been closed.”

The strange thing is that this happens at roughly the same time every day, and only once or twice a day.

Does anyone have any idea why this is happening ??

Cheers,
David

Is the DB forcing connections closed on a scheduled basis?

Unfortunately no. I’ve done some more digging through the history of log files the client has and the times range from 2am up till 6pm that I’ve seen (though I guess that it can be anytime). They have two IS’s clustered and most times the connection only gets closed on one node or the other. Only rarely do both nodes close the connection at the same time.

Cheers,
David

What are the connection pool settings? Is min pool size > than 0? If so, you should consider setting it to 0.

I thought of that, but, Min: 0 & Max: 10. Standard settings on all DB here…