<!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 5.50.4937.800" name=GENERATOR></HEAD>
<BODY>
<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></BODY></HTML>