This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

select for update --> OCI8 driver

 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can anyone give me some insight on this(second hand info, so it may be vague):
We have written an java program that accesses an Oracle DB using the thin drivers. We now have to move our program (that used to be limited to our network) to remote locations. To do this we needed to switch to the OCI8 drivers to deal with the firewall/security issues. After changing the drivers to OCI, our program started locking up for no apparent explainable reason. At the time, we were testing within the network. The procedure that seems to be locking it is "select...for update". No Exceptions are thrown, it just locks. Our DBA verified that the record was NOT locked at the time of hanging(so it wasn't waiting for a lock to be released).
some hypothesis to help me investigate this matter would be helpful. The more details I get, I'll relay them to you.
Thanks,
Jamie
 
Daniel Dunleavy
Ranch Hand
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If it was waiting for a lock to be set, I believe there is a parameter in Oracle which sets the amount of time to wait for a lock before failing.
Dan
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
we have just solved the problem. We were using an older driver version of classes12.zip for the OCI driver. Once we updated it to a newer version, everything worked fine.
Thanks for the reply Dan,
Jamie
I hate incompatiblility errors! I have been looking at the code for 2 days now! Oh well, at least I will sleep well this weekend!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic