Hibernate .createSQLQuery(...) mapping

[Jimmy Clark]

Hi,

Is it possible to map a class to the results of a SQL query instead of an actual table? This would be used for creating objects from data already in the database, not saving data to the database.

Say we have a query that pulls data from two tables.

SELECT T.account, V.firstBal, V.secondBal
FROM dbo.TestAccount as T, dbo.TestBal as V
WHERE T.month = 'xxx';

Can we map this to the class below and populate the objects with the createSQLQuery(...) method?

public final class AccountView {
    private String account;
    private String firstBal;
    private String secondBal;
...}

Something like

List l = session.createSQLQuery("SELECT ...").addEntity("AccountView).list();

[ August 09, 2008: Message edited by: James Clark ]