0 Replies Latest reply on Aug 25, 2004 5:29 AM by Baligh Belgacem

    Function mapping problem

    Baligh Belgacem Newbie


      i am using JBoss with Oracle 8. I have a CMP Bean which contains a finder with the next Query:

      select OBJECT(t) from table t where substring(t.field) = ?1

      the function mapping of the function substring in oracle 8 is as follows:

      <funtion-sql>substr(?1, ?2, ?3)</function-sql>

      but it doesn't work. The query can be comiled, but the finder generate an SQLException (invalid column name) at runtime.
      I looked in the trace files of Oracle, it seems that the function substring is not mapped to substr.

      can some one tell me why?

      thank you