[pgpool-general: 5128] Python + psycopg2 works. Java with JDBC doesn't

[Felipe Garcia]

I set up a pgoool (3.5.4) environment using the standard
pgpool.conf.sample-replication configuration, and I was using a Java
application to connect to it.

The Java app using JDBC, doesn't work. It gives me the following error
https://gist.github.com/rhossi/c105fdee67b2ae6a0e89a89ca0b6971d

In the pgpool log, I have this log
https://gist.github.com/rhossi/acb85d5d578484c38bf9baccf2182213

I've wrote a Python application using the package psycopg2 (which uses
libpq), and with this program I am able to successfully connect.

Most strange is, I think there might be a bug in pgpool. If I start pgppool
and run the Java application, I get the error above. But If I start pgpool,
and run the Python app a couple of times, and then run the Java app, the
Java app works.

The code for the Java Application -
https://gist.github.com/rhossi/b10c0cd20ac0284d758da405886a0320

The code for the Python application
- https://gist.github.com/rhossi/98004f6e62795b67cb84997d8d4d2250

Can someone help me, please?

Thanks,

Felipe Garcia
+55 (11) 98899-6065
Aviso: Geralmente, email é a melhor forma de me encontrar. Eu tentarei
responder a sua mensagem o mais rápido possível.
Note: Generally, email is the best way to reach me.  I will respond to your
message as soon as possible
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161120/b49a6818/attachment.html>