CODEWITHSUNDEEP
postgresqlspring-bootconnection-poolingpgbouncer
Illia
Illia

Reputation: 158

How to connect in spring boot to PGbouncer?

I'm tring to connect my spring boot app to PGbouncer connection pool on digital ocean cloud. But I get the error "prepared statement "S_1" already exists". As I understand the issue is Hikari connection pool. Should I turn it off? If yes how to do it? Or maybe exists some other solution?

Upvotes: 0

Views: 1888

Answers (1)

Illia
Illia

Reputation: 158

Add the parameter 'prepareThreshold=0' to connection string fixed problem.

Upvotes: 2

Related Questions