Toggle Current Issue
ID: 1372 Reporter: phoefling
Status:
New New
 Resolution:
unresolved
Category: Orion Reported Version: 2.0.2
Last seen Version: 2.0.2 Fixed Version:
Platform: Other OS: Windows 2000
Java version: 1.5 Severity: normal
Visibility: Public Public
Summary: Oracle 11g select for update query hangs
Description: Using Oracle 11g, the following query never returns:

SELECT xxx FROM foo WHERE Id=yyy FOR UPDATE


Collapse Public phoefling 20090914 11:39:08
Modification: Issue created

Collapse Public dmitrii.cretu 20091105 03:36:08
Modification: Comment added.
Comment: Maybe table xxx is actually blocked by another user and there is no error.

Can you try ("nowait" added):


SELECT xxx FROM foo WHERE Id=yyy FOR UPDATE nowait

Collapse Public dmitrii.cretu 20091105 03:37:07
Modification: Comment added.
Comment: I meant "table foo"

Collapse Public phoefling 20091105 06:51:34
Modification: Comment added.
Comment: We tried nowait, and it failed in a different way. This same code works just fine with oracle 10g and 9i drivers, but fails with the 11g driver. How is Orion handling connection pooling?