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]
