How are joins handled using Hinernate.

Recent Questions

Difference between session.save() , session.saveOrUpdate() and session.persist()? view answer
Q.What is the difference between hibernate and jdbc ? view answer
Q. What is lazy fetching in Hibernate? With Example . view answer
Q.what is the advantage of Hibernate over jdbc? view answer
How to Integrate Struts Spring Hibernate ? view answer
How to prevent concurrent update in Hibernate? view answer
How to perevent slate object updatation in Hibernate ? view answer
What is version checking in Hibernate ? view answer
How to handle user think time using hibernate ? view answer
Q.Transaction with plain JDBC in Hibernate ? view answer
Q.What are the general considerations or best practices for defining your Hibernate persistent classes? view answer
Q.Difference between session.update() and session.lock() in Hibernate ? view answer
Q.Difference between getCurrentSession() and openSession() in Hibernate ? view answer
Difference between session.saveOrUpdate() and session.merge()? view answer
Filter in Hibernate with Example? view answer
Q.How does Value replacement in Message Resource Bundle work? view answer
Difference between list() and iterate() i9n Hibernate? view answer
Difference between session.load() and session.get() ? view answer
Deleting persistent objects view answer
SQL statements execution order. view answer
Difference between session.saveOrUpdate() and session.merge(); view answer
Modifying persistent objects? view answer
SQL Queries In Hibernate.. view answer
Filter in Hibernate view answer
Criteria Query Two Condition view answer
Equal and Not Equal criteria query. view answer
Cascade Save or Update in Hibernate ? view answer
One To Many Bi-directional Relation in Hibernate? view answer
One To Many Mapping Using List ? view answer
Many To Many Relation In Hibernate ? view answer
What does session.refresh() do ? view answer
Difference between session.load() and session.get()? view answer
Hibernate setup using .cfg.xml file ? view answer
How to add .hbm.xml file in sessionFactory? view answer
How to get Hibernate statistics ? view answer
How to set 2nd level cache in hibernate with EHCache? view answer
How to get JDBC connections in hibernate? view answer
How will you configure Hibernate? view answer
How to create Session and SessionFactory in Hibernate? view answer
What are the Instance states in Hibernate? view answer
What are the core components in Hibernate ? view answer
What is a Hibernate Session? Can you share a session object between different theads? view answer
addScalar() method in hibernate... view answer
Hibernate session.close does _not_ call session.flush ? view answer
What is the main difference between Entity Beans and Hibernate ? view answer
Difference between session.save() and session.saveOrUpdate()? view answer
How are joins handled using Hinernate. view answer
What is Hibernate proxy? view answer
What is the main advantage of using the hibernate than using the sql ? view answer
how to create primary key using hibernate? view answer
what is the advantage of Hibernate over jdbc? view answer
How to Execute Stored procedure in Hibernate ? view answer
what is lazy fetching in hibernate? view answer

!!! Hibernate Frequently Asked Questions !!!

How are joins handled using Hinernate.

Click to View Answer Below

!!!Answer!!!- From Technical Expert

Best is use Criteria query
Example -
You have parent class
public class Organization {
private long orgId;
private List messages;
}
Child class
public class Message {
    private long messageId;
private Organization organization;
}

.hbm.xml file

<class name="com.bean.Organization" table="ORGANIZATION">
<bag name="messages" inverse="true" cascade="delete" lazy="false">
            <key column="MSG_ID" />
            <one-to-many
                class="com.bean.Message" />
        </bag>

</class>

<class name="com.bean.Message" table="MESSAGE">
    <many-to-one name="organization" column="ORG_ID" lazy="false"/>

</class>
Get all the messages from message table where organisation id = <any id>

Criteria query is :
session.createCriteria(Message.class).createAlias("organization","org").
            add(Restrictions.eq("org.orgId",new Long(orgId))).add(Restrictions.in("statusCode",status)).list();

you can get all the details in hibernate website.
<a href="http://www.hibernate.org/hib_docs/reference/en/html/associations.html">http://www.hibernate.org/hib_docs/reference/en/html/associations.html</a>

