Postgres Pro
Downloads
Home   >   mailing lists

Re: JDBC: ERROR: portal "C_2" does not exist - Mailing list pgsql-jdbc

From Vladimir Sitnikov
Subject Re: JDBC: ERROR: portal "C_2" does not exist
Date
Msg-id CAB=Je-FT2PxtXUYD+ricnfFrOHMtfbXOpjm_8aspd2PQRzBwyA@mail.gmail.com
Whole thread Raw
In response to Re: JDBC: ERROR: portal "C_2" does not exist  (Blake McBride <blake1024@gmail.com>)
List pgsql-jdbc
Tree view
>Just knowing it should work is a big help.

That is true.
The error <<portal "C_2" does not exist>> should not happen in the regular app flow.

The symptom reminds me "do not close refcursor after reading if fetchsize has been set"
so I wonder if the issue reproduces with v42.3.1

We can't heal wong load-balancer configurations at the driver level,
however, we could make the error message easier to understand and diagnose.
I've filed https://github.com/pgjdbc/pgjdbc/issues/2468 for enhancing the user-facing message.

Yet another option to diagnose the issue is to capture trace logs from the driver.

Vladimir

pgsql-jdbc by date:

Previous
From: Blake McBride
Date:
Subject: Re: JDBC: ERROR: portal "C_2" does not exist
Next
From: Blake McBride
Date:
Subject: Re: JDBC: ERROR: portal "C_2" does not exist