JDBC Error - Buffer is full

Moderator: NorbertKrupa

Post Reply
beth
Intermediate
Intermediate
Posts: 58
Joined: Tue Oct 01, 2013 12:42 pm

JDBC Error - Buffer is full

Post by beth » Fri Feb 21, 2014 5:55 pm

Has anyone experienced the following error with a JDBC connection to Vertica? If so, how did you fix it?

java.sql.SQLException: [Vertica][VJDBC](100102) Statement "SELECT COUNT(1) FROM store_bld.store_bld WHERE store_key = ?" cannot execute because the driver has not finished reading the current open ResultSet. The driver cannot finish reading the current ResultSet because its buffer (8192 bytes) is full. The current ResultSet must be fully iterated through or closed before another statement can
execute.

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: JDBC Error - Buffer is full

Post by NorbertKrupa » Fri Feb 21, 2014 6:07 pm

Have you looked at any of the results from Google?
Hi Raj, Vertica does not support multiple cursors. You'll need to either read the result sets in one at a time, or open multiple connections. Please see the JDBC documentation for further details.
Checkout vertica.tips for more Vertica resources.

beth
Intermediate
Intermediate
Posts: 58
Joined: Tue Oct 01, 2013 12:42 pm

Re: JDBC Error - Buffer is full

Post by beth » Fri Feb 21, 2014 6:53 pm

HI,

Yes, I read those links. So, do you think that I am not closing a result set before trying to read another? Hmm. That must be what I am doing. I will take a look at the process again. This is something I am doing in a product called Talend.

Thanks for your assistance.

Post Reply

Return to “JDBC”