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