Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc FOR UPDATE clause limitation

 
Steve Dambrosio
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Howdy - love your website... I'm having a problem with a jdbc limitation that is pretty common based on researching other posts; however I haven't been able to find a workaround or solution! Perhaps you can point me to a posting that solves this problem or help me directly. It all started out with this from the Oracle JDBC manual:

FOR UPDATE Clause Limitation in an Updatable Result Set
A query cannot have the FOR UPDATE clause in the SELECT statement if you are
using an updatable result set. If you use the FOR UPDATE clause and try to update a
result set, an SQLException will be thrown.

(BTW, the exception is the mysterious "missing parenthesis" message that you know all too well).

I want to lock a row for the duration of a transaction. The only solution I was able to find was to use a positioned update: UPDATE... WHERE CURRENT OF cursor. That would be perfect and is the technique I use in other languages. But that doesn't work because it's not supported by my driver! Now I'm stuck. What I'm doing is very, very normal and common so there must be a solution. Thanks.





 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic