I will consider this option, thanks !

Guillaume de Vinzelles
DSI/PFS Neuf Cegetel
Altran Technologies
 
[EMAIL PROTECTED]
 
01 70 18 21 64

-----Message d'origine-----
De : Mikolaj Rydzewski [mailto:[EMAIL PROTECTED] 
Envoyé : mercredi 11 octobre 2006 16:46
À : Tomcat Users List
Objet : Re: JDBC Pool exhaustion

DE VINZELLES, Guillaume (ext.) wrote:
> finally {
>       try {
>               if (result != null) {
>                       result.close();
>                       result = null;
>               }
>               if (oCmd != null) {
>                       oCmd.close();
>                       oCmd = null;
>               }
>               if (myConnection != null) {
>                       myConnection.close();
>                       myConnection = null;
>               }
>       } catch (SQLException e) {}
> }
>   
You use plain JDBC calls. Have you considered  jakarta commons dbutils 
here? It simplifies a lot: no more need to do nasty finally{} calls.

-- 
Mikolaj Rydzewski <[EMAIL PROTECTED]>


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to