Help!!
I have a java, jsp web application connecting with oracle 9i database. I do the connection with JNDI. It is a data intense application where several queries are made to database and so prepared statements and resultset etc. As soon as the resultset is loaded into an arraylist the resultset, statements and connection are closed. I have gone over and over in the code to see all are closed. But there are inactive sessions left in oracle inspite of the careful closing of all the objects. Does anybody have any clues why this is happening. Help please! I have been wrestling with this problem for too long by myself.
This is my code in server.xml file as to the datasource setting.
Suraj
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/myoracle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:oci8:@mydb</value>
</parameter>
<parameter>
<name>username</name>
<value>user</value>
</parameter>
<parameter>
<name>password</name>
<value>pass</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>20</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>20000</value>
</parameter>
</ResourceParams>