Hibernate Archives

Hibernate mapping files detail

January 29, 2023January 28, 2023 by Manish Sahu

Mapping Declaration Object/relational mappings are usually defined in XML document. The mapping language is Java-centric, meaning that mappings are constructed around persistent class declarations, not table declarations. Mapping Document

<?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="pojo">
<class name="Employee" table=”Employee”>
<id name="id" type=”java.lang.Long”>
<generator class=”sequence”/>
</id>
</class>
</hibernate-mapping>

<strong><class>  </strong>element

<?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="pojo">

</id>

</class>

</hibernate-mapping>

<strong><class> </strong>element

The element maps the domain object with corresponding entity in the database. hibernate-mapping element allows you to nest several persistent mappings, as shown above. It … Read more

Detail of program

January 29, 2023January 28, 2023 by Manish Sahu

Hibernate client application is the actual application who wants to intrect with database software. In the client application development two important roles are involved. get hibernate session object from a pool called hibernate seassionFactory. Use hibernate session object to perform curd operation on the database table. Persistance operation single row operations, Bulk operations. Single row … Read more

Hibernet first program

January 29, 2023January 28, 2023 by Manish Sahu

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>
<property name="hibernate.dialect"<org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/ebhor</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">root</property>
<mapping resource="Pojo/Employee.hbm.xml"/>
</session-factory>
</hibernate-configuration>

<?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>

<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>

<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/ebhor</property>

</session-factory>

</hibernate-configuration>

Employee.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>
<class name="Pojo.Employee" table="employee" catalog="ebhor">
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator />
</id>
<property name="firstName" type="string">
<column name="FirstName" length="45" not-null="true" />
</property>
<property name="lastName" type="string">
<column name="LastName" length="45" not-null="true" />
</property>
<property name="email" type="string">
<column name="Email" length="45" not-null="true" />
</property>
</class>
</hibernate-mapping>

<?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>

</id>

</property>

</property>

</property>

</class>

</hibernate-mapping>

Employee.java

package Pojo;
public class Employee implements java.io.Serializable {

private Integer id;
private String firstName;
private String lastName;
private String email;

public Employee() {
}

public Employee(String firstName, String lastName, String email) {
this.firstName = firstName;
this.lastName = lastName;
this.email = email;
}

public Integer getId() {
return this.id;
}

public void setId(Integer id) {
this.id = id;
}
public String getFirstName() {
return this.firstName;
}

public void setFirstName(String firstName) {
this.firstName = firstName;
}
public String getLastName() {
return this.lastName;
}

public void setLastName(String lastName) {
this.lastName = lastName;
}
public String getEmail() {
return this.email;
}

public void setEmail(String email) {
this.email = email;
}
}

package Pojo;

public class Employee implements java.io.Serializable {

private Integer id;

private String firstName;

private String lastName;

private String email;

public Employee() {

}

public Employee(String firstName, String lastName, String email) {

this.firstName = firstName;

this.lastName = lastName;

this.email = email;

}

public Integer getId() {

return this.id;

}

public void setId(Integer id) {

this.id = id;

}

public String getFirstName() {

return this.firstName;

}

public void setFirstName(String firstName) {

this.firstName = firstName;

}

public String getLastName() {

return this.lastName;

}

public void setLastName(String lastName) {

this.lastName = lastName;

}

public String getEmail() {

return this.email;

}

public void setEmail(String email) {

this.email = email;

}

EmpInsert.java

package HibClient;

import Pojo.Employee;
import org.hibernate.cfg.Configuration;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.Session;
import org.hibernate.HibernateException;

public class EmpInsert
{
public static void main(String args[])
{
try
{
// This step will read hibernate.cfg.xml and prepare hibernate for use
Configuration conf = new Configuration();
Configuration cf = conf.configure();
SessionFactory factory = cf.buildSessionFactory();
Session session = factory.openSession();
System.out.println("++++++++++++++");
//Create new instance of Contact and set values in it

Employee emp = new Employee();

emp.setFirstName("anurag");
emp.setLastName("Singh");
emp.setEmail("anuragsingh11ls@gmail.com");
System.out.println("insertion");
Transaction tx=session.beginTransaction();
session.save(emp);
tx.commit();

session.close();
}
catch (HibernateException e)
{

System.out.println(" "+e.getMessage());
e.printStackTrace();
}
} 
}

package HibClient;

import Pojo.Employee;

import org.hibernate.cfg.Configuration;

import org.hibernate.SessionFactory;

import org.hibernate.Transaction;

import org.hibernate.Session;

import org.hibernate.HibernateException;

public class EmpInsert

{

public static void main(String args[])

{

try

{

// This step will read hibernate.cfg.xml and prepare hibernate for use

Configuration conf = new Configuration();

Configuration cf = conf.configure();

SessionFactory factory = cf.buildSessionFactory();

Session session = factory.openSession();

System.out.println("++++++++++++++");

//Create new instance of Contact and set values in it

Employee emp = new Employee();

emp.setFirstName("anurag");

emp.setLastName("Singh");

emp.setEmail("[email protected]");

System.out.println("insertion");

Transaction tx=session.beginTransaction();

session.save(emp);

tx.commit();

session.close();

}

catch (HibernateException e)

{

System.out.println(" "+e.getMessage());

e.printStackTrace();

}

Whenever this program get compiled and run this application as simple java application run same this client application insert the records in database.

Components using hibernate based application

January 28, 2023January 27, 2023 by Manish Sahu

Pojo class. Hbm.xml file. Hibernate configuration . xml file. Client class of hibernate. Pojo class It is an ordinary java class having member variable.the pojo class will be mapped with table and member variable will be mapped with table columns in the process of o-r mapping.this class will used by hibernate client application to developed … Read more

Hibernate Architecture

January 28, 2023January 27, 2023 by Manish Sahu

Hibernate support all layer architecture single layer,2 layer,n layer High level architecture of Hibernate can be described as shown in following illustration. Hibernate configuration file In earlier version it was a properties file from hibernate 2.2x it is change if no file is explicitly specified it becomes a hibernate-cfg.xml file as the hibernate configuration file … Read more

Features of Hibernate

January 28, 2023January 27, 2023 by Manish Sahu

Transparent persistence without byte code processing Object-oriented query language Powerful object-oriented query language Full support for polymorphic queries New Criteria queries Native SQL queries Object / Relational mappings Three different O/R mapping strategies Multiple-objects to single-row mapping Polymorphic associations Bidirectional associations Automatic primary key generation Multiple synthetic key generation strategies Support for application assigned identifiers … Read more

Date range query on Timestamp field in HQL

January 18, 2023January 18, 2023 by manish

Suppose we want to make query between two dates in a timestamp field for example We have a table colors to store different colors

create table colors(
color_id bigint(10)NOT NULL AUTO_INCREMENT,
color varchar(50),
add_date timestamp DEFAULT 0,
status varchar(20),
primary Key(color_id));

create table colors(

color_id bigint(10)NOT NULL AUTO_INCREMENT,

color varchar(50),

add_date timestamp DEFAULT 0,

status varchar(20),

primary Key(color_id));

Pojo class for color table is

public class Color  implements java.io.Serializable {
     private Long colorId;
     private String color;
     private Timestamp addDate;
     private String status;
//getter setter and constructor

public class Color implements java.io.Serializable {

private Long colorId;

private String color;

private Timestamp addDate;

private String status;

//getter setter and constructor

Above class shows that addDate is timestamp field and we want to query it as date for that we have casted timestamp field … Read more