java : traiter les erreurs SQL

voici un exemple tiré de ce site de java superbe www.exampledepot.com


try {
// Execute SQL statements...
} catch (SQLException e) {
while (e != null) {
// Retrieve a human-readable message identifying the reason for the exception
String message = e.getMessage();

// This vendor-independent string contains a code that identifies
// the reason for the exception.
// The code follows the Open Group SQL conventions.
String sqlState = e.getSQLState();

// Retrieve a vendor-specific code identifying the reason for the exception.
int errorCode = e.getErrorCode();

// If it is necessary to execute code based on this error code,
// you should ensure that the expected driver is being
// used before using the error code.

// Get driver name
String driverName = connection.getMetaData().getDriverName();
if (driverName.equals("Oracle JDBC Driver") && errorCode == 123) {
// Process error...
}

// The exception may have been chained; process the next chained exception
e = e.getNextException();
}
}