SQL to HQL Converter Utility

sqltohql · **Joined:** Sat Aug 30, 2008 9:50 am **Posts:** 6

Please drop a mail at sqltohql@ymail.com if you need SQL to HQL convertion utility. This utility converts any complex SQLs (sub queries, joins, unions, groupby, etc.) to accurate HQL (Hibernate Query Language).

max · **Posted:** Sun Aug 31, 2008 3:05 pm

why dont you just post info here ? Or maybe its just a scam ? ;)

sqltohql · **Joined:** Sat Aug 30, 2008 9:50 am **Posts:** 6

Its not yet generalised, I would need your hbm file to do the final touch up.

max · **Posted:** Tue Sep 02, 2008 2:16 am

You can find all my mapping files in Hibernate test suite ;)

sqltohql · **Joined:** Sat Aug 30, 2008 9:50 am **Posts:** 6

It works for most of hbm files...

max · **Posted:** Tue Sep 09, 2008 9:44 am

so please tell us more ? :)

jAcke · **Joined:** Thu Sep 11, 2008 8:35 am **Posts:** 4

I was looking for such a utility.
Max, from your response may I assume that I will not find a good solution for this?

max · **Posted:** Thu Sep 11, 2008 12:19 pm

Well, I've never seen one and I can't imagine anything that can handle this except for very trivial conversions....hence why i'm interested in hearing about what sql2hql have to say/show ;)

jAcke · **Joined:** Thu Sep 11, 2008 8:35 am **Posts:** 4

Thanks Max!
say, what about tools that translates sql from a specific db to another specific db.
can they be any good in your opinion?

david · **Posted:** Sun Sep 21, 2008 2:58 am

Hibernate does a great job of converting HQL to many DB SQLs. :-).