com.mimer.jdbc
Class SQLException

java.lang.Object
  |
  +--java.lang.Throwable
        |
        +--java.lang.Exception
              |
              +--com.mimer.jdbc.SQLException

All Implemented Interfaces:

java.io.Serializable

Direct Known Subclasses:

BatchUpdateException, SQLWarning

public class SQLException

extends java.lang.Exception

An exception that provides information on a database access error or other errors.

Each SQLException provides several kinds of information:

• a string describing the error. This is used as the Java Exception message, available via the method getMesage.
• a "SQLstate" string, which follows the XOPEN SQLstate conventions. The values of the SQLState string are described in the XOPEN SQL spec.
• an integer error code that is specific to each vendor. Normally this will be the actual error code returned by the underlying database.
• a chain to a next Exception. This can be used to provide additional error information.

Below are the errors returned by the Mimer JDBC driver itself. For errors returned by the driver but originating from the server, see the Mimer SQL Programmers Reference. % is a placeholder for dynamically generated text clarifying the error.

Vendor code	SQL State	Descriptive text
-22000	HYC00	java.sql.SQLException: Optional feature (%) not implemented
-22001	22023	java.sql.SQLException: Argument not allowed in %
-22002	HY000	java.sql.SQLException: Can not execute a statement with parameter markers. Use PreparedStatement or CallableStatement
-22003	HY000	java.sql.SQLException: The statement contains a query. Use executeQuery() or execute()
-22004	HY000	java.sql.SQLException: The statement is not a query. Use executeUpdate() or execute()
-22006	2200G	java.sql.SQLException: Type mismatch
-22007	08006	java.sql.SQLException: Server returned bad handshake message
-22008	08004	java.sql.SQLException: This Mimer JDBC driver (%) requires at least 8.2 servers, which the database % on host % using port % is not, %
-22009	08001	java.sql.SQLException: Redirection message specified unknown protocol: %
-22010	08001	java.sql.SQLException: Connection failed, too many redirections
-22011	08004	java.sql.SQLException: VAR code necessary for login
-22013	08S01	java.sql.SQLException: Could not send data to server, %
-22014	08S01	java.sql.SQLException: Could not receive data from server, %
-22015	08006	java.sql.SQLException: The connection with the server was lost
-22016	08001	java.sql.SQLException: Illegal port: %, %
-22017	08001	java.sql.SQLException: Could not establish connection to server % on host % using port %, %
-22018	08001	java.sql.SQLException: Could not create streams to server on host % using port %, %
-22019	08001	java.sql.SQLException: Error when doing handshake with database % on host % using port %, %
-22020	08001	java.sql.SQLException: Error when reading redirection message from database %, host %, port %, %
-22021	22018	java.sql.SQLException: Invalid character value for cast
-22022	08004	java.sql.SQLException: Beta period expired %, current timestamp is %. The server does not have a beta license.
-22023	07009	java.sql.SQLException: Illegal column index: %. Valid is 1 to %
-22024	07009	java.sql.SQLException: Illegal parameter index: %. Valid is 1 to %
-22025	0A000	java.sql.SQLException: Server returned unknown datatype: %
-22026	07009	java.sql.SQLException: Column '%' is not in the ResultSet
-22029	23000	java.sql.SQLException: The parameter is not nullable
-22030	24000	java.sql.SQLException: The ResultSet is not positioned on a row
-22031	07002	java.sql.SQLException: No value was set for parameter number
-22032	HY024	java.sql.SQLException: Cannot specify negative Max Field Size
-22033	HY024	java.sql.SQLException: Cannot specify negative Max Rows
-22034	HY024	java.sql.SQLException: Cannot specify negative Timeout
-22035	HY010	java.sql.SQLException: Statement is closed
-22036	HY000	java.sql.SQLException: Server returned illegal isolation code: %
-22037	HY096	java.sql.SQLException: Illegal isolation level: %
-22038	22018	java.sql.SQLException: Could not convert the string '%' to a numeric value
-22039	22001	java.sql.SQLException: String data, right truncation when converting '%' to numeric with precision % and scale %
-22040	01S07	java.sql.SQLException: Fractional truncation
-22041	HY009	java.sql.SQLException: Invalid use of null pointer
-22042	08003	java.sql.SQLException: Connection is closed
-22043	HY010	java.sql.SQLException: PreparedStatement is closed
-22044	HY010	java.sql.SQLException: ResultSet is closed
-22045	22007	java.sql.SQLException: Invalid datetime format
-22046	HY000	java.sql.SQLException: An internal error occured in %
-22047	22003	java.sql.SQLException: Numeric value out of range
-22048	22001	java.sql.SQLException: String data, right truncation
-22049	22015	java.sql.SQLException: Interval field overflow
-22050	34000	java.sql.SQLException: Invalid cursor name (%)
-22051	07002	java.sql.SQLException: Parameter number %, which is output, was not registered.
-22052	HY000	java.sql.SQLException: Could not convert Unicode character to ISO8859-1
-22053	HY000	java.sql.SQLException: Statement type not recognized, STY %
-22054	HY000	java.sql.SQLException: % statements currently not supported via this JDBC driver
-22055	HY008	java.sql.SQLException: Request cancelled
-22056	HY000	java.sql.SQLException: Could not set socket timeout, %
-22057	HY109	java.sql.SQLException: Method % is not allowed on forward only cursors.
-22058	HY000	java.sql.SQLException: Could not connect within % seconds
-22059	HY000	java.sql.SQLException: Invalid result set type, %
-22060	HY000	java.sql.SQLException: Invalid concurrency, %
-22061	22008	java.sql.SQLException: Datetime field overflow
-22062	HY010	java.sql.SQLException: No statements added to batch
-22063	HY000	java.sql.SQLException: The driver does not support TYPE_SCROLL_SENSITIVE result sets. A TYPE_SCROLL_INSENSITIVE result set was returned
-22064	HY010	java.sql.SQLException: No parameters were batched
-22065	HY010	java.sql.SQLException: Must call addBatch() before executing the batch
-22066	HY010	java.sql.SQLException: Use executeBatch() to execute with batched parameters
-22067	HY000	java.sql.SQLException: Only INSERT, UPDATE and DELETE statements are allowed in batches.
-22068	HY000	java.sql.SQLException: Only procedure calls which invoke non-result procedures are allowed in CallableStatement batches.
-22069	HY000	java.sql.SQLException: Only input parameters are allowed.
-22070	HY010	java.sql.SQLException: The statement has not been executed
-22071	HY010	java.sql.SQLException: The result set belongs to a program ident which is not active.
-22072	HY107	java.sql.SQLException: Invalid absolute row number (0).
-22073	08003	java.sql.SQLException: PooledConnection is closed
-22074	08003	java.sql.SQLException: This object does not support the method %
-22075	0A000	java.sql.SQLException: % is not supported by % servers and earlier
-22076	HY010	java.sql.SQLException: Stream is closed
-22077	HY010	java.sql.SQLException: IOException on InputStream (%)
-22078	HYC00	java.sql.SQLException: % not supported on % version
-22079	08004	java.sql.SQLException: This Mimer JDBC driver (%) is too old for the database % on host % using port %, %
-22080	HY000	java.sql.SQLException: Server returned %(%) - too large for this driver
-22081	HY024	java.sql.SQLException: Tried to set fetch direction to %, which is illegal
-22082	HYC00	java.sql.SQLException: The registered data type (%) was not supported
-22083	HY024	java.sql.SQLException: Illegal result set type (%)
-22084	HY024	java.sql.SQLException: Illegal result set concurrency (%)
-22085	HY024	java.sql.SQLException: Negative fetch size specified
-22086	HY024	java.sql.SQLException: Fetch size can not be larger than maxRows (%)
-22087	25000	java.sql.SQLException: % object became invalid after transaction ended
-22088	HY010	java.sql.SQLException: % is closed
-22089	22001	java.sql.SQLException: CharacterStream was shorter (% characters) than specified (% characters)

