Connection leak

[praveen kumar soni]

Hello ,

i am using weblogic8.1SP3 , i am having a arch of DAO's , from where i call the database , i am using connection pooling of weblogic , but suddenly i am getting an exception which says , the follwoing ..

<Sep 23, 2005 6:21:34 PM GMT+05:30> <Warning> <JDBC> <BEA-001074> <A JDBC pool connection leak was detected. A connectio
n leak occurs when a connection obtained from the pool was not closed explicitly by calling close() and then was dispose
d by the garbage collector and returned to the connection pool. The following stack trace at create shows where the leak
ed connection was created. [Null exception passed, creating stack trace for offending caller]
at weblogic.utils.StackTraceUtils.throwable2StackTrace(StackTraceUtils.java:28)
at weblogic.jdbc.wrapper.JTSConnection.finalizeInternal(JTSConnection.java:115)
at weblogic.jdbc.wrapper.JTSConnection_oracle_jdbc_driver_T4CConnection.finalize(Unknown Source)
at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)
>

can someone help , i have tried all options , and used all the startup options of weblogic, is there a patch which can atleast give me full stack trace ! as to where the exception started from ....

thanx in advance

[ankush purwar]

Check whether you are closing the connection at right time or not.
I mean it might be possible that you are closing connection after transaction commited.

[Santosh Maskar]

here is the simillar problem along with the solution

http://forums.bea.com/bea/message.jspa?messageID=202174580&tstart=0

this might help you

Thanks,
Santosh