No subject
Mon Aug 23 13:50:29 EDT 2004
objects such as Connections, ResultSets etc so when you open one of =
these it opens a cursor. If you've run out of cursors then it would =
suggest 1 of 2 things:
1) Your environment has genuinely run out of cursors, so you need to =
increase the number in Oracle.
2) A resource leak in OFBiz or JOTM/Tyrex (which are you using?)
The J2EE project we were working on at the time invariably came down to =
number 2 as the cause as it's all to easy to miss a close() statement. =
We only really hit number 1 in the earlier stages of development/testing =
as we ran the heavier routines on the system.
Although initially this was a pain with Oracle, it turned out to be very =
handy for picking up on any leaks. You can have one system monitoring =
the open cursors (sorry can't remember the commands) even listing what =
some of the data was to help you track it back to the actual command and =
then just run a simple test case and check the state of the cursors =
before and after as it should be the same.
What is the current maximum number of cursors set on your database?
If you flush/bounce the database and run the import how high does the =
maximum have to be set before it will complete the import?
If it completes the import how many cursors have been left open?
You could reduce the size of the testing by removing all but one of the =
initial import XML files from commonapp/db and ecommerce/etc.
I hope this is helpful and let us know your findings,
Ray
----- Original Message -----=20
From: Tom Topping=20
To: OFBiz-Users at lists.sourceforge.net=20
Sent: Monday, August 18, 2003 7:23 PM
Subject: [OFBiz-Users]error, while loading org.ofbiz.commonapp.
Hi Andy,
I took ofbiz code from cvs yesterday and configured my oracle database =
in the configuration file.
When I try to load loading org.ofbiz.commonapp from the page=20
http://localhost:8080/webtools/control/main/install. I got following =
error.=20
This was working fine with the ofbiz-2.1.1.
Please let me know your comments.
Thanks,
Tom
=
*************************************************************************=
******************
Error file starts here
org.ofbiz.core.entity.GenericEntityException: while inserting: =
[GenericEntity:CountryCapital][countryCode,HT][co
ital,Port-au-Prince] (SQL Exception while executing the =
following:INSERT INTO COUNTRY_CAPITAL (COUNTRY_CODE, COU
ITAL) VALUES (?, ?) (ORA-01000: maximum open cursors exceeded
))
-------------------------------------------------------------------------=
-----
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
------=_NextPart_000_00AE_01C36640.FDEC2E80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Tom,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>This comment comes from a previous life =
time as=20
I've not used Oracle with OFBiz, and don't have Oracle any more. I guess =
some of=20
this will not be new to you but it will hopefully give others who've not =
used=20
Oracle some understanding.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>F</FONT><FONT face=3DArial size=3D2>rom =
what I remember=20
Oracle cursors are directly related to the JDBC objects such as =
Connections,=20
ResultSets etc so when you open one of these it opens a cursor. =
</FONT><FONT=20
face=3DArial size=3D2>If you've run out of cursors then =
it would suggest 1=20
of 2 things:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>1) Your environment has genuinely =
run out of=20
cursors, so you need to increase the number in Oracle.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>2) A resource leak in OFBiz =
or JOTM/Tyrex=20
(which are you using?)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The J2EE project we were working on at =
the time=20
invariably came down to number 2 as the cause as it's all to easy to =
miss a=20
close() statement. We only really hit number 1 in the earlier stages of=20
development/testing as we ran the heavier routines on the=20
system.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Although initially this was a pain =
with=20
Oracle, it turned out to be very handy for picking up on any leaks. =
You can=20
have one system monitoring the open cursors (sorry can't remember the =
commands)=20
even listing what some of the data was to help you track it back to the =
actual=20
command and then just run a simple test case and check the state of the =
cursors=20
before and after as it should be the same.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>What is the current maximum number of =
cursors set=20
on your database?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>If you flush/bounce the database and =
run the import=20
how high does the maximum have to be set before it will complete the=20
import?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>If it completes the import how many =
cursors have=20
been left open?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>You could reduce the size of the =
testing by=20
removing all but one of the initial import XML files from commonapp/db =
and=20
ecommerce/etc.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I hope this is helpful and let us know =
your=20
findings,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Ray</FONT></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Drk_learn at yahoo.com href=3D"mailto:rk_learn at yahoo.com">Tom =
Topping</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
title=3DOFBiz-Users at lists.sourceforge.net=20
=
href=3D"mailto:OFBiz-Users at lists.sourceforge.net">OFBiz-Users at lists.sourc=
eforge.net</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, August 18, 2003 =
7:23=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [OFBiz-Users]error, =
while=20
loading org.ofbiz.commonapp.</DIV>
<DIV><BR></DIV>
<DIV><FONT size=3D2>
<P>Hi Andy,</P>
<P>I took ofbiz code from cvs yesterday and configured my oracle =
database in=20
the configuration file.</P>
<P>When I try to load loading org.ofbiz.commonapp from the page =
</P>
<P><A=20
=
href=3D"http://localhost:8080/webtools/control/main/install">http://local=
host:8080/webtools/control/main/install</A>.=20
I got following error. </P>
<P>This was working fine with the ofbiz-2.1.1.</P>
<P>Please let me know your comments.</P>
<P>Thanks,</P>
<P>Tom</P>
=
<P>**********************************************************************=
*********************</P>
<P>Error file starts here</P>
<P>org.ofbiz.core.entity.GenericEntityException: while inserting:=20
[GenericEntity:CountryCapital][countryCode,HT][co</P>
<P>ital,Port-au-Prince] (SQL Exception while executing the =
following:INSERT=20
INTO COUNTRY_CAPITAL (COUNTRY_CODE, COU</P>
<P>ITAL) VALUES (?, ?) (ORA-01000: maximum open cursors exceeded</P>
<P>))</P></FONT></DIV>
<P>
<HR SIZE=3D1>
Do you Yahoo!?<BR><A=20
=
href=3D"http://us.rd.yahoo.com/evt=3D10469/*http://sitebuilder.yahoo.com"=
>Yahoo!=20
SiteBuilder</A> - Free, easy-to-use web site design=20
software</BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_00AE_01C36640.FDEC2E80--
More information about the Users
mailing list