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

[Сергей Мелехин]

"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>:

> 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/20161122/883d230f/attachment.html>