Geek asks and answers

What does this BatchUpdateException mean?

I get this BatchUpdateException from the stmt.executeBatch () statement:

BatchUpdateException: A resultset was created for update

There is no information on the Internet about this exception message. What does it mean? Tracing does not contain anything useful, except that the stored procedure failed.

+3
source share
3 answers

I would interpret the message as meaning that the SQL statement you added through addBatch()created ResultSet, which means that this is not your regular statement INSERT, UPDATEor DELETE.

Statements that must return results cannot be performed in batches with JDBC.

JDBC ( " " ) :

BatchUpdateException executeBatch, (1) SQL, , ( ) (2) SQL - .

, 1 .

+9

- insert/update/delete, . . 1x 1000 , 1000x1. A BatchUpdateException , 1 ( ) - . , , . Mayby dba , .

+1

I deleted one column from the table. When I tried to insert records into this table, I was getting a BatchUpdateException.

After running the command below, the problem is resolved.

REORG TABLE TABLE_NAME

0
source

More articles:


All Articles