The Vertica Database Forums

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.

Have you looked at any of the results from Google?

• JDBC driver buffer (8192 bytes) is full, cant have two resultsets open at the same time.

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.

• Vertica connection to remote cluster hangs.
• vertica - query max results set to 20 generates warning

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.