1 Reply Latest reply on Oct 22, 2003 11:10 AM by Raja

    JDBC functions

    sbello Newbie

      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



        • 1. Re: JDBC functions
          Raja Master

          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