i'm new to hibernate and am researching using sql script. i was able to generate simple sql (single table) using session.createSQLQuery()

i wish now to create a more complex query based on the following:

SELECT A.ACCOUNT, A.TYPE,
C.LASTNAME, C.FIRSTNAME,
AD.ADDRESS1, AD.CITY
FROM schema.ACCOUNT A, schema.CONTACT C, schema.ADDRESS AD
WHERE C.ACCOUNTID = A.ACCOUNTID(+)
AND C.ADDRESSID = AD.ADDRESSID(+)
AND C.LASTNAME = 'myname'

what might the hbm.xml consist of? and is thera an HQL configuration that is more suited.

i wish to continue to use SQL due to the development team experience

any documentation links would be helpful

thanks -

well, your hbm.xml files are needed to map the tables and HQL is not a configuration language but a SQL abstraction language. you can continue to use native SQL through hibernate

http://www.hibernate.org/5.html