Hi,

I have an sql similar to the one given below. I am trying to figure out how to acheive this in hibernate 3.

I am a beginner to hibernate and I could succesfully do the CRUD operations when the query is something like this: 'select * from table'.

SELECT
i.id,
i.sa,
i.curr,
i.num,
i._line_id,
acc.cd,

FROM

ITEM i,
ACCOUNT acc
WHERE
i.cd = 'ACT' AND
i.type_cd = 'LINE' AND
acc.type_cd = 'S'

How do I acheive the CRUD operations in hibernate 3 with something similar to the above query.

Any help will be greatly appreciated.

Thanks

Assuming you have an Item class and an Account class, your hql query would look pretty similar to what you have already written, except that it would use case sensitive class names and property names instead of table/column names. And, you could get objects of type Item, Account as return values instead of individual column values.

SELECT i, acc
FROM
Item i,
Account acc
WHERE
i.cd = 'ACT' AND
i.type_cd = 'LINE' AND
acc.type_cd = 'S'

Hi,

Can you help me in putting the class and .hbm file for the account with the basic columns and attributes in the class.

Appreciate it.

-Ram

It would be something along hte lines of....

public class Account {
int id;
String cd;
String typeCd;

//generate the getters and setters for hte above properties...
}


<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="Account" table="ACCOUNT" >
<id name="id" type="integer"/>
<property name="cd" type="string" column="cd"/>
<property name="typeCd type="string" column="type_cd"/>
</class>
</hibernate-mapping>

PS. Dont' forget to Rate the posting.

Hi Again,

should it not mention any relationship between the account and the item table in the .hbm file.

When I load the class with the primaykey of the item table I want to pick one of the columns in the account table based the foriegnkey relationship.

Thanks for you help.

-Ram