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