We have been running into a difficult exception while using the MS SQL Server JDBC driver and the execSQL service. It appears that there may be some thread safety and/or other incompatibilities with this driver, execSQL, and/or the connection pool.
The exception thrown by the JDBC driver is called “Object has been closed”. This exception means that something, or some thread has “closed” the object before it finished. This error occurs often but is very difficult to reproduce in a development environment. We notice it on a number of different calling services that are running concurrently (e.g. 2 different services may be calling the same execSQL at the same time). Again, it is not easy to reproduce. I scheduled 3 different services to run every second on the development server. These services all wind up calling the same execSQL. After about 20 mins I managed to create one “closed socket” exception … after about 4 hours … I managed to create a few of the “Object has been closed” exceptions.
Has anyone run into something similar? TIA for replies.