Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBCP Logging doesn't work

843841Feb 3 2005 — edited Oct 10 2005
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2005
Added on Feb 3 2005
2 comments
454 views