I have an application server (WebSphere) doing connection pooling with a max limit of 30 connections. My database is Oracle 9i. When I run a program through the application server, I get the following error: "ORA-00018:maximum number of sessions exceeded."
I am being very careful in closing all the PreparedStatements, CallableStatements, ResultSets and Connections in the program.
I will be very thankful if you can figure what the problem is.
This was first published in December 2006