Forums Register Login

Hibernate mapping

+Pie Number of slices to send: Send
Hi,

I am new to hibernate.

Right now I am doing a simple project on hibernate. I have a simple question

I have two tables for example: TableA and TableB.
TableA has TableId and TableAName.
TableB has TableId, UserId and TableBScore.

Both TableIds are primary keys. Now I would like to retrieve TableAName, TableBScore based on UserId from TableB. I have a basic idea that how to write in SQL.
Select A.TableAName, B.TableBScore from TableA A,TableB B where A.TableId=B.TableB and B.UserId=1;

I was trying to do this using HQL I couldn't understand how to do this scenario. Can anyone help me in this?

Thanks for your help in advance.
+Pie Number of slices to send: Send
It depends on your mapping between the two objects. If you have mapped the association then it is very simple

Select A.TableAName, B.TableBScore from TableA A,TableB B where A.TableId=B.TableB and B.UserId=1;

in HQL it would be

"SELECT a.tableAName, b.tableBScore FROM ObjectA a JOIN ObjectB b WHERE b.userId=1"

tableAName and tableBScore are the attributes of your Objects, not field names here.

Hope that helps.

Also note that a projection query in Hibernate returns an Object[] for the records. If you want the full ObjectA with reference to ObjectB then just do

in HQL

"FROM ObjectA a JOIN FETCH ObjectB b WHERE b.userId=1"

Mark
+Pie Number of slices to send: Send
You need to join both entities. As per your code, we are assuming that A.TableId=B.TableB are same. Means both tables have same primary key. So this is one to one mapping and you can use primaryKey join annotation to map both entity. In that case you need to pass userId only in find method for table B and you will get data from Table A also.

Make sure table B is the owner of the relationship.
Getting married means "We're in love, so let's tell the police!" - and invite this tiny ad to the wedding:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1537 times.
Similar Threads
Hibernate one-to-on id mapping issue
FOREIGN KEY
Hibernate Composite & foreign key, please help
Legacy and Hibernate1-2-M Mapping
Hibernate 3.1
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 03:58:45.