wood burning stoves 2.0*
The moose likes JDBC and the fly likes Oracle Clob ResultSet Type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle Clob ResultSet Type" Watch "Oracle Clob ResultSet Type" New topic

Oracle Clob ResultSet Type

Pearlo Muthukumaran
Ranch Hand

Joined: Sep 17, 2002
Posts: 79
Hi all,
I am accessing the CLOB field in a table using the resultset of type ResultSet.TYPE_SCROLL_SENSITIVE. And this bean (simple bean no EJB) is accessed from a servlet. When there is a single client access for servlet, things are working fine. When I simulate a load condition at web tier by creating multiple client threads, the results become erratic and oracle.jdbc.driver.OracleDriver throws exception while scrolling through the resultset.
Though I have fixed the problem by changing the resultset type, I would like to know the reasons behind it.
Could anyone please clarify?
Dana Hanna
Ranch Hand

Joined: Feb 28, 2003
Posts: 227
We'd need to see some of the data access code to determine if there are any Threading issues
I agree. Here's the link: http://aspose.com/file-tools
subject: Oracle Clob ResultSet Type
Similar Threads
clobResultSet.next() throws error
How to use oracle 9.2 driver for oracle817's CLOB?
Converting a String to Clob for insert into DB
use of CLOB,help me.
updating a CLOB field using oracle