home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)