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.checkQu eryStatus(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(IfxR esultSet.java:394)
com.informix.jdbc.IfxStatement.executeImpl(IfxStat ement.java:890)
com.informix.jdbc.IfxPreparedStatement.execute(Ifx PreparedStatement.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

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.checkQu eryStatus(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(IfxR esultSet.java:394)
> com.informix.jdbc.IfxStatement.executeImpl(IfxStat ement.java:890)
> com.informix.jdbc.IfxPreparedStatement.execute(Ifx PreparedStatement.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