jQuery in Action, 3rd edition
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
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: http://aspose.com/file-tools
subject: Oracle Clob ResultSet Type
It's not a secret anymore!