Java Enterprise in a Nutshell, Third Edition

Return Codes

The SQL-92 standard defines a set of SQLSTATE return codes . SQLSTATE is defined as a five-character string, with the leftmost two characters defining the error class, and the remaining three characters defining the error subclass. Some database vendors may extend these return codes; classes beginning with the numbers 5 through 9 and letters I through Z are reserved for such implementation-specific extensions. The SQLSTATE code for a particular JDBC action can be retrieved via the getSQLState() method of SQLException. Table D-3 lists the SQLSTATE return codes defined in SQL-92.

Table D-3. SQL-92 SQLSTATE return codes

Class	Class definition	Subclass	Subclass definition
00	Successful completion	000	None
01	Warning	000	None
		001	Cursor operation conflict
		002	Disconnect error
		003	Null value eliminated in set function
		004	String data, right truncation
		005	Insufficient item descriptor areas
		006	Privilege not revoked
		007	Privilege not granted
		008	Implicit zero-bit padding
		009	Search expression too long for information schema
		00A	Query expression too long for information schema
02	No data	000	None
07	Dynamic SQL error	000	None
		001	Using clause doesn’t match dynamic parameters
		002	Using clause doesn’t match target specifications
		003	Cursor specification can’t be executed
		004	Using clause required for dynamic parameters
		005	Prepared statement not a cursor specification
		006	Restricted data type attribute violation
		007	Using clause required for result ...