Hi,

I am using c3p0 for connection pooling postgres 7.3 DB connections. The connections are obtained from different java processes and use the same c3p0 wrapper library. The DB instance is same for all processes with same username/ password. Following is the configuration:

checkoutTimeout = 300000
debugUnreturnedConnectionStackTraces = true
maxIdleTime = 10
unreturnedConnectionTimeout = 15
driverClass = com.mysql.jdbc.Driver
jdbcUrl = jdbc:postgresql://192.168.12.20:5432/vnet_data_vnet
user = vnet
password = vnet
maxPoolSize= 50
maxStatements = 1000

The problem is that after a while the processes are started I start getting the following error:
Please suggest how it can be resolved.

2009-12-10 17:18:08,936 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] resourcepool.BasicResourcePool     - decremented pending_acquires: 0
2009-12-10 17:18:08,936 DEBUG [RMI TCP Connection(2)-192.168.12.20] dbConnection.DbConnectionPool     - looking for connection pool type:0
2009-12-10 17:18:08,945 DEBUG [RMI TCP Connection(2)-192.168.12.20] resourcepool.BasicResourcePool     - incremented pending_acquires: 1
2009-12-10 17:18:08,945 DEBUG [RMI TCP Connection(2)-192.168.12.20] resourcepool.BasicResourcePool     - incremented pending_acquires: 2
2009-12-10 17:18:08,945 DEBUG [RMI TCP Connection(2)-192.168.12.20] resourcepool.BasicResourcePool     - incremented pending_acquires: 3
2009-12-10 17:18:08,945 DEBUG [RMI TCP Connection(2)-192.168.12.20] resourcepool.BasicResourcePool     - com.mchange.v2.resourcepool.BasicResourcePool@4be2cc config: [start -> 3; min -> 3; max -> 15; inc -> 3; num_acq_attempts -> 30; acq_attempt_delay -> 1000; check_idle_resources_delay -> 0; mox_resource_age -> 0; max_idle_time -> 0; excess_max_idle_time -> 0; destroy_unreturned_resc_time -> 0; expiration_enforcement_delay -> 0; break_on_acquisition_failure -> false; debug_store_checkout_exceptions -> false]
2009-12-10 17:18:08,945 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] resourcepool.BasicResourcePool     - An exception occurred while acquiring a poolable resource. Will retry.
java.lang.NullPointerException
    at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
    at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
    at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
    at java.sql.DriverManager.getDriver(DriverManager.java:253)
    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
    at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)


regards,
Pankaj