Hi,

I am new to Hibernate and I have a question about mapping specific columns to a bean.
I have a SQL query that joins to 2 tables. I am only retrieving a limited number of the columns from each table.

What would be the best/easiest way to populate a single java bean with the columns from both tables ?

Thanks in advance!

Ive found that if you want to stick with standard sql and use hibernate at the sametime, use createSQL()


Iterator results = sqlSession.createSQLQuery(query)

You are also going to want to use .addScalar after that too. This will indicate which values you are actually returning.


String query = "select a, b from table";
Iterator results = sqlSession.createSQLQuery(query)
.addScalar("a",Hibernate.STRING)
.addScalar("b",Hibernate.STRING).list().iterator();

then you can pull the values out by going through the iterator like this

while (results.hasNext()) {
Object[] column = (Object[]) results.next();



the value for a will be in column[0] and the value for b will be in column[1]

hope that helps.

Hi,
Thanks for the reply.

I have found that if I map a new entity bean in my hbm.xml file and then call the addEntity(class name), Hibernate will populate the bean, with only the columns from my SQLQuery, for me successfully.

I guess this would be the same as a DataTransferObject.


My question(s) are as follows:

1. Is this bad practice ?
2. Is there a down side to doing this ?
3. Is there a better way ?