>>>>> "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, considering the problems
that it could cause it's a good discipline.  How knows, maybe some
release of a driver will not like just that.  I'd call this best
practice :)

TY> ----- Original Message ----- From: Allen fogleson
TY> <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>
TY> Sent: Thursday, June 21, 2001 3:44 PM Subject: Re: [JBoss-user]
TY> closing PreparedStatements


>> also I have always closed things in reverse order...... resultset,
>> preparedstatement, connection. it may or may not matter depending
>> on the drivers i guess, but better safe than sorry. amazingly ihave
>> seen problems with oracle and closing connections before resultsets
>> and prepared statements. at least that is all we could ever figure
>> out the problem was.
>> 



TY> _______________________________________________ JBoss-user mailing
TY> list [EMAIL PROTECTED]
TY> http://lists.sourceforge.net/lists/listinfo/jboss-user



-- 
  Nicolai P Guba    http://www.gnu.org         http://www.frontwire.com
                    mailto:[EMAIL PROTECTED]     mailto:[EMAIL PROTECTED]
                    GSM: +44 (0)7909 960 751   DDI: +44 (0)20 7368 9708

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to