JDBC functions

[sbello]

I'm working with Jboss and Informix. 7.30 DB. I have a problem: when I try to execute a query through JDBC, I can't use functions like trim(), or upper(). It's strange, since this DB supports those functions, I have tested it using dbaccess. The messages I get using Jboss are like this: "java.sql.SQLException: Routine (upper) can not be resolved". Could anybody help me?

Thanks a lot

[raja05]

You might want to add these functions in ur standardjbosscmp-jdbc.xml in the config directory of JBoss.
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
</function-mapping>

Put this under the type-mapping for informix. Look at the oracle examples in teh same file to see how the function entries can be made.

-Raj