>>>>> "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 != null ){ c.close(); } if( s != null ){ s.close();
>>> } if( r != null ){ s.close(); } } catch( SQLException e ){ throw
>>> new EJBException( "ExtendedJDBC: close: " + e.getMessage() ); } }
>>>
d> You should probably also put a try ... catch block around each
d> close, otherwise it's vaguely possible that an exception thrown by
d> one close method could cause you to not close another object or
d> two.
Cheers muchos. Yeah, that util needs a bit more refining. However,
closing the prep stmt before the conn helped (DUH!). Never mind. I
can always blame it on caffeeine :)
Happy Hacking!
--
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
