| java.lang.Object | ||||
| ↳ | java.lang.Throwable | |||
| ↳ | java.lang.Exception | |||
| ↳ | java.sql.SQLException | |||
| ↳ | java.sql.BatchUpdateException | |||
This exception is thrown if a problem occurs during a batch update operation.
A BatchUpdateException provides additional information about the
problem that occurred, compared with a standard SQLException. It
supplies update counts for successful commands which were executed before the
exception was encountered.
The element order in the array of update counts matches the order that the commands were added to the batch operation.
Once a batch update command fails and a BatchUpdateException is
thrown, the JDBC driver may continue processing the remaining commands in the
batch. If the driver does process more commands after the problem occurs, the
array returned by BatchUpdateException.getUpdateCounts has an element
for every command in the batch, not only those that executed successfully. In
this case, the array element for any command which encountered a problem is
set to Statement.EXECUTE_FAILED.
| Public Constructors | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Creates a default
BatchUpdateException with the parameters
reason, SQLState, and update counts set to null and the vendor code set to 0. | |||||||||||
Creates a
BatchUpdateException with the updateCounts set
to the supplied value. | |||||||||||
Creates a
BatchUpdateException with the updateCounts and
reason set to the supplied values. | |||||||||||
Creates a
BatchUpdateException with the reason, SQLState and updateCounts set to the supplied values. | |||||||||||
Creates a
BatchUpdateException for the case where all relevant
information is provided. | |||||||||||
| Public Methods | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Gets the update count array giving status information for every
command that was attempted in the batch.
| |||||||||||
|
[Expand]
Inherited Methods | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
From class java.sql.SQLException
| |||||||||||
From class java.lang.Throwable
| |||||||||||
From class java.lang.Object
| |||||||||||
Creates a default BatchUpdateException with the parameters
reason, SQLState, and update counts set to null and the vendor code set to 0.
Creates a BatchUpdateException with the updateCounts set
to the supplied value. All other fields are set to their
default values.
| updateCounts | the array of updateCounts giving the number of
successful updates (or another status code) for each command
in the batch that was attempted.
|
|---|
Creates a BatchUpdateException with the updateCounts and
reason set to the supplied values. All other fields are set to their
default values.
| reason | the message providing information about the source of this exception. |
|---|---|
| updateCounts | the array of updateCounts giving the number of
successful updates (or another status code) for each command
in the batch that was attempted.
|
Creates a BatchUpdateException with the reason, SQLState and updateCounts set to the supplied values. All other
fields are set to their default values.
| reason | the message providing information about the source of this exception. |
|---|---|
| SQLState | the X/OPEN value to use for the SQLState |
| updateCounts | the array of updateCounts giving the number of
successful updates (or another status code) for each command
in the batch that was attempted.
|
Creates a BatchUpdateException for the case where all relevant
information is provided.
| reason | the message providing information about the source of this exception. |
|---|---|
| SQLState | the X/OPEN value to use for the SQLState. |
| vendorCode | the value to use for the vendor error code. |
| updateCounts | the array of updateCounts giving the number of
successful updates (or another status code) for each command
in the batch that was attempted.
|
Gets the update count array giving status information for every command that was attempted in the batch.
If a batch update command fails and a BatchUpdateException is
thrown, the JDBC driver may continue processing the remaining commands in
the batch. If the driver does so, the array returned by BatchUpdateException.getUpdateCounts has an element for every command in
the batch, not only those that executed successfully. In this case, the
array element for any command which encountered a problem is set to
Statement.EXECUTE_FAILED.
Statement.SUCCESS_NO_INFO indicating that the command completed
successfully, but the amount of altered rows is unknown.Statement.EXECUTE_FAILED indicating that the command
was unsuccessful.