tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "DE VINZELLES, Guillaume \(ext.\)" <Guillaume.DEVINZELLES.prestata...@neufcegetel.fr>
Subject RE: JDBC Pool exhaustion
Date Wed, 11 Oct 2006 14:51:26 GMT
I will consider this option, thanks !

Guillaume de Vinzelles
DSI/PFS Neuf Cegetel
Altran Technologies
 
guillaume.devinzelles@neufcegetel.fr
 
01 70 18 21 64

-----Message d'origine-----
De : Mikolaj Rydzewski [mailto:miki@ceti.pl] 
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 <miki@ceti.pl>


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


Mime
View raw message