What does this BatchUpdateException mean?

java exception sqlexception batch-updates
Björn Lindqvist picture Björn Lindqvist · Mar 15, 2011 · Viewed 9.4k times · Source

I'm getting this BatchUpdateException from a stmt.executeBatch() statement:

BatchUpdateException: A resultset was created for update

The internet does not have any information on this exception message. What does it mean? The traceback doesn't contain anything useful other than that a stored procedure failed.

Answer

Joachim Sauer picture Joachim Sauer · Mar 15, 2011

I'd interpret the message as meaning that an SQL statement that you added via addBatch() has produced a ResultSet, meaning that it's not your normal INSERT, UPDATE or DELETE statement.

Statements that should return results can't be executed in batches with JDBC.

The JDBC Tutorial (under the heading "Handling Batch Update Exceptions") confirms it:

You will get a BatchUpdateException when you call the method executeBatch if (1) one of the SQL statements you added to the batch produces a result set (usually a query) or (2) one of the SQL statements in the batch does not execute successfully for some other reason.

You seem to be running into case 1 here.

Related questions

java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 0)

public class Brothers extends javax.swing.JFrame { /** * declaring connection and SQL statement */ Connection cn; Statement st; PreparedStatement pstmt=null; PreparedStatement pst; ResultSet rs; Object fname, mname, lname, bdate, nation, statusq,InstNo, photo, combo, place, mimi; int status; public Brothers() { dbconnect _…

Read More
Java Oracle localhost connection error (ORA-12505)

I am trying to currently connect to a database on my current computer. import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class Main { public static void main(String[] argv) throws Exception { Connection connection = null; try { // …

Read More
How do you assert that a certain exception is thrown in JUnit 4 tests?

How can I use JUnit4 idiomatically to test that some code throws an exception? While I can certainly do something like this: @Test public void testFooThrowsIndexOutOfBoundsException() { boolean thrown = false; try { foo.doStuff(); } catch (IndexOutOfBoundsException e) { thrown = true; } assertTrue(thrown); } I …

Read More