I'm new to hibernate and interested to know wheather there's any way (or tool) can debug HQL(or hibernate-provided query language) more directly; for user can key in their query and see the result immediately (or similar tool like sqlplus/sql analyzer). Though I know, thorugh generated SQL (hibernate setting), we're able to debug error when coding programs. Yet it's a tedious steps. For instance, if I use query like Session.find("select a, b from a in class A, b in class B where ... ") it may generate whole columns, of which many are meaninglessly to us (when debugging). So I'm curious that anyone knows weather there're tools providing more intuitive way to test prgrammers's query being right or wrong. (or any better any ideas are welcome)
I appreciate any suggestions,
thank you very much.
|