File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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:
subject: Oracle Clob ResultSet Type
jQuery in Action, 3rd edition