"NzSQLException: The update count exceeded Integer.MAX_VALUE" ERROR only on JDBC connection

Question

When constructing a rather large table in netezza, I get the following ERROR when using a JDBC connection:

org.netezza.error.NzSQLException: The update count exceeded Integer.MAX_VALUE.

The table does get created properly, but the code throws an exception. When I try running the same SQL using nzsql I get:

INSERT 0 2395423258

i.e. no thrown exceptions. It seems the variable storing the count of records in JDBC is not large enough?

Has anyone else encountered this error? How did you deal with it?

Answer 1

Modify your connection string to include ignoreUpdateCount=on as a parameter and try again.