See Also:

Serialized Form

Constructor Summary

SQLException()
Constructs an SQLException object; reason defaults to null, SQLState defaults to null, and vendorCode defaults to 0.

SQLException(java.lang.String reason)
Constructs an SQLException object with a reason; SQLState defaults to null, and vendorCode defaults to 0.

SQLException(java.lang.String reason, java.lang.String SQLState)
Constructs an SQLException object with a reason and SQLState; vendorCode defaults to 0.

SQLException(java.lang.String reason, java.lang.String SQLState, int vendorCode)
Constructs a fully-specified SQLException object.

Method Summary

int	getErrorCode() Retrieves the vendor-specific exception code for this SQLException object.
SQLException	getNextException() Retrieves the exception chained to this SQLException object.
java.lang.String	getSQLState() Retrieves the SQLState for this SQLException object.
void	setNextException(SQLException ex) Adds an SQLException object to the end of the chain.

Methods inherited from class java.lang.Throwable

fillInStackTrace, getCause, getLocalizedMessage, getMessage, getStackTrace, initCause, printStackTrace, printStackTrace, printStackTrace, setStackTrace, toString

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

SQLException

public SQLException()

Constructs an SQLException object; reason defaults to null, SQLState defaults to null, and vendorCode defaults to 0.

SQLException

public SQLException(java.lang.String reason)

Constructs an SQLException object with a reason; SQLState defaults to null, and vendorCode defaults to 0.

Parameters:

reason - a description of the exception

SQLException

public SQLException(java.lang.String reason,
                    java.lang.String SQLState)

Constructs an SQLException object with a reason and SQLState; vendorCode defaults to 0.

Parameters:

reason - a description of the exception

SQLState - an XOPEN code identifying the exception

SQLException

public SQLException(java.lang.String reason,
                    java.lang.String SQLState,
                    int vendorCode)

Constructs a fully-specified SQLException object.

Parameters:

reason - a description of the exception

SQLState - an XOPEN code identifying the exception

vendorCode - a database vendor-specific exception code

Method Detail

getErrorCode

public int getErrorCode()

Retrieves the vendor-specific exception code for this SQLException object.

Returns:

the vendor's error code

getNextException

public SQLException getNextException()

Retrieves the exception chained to this SQLException object.

Returns:

the next SQLException object in the chain; null if there are none

getSQLState

public java.lang.String getSQLState()

Retrieves the SQLState for this SQLException object.

Returns:

the SQLState value

setNextException

public void setNextException(SQLException ex)

Adds an SQLException object to the end of the chain.

Parameters:

ex - the new exception that will be added to the end of the SQLException chain