Skip Headers

Oracle® Database JDBC Developer's Guide and Reference
10g Release 1 (10.1)

Part Number B10979-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

A JDBC Error Messages

This appendix briefly discusses the general structure of JDBC error messages, then lists general JDBC error messages and TTC error messages that the Oracle JDBC drivers can return. The appendix is organized as follows:

Each of the message lists is first sorted by ORA number, and then alphabetically.

For general information about processing JDBC exceptions, see "Processing SQL Exceptions".

A.1 General Structure of JDBC Error Messages

The general JDBC error message structure allows runtime information to be appended to the end of a message, following a colon, as follows:

<error_message>:<extra_info>

For example, a "closed statement" error might be output as follows:

Closed Statement:next

This indicates that the exception was thrown during a call to the next() method (of a result set object).

In some cases, the user can find the same information in a stack trace.

A.2 General JDBC Messages

This section lists general JDBC error messages, first sorted by ORA number, and then alphabetically.

A.2.1 JDBC Messages Sorted by ORA Number

ORA Number Message

ORA-17001

Internal Error

ORA-17002

Io exception

ORA-17003

Invalid column index

ORA-17004

Invalid column type

ORA-17005

Unsupported column type

ORA-17006

Invalid column name

ORA-17007

Invalid dynamic column

ORA-17008

Closed Connection

ORA-17009

Closed Statement

ORA-17010

Closed Resultset

ORA-17011

Exhausted Resultset

ORA-17012

Parameter Type Conflict

ORA-17014

ResultSet.next was not called

ORA-17015

Statement was cancelled

ORA-17016

Statement timed out

ORA-17017

Cursor already initialized

ORA-17018

Invalid cursor

ORA-17019

Can only describe a query

ORA-17020

Invalid row prefetch

ORA-17021

Missing defines

ORA-17022

Missing defines at index

ORA-17023

Unsupported feature

ORA-17024

No data read

ORA-17025

Error in defines.isNull ()

ORA-17026

Numeric Overflow

ORA-17027

Stream has already been closed

ORA-17028

Can not do new defines until the current ResultSet is closed

ORA-17029

setReadOnly: Read-only connections not supported

ORA-17030

READ_COMMITTED and SERIALIZABLE are the only valid transaction levels

ORA-17031

setAutoClose: Only support auto close mode on

ORA-17032

cannot set row prefetch to zero

ORA-17033

Malformed SQL92 string at position

ORA-17034

Non supported SQL92 token at position

ORA-17035

Character Set Not Supported !!

ORA-17036

exception in OracleNumber

ORA-17037

Fail to convert between UTF8 and UCS2

ORA-17038

Byte array not long enough

ORA-17039

Char array not long enough

ORA-17040

Sub Protocol must be specified in connection URL

ORA-17041

Missing IN or OUT parameter at index:

ORA-17042

Invalid Batch Value

ORA-17043

Invalid stream maximum size

ORA-17044

Internal error: Data array not allocated

ORA-17045

Internal error: Attempt to access bind values beyond the batch value

ORA-17046

Internal error: Invalid index for data access

ORA-17047

Error in Type Descriptor parse

ORA-17048

Undefined type

ORA-17049

Inconsistent java and sql object types

ORA-17050

no such element in vector

ORA-17051

This API cannot be be used for non-UDT types

ORA-17052

This ref is not valid

ORA-17053

The size is not valid

ORA-17054

The LOB locator is not valid

ORA-17055

Invalid character encountered in

ORA-17056

Non supported character set (add orai18n.jar in your classpath)

ORA-17057

Closed LOB

ORA-17058

Internal error: Invalid NLS Conversion ratio

ORA-17059

Fail to convert to internal representation

ORA-17060

Fail to construct descriptor

ORA-17061

Missing descriptor

ORA-17062

Ref cursor is invalid

ORA-17063

Not in a transaction

ORA-17064

Invalid Sytnax or Database name is null

ORA-17065

Conversion class is null

ORA-17066

Access layer specific implementation needed

ORA-17067

Invalid Oracle URL specified

ORA-17068

Invalid argument(s) in call

ORA-17069

Use explicit XA call

ORA-17070

Data size bigger than max size for this type

ORA-17071

Exceeded maximum VARRAY limit

ORA-17072

Inserted value too large for column

ORA-17073

Logical handle no longer valid

ORA-17074

invalid name pattern

ORA-17075

Invalid operation for forward only resultset

ORA-17076

Invalid operation for read only resultset

ORA-17077

Fail to set REF value

ORA-17078

Cannot do the operation as connections are already opened

ORA-17079

User credentials doesn't match the existing ones

ORA-17080

invalid batch command

ORA-17081

error occurred during batching

ORA-17082

No current row

ORA-17083

Not on the insert row

ORA-17084

Called on the insert row

ORA-17085

Value conflicts occurs

ORA-17086

Undefined column value on the insert row

ORA-17087

Ignored performance hint: setFetchDirection()

ORA-17088

Unsupported syntax for requested resultset type and concurrency level

ORA-17089

internal error

ORA-17090

operation not allowed

ORA-17091

Unable to create resultset at the requested type and/or concurrency level

ORA-17092

JDBC statements cannot be created or executed at end of call processing

ORA-17093

OCI operation returned OCI_SUCCESS_WITH_INFO

ORA-17094

Object type version mismatched

ORA-17095

Statement Caching is not enabled for this Connection object

ORA-17096

Statement Caching cannot be enabled for this logical connection

ORA-17097

Invalid PL/SQL Index Table element type

ORA-17098

Invalid empty lob operation

ORA-17099

Invalid PL/SQL Index Table array length

ORA-17100

Invalid database Java Object

ORA-17101

Invalid properties in OCI Connection Pool Object

ORA-17102

Bfile is read only

ORA-17103

invalid connection type to return via getConnection. Use getJavaSqlConnection instead

ORA-17104

SQL statement to execute cannot be empty or null

ORA-17105

connection session time zone was not set

ORA-17106

invalid combination of connections specified

ORA-17107

invalid proxy type specified

ORA-17108

No max length specified in defineColumnType

ORA-17109

standard Java character encoding not found

ORA-17110

execution completed with warning

ORA-17111

Invalid connection cache TTL timeout specified

ORA-17112

Invalid thread interval specified

ORA-17113

Thread interval value is more than the cache timeout value

ORA-17114

could not use local transaction commit in a global transaction

ORA-17115

could not use local transaction rollback in a global transaction

ORA-17116

could not turn on auto-commit in an active global transaction

ORA-17117

could not set savepoint in an active global transaction

ORA-17118

could not obtain ID for a named Savepoint

ORA-17119

could not obtain name for an un-named Savepoint

ORA-17120

could not set a Savepoint with auto-commit on

ORA-17121

could not rollback to a Savepoint with auto-commit on

ORA-17122

could not rollback to a local txn Savepoint in a global transaction

ORA-17123

Invalid statement cache size specified

ORA-17124

Invalid connection cache Inactivity timeout specified

ORA-17125

Improper statement type returned by explicit cache

ORA-17126

Fixed Wait timeout elapsed

ORA-17127

Invalid Fixed Wait timeout specified

A.2.2 JDBC Messages Sorted Alphabetically

ORA Number Message

ORA-17066

Access layer specific implementation needed

ORA-17102

Bfile is read only

ORA-17038

Byte array not long enough

ORA-17084

Called on the insert row

ORA-17028

Can not do new defines until the current ResultSet is closed

ORA-17019

Can only describe a query

ORA-17078

Cannot do the operation as connections are already opened

ORA-17032

cannot set row prefetch to zero

ORA-17039

Char array not long enough

ORA-17035

Character Set Not Supported !!

ORA-17008

Closed Connection

ORA-17057

Closed LOB

ORA-17010

Closed Resultset

ORA-17009

Closed Statement

ORA-17105

connection session time zone was not set

ORA-17065

Conversion class is null

ORA-17118

could not obtain ID for a named Savepoint

ORA-17119

could not obtain name for an un-named Savepoint

ORA-17122

could not rollback to a local txn Savepoint in a global transaction

ORA-17121

could not rollback to a Savepoint with auto-commit on

ORA-17120

could not set a Savepoint with auto-commit on

ORA-17117

could not set savepoint in an active global transaction

ORA-17116

could not turn on auto-commit in an active global transaction

ORA-17114

could not use local transaction commit in a global transaction

ORA-17115

could not use local transaction rollback in a global transaction

ORA-17017

Cursor already initialized

ORA-17070

Data size bigger than max size for this type

ORA-17025

Error in defines.isNull ()

ORA-17047

Error in Type Descriptor parse

ORA-17081

error occurred during batching

ORA-17071

Exceeded maximum VARRAY limit

ORA-17036

exception in OracleNumber

ORA-17110

execution completed with warning

ORA-17011

Exhausted Resultset

ORA-17060

Fail to construct descriptor

ORA-17037

Fail to convert between UTF8 and UCS2

ORA-17059

Fail to convert to internal representation

ORA-17077

Fail to set REF value

ORA-17126

Fixed Wait timeout elapsed

ORA-17087

Ignored performance hint: setFetchDirection()

ORA-17125

Improper statement type returned by explicit cache

ORA-17049

Inconsistent java and sql object types

ORA-17072

Inserted value too large for column

ORA-17089

internal error

ORA-17001

Internal Error

ORA-17045

Internal error: Attempt to access bind values beyond the batch value

ORA-17044

Internal error: Data array not allocated

ORA-17046

Internal error: Invalid index for data access

ORA-17058

Internal error: Invalid NLS Conversion ratio

ORA-17068

Invalid argument(s) in call

ORA-17080

invalid batch command

ORA-17042

Invalid Batch Value

ORA-17055

Invalid character encountered in

ORA-17003

Invalid column index

ORA-17006

Invalid column name

ORA-17004

Invalid column type

ORA-17106

invalid combination of connections specified

ORA-17124

Invalid connection cache Inactivity timeout specified

ORA-17111

Invalid connection cache TTL timeout specified

ORA-17103

invalid connection type to return via getConnection. Use getJavaSqlConnection instead

ORA-17018

Invalid cursor

ORA-17100

Invalid database Java Object

ORA-17007

Invalid dynamic column

ORA-17098

Invalid empty lob operation

ORA-17127

Invalid Fixed Wait timeout specified

ORA-17074

invalid name pattern

ORA-17075

Invalid operation for forward only resultset

ORA-17076

Invalid operation for read only resultset

ORA-17067

Invalid Oracle URL specified

ORA-17099

Invalid PL/SQL Index Table array length

ORA-17097

Invalid PL/SQL Index Table element type

ORA-17101

Invalid properties in OCI Connection Pool Object

ORA-17107

invalid proxy type specified

ORA-17020

Invalid row prefetch

ORA-17123

Invalid statement cache size specified

ORA-17043

Invalid stream maximum size

ORA-17064

Invalid Sytnax or Database name is null

ORA-17112

Invalid thread interval specified

ORA-17002

Io exception

ORA-17092

JDBC statements cannot be created or executed at end of call processing

ORA-17073

Logical handle no longer valid

ORA-17033

Malformed SQL92 string at position

ORA-17021

Missing defines

ORA-17022

Missing defines at index

ORA-17061

Missing descriptor

ORA-17041

Missing IN or OUT parameter at index:

ORA-17082

No current row

ORA-17024

No data read

ORA-17108

No max length specified in defineColumnType

ORA-17050

no such element in vector

ORA-17056

Non supported character set

ORA-17034

Non supported SQL92 token at position

ORA-17063

Not in a transaction

ORA-17083

Not on the insert row

ORA-17026

Numeric Overflow

ORA-17094

Object type version mismatched

ORA-17093

OCI operation returned OCI_SUCCESS_WITH_INFO

ORA-17090

operation not allowed

ORA-17012

Parameter Type Conflict

ORA-17030

READ_COMMITTED and SERIALIZABLE are the only valid transaction levels

ORA-17062

Ref cursor is invalid

ORA-17014

ResultSet.next was not called

ORA-17031

setAutoClose: Only support auto close mode on

ORA-17029

setReadOnly: Read-only connections not supported

ORA-17104

SQL statement to execute cannot be empty or null

ORA-17109

standard Java character encoding not found

ORA-17096

Statement Caching cannot be enabled for this logical connection

ORA-17095

Statement Caching is not enabled for this Connection object

ORA-17016

Statement timed out

ORA-17015

Statement was cancelled

ORA-17027

Stream has already been closed

ORA-17040

Sub Protocol must be specified in connection URL

ORA-17054

The LOB locator is not valid

ORA-17053

The size is not valid

ORA-17051

This API cannot be be used for non-UDT types

ORA-17052

This ref is not valid

ORA-17113

Thread interval value is more than the cache timeout value

ORA-17091

Unable to create resultset at the requested type and/or concurrency level

ORA-17086

Undefined column value on the insert row

ORA-17048

Undefined type

ORA-17005

Unsupported column type

ORA-17023

Unsupported feature

ORA-17088

Unsupported syntax for requested resultset type and concurrency level

ORA-17069

Use explicit XA call

ORA-17079

User credentials doesn't match the existing ones

ORA-17085

Value conflicts occurs

A.3 HeteroRM XA Messages

The following are the JDBC error messages that are specific to the HeteroRM XA feature.

A.3.1 HeteroRM XA Messages Sorted by ORA Number

ORA Number Message

ORA-17200

Unable to properly convert XA open string from Java to C

ORA-17201

Unable to properly convert XA close string from Java to C

ORA-17202

Unable to properly convert RM name from Java to C

ORA-17203

Could not cast pointer type to jlong

ORA-17204

Input array too short to hold OCI handles

ORA-17205

Failed to obtain OCISvcCtx handle from C-XA using xaoSvcCtx

ORA-17206

Failed to obtain OCIEnv handle from C-XA using xaoEnv

ORA-17207

The tnsEntry property was not set in DataSource

ORA-17213

C-XA returned XAER_RMERR during xa_open

ORA-17215

C-XA returned XAER_INVAL during xa_open

ORA-17216

C-XA returned XAER_PROTO during xa_open

ORA-17233

C-XA returned XAER_RMERR during xa_close

ORA-17235

C-XA returned XAER_INVAL during xa_close

ORA-17236

C-XA returned XAER_PROTO during xa_close

A.3.2 HeteroRM XA Messages Sorted Alphabetically

ORA Number Message

ORA-17203

Could not cast pointer type to jlong

ORA-17235

C-XA returned XAER_INVAL during xa_close

ORA-17215

C-XA returned XAER_INVAL during xa_open

ORA-17236

C-XA returned XAER_PROTO during xa_close

ORA-17216

C-XA returned XAER_PROTO during xa_open

ORA-17233

C-XA returned XAER_RMERR during xa_close

ORA-17213

C-XA returned XAER_RMERR during xa_open

ORA-17206

Failed to obtain OCIEnv handle from C-XA using xaoEnv

ORA-17205

Failed to obtain OCISvcCtx handle from C-XA using xaoSvcCtx

ORA-17204

Input array too short to hold OCI handles

ORA-17207

The tnsEntry property was not set in DataSource

ORA-17202

Unable to properly convert RM name from Java to C

ORA-17201

Unable to properly convert XA close string from Java to C

ORA-17200

Unable to properly convert XA open string from Java to C

A.4 TTC Messages

This section lists TTC error messages, first sorted by ORA number, and then alphabetically.

A.4.1 TTC Messages Sorted by ORA Number

ORA Number Message

ORA-17401

Protocol violation

ORA-17402

Only one RPA message is expected

ORA-17403

Only one RXH message is expected

ORA-17404

Received more RXDs than expected

ORA-17405

UAC length is not zero

