[pgpool-general: 2378] Re: Error when use pgpool2 with JDBC

Lachezar Dobrev l.dobrev at gmail.com
Tue Jan 7 19:46:33 JST 2014


  Denis,
  Could you share the way your JDBC Pool is set up? Do you use
Tomcat's pooling? It might be something specific there.
  What's the URL you're using, does it have any parameters (omit
security configuration).
  Google-ing this one shows some references to some decisions in 2009…

  As far as I can tell the query is executed by the JDBC Driver if the
data base is version 9.0 or newer:
   org.postgresql.core.v3.ConnectionFactoryImpl.java#runInitialQueries(...)

  It seems the driver sets the extra_float_digits to 2 in the start-up
packet, and then after connecting (and getting the actual version)
tries to increase it if the database is version 9.0 or newer.


More information about the pgpool-general mailing list