I just want to pass through the working SQL through Hibernate but have Hibernate convert rows back into objects.

Have several complex legacy SQL queries that blow up during Hibernate's parsing. Hibernate createSQLQuery() forces one to addEntiity() with an alias even though no alias is in legacy code. Put proper alias stuff in legacy and hell brakes loose during parsing.

No, I don't want to take time to convert all the queries to HQL and retest them all.



Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

use h3.1 and <return-property> or if the queries return teh same column names as used in the mapping of the objects just dont specify any alias and it will work.