Java Database Connectivity (JDBC)

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!

Memory leakage issue while using PreparedStatement

693212Mar 27 2009 — edited Dec 4 2009

Hello,

I am facing one problem of generating heap dump on was server and after analysing it has been observed oracle.jdbc.driber.TC4PreparedStatement holding the maximum size in memory almost one third of total allow in max heap size of jvm.

Driver name: ojdbc14.jar

version: 10.1.0.4.2

i went through on oracle site and found below known issue/limitation, please provide any solution for same.

Refer below url for above issue:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_readme101020.html

Some memory Leak when using PreparedStatement with tables
containing large char or varchar column. The problem can be
worked around by enabling statement caching

If any patch regarding same has been released kindly help me in this.

Thanks

Bineet

Edited by: user7654817 on Mar 29, 2009 8:32 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 1 2010

Added on Mar 27 2009

#java-database-connectivity-jdbc

3 comments

3,064 views