Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Avoid duplicate inf

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

shearer

Post subject: Avoid duplicate inf

Posted: Sat Oct 27, 2007 12:51 pm

Newbie

Joined: Sat Oct 27, 2007 12:32 pm
Posts: 2

I have two tables with one to many relationship. What can I do in order to avoid duplicate information.

For instance

Categories
Id
Name

Products
Id
IdCategory
Name

What can i do to select information from both tables and also to specify criteria for both tables without retrieving duplicate information???

Im not sure if the only way is with a subquery
Thanks

Top

egore911

Post subject:

Posted: Mon Oct 29, 2007 6:30 am

Newbie

Joined: Thu Oct 18, 2007 10:38 am
Posts: 7

Try the query:

Code:

Query q = session.createQuery("select cat from Products as prod inner join prod.idCategory");
List<Products> result = q.list();

for (Products p : result) {
  System.out.println(p.getName() + " is in " + p.getIdCategory().getName());

No garantuee for this. The interesting part is the inner join.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum