[pgpool-general: 5135] Re: Python + psycopg2 works. Java with JDBC doesn't
cpro29a at gmail.com
Tue Nov 22 15:53:34 JST 2016
"portal does not exist" hints on some problem with prepared statements.
Can we have a look on your code that does this insert, and pgpool.conf?
С Уважением, Сергей Мелехин.
2016-11-22 7:00 GMT+10:00 Felipe Garcia <felipecpg at gmail.com>:
> 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/
> 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
>>> In the pgpool log, I have this log https://gist.github.com/rh
>>> 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
>>> The code for the Python application
>>> - https://gist.github.com/rhossi/98004f6e62795b67cb84997d8d4d2250
>>> Can someone help me, please?
>>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general