Hai Friends

I am working with Hibernate 3.0 and my DataBase is MS SQL 2000

I have a class called Contact and there are two classes which extends this class,these are called ContactAddress,ContactQualification.I am using table per subclass stratergy.

My problem is i want to retrieve all the information to a particular ID along with the subclasses data also.Can anyone help me

I have written the query like this

session.createQuery("from com.yash.hibernate.Contact as contact where contact.id = :fname").setParameter("fname", new Integer(2));

Is this right ? any changes i have to made. ?


Please help me i am in pressure to sovle this one.

Thanks in Advance.

Yes, with this query, you retrive data of the superclass along with data of one of the subclasses (if they shared same primary key).

Thanks for your reply but can you please tell me how to capture the data produced by the above query and display it (I mean do I need to use Iterator if so can please you tell me ) .Yes i am have same PK .