Re: Connection pooling in java

["Ido M. Tamir" <tamir(at)imp(dot)univie(dot)ac(dot)at>]

On Friday 22 December 2006 09:02, janaka priyadarshana wrote:


http://www.mchange.com/projects/c3p0/index.html

c3p0 was designed to be butt-simple to use. Just put the jar file 
[lib/c3p0-0.9.0.jar] in your application's effective CLASSPATH, and make a 
DataSource like this: 

import com.mchange.v2.c3p0.*;
        
...
        
ComboPooledDataSource cpds = new ComboPooledDataSource();
cpds.setDriverClass( "org.postgresql.Driver" ); //loads the jdbc driver            
cpds.setJdbcUrl( "jdbc:postgresql://localhost/testdb" );
cpds.setUser("dbuser");                                  
cpds.setPassword("dbpassword");                                  
      
[Optional] If you want to turn on PreparedStatement pooling, you must also set 
maxStatements and/or maxStatementsPerConnection(both default to 0): 

cpds.setMaxStatements( 180 );                                  
      
 Do whatever you want with your DataSource, which will be backed by a 
Connection pool set up with default parameters. You can bind the DataSource 
to a JNDI name service, or use it directly, as you prefer. 
 When you are done, you can clean up the DataSource you've created like this: 

DataSources.destroy( cpds );
      
 That's it! The rest is detail. 

hth
ido