You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@xmlbeans.apache.org by Celinio Fernandes <cf...@pagesjaunes.fr> on 2005/08/02 12:03:57 UTC
RE : RE : ORA-01000: maximum open cursors exceeded
Thanks,
That is the information I needed to remember:
"every SQL statement you run against an ORACLE server opens a database
cursor implicitly"
The solution should never be to increase the number of cursors open in
the Oracle server parameters,
that would be a mistake (poor performances, use of a lot memory, etc )
I had not closed the PreparedStatement after executing the request and
that was a mistake (close() ).
That was more some JDBC related stuff than XMLbeans.
Sorry.
-----Message d'origine-----
De : Cordes, Hans-Dieter [mailto:hdcordes@emea.att.com]
Envoyé : mardi 2 août 2005 11:38
À : user@xmlbeans.apache.org
Objet : RE: RE : ORA-01000: maximum open cursors exceeded
Hello Celinio,
I have some ORACLE background, and here is what I would say:
- every SQL statement you run against an ORACLE server
opens a database cursor implicitly
- there is an "OPEN_CURSORS" parameter in the "init.ora"
file that the server uses for its own initialsation;
the default value is 50
- the "OPEN_CURSORS" parameter defines the maximum of open
cursors a given user can have in parallel
- to avoid the given ORACLE error message, you should
ask your ORACLE admin to change the "OPEN_CURSORS"
value in the "init.ora" file (the file name may be
different in your environment!) to a much higher
value, let us say 1000 or so; or ask the admin
for his/her experiences
I hope this will help you with your ORACLE problem.
Regards,
Hans-Dieter Cordes
-----Original Message-----
From: Celinio Fernandes [mailto:cfernandes.externe@pagesjaunes.fr]
Sent: Dienstag, 2. August 2005 11:15
To: user@xmlbeans.apache.org
Subject: RE : ORA-01000: maximum open cursors exceeded
I got my answer, I need to use:
instruction.close();
Still, does anyone know a proper way to do it with Xmlbeans ? Thanks
To : user@xmlbeans.apache.org
Object : ORA-01000: maximum open cursors exceeded
Hi,
I would like to make sure this error has nothing to do with XMLbeans. I
am executing a SELECT query each time I have a father tag, to get
information about him, passing the son and daughter as arguments to the
SELECT query. There are like 1000 fathers, and the maximum open cursors
in Oracle is limited to 50.
</grandfather>
<father>
<son>aaa</son>
<daughter>bbb</daughter>
</father>
<father>
<son>ccc</son>
<daughter>ddd</daughter>
</father>
<father>
<son>eee</son>
<daughter>fff</daughter>
</father>
etc ...
<grandfather>
So, before digging into the JDBC stuff, i would like to make sure: Does
Xmlbeans handle queries differently ? I mean I do not open any cursor
when I execute a SELECT query. So where do these open cursors come from
?
Also, if you know another way to do it, please let me know.
Thanks for your feedback.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@xmlbeans.apache.org
For additional commands, e-mail: user-help@xmlbeans.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@xmlbeans.apache.org
For additional commands, e-mail: user-help@xmlbeans.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@xmlbeans.apache.org
For additional commands, e-mail: user-help@xmlbeans.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@xmlbeans.apache.org
For additional commands, e-mail: user-help@xmlbeans.apache.org
(Date to Date) instead of (Date to String)
Posted by Celinio Fernandes <cf...@pagesjaunes.fr>.
Hi,
Maybe I am missing something, please tell me if this is the case.
I generated the javabean classes using the scomp command, under DOS.
One thing that I do not understand is that it seems it has generated
wrong return types for the getters / setters
for the tags of type Date.
For instance:
<xs:element name="DATE_CREATION" type="Date" minOccurs="0"/>
has generated a getter that returns a String, instead of a date :
String
noNamespace.MPGPVCDocument.MPGPVC.EPJ.IOS.IO.getDATECREATION()
Does anyone have any information regarding this ?
Thanks
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@xmlbeans.apache.org
For additional commands, e-mail: user-help@xmlbeans.apache.org
RE : ORA-01000: maximum open cursors exceeded
Posted by Stuart Charlton <st...@mac.com>.
Just a quick note, I'm a certfied Oracle DBA, and while you should be calling close(), this rarely truly means "close", especially if you're using statement caches (and if you aren't, you probably should :).
In oracle it's most scalable to cache open Statements for as long as possible. Ideally this should be done by the JDBC driver or whatever connection pool infrastructure you have, but you could also do it in your application if you're doing manual connections.
On high volume applications I often set OPEN_CURSORS to upwards of 10000. It's a threshold to prevent runaway apps from killing the database, that's all.
Sorry for the JDBC off topic, but just thought I'd chime in..
Cheers
Stu
On Tuesday, August 02, 2005, at 06:04AM, Celinio Fernandes <cf...@pagesjaunes.fr> wrote:
>Thanks,
>That is the information I needed to remember:
>
>"every SQL statement you run against an ORACLE server opens a database
>cursor implicitly"
>
>The solution should never be to increase the number of cursors open in
>the Oracle server parameters,
>that would be a mistake (poor performances, use of a lot memory, etc )
>
>I had not closed the PreparedStatement after executing the request and
>that was a mistake (close() ).
>That was more some JDBC related stuff than XMLbeans.
>Sorry.
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@xmlbeans.apache.org
For additional commands, e-mail: user-help@xmlbeans.apache.org