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
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!