JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

Effect: The number of rows that are fetched from the database when more rows are needed is not

set.

Recovery: For the setFetchSize() method, supply a valid row value that is greater than or

equal to 0.

29043 HY000 Max rows value is not valid

Cause: An attempt was made to set a limit of less than 0 for the maximum number of rows that

any ResultSet object can contain.

Effect: The limit for the maximum number of rows is not set.

Recovery: For the setMaxRows() method, use a valid value that is greater than or equal to 0.

29044 HY000 Query timeout value is not valid

Cause: An attempt was made to set a value of less than 0 for the number of seconds the driver

waits for a Statement object to execute.

Effect: The query timeout limit is not set.

Recovery: For the setQueryTimeout() method, supply a valid value that is greater than or

equal to 0.

29045 01S07 Fractional truncation

Cause: The data retrieved by the ResultSet getter method has been truncated.

Effect: The data retrieved is truncated.

Recovery: Make sure that the data to be retrieved is within a valid data-type range.

29046 22003 Numeric value out of range

Cause: A value retrieved from the ResultSet getter method is outside the range for the data

type.

Effect: The ResultSet getter method does not retrieve the data.

Recovery: Make sure the data to be retrieved is within a valid data-type range.

29047 HY000 Batch update failed. See next exception for details

Cause: One of the commands in a batch update failed to execute properly.

Effect: Not all the batch-update commands succeed. See the subsequent exception for more

information.

Recovery: View the subsequent exception for possible recovery actions.

29048 HY009 Invalid use of null

Cause: A parameter that has an expected table name is set to null.

Effect: The DatabaseMetadata method does not report any results.

Recovery: For the DatabaseMetaData method, supply a valid table name that is not null.

29049 25000 Invalid transaction state

Cause: The begintransaction() method was called when a transaction was in progress.

Effect: A new transaction is not started.

Recovery: Before calling the begintransaction() method, validate whether other transactions

are currently started.

Type 4 Driver Error Messages 91