JDBC: ERROR: portal "C_2" does not exist

From: Blake McBride <blake1024(at)gmail(dot)com>
To: pgsql-jdbc(at)lists(dot)postgresql(dot)org
Subject: JDBC: ERROR: portal "C_2" does not exist
Date: 2022-03-11 18:07:09
Message-ID: CABwHSOsgSDc=9eSQThjthe0AwECQzPn4pBSeQ6vcoTfL5b058Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Greetings,

When I do a resultSet.next(), I am getting an exception: ERROR:
portal "C_2" does not exist

The facts:

64-bit Linux
JDK 1.8.0_322
postgresql-42.3.3.jar
psql (PostgreSQL) 14.2

conn.setAutoCommit(false);

PreparedStatement pstat = conn.prepareStatement(sql);

pstat.setFetchSize(50);

I do a query that will have thousands of records. I get the first 50
just fine. When I do:

rset.next() the 51st time, I get an exception: ERROR: portal "C_2"
does not exist

There is no C_2 anywhere in my code or query.

Sure appreciate any help!

Thanks!

Blake McBride

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Sehrope Sarkuni 2022-03-11 19:04:21 Re: JDBC: ERROR: portal "C_2" does not exist
Previous Message Sehrope Sarkuni 2022-03-11 16:46:32 Re: JDBC prepared statement: a 32767 limit of arguments number