commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Juozas Baliuka" <>
Subject Re: DBCP validation query: how to use?
Date Sun, 09 Jun 2002 07:34:36 GMT
 I think you need to enable "ping" in configuration.
But you can solve this in postgres :
1. use BYTEA type for bynary strings.
2. check the last driver version, I am not sure it is fixed in the last
versoin, but it
is no problems to fix it, driver is open source. Current "STABLE" version
has this bug.
Escape table you can find in user's guide.

> I'm using the latest DBCP release to create a Datasource as follows,
> against a PostgreSQL database:
> Class.forName("org.postgresql.Driver");
> ObjectPool connectionPool = new GenericObjectPool(null);
> ConnectionFactory connectionFactory = new
> DriverManagerConnectionFactory("jdbc:postgresql://localhost/mydb",
> "bryan", "nopw");
> String validationQuery = "select 1 as test";
> PoolableConnectionFactory poolableConnectionFactory = new
> PoolableConnectionFactory(connectionFactory, connectionPool, null,
> validationQuery, false, true);
> dataSource = new PoolingDataSource(connectionPool);
> I'm chasing down a different bug which is hosing my postgres connections
> - trying to insert strings into TEXT fields, which contain nulls.
> Evidently Postgres doesn't like that, and hoses the connection.
> But, according to how I've initialized the pool (above), should DBCP be
> testing my connections with my validation query, noticing my hosed
> connections, and creating new ones for me? Observed behavior indicates
> otherwise... It keeps resuing the hosed connection to future calls of
> dataSource.getConnection(), throwing off future executing code.
> Am I doing something wrong?
> Thank you,
> Bryan

To unsubscribe, e-mail:   <>
For additional commands, e-mail: <>

View raw message