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) | |