[opencms-dev] OCMS 6.0b1 Max open cursors issue on Oracle

David Schnall dschnall at bobex.com
Fri Feb 25 18:57:09 CET 2005


Hello,
 
I am testing opencms 6.0beta1 with a target installation on Oracle 8.1.6
with Oracle jdbc driver 9.0.14 (latest one supporting Oracle 8.1.6).
Platform: Tomcat 5.5.7, JDK 1.4.2_06
 
I've removed the 3 WAIT 10 in FOR UPDATE queries in queries.properties to
make the SQL compatible with Oracle 8
 
Set-up runs fine until the workspace import (Step 8) starts where ORA-1000
(max open cursors) are generated after some time. 
Any idea where I should look for statements that might not be closing
(probably in a loop). 
Issue is the same as discussed in mail-archive of August 9 2004 'Oracle -
Open Cursors issue'
 
Increasing the number of allowed OPEN_CURSORS is not the answer I am looking
for  :-) 
 
Thanks
 
David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050225/a6292972/attachment.htm>


More information about the opencms-dev mailing list