ORA-17406

Exceeding maximum buffer length

ORA-17407

invalid Type Representation(setRep)

ORA-17408

invalid Type Representation(getRep)

ORA-17409

invalid buffer length

ORA-17410

No more data to read from socket

ORA-17411

Data Type representations mismatch

ORA-17412

Bigger type length than Maximum

ORA-17413

Exceding key size

ORA-17414

Insufficient Buffer size to store Columns Names

ORA-17415

This type hasn't been handled

ORA-17416

FATAL

ORA-17417

NLS Problem, failed to decode column names

ORA-17418

Internal structure's field length error

ORA-17419

Invalid number of columns returned

ORA-17420

Oracle Version not defined

ORA-17421

Types or Connection not defined

ORA-17422

Invalid class in factory

ORA-17423

Using a PLSQL block without an IOV defined

ORA-17424

Attempting different marshaling operation

ORA-17425

Returning a stream in PLSQL block

ORA-17426

Both IN and OUT binds are NULL

ORA-17427

Using Uninitialized OAC

ORA-17428

Logon must be called after connect

ORA-17429

Must be at least connected to server

ORA-17430

Must be logged on to server

ORA-17431

SQL Statement to parse is null

ORA-17432

invalid options in all7

ORA-17433

invalid arguments in call

ORA-17434

not in streaming mode

ORA-17435

invalid number of in_out_binds in IOV

ORA-17436

invalid number of outbinds

ORA-17437

Error in PLSQL block IN/OUT argument(s)

ORA-17438

Internal - Unexpected value

ORA-17439

Invalid SQL type

ORA-17440

DBItem/DBType is null

ORA-17441

Oracle Version not supported. Minimum supported version is 7.2.3.

ORA-17442

Refcursor value is invalid

ORA-17443

Null user or password not supported in THIN driver

ORA-17444

TTC Protocol version received from server not supported

A.4.2 TTC Messages Sorted Alphabetically

ORA Number Message

ORA-17424

Attempting different marshaling operation

ORA-17412

Bigger type length than Maximum

ORA-17426

Both IN and OUT binds are NULL

ORA-17411

Data Type representations mismatch

ORA-17440

DBItem/DBType is null

ORA-17437

Error in PLSQL block IN/OUT argument(s)

ORA-17413

Exceding key size

ORA-17406

Exceeding maximum buffer length

ORA-17416

FATAL

ORA-17414

Insufficient Buffer size to store Columns Names

ORA-17438

Internal - Unexpected value

ORA-17418

Internal structure's field length error

ORA-17433

invalid arguments in call

ORA-17409

invalid buffer length

ORA-17422

Invalid class in factory

ORA-17419

Invalid number of columns returned

ORA-17435

invalid number of in_out_binds in IOV

ORA-17436

invalid number of outbinds

ORA-17432

invalid options in all7

ORA-17439

Invalid SQL type

ORA-17408

invalid Type Representation(getRep)

ORA-17407

invalid Type Representation(setRep)

ORA-17428

Logon must be called after connect

ORA-17429

Must be at least connected to server

ORA-17430

Must be logged on to server

ORA-17417

NLS Problem, failed to decode column names

ORA-17410

No more data to read from socket

ORA-17434

not in streaming mode

ORA-17443

Null user or password not supported in THIN driver

ORA-17402

Only one RPA message is expected

ORA-17403

Only one RXH message is expected

ORA-17420

Oracle Version not defined

ORA-17441

Oracle Version not supported. Minimum supported version is 7.2.3.

ORA-17401

Protocol violation

ORA-17404

Received more RXDs than expected

ORA-17442

Refcursor value is invalid

ORA-17425

Returning a stream in PLSQL block

ORA-17431

SQL Statement to parse is null

ORA-17415

This type hasn't been handled

ORA-17444

TTC Protocol version received from server not supported

ORA-17421

Types or Connection not defined

ORA-17405

UAC length is not zero

ORA-17423

Using a PLSQL block without an IOV defined

ORA-17427

Using Uninitialized OAC