Hi all,

I have a web application thats output is dependent on sql queries. currently the application is tightly bound with oracle database.
We are required to make the appl. db independent, so we are opted hibernate, because it gives a user to write hqls.
Currently the existing application is using the select case ... then ... end stmts.
So my question is, can i use "case" stmt in hql select queries, even if the underlying database (say mysql) does not provide the case feature straight forward. Or there is some internal handling of case in hibernate itself, even if the underlying db has no support for case.

Waiting for your reply.
Thanks in advance
Debojit

Dont use database specific sql in hql. hibernate will not handle it if database does not support a particular one