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

    Function mapping problem

    Baligh Belgacem Newbie

      Hi,

      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-mapping>
      <function-name>substring</function-name>
      <funtion-sql>substr(?1, ?2, ?3)</function-sql>
      </function-mapping>


      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

      bbm