[pgpool-general: 5124] Issue with pgpool 3.5.4 and JDBC

[Felipe Garcia]

I have a pgpool 3.5.4 with memcache enabled, and I use it to connect to
Redshift.

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.

1) Using JDBC with pgpool with caching enabled I get an error

2016-11-15 10:56:27: pid 31043: FATAL:  Backend throw an error message

2016-11-15 10:56:27: pid 31043: DETAIL:  Exiting current session because of
an error from backend

2016-11-15 10:56:27: pid 31043: HINT:  BACKEND Error: "portal "pgpool31043"
does not exist"


2) Using JDBC with pgpool with caching disabled it works

3) Using psycopg2 or psql command line with pgpool with caching either
enabled or disabled it works

Can someone help me understand why only JDBC is not working?


Thanks
Felipe Garcia

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161115/8959c724/attachment.html>