Struts Tutorials:
Struts2 Tag CheckBoxList
, Checkbox, Iterator, IF
Struts2 Tag Library Example
Struts2 Tiles Example
Struts2 Tiles I18N Example
Struts2 Questions
Struts Tiles I18N Example
Struts Eclipse MVC
Struts2 Tags
Struts2 Example and Tutorial
Struts MVC
Struts2 Validation



Hibernate Tutorials:
Hibernate Case Study
Class Hierarchy Persist Example
Using Hibernate Interceptor
Hibernate Questions with Answer
Hibernate Many-to-Many Mapping Example
Hibernate one-to-many Mapping Example
Hibernate and ORM tools
Spring Hibernate Example
Hibernate SessionFactory Example
Hibernate Mapping Class Hierarchy
Hibernate Questions
Hibernate SessionFactory Questions

Spring Hibernate Example:
Spring Hibernate Case Study

Written By : admin
Title :
SessionFactory

Description :
Question on Session Factory Creation
More...

Written By : Amit
Title :
Interview Questions

Description :
On Hibernate
More...

Written By : Amit
Title :
mapping class hierarchy table per subclass

Description :
Example
More...

Written By : Amit
Title :
ways create Hibernate SessionFactory

Description :
Example
More...

Written By : Amit
Title :
Spring Hibernate Integration example

Description :
Example
More...

Tags/Keywords : Hibernate named, Hibernate query,Hibernate named query,  Hibernate sample,Example code
Author : ISHTEK
Date (Year/Month/Date): 2009-06-27
Hibernate Query with characters conflicting with Markup.

Please be informed that NONE of the design/code from this
page is claiming to be some sort of best practices and we DO NOT expect
any of our visitor/reader of this page to assume this as some sort of
best practice for any context and should not be using this 
as it is without appropriate evaluation to their, so to say, 
specific programming context.

This page intends only to provide bit and piece of known ways  for
doing some sort of example and may not be fit for any other purpose.


Hibernate Query with characters conflicting with Markup.

Some of the characters or symbols, those if used in an XML
file will cause XML parser to malfunction, thus causing
program non functioning.



Advertisement : 



Similarly a case study discussed here:
If >, <,>=, <= etc are some of the notations,
those are used in SQL query to represent conditionality,
suchh as greater than, lesser than, greater than and
equals to, lesser than and equals to some value.

Suppose need arises to use these notations/operators along
with Hibernate named query in HBM XML file. In that case 
one has to use CDATA along with the named query in HBM file.

Using an example you might have seen already in one of the
examples on Hibernate:

Employee and Department sharing many to one type of association
mapping with one another.

This example uses following software environment:

1. JDK 5.0
2. Eclipse 3.2
3. Hibernate 3.2
4. HSQLDB 1.8.0

Table creational DDL is as follows:
---------------------------------------------------------

create table Address
(address_id varchar(10) not null, addr_line_1 varchar(50) not null,
 addr_line_2 varchar(50) not null,addr_line_3 varchar(50) not null,
 city varchar(20) not null, state varchar(20) not null, pin integer,
 primary key(address_id));

---------------------------------------------------------

Java POJO for this example is Address.java
Address.java
---------------------------------------------------------
package demo.profile;

import java.io.Serializable;

public class Address extends Contact implements Serializable {

	private String addressId;
	private String addrLine1;
	private String addrLine2;
	private String addrLine3;
	private String city;
	private String state;
	private int pin;
	public String getAddrLine1() {
		return addrLine1;
	}
	public void setAddrLine1(String addrLine1) {
		this.addrLine1 = addrLine1;
	}
	public String getAddrLine2() {
		return addrLine2;
	}
	public void setAddrLine2(String addrLine2) {
		this.addrLine2 = addrLine2;
	}
	public String getAddrLine3() {
		return addrLine3;
	}
	public void setAddrLine3(String addrLine3) {
		this.addrLine3 = addrLine3;
	}
	public String getCity() {
		return city;
	}
	public void setCity(String city) {
		this.city = city;
	}
	public int getPin() {
		return pin;
	}
	public void setPin(int pin) {
		this.pin = pin;
	}
	public String getState() {
		return state;
	}
	public void setState(String state) {
		this.state = state;
	}
	public String getAddressId() {
		return addressId;
	}
	public void setAddressId(String addressId) {
		this.addressId = addressId;
	}
}
---------------------------------------------------------

My Example configuration file for creating Hibernate SessionFactory
is as follows:
hibernate.cfg.xml
---------------------------------------------------------
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

    <session-factory>

        <!-- Database connection settings -->
        <property name="connection.driver_class">
		  org.hsqldb.jdbcDriver
	</property>
        <property name="connection.url">
		  jdbc:hsqldb:hsql://localhost/
	</property>
        <property name="connection.username">sa</property>
        <property name="connection.password"></property>

        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>

        <!-- SQL dialect -->
        <property name="dialect">
		  org.hibernate.dialect.HSQLDialect
	</property>

        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>

        <mapping resource="demo/profile/address.hbm.xml"/>

    </session-factory>

</hibernate-configuration>
---------------------------------------------------------



Advertisement : 



The named query is defined in the address.hbm.xml file:

address.hbm.xml
---------------------------------------------------------
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="demo.profile">
  <class name="Address" table="Address">
   <id name="addressId" access="property" column="address_id"/>
   <property name="addrLine1" column="addr_line_1"/>
   <property name="addrLine2" column="addr_line_2"/>
   <property name="addrLine3" column="addr_line_3"/>  	
   <property name="city" column="city"/>
   <property name="state" column="state"/>
   <property name="pin" column="pin"/> 
  </class>
  <query name="findaddress">
      <![CDATA[ 
      from Address a where a.pin > ? 
      ]]>
  </query>
  
</hibernate-mapping>
---------------------------------------------------------

Testing client program for this example is very simple,
it just gets the named query from the HBM file, and then
sets appropriate parameter value to the query, starting
with the parameter index as '0'. 
Final result is the number of the address records fetched from
database, in this example it is '1'.

AddressClient.java
---------------------------------------------------------

import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;


public class AddressClient {
  private static final SessionFactory sessionFactory;
  static {
   try {
  // Create the SessionFactory from hibernate.cfg.xml
    sessionFactory = new Configuration().configure().buildSessionFactory();
   } catch (Throwable ex) {
  // Make sure you log the exception, as it might be swallowed
     System.err.println("Initial SessionFactory creation failed." + ex);
     throw new ExceptionInInitializerError(ex);
   }
  }

  public AddressClient() {
    Session session = sessionFactory.openSession();
    session.beginTransaction();
    List listAddress = session.getNamedQuery("findaddress")	                                               .setParameter(0, 753012).list();
    System.out.println(listAddress.size());
  }
	/**
	 * @param args
	 */
	public static void main(String[] args) {
        new AddressClient();
	}
}
---------------------------------------------------------

Author of this article/writeup has expressed his/her willingness
to help or guide users with any technical difficulties he/she faces
while working with the example code environment setting up, running
and resolving any such exception raised during compile or at runtime.
You may ask for any technical doubt or seek technical help related to
this article by using following form to reach for technical help
from the Author for FREE.

This article's Author shall be reading your request and responding
within reasonable time (no resolution timeframe defined as such).

Copyright © 2008-2009, Interview-Questions-Tips-Forum, All Rights Reserved.