File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle Clob ResultSet Type

 
Pearlo Muthukumaran
Ranch Hand
Posts: 79
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
Rgds
Muthu
 
Dana Hanna
Ranch Hand
Posts: 227
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We'd need to see some of the data access code to determine if there are any Threading issues
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic