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

Database
N/A

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.
N/A

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.
N/A

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.