All Forums Database
jliu 4 posts Joined 09/10
18 Sep 2010
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.

tomnolan 594 posts Joined 01/08
20 Sep 2010

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.

jliu 4 posts Joined 09/10
21 Sep 2010

hi, thanks for your help.

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

thanks/.

tomnolan 594 posts Joined 01/08
21 Sep 2010

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

jliu 4 posts Joined 09/10
24 Sep 2010

thanks very much.

i will changes my application limit number.

You must sign in to leave a comment.