OracleDataSource.close() and the servlet destroy() method
596844Jan 2 2008 — edited Nov 20 2014I could never get an answer about the importance of the OracleDataSource.close() method, so I assumed that it was a good idea to use it in my servlets. I thought I would be clever and put it in the servlet destroy() methods of our application.
This worked well in Tomcat, but failed in WebLogic. In the WebLogic I would get errors saying that the connection was already closed by OracleDataSource.close() when I tried to use a connection. This might have something to do with the way WebLogic loads and unloads servlets.
Anyway I "solved" the problem by removing the close. Is this OK?