This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization 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