All Forums Connectivity
jld@fitc 14 posts Joined 04/12
27 Feb 2013
[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

tomnolan 594 posts Joined 01/08
27 Feb 2013

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@fitc 14 posts Joined 04/12
01 Mar 2013

thanks
Noted: application bug
though still a question: anything that can be driven using an url parameter?
rgds
JLD

tomnolan 594 posts Joined 01/08
01 Mar 2013

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@fitc 14 posts Joined 04/12
04 Mar 2013

thanks.

You must sign in to leave a comment.