<div dir="ltr">Hi, Felipe!<div>JDBC (and py-postgresql) uses so called extended protocol, while psycopg uses generic one.</div><div>Anyway it would be helpful to see pgpool.log. This traceback and error message do not have enough details about error.</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature">С Уважением, Сергей Мелехин.</div></div>
<br><div class="gmail_quote">2016-11-21 1:02 GMT+10:00 Felipe Garcia <span dir="ltr"><<a href="mailto:felipecpg@gmail.com" target="_blank">felipecpg@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">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.<div><br></div><div>The Java app using JDBC, doesn't work. It gives me the following error <a href="https://gist.github.com/rhossi/c105fdee67b2ae6a0e89a89ca0b6971d" target="_blank">https://gist.github.com/<wbr>rhossi/<wbr>c105fdee67b2ae6a0e89a89ca0b697<wbr>1d</a></div><div><br></div><div>In the pgpool log, I have this log <a href="https://gist.github.com/rhossi/acb85d5d578484c38bf9baccf2182213" target="_blank">https://gist.github.com/<wbr>rhossi/<wbr>acb85d5d578484c38bf9baccf21822<wbr>13</a></div><div><br></div><div>I've wrote a Python application using the package psycopg2 (which uses libpq), and with this program I am able to successfully connect.</div><div><br></div><div>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.</div><div><br></div><div>The code for the Java Application - <a href="https://gist.github.com/rhossi/b10c0cd20ac0284d758da405886a0320" target="_blank">https://gist.github.com/<wbr>rhossi/<wbr>b10c0cd20ac0284d758da405886a03<wbr>20</a></div><div><br></div><div>The code for the Python application</div><div>- <a href="https://gist.github.com/rhossi/98004f6e62795b67cb84997d8d4d2250" target="_blank">https://gist.github.com/<wbr>rhossi/<wbr>98004f6e62795b67cb84997d8d4d22<wbr>50</a><br></div><div><br></div><div>Can someone help me, please?</div><div><br></div><div>Thanks,</div><div><br clear="all"><div><div class="m_5810892696382596513gmail_signature"><div dir="ltr">Felipe Garcia<div><a href="tel:%2B55%20%2811%29%2098899-6065" value="+5511988996065" target="_blank">+55 (11) 98899-6065</a><br><div><div><font size="1" color="#999999">Aviso: Geralmente, email é a melhor forma de me encontrar. Eu tentarei responder a sua mensagem o mais rápido possível.</font></div><div><span style="background-color:rgb(255,255,255)"><font size="1" color="#999999">Note: Generally, email is the best way to reach me. I will respond to your message as soon as possible</font></span><br></div><div><font size="1" color="#444444"><br></font></div></div></div></div></div></div>
</div></div>
<br>______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>