I have a JSP application which uses the JRun connection pooling, by
requesting a connection from the Datasource.
After use, the ResultSet, Statement/PreparedStatement and Connection
objects are closed by calling the close() method, so it should return to
the pool.
However, every time I open a JSP page, it is not using free connections
from the connection pool, but opening a
new connection every time (I can see that in the Oracle process list). So
after several pages, Oracle throws an error
saying it has reached its 50 process maximum.
I am using JRun 3.0/3.1 on Linux connecting to an Oracle 8.1.6 server using
the Oracle Thin JDBC drivers.
Note: the ResultSet is dispatched to the JSP page and we close all the db
resources after looping through the ResultSet.
Regards,
Andrew Stobbe
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
