<div dir="ltr">"portal does not exist" hints on some problem with prepared statements.<div>Can we have a look on your code that does this insert, and pgpool.conf?</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-22 7:00 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">Hi,<div><br></div><div>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?</div><div><br></div><div>I've justed tested the new pgpool 3.6.0 and the problem persists. Here are the logs for pgpool <a href="https://gist.github.com/rhossi/8ae15ca541d6699df6c141877a65bd39" target="_blank">https://gist.github.<wbr>com/rhossi/<wbr>8ae15ca541d6699df6c141877a65bd<wbr>39</a></div><div><br></div><div>Thanks,</div><div><br></div><div>Felipe</div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><span class=""><br clear="all"><div><div class="m_2482138858542986764gmail_signature" data-smartmail="gmail_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>
<br></span><div><div class="h5"><div class="gmail_quote">On Mon, Nov 21, 2016 at 1:16 AM, Сергей Мелехин <span dir="ltr"><<a href="mailto:cpro29a@gmail.com" target="_blank">cpro29a@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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="m_2482138858542986764m_-633016799277236987gmail_signature" data-smartmail="gmail_signature">С Уважением, Сергей Мелехин.</div></div>
<br><div class="gmail_quote"><div><div class="m_2482138858542986764h5">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></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="m_2482138858542986764h5"><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/c105fdee67b2ae6a0e89a89<wbr>ca0b6971d</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/rh<wbr>ossi/acb85d5d578484c38bf9baccf<wbr>2182213</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/rhos<wbr>si/b10c0cd20ac0284d758da405886<wbr>a0320</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/rhossi<wbr>/98004f6e62795b67cb84997d8d4d2<wbr>250</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_2482138858542986764m_-633016799277236987m_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></div></div>______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">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>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div>