when i use jdbc connection Teradata(12.0), i get errors "[TeraJDBC 13.00.00.16] [Error 5966] [SQLState HY000]"

Database
Fan

when i use jdbc connection Teradata(12.0), i get errors "[TeraJDBC 13.00.00.16] [Error 5966] [SQLState HY000]"

my Teradata is 12.0 and jdbc version is 13.00.00.16.

when i connetion Teradata by jdbc i get flow exception:

Caused by: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.00.00.16] [Error 5966] [SQLState HY000] Too many data records packed in one USING row.

in jdbc i ues addBatch() and executeBatch().

my record counts about 1000000.
4 REPLIES
Teradata Employee

Re: when i use jdbc connection Teradata(12.0), i get errors "[TeraJDBC 13.00.00.16] [Error 5966] [SQLState HY000]"

The Teradata Database Messages reference says:

5966 Too many data records packed in one USING row.
Explanation: User has defined too many data records in one USING row. The limit is 16383.
Generated By: PAR modules.
For Whom: End User.
Remedy: Correct the request and resubmit it.

The error message means that your application used addBatch to bind too many rows of input values to the PreparedStatement before calling executeBatch.
Fan

Re: when i use jdbc connection Teradata(12.0), i get errors "[TeraJDBC 13.00.00.16] [Error 5966] [SQLState HY000]"

hi, thanks for your help.

i can change this limit to another value?
how i can change this limit value?

thanks/.
Teradata Employee

Re: when i use jdbc connection Teradata(12.0), i get errors "[TeraJDBC 13.00.00.16] [Error 5966] [SQLState HY000]"

You cannot change that Teradata Database limit.
You need to change your application so that it binds fewer rows of data per batch.
Fan

Re: when i use jdbc connection Teradata(12.0), i get errors "[TeraJDBC 13.00.00.16] [Error 5966] [SQLState HY000]"

thanks very much.

i will changes my application limit number.