• Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL Exceptions  RSS feed

 
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My application is running in Websphere 5 and DB is Oracle 9.2.04. I am seeing following exceptions very irregularly.
=========================================================
java.sql.SQLException: Refcursor value is invalid
[4/2/04 13:10:07:609 CST] 6eda6eda StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode 17,002 and SQLState <null>, to a StaleConnectionException: java.sql.SQLException: Io exception: Protocol violation
java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv
=========================================================
Occurance of these exceptions are very random. For same resultset it may appear or may not.
Could someone please tell me if this DB problem or JDBC problem(Java)?
Thanks,
 
author & internet detective
Marshal
Posts: 37693
575
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sanjeev,
The key here is that it is a stale connection exception. It is happening intermittently on the first access after a while. You can fix this, by trying again (manually or pragmatically) when it happens. The second attempt will usually go through.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!