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

[Alexander Kandzior]

David,
 
we just updated support for Oracle 8.1.7 in the CVS HEAD. We also did some
testing with Oracle 8.1.7 this week. The JDBC driver used was the old
"classes12.zip" for 8.1.7. 
 
If possible, you could try to check out the version from CVS and see if you
still encounter the open cursor issue with that version. We did not
encounter any issues with Oracle 8.1.7 after the changes where made.
 
If you can't check out from CVS, the next beta 2 version (due in about 6
weeks or so) will have these patches applied.

Best Regards,
Alex.

Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com <http://www.alkacon.com/> 



 


  _____  

From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of David Schnall
Sent: Friday, February 25, 2005 6:57 PM
To: opencms-dev at opencms.org
Subject: [opencms-dev] OCMS 6.0b1 Max open cursors issue on Oracle


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/56284a53/attachment.htm>