Informix - Problem description
Problem IT42707 | Status: Closed |
JDBC: A -79754 WRITE FAULT EXCEPTION IS THROWN WHEN INSERTING ANUMLAUT INTO A CLOB USING A PARAMETERIZED PREPARESTATEMENT | |
product: | |
IBM CSDK / 5724C2381 / 450 - CSDK 4.50 | |
Problem description: | |
When inserting an umlaut into a clob column via a parameter passed to a prepared statement, Informix JDBC will throw the following exception: $ java SimpleInsert -79754 java.sql.SQLException: Write Fault at com.informix.util.IfxErrMsg.buildExceptionWithMessage(IfxErrMsg. java:421) at com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:396) at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:378) at com.informix.jdbc.IfxSmBlob.createBlobOnServer(IfxSmBlob.java:40 1) at com.informix.jdbc.IfxResultSet.executeUpdate(IfxResultSet.java:2 19) at com.informix.jdbc.IfxStatement.executeUpdateImpl(IfxStatement.ja va:967) at com.informix.jdbc.IfxPreparedStatement.executeUpdate(IfxPrepared Statement.java:322) at SimpleInsert.main(SimpleInsert.java:37) If the umlaut is removed, the insert completes successfully. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix JDBC prior to 4.50.JC10. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix JDBC 4.50.JC10. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix JDBC prior to 4.50.JC10. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix JDBC 4.50.JC10. * **************************************************************** | |
Comment | |
Fixed in Informix JDBC 4.50.JC10. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.12.2022 17.02.2023 17.02.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |