It's not only OK - you must do it (the connection returned is a wrapper for a pooled connection and returns it to the pool after the transaction has finished). Furthermore you should check very carefull to close explicitely all created statements, too - some databases will make trouble, otherwise. Regards Jens Stutte > -----Ursprüngliche Nachricht----- > Von: Mikael Stĺldal [mailto:[EMAIL PROTECTED]] > Gesendet am: Freitag, 20. Juli 2001 10:54 > An: Orion-Interest > Betreff: SV: EJB, JDBC and transactions > > > U should manage the JDBC connections as u would do normally. > > And that is? > > Should I do like this in every method? > > { > Connection conn = dataSource.getConnection(); > > // use the connection > > conn.close(); > } > > Is it OK to close() a connection even if the transaction > isn't finished? >
