en database c3p0

jActiveRecord provides a way to connect database with javax.sql.DataSource connection pool as well.

• open(DataSource pool): Attempts to establish a connection database with pooled data source.

Therefore, jActiveRecord can work with C3P0 data source pool:

ComboPooledDataSource pool = new ComboPooledDataSource();
pool.setDriverClass("org.postgresql.Driver");
pool.setJdbcUrl("jdbc:postgresql:test");
pool.setUser("postgres");
pool.setPassword("password");
pool.setMinPoolSize(20);
pool.setMaxPoolSize(120);
pool.setAcquireIncrement(10);

DB dbo = DB.open(pool);
// Todo

pool.close();