- java.lang.Object
-
- java.lang.Throwable
-
- java.lang.Exception
-
- java.sql.SQLException
-
- java.sql.BatchUpdateException
-
- All Implemented Interfaces:
- Serializable, Iterable<Throwable>
public class BatchUpdateException extends SQLException
The subclass ofSQLException
thrown when an error occurs during a batch update operation. In addition to the information provided bySQLException
, aBatchUpdateException
provides the update counts for all commands that were executed successfully during the batch update, that is, all commands that were executed before the error occurred. The order of elements in an array of update counts corresponds to the order in which commands were added to the batch.After a command in a batch update fails to execute properly and a
BatchUpdateException
is thrown, the driver may or may not continue to process the remaining commands in the batch. If the driver continues processing after a failure, the array returned by the methodBatchUpdateException.getUpdateCounts
will have an element for every command in the batch rather than only elements for the commands that executed successfully before the error. In the case where the driver continues processing commands, the array element for any command that failed isStatement.EXECUTE_FAILED
.- Since:
- 1.2
- See Also:
- Serialized Form
-
-
Constructor Summary
Constructors Constructor and Description BatchUpdateException()
Constructs aBatchUpdateException
object.BatchUpdateException(int[] updateCounts)
Constructs aBatchUpdateException
object initialized with a givenupdateCounts
.BatchUpdateException(int[] updateCounts, Throwable cause)
Constructs aBatchUpdateException
object initialized with a givencause
andupdateCounts
.BatchUpdateException(String reason, int[] updateCounts)
Constructs aBatchUpdateException
object initialized with a givenreason
andupdateCounts
.BatchUpdateException(String reason, int[] updateCounts, Throwable cause)
Constructs aBatchUpdateException
object initialized with a givenreason
,cause
andupdateCounts
.BatchUpdateException(String reason, String SQLState, int[] updateCounts)
Constructs aBatchUpdateException
object initialized with a givenreason
,SQLState
andupdateCounts
.BatchUpdateException(String reason, String SQLState, int[] updateCounts, Throwable cause)
Constructs aBatchUpdateException
object initialized with a givenreason
,SQLState
,cause
, andupdateCounts
.BatchUpdateException(String reason, String SQLState, int vendorCode, int[] updateCounts)
Constructs aBatchUpdateException
object initialized with a givenreason
,SQLState
,vendorCode
andupdateCounts
.BatchUpdateException(String reason, String SQLState, int vendorCode, int[] updateCounts, Throwable cause)
Constructs aBatchUpdateException
object initialized with a givenreason
,SQLState
,vendorCode
cause
andupdateCounts
.BatchUpdateException(Throwable cause)
Constructs aBatchUpdateException
object initialized with a givencause
.
-
Method Summary
Methods Modifier and Type Method and Description int[]
getUpdateCounts()
Retrieves the update count for each update statement in the batch update that executed successfully before this exception occurred.-
Methods inherited from class java.sql.SQLException
getErrorCode, getNextException, getSQLState, iterator, setNextException
-
Methods inherited from class java.lang.Throwable
addSuppressed, fillInStackTrace, getCause, getLocalizedMessage, getMessage, getStackTrace, getSuppressed, initCause, printStackTrace, printStackTrace, printStackTrace, setStackTrace, toString
-
-
-
-
Constructor Detail
-
BatchUpdateException
public BatchUpdateException(String reason, String SQLState, int vendorCode, int[] updateCounts)
Constructs aBatchUpdateException
object initialized with a givenreason
,SQLState
,vendorCode
andupdateCounts
. Thecause
is not initialized, and may subsequently be initialized by a call to theThrowable.initCause(java.lang.Throwable)
method.- Parameters:
reason
- a description of the errorSQLState
- an XOPEN or SQL:2003 code identifying the exceptionvendorCode
- an exception code used by a particular database vendorupdateCounts
- an array ofint
, with each element indicating the update count,Statement.SUCCESS_NO_INFO
orStatement.EXECUTE_FAILED
for each SQL command in the batch for JDBC drivers that continue processing after a command failure; an update count orStatement.SUCCESS_NO_INFO
for each SQL command in the batch prior to the failure for JDBC drivers that stop processing after a command failure- Since:
- 1.2
-
BatchUpdateException
public BatchUpdateException(String reason, String SQLState, int[] updateCounts)
Constructs aBatchUpdateException
object initialized with a givenreason
,SQLState
andupdateCounts
. Thecause
is not initialized, and may subsequently be initialized by a call to theThrowable.initCause(java.lang.Throwable)
method. The vendor code is initialized to 0.- Parameters:
reason
- a description of the exceptionSQLState
- an XOPEN or SQL:2003 code identifying the exceptionupdateCounts
- an array ofint
, with each element indicating the update count,Statement.SUCCESS_NO_INFO
orStatement.EXECUTE_FAILED
for each SQL command in the batch for JDBC drivers that continue processing after a command failure; an update count orStatement.SUCCESS_NO_INFO
for each SQL command in the batch prior to the failure for JDBC drivers that stop processing after a command failure- Since:
- 1.2
-
BatchUpdateException
public BatchUpdateException(String reason, int[] updateCounts)
Constructs aBatchUpdateException
object initialized with a givenreason
andupdateCounts
. Thecause
is not initialized, and may subsequently be initialized by a call to theThrowable.initCause(java.lang.Throwable)
method. TheSQLState
is initialized tonull
and the vender code is initialized to 0.- Parameters:
reason
- a description of the exceptionupdateCounts
- an array ofint
, with each element indicating the update count,Statement.SUCCESS_NO_INFO
orStatement.EXECUTE_FAILED
for each SQL command in the batch for JDBC drivers that continue processing after a command failure; an update count orStatement.SUCCESS_NO_INFO
for each SQL command in the batch prior to the failure for JDBC drivers that stop processing after a command failure- Since:
- 1.2
-
BatchUpdateException
public BatchUpdateException(int[] updateCounts)
Constructs aBatchUpdateException
object initialized with a givenupdateCounts
. initialized by a call to theThrowable.initCause(java.lang.Throwable)
method. Thereason
andSQLState
are initialized to null and the vendor code is initialized to 0.- Parameters:
updateCounts
- an array ofint
, with each element indicating the update count,Statement.SUCCESS_NO_INFO
orStatement.EXECUTE_FAILED
for each SQL command in the batch for JDBC drivers that continue processing after a command failure; an update count orStatement.SUCCESS_NO_INFO
for each SQL command in the batch prior to the failure for JDBC drivers that stop processing after a command failure- Since:
- 1.2
-
BatchUpdateException
public BatchUpdateException()
Constructs aBatchUpdateException
object. Thereason
,SQLState
andupdateCounts
are initialized tonull
and the vendor code is initialized to 0. Thecause
is not initialized, and may subsequently be initialized by a call to theThrowable.initCause(java.lang.Throwable)
method.- Since:
- 1.2
-
BatchUpdateException
public BatchUpdateException(Throwable cause)
Constructs aBatchUpdateException
object initialized with a givencause
. TheSQLState
andupdateCounts
are initialized tonull
and the vendor code is initialized to 0. Thereason
is initialized tonull
ifcause==null
or tocause.toString()
ifcause!=null
.- Parameters:
cause
- the underlying reason for thisSQLException
(which is saved for later retrieval by thegetCause()
method); may be null indicating the cause is non-existent or unknown.- Since:
- 1.6
-
BatchUpdateException
public BatchUpdateException(int[] updateCounts, Throwable cause)
Constructs aBatchUpdateException
object initialized with a givencause
andupdateCounts
. TheSQLState
is initialized tonull
and the vendor code is initialized to 0. Thereason
is initialized tonull
ifcause==null
or tocause.toString()
ifcause!=null
.- Parameters:
updateCounts
- an array ofint
, with each element indicating the update count,Statement.SUCCESS_NO_INFO
orStatement.EXECUTE_FAILED
for each SQL command in the batch for JDBC drivers that continue processing after a command failure; an update count orStatement.SUCCESS_NO_INFO
for each SQL command in the batch prior to the failure for JDBC drivers that stop processing after a command failurecause
- the underlying reason for thisSQLException
(which is saved for later retrieval by thegetCause()
method); may be null indicating the cause is non-existent or unknown.- Since:
- 1.6
-
BatchUpdateException
public BatchUpdateException(String reason, int[] updateCounts, Throwable cause)
Constructs aBatchUpdateException
object initialized with a givenreason
,cause
andupdateCounts
. TheSQLState
is initialized tonull
and the vendor code is initialized to 0.- Parameters:
reason
- a description of the exceptionupdateCounts
- an array ofint
, with each element indicating the update count,Statement.SUCCESS_NO_INFO
orStatement.EXECUTE_FAILED
for each SQL command in the batch for JDBC drivers that continue processing after a command failure; an update count orStatement.SUCCESS_NO_INFO
for each SQL command in the batch prior to the failure for JDBC drivers that stop processing after a command failurecause
- the underlying reason for thisSQLException
(which is saved for later retrieval by thegetCause()
method); may be null indicating the cause is non-existent or unknown.- Since:
- 1.6
-
BatchUpdateException
public BatchUpdateException(String reason, String SQLState, int[] updateCounts, Throwable cause)
Constructs aBatchUpdateException
object initialized with a givenreason
,SQLState
,cause
, andupdateCounts
. The vendor code is initialized to 0.- Parameters:
reason
- a description of the exceptionSQLState
- an XOPEN or SQL:2003 code identifying the exceptionupdateCounts
- an array ofint
, with each element indicating the update count,Statement.SUCCESS_NO_INFO
orStatement.EXECUTE_FAILED
for each SQL command in the batch for JDBC drivers that continue processing after a command failure; an update count orStatement.SUCCESS_NO_INFO
for each SQL command in the batch prior to the failure for JDBC drivers that stop processing after a command failurecause
- the underlying reason for thisSQLException
(which is saved for later retrieval by thegetCause()
method); may be null indicating the cause is non-existent or unknown.- Since:
- 1.6
-
BatchUpdateException
public BatchUpdateException(String reason, String SQLState, int vendorCode, int[] updateCounts, Throwable cause)
Constructs aBatchUpdateException
object initialized with a givenreason
,SQLState
,vendorCode
cause
andupdateCounts
.- Parameters:
reason
- a description of the errorSQLState
- an XOPEN or SQL:2003 code identifying the exceptionvendorCode
- an exception code used by a particular database vendorupdateCounts
- an array ofint
, with each element indicating the update count,Statement.SUCCESS_NO_INFO
orStatement.EXECUTE_FAILED
for each SQL command in the batch for JDBC drivers that continue processing after a command failure; an update count orStatement.SUCCESS_NO_INFO
for each SQL command in the batch prior to the failure for JDBC drivers that stop processing after a command failurecause
- the underlying reason for thisSQLException
(which is saved for later retrieval by thegetCause()
method); may be null indicating the cause is non-existent or unknown.- Since:
- 1.6
-
-
Method Detail
-
getUpdateCounts
public int[] getUpdateCounts()
Retrieves the update count for each update statement in the batch update that executed successfully before this exception occurred. A driver that implements batch updates may or may not continue to process the remaining commands in a batch when one of the commands fails to execute properly. If the driver continues processing commands, the array returned by this method will have as many elements as there are commands in the batch; otherwise, it will contain an update count for each command that executed successfully before theBatchUpdateException
was thrown.The possible return values for this method were modified for the Java 2 SDK, Standard Edition, version 1.3. This was done to accommodate the new option of continuing to process commands in a batch update after a
BatchUpdateException
object has been thrown.- Returns:
- an array of
int
containing the update counts for the updates that were executed successfully before this error occurred. Or, if the driver continues to process commands after an error, one of the following for every command in the batch:- an update count
Statement.SUCCESS_NO_INFO
to indicate that the command executed successfully but the number of rows affected is unknownStatement.EXECUTE_FAILED
to indicate that the command failed to execute successfully
- Since:
- 1.3
-
-
Traduction non disponible
Les API Java ne sont pas encore traduites en français sur l'infobrol. Seule la version anglaise est disponible pour l'instant.
Version en cache
01/11/2024 03:21:24 Cette version de la page est en cache (à la date du 01/11/2024 03:21:24) afin d'accélérer le traitement. Vous pouvez activer le mode utilisateur dans le menu en haut pour afficher la dernère version de la page.Document créé le 11/06/2005, dernière modification le 04/03/2020
Source du document imprimé : https://www.gaudry.be/java-api-rf-java/sql/batchupdateexception.html/.html
L'infobrol est un site personnel dont le contenu n'engage que moi. Le texte est mis à disposition sous licence CreativeCommons(BY-NC-SA). Plus d'info sur les conditions d'utilisation et sur l'auteur.
Références
Ces références et liens indiquent des documents consultés lors de la rédaction de cette page, ou qui peuvent apporter un complément d'information, mais les auteurs de ces sources ne peuvent être tenus responsables du contenu de cette page.
L'auteur de ce site est seul responsable de la manière dont sont présentés ici les différents concepts, et des libertés qui sont prises avec les ouvrages de référence. N'oubliez pas que vous devez croiser les informations de sources multiples afin de diminuer les risques d'erreurs.