<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=170310018-25022005><FONT face=Arial
color=#0000ff size=2>David,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=170310018-25022005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=170310018-25022005>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. </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=170310018-25022005></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=170310018-25022005>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.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=170310018-25022005></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=170310018-25022005>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.</SPAN></FONT></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Best Regards,<BR>Alex.<BR><BR>Alexander Kandzior<BR>Alkacon
Software - The OpenCms Experts<BR><A
href="http://www.alkacon.com/">http://www.alkacon.com</A><BR><BR></FONT></P>
<DIV> </DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org] <B>On Behalf Of </B>David
Schnall<BR><B>Sent:</B> Friday, February 25, 2005 6:57 PM<BR><B>To:</B>
opencms-dev@opencms.org<BR><B>Subject:</B> [opencms-dev] OCMS 6.0b1 Max open
cursors issue on Oracle<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>
<DIV><FONT face=Arial size=2><SPAN
class=893203117-25022005>Hello,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=893203117-25022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=893203117-25022005>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).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=893203117-25022005>Platform: Tomcat
5.5.7, JDK 1.4.2_06</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=893203117-25022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=893203117-25022005>I've removed the 3
WAIT 10 in FOR UPDATE queries in queries.properties to make the SQL compatible
with Oracle 8</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=893203117-25022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=893203117-25022005>Set-up runs fine
until the workspace import (Step 8) starts where ORA-1000 (max open cursors)
are generated<SPAN class=073515417-25022005> after some time</SPAN>.
</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=893203117-25022005>Any idea where I
should look for statements that might not be closing (probably in a
loop). </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=893203117-25022005>Issue is the same
as discussed in mail-archive of August 9 2004 'Oracle - Open Cursors
issue'</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=893203117-25022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=893203117-25022005><SPAN
class=073515417-25022005>Increasing the number of allowed OPEN_CURSORS is not
the answer I am looking for :-) </SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=893203117-25022005><SPAN
class=073515417-25022005></SPAN></SPAN></FONT><FONT face=Arial size=2><SPAN
class=893203117-25022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=893203117-25022005>Thanks</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial
size=2>David</FONT></DIV></DIV></BLOCKQUOTE></BODY></HTML>