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
this entry in this forum with Questions?
1. where can I find some doc on this?
2. causes ?
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.
Noted: application bug
though still a question: anything that can be driven using an url parameter?
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.