i posted this request about a week ago, and would like to know any
developers thoughts on this. to summerize, i'd like to be able to force a
datasource to timeout any connections in the pool after a period of time.
we're running jboss 3.0.6 with oracle 8i and right now and we're constantly
I'd rather figure out what is causing the problem. Does cursor == open
statement? Open resultset? Are you using cmp? If bmp are you closing
everything in finally blocks?
A known problem is that the jca-jdbc wrappers don't track open statements
for you and close them when you close the connection
Bill Burke wrote:
I am not sure I understand your problem. In RFE you are saying
cached prepared statements stay alive and cause this error.
What caches prepared statements? Did you explicitly enabled
statement caching on oracle connections?
I remember seeing this error message but it turned
the oracle tables you mentioned
to see if i can get some more information.
thank you all again for your replies!
Ryan
-Original Message-
From: Igor Fedorenko [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 12:56 PM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-dev] jbosscx rfe 677512
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
Sonnek, Ryan
Sent: Monday, February 17, 2003 4:42 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [JBoss-dev] jbosscx rfe 677512
thank you all for your reply, i'll try and clear some things up for all
On Monday, February 17, 2003, at 05:21 PM, Timothy Barreto wrote:
try { ...
} finally {
try { rs.close(); rs=null;
stmt.close(); stmt=null;
} catch (Exception e){}
}
You need to put rs.close() and stmt.close() in different try blocks.
If rs.close() throws an exception