Hi,
I assumed that prepared statements were being cached as stated
in original e-mail. In such setup, raising the setup is usually
necessary for any larger application. If one has a bug in code
this of course will not solve the problem.
Ari S.
----- Original Message -----
From: [EMAIL PROTECTED]
To: jBoss
Sent: 20. marraskuuta 2000 15:09
Subject: Re: [jBoss-User] Max open cursors problem using oracle db
Raising the Max open cursors may not be solving the real problem. Check your
code and make sure you are closing the prepared statements that you are
using. If you do ot do this and then close the connection you leave
reasources open on the Oracle server. Also, you shouldn't reuse a prepared
statement again until after you have closed it first. In a connection pooled
environment, not closing the connections resources before calling close on
the connection leaves the resources open on the db server because
technically the connection is not closed just returned to the pool.
John Kidd
"Ari Suutari" <[EMAIL PROTECTED]>
Sent by: <[EMAIL PROTECTED]>
11/20/2000 05:22 AM
Please respond to "jBoss"
To: "jBoss" <[EMAIL PROTECTED]>
cc:
Subject: Re: [jBoss-User] Max open cursors problem using
oracle db
Hi,
Or set OPEN_CURSORS=larger value. The initial default
is usually quite small.
Ari S.
----- Original Message -----
From: "Shahar Solomianik" <[EMAIL PROTECTED]>
To: "'jBoss'" <[EMAIL PROTECTED]>
Sent: 20. marraskuuta 2000 12:30
Subject: RE: [jBoss-User] Max open cursors problem using oracle db
> Hi Tilmann.
>
> The max open cursors in Oracle db is a "known" performance issue - Oracle
> actually doesnt close the cursors (even when you call close()) but caches
> them.
> To really close the cursors, you must supply an init parameter in
> initxxx.ora :
>
> CLOSE_CACHED_OPEN_CURSORS = TRUE
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Tilmann Ludwig
> Sent: Monday, November 20, 2000 12:13 PM
> To: 'jboss-user'
> Subject: [jBoss-User] Max open cursors problem using oracle db
>
>
> I'm still getting the max open cursors problem, using an oracle db and
JBOSS
> 2.0 FINAL.
> Is there a way, to configure the caching of prepared statement through
> jboss.jcml (Marc Fleury
> wrote, that this would be possible ind JBOSS FINAL).
>
> Thanx
>
> Tilmann
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
