user1591668 user1591668 - 1 year ago 95
Java Question

JDBC and pgbouncer can they work with createStatement

I have learned that JDBC

and PGBouncer can not work together because
uses session pooling and is pre-compiled and PGbouncer uses transactional level pooling.

My question is can
be used with PGBouncer since it is not pre-compiled? and if not can someone point me to another Java api that can connect to the database and can use PGbouncer?

Jan Jan
Answer Source

PgBouncer FAQ states that while it does not support PreparedStatements to be pooled, you can disable them by adding parameter prepareThreshold=0 into the JDBC connect URL.

This way you keep the benefits of PreparedStatement for other databases you might connect to in the future but still have a working connection through PgBouncer.