Re: Problem with Java UDR (-7438 Unsupported data type)

Without code to look at or a sample insert statement, I would take a look at the TEXT field. It is possible that you have a driver which is masking some of the interactions with BLOB/CLOB/TEXT type data in your ide. ( Just a thought ) Chris S. On Tue, 2007-05-08 at 09:46 -0700, tol7481@iperbole.bologna.it wrote: > 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 > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list