Hi,

Does anybody know how to use the HSQL in a property formula, like:

I searched topics in the forum and a guy saild that function would be supported in Hibernate 2.2. Is it realy? And when will Hibernate 2.2 or 3 will be released?


Thanks in advance.

James

This is already supported in Hibernate 2.1, just use it. However, it's a SQL expression, not an HQL expression.

A problem with a SQL expression is that wrong SQL statements will be generated from the same mapping file used in the different schemas. It is better that all possible query statements in the model are written in the same language, either SQL or HQL. Do you think so?

Regards,

James

I think that queries should be externalized to the mapping files, hence I don't see a problem with either language or "wrong SQL".

I do agree. But what I was suggesting to consider is that using HQL in a formula property will keep the model more flexible and programmers do not need to know stuff, e.g the real schema, table name or column name, in the depoyment process, but just use HQL in the formula. In my opition, it is a good engineering practice not to use two classes of query statements together in the same model.

Just a personal point and welcome any discussion.

Regards,

James

But you are looking at the database schema anyway when you write the mapping, so writing a SQL expression is perfectly fine. Keep in mind that you sometimes _need_ native SQL to get what you want in the formula. This is much more powerful than using HQL, which has a higher abstraction level.