Problem with Java UDR (-7438 Unsupported data type)

Posted in 2007

tol7481@iperbole.bologna.it — 8 May 2007 09:46:21 -0700 — source: Usenet: comp.databases.informix

Hi, I've developed a Java UDR and the call to this UDR produces, after some processing, an INSERT of a record in a table but this insert fails... I get the following stack trace informix.jvp.dbapplet.impl.GenErr.sqle(GenErr.java(Compiled Code)) informix.jvp.dbapplet.impl.SAPIRequestImpl.checkQueryStatus(SAPIRequestImpl.java(Compiled Code)) com.informix.jdbc.IfxDirectProtocol.executeCommand(IfxDirectProtocol.java: 666) com.informix.jdbc.IfxDirectProtocol.executeExecute(IfxDirectProtocol.java: 1718) com.informix.jdbc.IfxDirectProtocol.executeExecute(IfxDirectProtocol.java: 1692) com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:394) com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:890) com.informix.jdbc.IfxPreparedStatement.execute(IfxPreparedStatement.java: 301) ... The INSERT is perfomed with a PreparedStatement. The SQLException has sqlstate IX000 and error code -7438 (Unsupported data type). I executed the very same Java code of the UDR from my IDE using the same data on the same DB and it worked without any problem... The table's fields have the datatypes CHAR, DATE, DECIMAL and TEXT. I'm using Informix 10.0 on AIX. Any idea? Thanks in advance, Andrea