IT42707: JDBC: A -79754 WRITE FAULT EXCEPTION IS THROWN WHEN INSERTING ANUMLAUT INTO A CLOB USING A PARAMETERIZED PREPARESTATEMENT

APAR status

• Closed as program error.

Error 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.
  

Local fix

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.                          *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix JDBC 4.50.JC10.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IBM CSDK

• Fixed component ID

  5724C2381

Applicable component levels