O'Reilly logo

Java Enterprise in a Nutshell, Third Edition by William Crawford, Jim Farley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required