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
I am using Informix 7.31 and JDBC 2.21 JC2.
I have tested the Upper function in a sample java program (not with jboss) and it works well.
I will try with Jboss later