Hi all,

I've recently started using Hibernate, and have been loving it. It just helps so much!

One problem that I have had with it is the queries - the queries are strings, which don't get compiled. It would be nice to be able to have the queries compiled to have them checked for validaty. In particular, I would like to be able to change an objects attribute name, and have the problem highlight for me.

For example, I might have a query:

"from object as o where o.name = ?"

If the attribute 'name' changes in o, the query, because its a string, won't throw a compile exception, and I won't know that there is a problem until runtime. Is there a way around this?

Thanks for any suggestions,

Mark

PS. Named SQL queries and the criteria approach are not solutions. Named sql queries do not get compiled at compile time, and neither does the criteria approach.

ie.
List cats = sess.createCriteria(Cat.class)
.add( Expression.like("name", "Fritz%") )
.add( Expression.between("weight", minWeight, maxWeight) )
.list();

The "name" is still being added as a string, which is the problem

No, not yet. Hasn't this been discussed here allready some days ago?

Hi All,

Terribly sorry if I've brought up a topic that was already discussed. I did take a look around before I posted, but probably missed the obvious. Would you be so kind as to point me in the right direction, or with a link to the earlier discussion so I can educate myself?

Thank you for pointing out that this isn't possible right now. That helps. I've thought about it for a bit, and it seems to me like a difficult problem, but it would be a nice one to solve.

Best regards,

Mark

Well, it was in a thread started by you http://forum.hibernate.org/viewtopic.php?t=927253&highlight=query+compile Simply crossposting the same stuff again is not especially productive.

I cross-posted because I thought I would try the beginners forum first, in case this was a dumb/simple question. Apparently it wasn't and no one there could give me a difinitive answer either, so I thought I would try here.

This approach seems appropriate to me, but let me know if you think otherwise and what else I could have done instead.

Thanks,

Mark