Answered By :	das Replied Date : May 21 2008
Answer :	This helps me lot
Answered By :	das Replied Date : May 21 2008
Answer :	One to many A Person can have zero, one or more memos. <class name="myPackage.Person" table="Person"> <id name="pid" type="int"> <column name="pid" /> <generator class="assigned" /> </id> ... <set name="memos" cascade="all" lazy="true"> <key column="mpid"/> <one-to-many class="myPackage.Memos"/> </set> </class> <class name="myPackage.Memos" table="Memos"> <property name="mpid" type="int"> <column name="mpid" /> </property> <property name="memkz" type="string"> <column name="memkz" length="7"> </column> </property> The HQL query can use a left join, so it isselect p from myPackage.Person p left join p.memos m where p.id < :maxid and (m.memkz is null or m.memkz = :memkz)
Answered By :	null Replied Date : Mar 29 2012
Answer :
Answered By :	null Replied Date : Mar 28 2012
Answer :
Answered By :	null Replied Date : Mar 27 2012
Answer :
Answered By :	null Replied Date : Mar 26 2012
Answer :
Answered By :	null Replied Date : Mar 24 2012
Answer :
Answered By :	null Replied Date : Mar 24 2012
Answer :
Answered By :	null Replied Date : Mar 23 2012
Answer :
Answered By :	null Replied Date : Mar 22 2012
Answer :
Answered By :	null Replied Date : Mar 21 2012
Answer :
Answered By :	null Replied Date : Mar 21 2012
Answer :
Answered By :	null Replied Date : Mar 19 2012
Answer :
Answered By :	null Replied Date : Mar 18 2012
Answer :
Answered By :	null Replied Date : Mar 15 2012
Answer :
Answered By :	null Replied Date : Mar 15 2012
Answer :
Answered By :	null Replied Date : Mar 9 2012
Answer :
Answered By :	null Replied Date : Mar 8 2012
Answer :
Answered By :	null Replied Date : Mar 8 2012
Answer :
Answered By :	null Replied Date : Mar 7 2012
Answer :
Answered By :	null Replied Date : Mar 7 2012
Answer :
Answered By :	null Replied Date : Mar 1 2012
Answer :
Answered By :	null Replied Date : Feb 28 2012
Answer :
Answered By :	null Replied Date : Feb 27 2012
Answer :
Answered By :	null Replied Date : Feb 23 2012
Answer :
Answered By :	null Replied Date : Feb 23 2012
Answer :
Answered By :	null Replied Date : Feb 22 2012
Answer :
Answered By :	null Replied Date : Feb 21 2012
Answer :
Answered By :	null Replied Date : Feb 7 2012
Answer :
Answered By :	null Replied Date : Feb 7 2012
Answer :
Answered By :	null Replied Date : Feb 6 2012
Answer :
Answered By :	null Replied Date : Feb 3 2012
Answer :
Answered By :	null Replied Date : Feb 2 2012
Answer :
Answered By :	null Replied Date : Jan 23 2012
Answer :
Answered By :	null Replied Date : Jan 23 2012
Answer :
Answered By :	null Replied Date : Jan 19 2012
Answer :
Answered By :	null Replied Date : Jan 13 2012
Answer :
Answered By :	null Replied Date : Jan 13 2012
Answer :
Answered By :	null Replied Date : Jan 12 2012
Answer :
Answered By :	null Replied Date : Jan 12 2012
Answer :
Answered By :	null Replied Date : Jan 11 2012
Answer :
Answered By :	null Replied Date : Jan 10 2012
Answer :
Answered By :	null Replied Date : Jan 10 2012
Answer :
Answered By :	null Replied Date : Jan 9 2012
Answer :
Answered By :	null Replied Date : Jan 8 2012
Answer :
Answered By :	null Replied Date : Jan 7 2012
Answer :
Answered By :	null Replied Date : Jan 7 2012
Answer :
Answered By :	null Replied Date : Jan 6 2012
Answer :
Answered By :	null Replied Date : Jan 6 2012
Answer :
Answered By :	null Replied Date : Jan 6 2012
Answer :
Answered By :	null Replied Date : Jan 6 2012
Answer :
Answered By :	null Replied Date : Dec 9 2011
Answer :
Answered By :	null Replied Date : Dec 9 2011
Answer :
Answered By :	null Replied Date : Nov 7 2011
Answer :
Answered By :	null Replied Date : Oct 20 2011
Answer :
Answered By :	null Replied Date : Oct 11 2011
Answer :
Answered By :	null Replied Date : Aug 29 2011
Answer :
Answered By :	null Replied Date : Jul 27 2011
Answer :
Answered By :	null Replied Date : Jul 3 2011
Answer :
Answered By :	null Replied Date : Jun 9 2011
Answer :
Answered By :	null Replied Date : Jun 2 2011
Answer :
Answered By :	null Replied Date : Jun 2 2011
Answer :
Answered By :	null Replied Date : Jun 1 2011
Answer :
Answered By :	null Replied Date : May 23 2011
Answer :
Answered By :	null Replied Date : May 21 2011
Answer :
Answered By :	null Replied Date : May 17 2011
Answer :
Answered By :	null Replied Date : Apr 16 2011
Answer :
Answered By :	null Replied Date : Apr 11 2011
Answer :
Answered By :	null Replied Date : Feb 1 2011
Answer :
Answered By :	null Replied Date : Feb 1 2011
Answer :
Answered By :	null Replied Date : Jan 24 2011
Answer :
Answered By :	null Replied Date : Jan 21 2011
Answer :
Answered By :	null Replied Date : Jan 20 2011
Answer :
Answered By :	null Replied Date : Jan 16 2011
Answer :
Answered By :	null Replied Date : Jan 15 2011
Answer :
Answered By :	null Replied Date : Jan 14 2011
Answer :
Answered By :	null Replied Date : Jan 13 2011
Answer :
Answered By :	null Replied Date : Jan 13 2011
Answer :
Answered By :	null Replied Date : Jan 12 2011
Answer :
Answered By :	null Replied Date : Jan 10 2011
Answer :
Answered By :	null Replied Date : Jan 10 2011
Answer :
Answered By :	null Replied Date : Jan 9 2011
Answer :
Answered By :	null Replied Date : Jan 1 2011
Answer :
Answered By :	null Replied Date : Nov 28 2010
Answer :
Answered By :	null Replied Date : Nov 25 2010
Answer :
Answered By :	null Replied Date : Nov 19 2010
Answer :
Answered By :	null Replied Date : Nov 17 2010
Answer :
Answered By :	null Replied Date : Nov 17 2010
Answer :
Answered By :	null Replied Date : Nov 4 2010
Answer :
Answered By :	null Replied Date : Oct 27 2010
Answer :
Answered By :	null Replied Date : Aug 21 2010
Answer :
Answered By :	null Replied Date : Aug 14 2010
Answer :
Answered By :	null Replied Date : Aug 14 2010
Answer :
Answered By :	null Replied Date : Aug 9 2010
Answer :
Answered By :	null Replied Date : May 8 2012
Answer :
Answered By :	null Replied Date : May 13 2012
Answer :
Answered By :	null Replied Date : May 18 2012
Answer :
Answered By :	null Replied Date : Jun 18 2012
Answer :
Answered By :	null Replied Date : Jun 19 2012
Answer :
Answered By :	null Replied Date : Jun 26 2012
Answer :
Answered By :	null Replied Date : Jul 9 2012
Answer :
Answered By :	null Replied Date : Aug 6 2012
Answer :
Answered By :	null Replied Date : Aug 11 2012
Answer :
Answered By :	null Replied Date : Aug 16 2012
Answer :
Answered By :	null Replied Date : Sep 7 2012
Answer :
Answered By :	null Replied Date : Sep 8 2012
Answer :
Answered By :	null Replied Date : Sep 8 2012
Answer :
Answered By :	null Replied Date : Sep 8 2012
Answer :
Answered By :	null Replied Date : Sep 10 2012
Answer :
Answered By :	null Replied Date : Oct 10 2012
Answer :
Answered By :	null Replied Date : Nov 29 2012
Answer :
Answered By :	null Replied Date : Dec 13 2012
Answer :
Answered By :	null Replied Date : Dec 29 2012
Answer :
Answered By :	null Replied Date : Dec 30 2012
Answer :
Answered By :	null Replied Date : Jan 2 2013
Answer :
Answered By :	null Replied Date : Mar 10 2013
Answer :
Answered By :	null Replied Date : Mar 25 2013
Answer :
Answered By :	null Replied Date : Mar 30 2013
Answer :

Ask Question and get answer from Expert.
View Answers List from Expert.

TechFAQ

Technology Expert Comments

Recent Questions

!!! Hibernate Frequently Asked Questions !!!

How are joins handled using Hinernate.

Click to View Answer Below

!!!Answer!!!- From Technical Expert

You can also contribute to this answer: