Hello,

If I use this kind of configuration on my hibernate.cfg.xml:



Can I do querys in HQL language or only in SQL?

Cheers!

The hibernate.dialect indicates to hibernate the database for which it needs to generate SQL given the HQL or Criteria Objects that you construct in your code. It does not define what you use in your program. Ideally, you should always be using HQL or the criteria API. Although for very exceptional scenarios where hibernate does not support a database specific SQL function or feature, you can use the Session.createSQLQuery() method that the Session Interface exposes.

Hello ranjan_george!

Ok I'ts works.

Thanks!