I am running into this error, where the connection pool connections go into an invalid state and our app fails. I dont really know why this happen (either due to DB restarts/ failover or network issues), but the driver should be able to recover from this.
we use jtds 1.2.5, tomcat 6 and mssql server 2012
[2014-05-05 14:07:19,988] [db] SQLException loading table definition for Template_Composition with state HY010: Invalid state, the Connection object is closed.
java.sql.SQLException: Invalid state, the Connection object is closed.
Resource name="csDataSource" auth="Container"
type="javax.sql.DataSource" maxActive="100" maxIdle="30"
Any help on this issue will be much appreciated.
Actually this looks more like a DBCP problem, the validation/retry should also be done for metadata. Can you show the complete stacktrace, who is calling that method when?
If this is a firewall problem, it might help to specify also maxConnLifetimeMillis=2601000 and make the evisction runs much more often. Both will clean out dead connections faster.
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.