>>>>> "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