2 Replies Latest reply on Oct 12, 2007 7:43 AM by Pete Muir

    How to addSqlFunction?

    Markus Heidt Newbie

      I need the week() function in HQL.

      If I had a HibernateSessionFactory and its Configuration I knew how to add the Sql function via addSqlFunction.

      But as I'm using annotations and ejb3, I'd appreciate any help.

      A "not possible" is an answer as well...

      The problem is, that I'm storing the hql queries in a database for a recursive tree, so that I try to prevent a mix of hql and native sql...

      Kind regards,
      Markus Heidt