The PostgreSQL JDBC Driver is now PgBouncer compliant

Three years ago a discussion was launched on the Pgbouncer mailing-list [1] about the JDBC Driver which does not disable prepared statements when using ?prepareThreshold=0 in the connection string.

At Clever Cloud, we provide PostgreSQL databases behind PgBouncer to handle pools of connections. And to optimize these pools, we use the transaction pooling mode. This mode will prevent clients from using prepared statements as the session is only used for one transaction.

To be able to use this mode internally we manually applied a patch to the driver. After 8 months of inactivity, the pull-request [2][3] was finally merged into the master branch of the driver.

Now we hope that the next version will be released soon.

References:

[1] http://lists.pgfoundry.org/pipermail/pgbouncer-general/2010-February/000507.html [2] https://github.com/pgjdbc/pgjdbc/pull/9 [3] https://github.com/pgjdbc/pgjdbc/pull/58

Blog

À lire également

Why we (finally) built our own managed Kubernetes

At Clever Cloud, we held off for a long time before offering a managed Kubernetes service. Not out of technological reluctance, Kubernetes is a great tool… but it was never designed to make developers’ lives easier.
Company Engineering

What is cloud migration?

Cloud migration represents a strategic step for organisations looking to transform their digital infrastructure.
Engineering

Clever Cloud at VivaTech 2025: demonstration of Clever AI, new partnerships and support for startups

At VivaTech 2025, Clever Cloud is highlighting a number of strategic announcements and innovations in line with its vision of a sovereign, open and resilient cloud. The team will be present in various pavilions, unveiling Clever AI for the first time, presenting a partnership with Grist, an open source data platform, signing a partnership for development in North Africa and stepping up its support for the startup ecosystem.
Company