- Original Message -
From: "Nicolai P Guba" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 5:02 AM
Subject: [JBoss-user] closing PreparedStatements
> Am I correct in assuming that PreparedStatements are cached/pooled and
&g
> "TY" == Tim Yates <[EMAIL PROTECTED]> writes:
TY> Hooray!! And I was worried that I was just being hopelessly
TY> paranoid ;-)
TY> Thanks for that :-) (I too use Oracle)
He's right. When he pointed that out to me I started closing them in
reverse order. Even if it's a bit paranoid, con
Hooray!!
And I was worried that I was just being hopelessly paranoid ;-)
Thanks for that :-) (I too use Oracle)
Tim.
- Original Message -
From: Allen fogleson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 3:44 PM
Subject: Re: [JBoss-u
> "d" == danch <[EMAIL PROTECTED]> writes:
d> Tim Yates wrote:
>> Wotcha!
>>
>>> That's what I did. Sorry for not supplying the implementation for
>>> that helper. 'ere it is. public static void close( Connection c,
>>> PreparedStatement s, ResultSet
>> r )
>>
>>> { try { if( c != nu
least that is all we could ever figure out the problem was.
al
- Original Message -
From: danch <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 10:02 AM
Subject: Re: [JBoss-user] closing PreparedStatements
> Tim Yates wrote:
>
> > Wot
Tim Yates wrote:
> Wotcha!
>
>
>> That's what I did. Sorry for not supplying the implementation for
>> that helper. 'ere it is.
>>
>> public static void close( Connection c, PreparedStatement s, ResultSet
>
> r )
>
>> {
>> try {
>> if( c != null ){
>> c.close();
>> }
>>
> "TY" == Tim Yates <[EMAIL PROTECTED]> writes:
TY> Wotcha!
Arrrgha!
>> That's what I did. Sorry for not supplying the implementation for
>> that helper. 'ere it is.
>>
>> public static void close( Connection c, PreparedStatement s,
>> ResultSet
TY> r )
>> { try { if( c != null ){ c.clos
Wotcha!
> That's what I did. Sorry for not supplying the implementation for
> that helper. 'ere it is.
>
> public static void close( Connection c, PreparedStatement s, ResultSet
r )
> {
> try {
> if( c != null ){
> c.close();
> }
> if( s != null ){
> s.close();
> }
>
> "TY" == Tim Yates <[EMAIL PROTECTED]> writes:
TY> Hiya! Try:
'ellau!
TY> - Original Message - From: Nicolai P Guba
TY> <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent:
TY> Thursday, June 21, 2001 10:02 AM Subject: [JBoss-user] closing
TY> PreparedStatements
>> finally { Extend
Hiya!
Try:
- Original Message -
From: Nicolai P Guba <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 10:02 AM
Subject: [JBoss-user] closing PreparedStatements
> finally {
> ExtendedJDBC.close( connection, prepStmt, result );
> }
>
Hello JBoss hackers :)
On closing a prepared statement when finished with my queries, I am
getting an exception from the minerva pool.
Am I correct in assuming that PreparedStatements are cached/pooled and
should not be closed?
== LOG
-Selecting
11 matches
Mail list logo