Informix - Problem description
Problem IT38644 | Status: Closed |
USING PREPAREDSTATEMENT.SETOBJECT() WILL ALLOW A VALUE THAT EXCEEDS THE RANGE FOR A SMALLINT DATA TYPE TO BE INSERTED | |
product: | |
IBM CSDK / 5724C2381 / 450 - CSDK 4.50 | |
Problem description: | |
Using PreparedStatement.setObject() will allow a value that exceeds the range for a smallint data type to be inserted. It should throw the following exception: -1214 Value too large to fit in a SMALLINT. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix JDBC prior to 4.50.JC8. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix JDBC 4.50.JC8. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix JDBC prior to 4.50.JC8. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix JDBC 4.50.JC8. * **************************************************************** | |
Comment | |
Fixed in Informix JDBC 4.50.JC8. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 07.10.2021 05.04.2022 05.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |