Validation of HQL query in the Java code / xml file

[epbernard]

When an Hibernate configuration is provided, Is the IDE able to validate a given HQL query written in the code or in the XML files?

The code level warning would be a killer feature

[maxandersen]

we could do this yes.

Just run the query through the QueryTranslator and mark a query as bad if it does not accept it.

Put it in jira (my biggest concern though is scalability of it...for e.g. huge projects)

[epbernard]

Eclipse calculates the warning when you actually see the java code, doesn't it?

My main concern is the ability to "reckognize" an HQL query in the code. (probably find the query used when createQuery is called).

[epbernard]

My point is to actually have a "compile-time like checking" PowerBuilder like feature reinvented by LINQ

[maxandersen]

huh ?

[maxandersen]

well i would target @NamedQuery first.

createQuery is triggy, but I guess we can assume if you have just a string in there it will be safe to validate it.

e.g.

q.createQuery("from Product p where p.x=?") would be checked but
I would skip

q.createQuery("from Producer p where " + someextra);

but named query annotations is doable first since they are much easier more efficient to locate.

[epbernard]

So
1. target @NamedQuery(ies) and hbm/ ejb3 DD
2. target simple strings (createQuery("...") or createQuery(CONSTANTS)
3. do some magic-ish things for more complex strings :-)

1 is cool
2 is fantastic
3 is a + but not that critical frankly