Hibernate Automatic Dirty Check for Detached Objects

To deal with Dirty check for detached objects in Hibernate there are two ways:

1) Use select-before-update=”true” mapping into your .hbm.xml file:

<class name=”com…….AbcVO”
table=”ABC” select-before-update=”true”>

2) By extending some of its public API:

http://www.brimllc.com/2010/08/hibernate-automatic-dirty-check-for-detached-objects/

SubSelect in hbm.xml file

<class name=”com……StaffView”
entity-name=”staff_phase2_with_Inactive”>
<subselect>
<![CDATA[
SELECT DISTINCT u.ID,
u.FIRST_NM,
u.LAST_NM,
u.MIDDLE_INIT_NM,
u.FULL_NM,
u.PRFRRD_FRST_NM,
u.STTS_CD,
u.STTS_NM
FROM USER_TABLE u
]]>
</subselect>
<id name=”staffSID” type=”string” length=”28″>
<column name=”ID” />
<generator />
</id>
<property …

.

.

.

.

.

.
</property>
</class>

How to add where clouse into xml.hbm mapping file

For many-to-one:

<many-to-one name=”rankTypeLookupData”
formula=”(SELECT l.LKP_ID FROM EQ_LOOKUP_DATA l WHERE l.DROPDOWN_CODE = ‘BV_STAFF_RANK_TYPE’ AND l.LKP_KEY = INDVL_RANK_TYPE)”
class=”com……LookupData” not-found=”ignore”>
<column name=”INDVL_RANK_TYPE” />
</many-to-one>

For one-to-many:

<set name=”regionList” table=”BV_REGION” cascade=”all” fetch=”join”
outer-join=”true” where=”DEL_IN = ‘N’” inverse=”true”>
<key column=”INDVL_RANK_ID” />
<one-to-many
class=”com……..StaffTeamRankRegion” />
</set>

Issue with createCriteria result set, class name appended by _$$_javassist_

Issue:  _$$_javassist_ is appended after class name, when you are using createCriteria(xyz.class) which have <set> or <bag> (one-to-many) relationship with Object that having <composite-id> instead of <id>.

Resolution: Instead of Using createCriteria(xyz.class), use EntityName for Criteria Query.

Ex: DetachedCriteria detachedCriteria = DetachedCriteria.forEntityName(“xyzSearch”);

Impact of Issue:

1. For java, if you are using any code which have  comparison with class name it will fail in that case.
2. If you are using any communication by RMI like: Spring BlazeDS for Flex & Java, It will not able to cast the Object in proper format & will give result in generics Object format.

How to use sequence in ID tag of hbm.xml???

How to use sequence in ID tag of hbm.xml???

<id name=“id” type=“java.lang.Long” column=“ID”>

<generatorclass=“sequence”><paramname=“sequence”>XYZ_TAG_STAFF_SEQ</param></generator>

</id>

How to call store procedure or package in Hibernate???

How to call store procedure or package in Hibernate???

Please find attachment for the solution: StoreProcCallWithHibernate

How to use Entity Name, specified in hbm.xml in DetachedCriteria???

 How to use Entity Name, specified in hbm.xml in DetachedCriteria???

OR

How to use OR Restriction in Criteria Query???

DetachedCriteria criteria = DetachedCriteria.forEntityName(“staff_phase2″);

Criterion crit1 = Restrictions.ilike(“lastName”, searchText.trim(), MatchMode.START);

 Criterion crit2 = Restrictions.ilike(“firstName”,searchText.trim(), MatchMode.START);

Criterion staffSearchCriterion = Restrictions.or(crit1, crit2); 

criteria.add(staffSearchCriterion);

Please find hbm.xml file used for this post, for your refrence: entity-name

Parent Child Join With Criteria & DetachedCriteria using HibernateCallback

How to join parent table to child table using Criteria Query???

Please find attachment for solution:

ParentChildWithCriteriaJoin

 

hbm.xml many-to-one & one-to-many Example

Example of many-to-one & one-to-many hbm.xml mapping

Mapping

Examples: SQL, HQL for Hibernate

 

HQL:

public List<CountryView> fetchCountryViewList(Long regionId) {

           String hqlQuery = ” from RegionView regionView where regionView.componentId = ‘BRKRVT’”;

           Session session = getSession();

 

           Query query = session.createQuery(hqlQuery);

 

           List<CountryView> result = query.list();

           returnresult;

}

 

SQL: