[TeraJDBC 13.10.00.32] [Error 1382] [SQLState HY000] The batch is empty

Connectivity
jld
Enthusiast

[TeraJDBC 13.10.00.32] [Error 1382] [SQLState HY000] The batch is empty

Hi there,

we upgraded from jdbc  12 to 13 (also made some tests with a jdbc 14) and we consistently get this error message

[TeraJDBC 13.10.00.32] [Error 1382] [SQLState HY000] The batch is empty

though for sure the select member executed on another jdbc connection/techno is returning rows.

So, far I did not find a place where the error is listed with cause(s) and/or possible solution

Hence,

this entry in this forum with Questions?

1. where can I find some doc on this?

2. causes ?

Thanks

Rgds

JL D

4 REPLIES
Teradata Employee

Re: [TeraJDBC 13.10.00.32] [Error 1382] [SQLState HY000] The batch is empty

Error 1382 indicates that the Java application called the executeBatch method with an empty batch.

This problem typically occurs due to an application bug such that the application is inserting many rows in a loop, and calling the executeBatch method periodically, but on the final pass through the loop the executeBatch method is called with no rows having been bound.

jld
Enthusiast

Re: [TeraJDBC 13.10.00.32] [Error 1382] [SQLState HY000] The batch is empty

thanks

Noted: application bug

though still a question: anything that can be driven using an url parameter?

rgds

JLD

Teradata Employee

Re: [TeraJDBC 13.10.00.32] [Error 1382] [SQLState HY000] The batch is empty

No, there is no Connection URL parameter to suppress this check.

Any time a Java application calls the executeBatch method for an empty batch, the Teradata JDBC Driver will throw SQLException with error code 1382.

jld
Enthusiast

Re: [TeraJDBC 13.10.00.32] [Error 1382] [SQLState HY000] The batch is empty

thanks.