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

[Felipe Garcia]

Hi,

Thanks for letting me know. What would be the alternatives in this case?
Are there any way of using JDBC and not using extended protocol?

I've justed tested the new pgpool 3.6.0 and the problem persists. Here are
the logs for pgpool
https://gist.github.com/rhossi/8ae15ca541d6699df6c141877a65bd39

Thanks,

Felipe




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


On Mon, Nov 21, 2016 at 1:16 AM, Сергей Мелехин <cpro29a at gmail.com> wrote:

> 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/rh
>> ossi/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/rhos
>> si/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/cfc4e873/attachment.html>