2 Replies Latest reply on Aug 19, 2004 3:28 AM by Alexey Loubyansky

    Jboss-QL function mapping?

    Jon Beyer Newbie

      Examining 'standardjbosscmp-jdbc.xml', I see numerous jboss-ql function -> SQL function mappings such as

       <function-mapping>
       <function-name>locate</function-name>
       <function-sql>locate(?1,?2)</function-sql>
       </function-mapping>
      


      Is it possible to extend jboss-ql by adding new entries? Such as:

       <function-mapping>
       <function-name>month</function-name>
       <function-sql>month(?1)</function-sql>
       </function-mapping>
      


      Or is jboss-ql limited to the defined functions?

      Thanks,
      Jon