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

Сергей Мелехин cpro29a at gmail.com
Mon Nov 21 12:16:13 JST 2016


Hi, Felipe!
JDBC (and py-postgresql) uses so called extended protocol, while psycopg
uses generic one.
Anyway it would be helpful to see pgpool.log. This traceback and error
message do not have enough details about error.

С Уважением, Сергей Мелехин.

2016-11-21 1:02 GMT+10:00 Felipe Garcia <felipecpg at gmail.com>:

> 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
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161121/4d378556/attachment.html>


More information about the pgpool-general mailing list