<div dir="ltr">I have a pgpool 3.5.4 with memcache enabled, and I use it to connect to Redshift.<div><br></div><div>I wrote two simple programs, one in Java (JDBC postgresql-9.4.1212.jre6.jar) and another one in Python (using psycopg2 postgres package) that just connects to pgpool, and execute a simple query (eg: select * from customer limit 10;) and I've noticed strange and different behaviors. I also ran the queries using the command line tool psql.</div><div><br></div><div>1) Using JDBC with pgpool with caching enabled I get an error</div><div>
<p class="gmail-p1"><span class="gmail-s1">2016-11-15 10:56:27: pid 31043: FATAL: Backend throw an error message</span></p>
<p class="gmail-p1"><span class="gmail-s1">2016-11-15 10:56:27: pid 31043: DETAIL: Exiting current session because of an error from backend</span></p>
<p class="gmail-p1"><span class="gmail-s1">2016-11-15 10:56:27: pid 31043: HINT: BACKEND Error: "portal "pgpool31043" does not exist"</span></p><p class="gmail-p1"><span class="gmail-s1"><br></span></p><p class="gmail-p1"><span class="gmail-s1">2) Using JDBC with pgpool with caching disabled it works</span></p><p class="gmail-p1"><span class="gmail-s1">3) Using psycopg2 or psql command line with pgpool with caching either enabled or disabled it works</span></p><p class="gmail-p1"><span class="gmail-s1">Can someone help me understand why only JDBC is not working?</span></p><p class="gmail-p1"><span class="gmail-s1"><br></span></p><p class="gmail-p1"><span class="gmail-s1">Thanks</span></p></div><div><div><div class="gmail_signature"><div dir="ltr">Felipe Garcia<div><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>