Hi there,
i defined a data source in server.xml and a reference in the web.xml.
I do a lookup and connect to the data base. "logAbandoned" is set to true. But where can i find the logging messages?
<ResourceParams name="jdbc/DB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>5</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
<!-- Ende -->
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:oci8:@...</value>
</parameter>
<parameter>
<name>username</name>
<value>user</value>
</parameter>
<parameter>
<name>password</name>
<value>pw</value>
</parameter>
<!--<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>-->
</ResourceParams>
Context ctx = new InitialContext();
Context env = (Context) ctx.lookup("java:comp/env/");
Object ds = env.lookup("jdbc/DB");
try
{
Connection c = ((DataSource) ds).getConnection();
Connection c2 = ((DataSource) ds).getConnection();
System.out.println("con: " + c);
System.out.println("con2: " + c2);
c2.close();
System.out.println("c2 close");
}
catch (Exception e_Exc)
{
e_Exc.printStackTrace();
}
Everything works fine, i can connect to the db. But with not closing a connection shouldn't there a log entry be made? i can't find any!?
'removeAbandonedTimeout' says to remove abonded connections after 5 secondes AND make a log entry?
i'm using tomcat 4.1.3. Thanx in advance.
Tim