Clob Ora11g jdbc6 jar
895132Oct 18 2011 — edited Jan 23 2012---------
JAVA
---------
Initially our Java servlet used ojdbc4.jar to connect to oracle database . After migrating to Oracle 11g database, we are facing difficulties to read clob data returned from a oracle function. This was working fine in the previous DB versions.
We later decided to use ojdbc6.jar to connect to Oracle 11g database but that didn't help either.
The challenge is we were able to read clob data only upto a certain length using substring say around 4000 characters. If we try to read a entire clob data to its length the DB connection gets closed.
---------
TOAD
---------
We got the same issue "Connection Closed" issue when running a direct SQL using TOAD Oracle Client.
I'm pretty sure the stored procedure works good as i'm able to query its length. I believe the problem lies within the clob serialization part by JDBC drivers.
Any help is much appreciated!!!
P.S: The oracle DB is located remotely and we usually establish VPN tunnel to connect to the Oracle DB instance for Java Servlet to communicate.
Thank You
Shashi