Hibernate auto increment with example

In previous example we learn how to map java object with database table for manually(not using auto increment) assigned all the values. To create primary key auto increment application by using hibernate mapping(hbm.xml) or using annotations continue reading this article. 

We need to create a database and create an employee table by using the below query.

Table:
CREATE table EMPLOYEE(
eid integer(10) primary key not null,
firstname varchar(30),
lastname varchar(30),
designation varchar(30),
salary double(10,2));

Here, we will create a bean/POJO (Plain Old Java Object) class of employee.

Employee.java:
package com.javatbrains.hibernate;

import java.io.Serializable;

/*This is the POJO class. It contains only Getter and Setter methods*/
public class Employee implements Serializable {
     private static final long serialVersionUID = -75885815725314443L;
    
     private int eid;
     private String firstName;
     private String lastName;
     private String designation;
     private double salary;

     public int getEid() {
          return eid;
     }

     public void setEid(int eid) {
          this.eid = eid;
     }

     public String getFirstName() {
          return firstName;
     }

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

     public String getLastName() {
          return lastName;
     }

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

     public String getDesignation() {
          return designation;
     }

     public void setDesignation(String designation) {
          this.designation = designation;
     }

     public double getSalary() {
          return salary;
     }

     public void setSalary(double salary) {
          this.salary = salary;
     }

}

          In Employee.java class contains eid, firstName, lastName, designation, salary of employee and setters and getter's of those properties. Here, emp is the auto increment, you no need to set the value explicitly.

employee.hbm.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
     <class name="com.ora.hibernate.examples.Employee" table="EMPLOYEE">
          <id name="eid" type="int">
              <column name="EID" />
              <generator class="increment" />
          </id>
          <property name="firstName" type="java.lang.String">
              <column name="FIRSTNAME" />
          </property>
          <property name="lastName" type="java.lang.String">
              <column name="LASTNAME" />
          </property>
          <property name="designation" type="java.lang.String">
              <column name="DESIGNATION" />
          </property>
          <property name="salary" type="double">
              <column name="SALARY" />
          </property>
     </class>
</hibernate-mapping>

          The above Employee java class mapping into database table ‘EMPLOYEE’ by using <class> tag in hibernate mapping file. In that file class properties are mapping into database table columns by using <property> and <class> tags. Here, <class> tag is not necessary, it is an optional tag.

Note: if you can’t specify the <column> tag, java class property name automatically taken by database table column name.
Now, I am trying to create hibernate configuration file.

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

          In the above configuration file contains the database properties of driver, connection url, user name, password, dialect. Here, dialect is the vendor specific one, there I am using MySQL Dialect. If your using any other databases like, Oracle, postgreSQL. You must specify that particular dialect.

          Finally, there I am mapping the employee.hbm.xml file into hibernate.cfg.xml file by using the <mapping> tag.

EmployeeTest.java:
package com.javatbrains.hibernate;

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

public class EmployeeTest {

     public static void main(String[] args) {
          Employee emp = new Employee();
          emp.setFirstName("Subbareddy");
          emp.setLastName("Nallamachu");
          emp.setDesignation("Software Engineer");
          emp.setSalary(12000.00d);

          SessionFactory sessionFactory = new Configuration().configure()
                   .buildSessionFactory();
          Session session = sessionFactory.openSession();
          Transaction transaction = session.beginTransaction();
          session.save(emp);
          transaction.commit();
          session.close();
     }

}

·         In the above ‘EmployeeTest’ class, I am trying to insert Employee java class object values into database 'EMPLOYEE' table. Here, you can see below steps to understand 'EmployeeTest' class.
·         Create 'Employee' object and set those values.
·         Create SessionFactory instance by using configure() method in Configuration class.
·         Open a session instance by using the openSession() providing by SessionFactory interface.
·         Get Transaction instance by using beginTransaction() method providing by Session interface.
·         Use save (Object obj), saveOrUpdate (Object obj) to save Employee object values into database table.
·         Then commit transaction by using commit () method providing by Transaction interface.
·         Finally, close session by using close() method providing by Session interface.

Same example with Hibernate Annotations:

          Now, I am explains how to do the same example by using hibernate annotations. This is simple and easy for programmers to do application with annotations. By using hibernate annotations we are not required to create any of hibernate mapping files in an application. Before going to do changes on old application you must read few annotations and their uses.

@Entity: declares the class as an entity bean.

@Table: is set at the class level. It allows you to define the table, catalogue and schema names for your entity mapping. If @Table is not defined the default values are used. The unqualified class of the entity.

 @ID: declares the identifier property of this entity bean. This represents the primary key column in the table.

@Column: declares column level (properties of the persistence class). This is the optional annotation. This annotation represents the database table column.

@GeneratedValue: is set at the identifier property level. That defined the generatedValue type as AUTO_IDENTITY, SEQUENCE, TABLE. If you declared generatedValue type as AUTO, you no need to enter the value manually for that field. That represents the AUTO_INCREMENT at database table level.

 Now coming to the application, majorly you need to do few changes in old application to convert hbm application to annotation application. In that mainly you need to change persistence (Employee.java) class. In this situation Employee.hbm.xml file is not required. You can change your old Employee.java file as like below,

Employee.java:
package com.javatbrains.hibernate;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Id;
import javax.persistence.Table;

import org.hibernate.annotations.Entity;

@Entity
@Table(name = "EMPLOYEE", catalog = "hibernatex")
public class Employee implements Serializable {
     private static final long serialVersionUID = -75885815725314443L;

     @Id
     @GeneratedValue
     @Column(name = "EID")
     private int eid;
     @Column(name = "FIRSTNAME")
     private String firstName;
     @Column(name = "LASTNAME")
     private String lastName;
     @Column(name = "DESIGNATION")
     private String designation;
     @Column(name = "SALARY")
     private double salary;

     public int getEid() {
          return eid;
     }

     public void setEid(int eid) {
          this.eid = eid;
     }

     public String getFirstName() {
          return firstName;
     }

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

     public String getLastName() {
          return lastName;
     }

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

     public String getDesignation() {
          return designation;
     }

     public void setDesignation(String designation) {
          this.designation = designation;
     }

     public double getSalary() {
          return salary;
     }

     public void setSalary(double salary) {
          this.salary = salary;
     }

}

          Once you done by editing the persistence class, Open hibernate.cfg.xml file and remove/comment the old mapping tag. Because your mapping Employee.hbm.xml, but now that is not required. We need to map Employee.java class into mapping file by using mapping tag. As like below,


<mapping class="com.javatbrains.hibernate.Employee"/>












          Once completed to do mapping of persistence class. Then go into EmployeeTest.java class and build Session Factory by using “Annotation Configuration” class. As like below line,










SessionFactory sessionFactory = new AnnotationConfiguration().configure().buildSessionFactory();












          You have done all the changes, just run it EmployeeTest.java class. You did’t get any exceptions your class executing successfully and your values inserted successfully into database. Open database and check employee table values are inserted are not.











































Location:
India
















Comments











Post a Comment



















Popular posts from this blog









how to count the page views by using JSP





















  To count no.of page's are viewed by user in your application is a challenge in real time application. In this page we will see how to count the page views when user has viewed the page.               Here, we will do one example how many times user has visited each page in our application. In this post we will come to know, how to count the total application page views as well as individually each pages count.               Let us assume my web application name is "Page Counter". For creating the web application in eclipse IDE, Click here . This Page Counter contains three pages, assume that are the different pages in an application. But, there is the link between each other files for navigating from one page to another. Also it will show the total pages view count and individual page view count in all the pages. Let us see, below is my first jsp file,             ...








Read more










Multithreading in java with example





















 Multithreading  is one of the most important concept in core java. In this article we will learn what is multithreading? , what is the use of it? and What is the use of Synchronization and when to use it?  with detailed examples.   At a time, two or more threads are accessing the same object is called as Multithreading  in Java .  First,   we will create two threads for two objects. It is also possible to run two or more threads on a single class object. In this case, there is a possibility to get unreliable results.     If the two threads are perform same task, then they need same object to be executed each time. For your better understanding, take an example of any reservations like, railway, movie ticket booking,etc.      Let us think only one berth is available in a train and two passengers are asking for that berth. The first person has sent a request to allocate that ticket/berth to him. At the same time, the second person also sent a request to allocate that ...








Read more










How to retrieve data from table by using JDBC with example





















  To retrieve data from mysql data table by using jdbc, we need to confirm weather which table data we need to retrieve. To confirm open your mysql and view all database names by using the ' show databases ' commands in mysql. Then select which is your database name from showing list of database names, by using the ' use <database  name> ' command in mysql.     Then we need to see all your existing tables by executing the ' show tables ' command. This command gives you the list of existing tables in your selected database. You need to use existing table only you can follow with that. But, here we will see with entirely new which is not existing in mysql database. Now, We will create simple mysql table with minimal columns.          create    table emp(eno integer(10), ename varchar(30), sal float);          The above command creates a new table, we will move further to insert records into emp table by executing the insert which we mentioned in the below.  ...








Read more










Prime, Fibonacci and Factorial number with example in java





















Prime number, Fibonacci series and Factorial number programs are most commonly asked questions in interview. Read this article to know what is and how to write programs for prime number, fibonacci series and factorial number.   Prime Number: prime number is natural number greater than 1 that has no positive divisor other than 1 and itself. A natural number greater than 1 is not a prime number, is called Composite number . For example, 7 is a prime number. Because it can divide with 1 and 7 only. Where as 8 is composite number. Since it has the divisor 2 and 4 in addition to the 1 and 8.   The below example represents the finding the passing number is prime number or not. If the passing number is prime number it will print true otherwise it will print false.    package  com . javatbrains . practice ;   public  class  PrimeNumber  {       public  boolean  isPrimeNumber ( int  number )  {            if ( number <=  1 )               return  false ;              // There's only one ...








Read more










How to insert images into database using JDBC?





















     How to insert images into database table by using JDBC? To know about these topic follow the below lines,               Before going to write a JDBC program for inserting images into database table, we need to create a specific table for inserting images column datatype. For creating the database table, execute the below command in MySQL command prompt.      1 2 3 4  CREATE  TABLE  ` images `  ( ` image_id `  int ( 11 ) NOT  NULL  AUTO_INCREMENT, ` image_flag `  int ( 11 ) NOT  NULL , ` image `  longblob NOT  NULL , PRIMARY  KEY  ( ` image_id ` ));                 After executing the above query in MySQL command prompt, execute the below query to know weather the above table query is created or not.      1  Show  tables;                 When you have executed the above query that will show you the list of table which all exists in the current database. Current tab...








Read more










How to sort list of objects in java with examples





















We could achieve list of objects sorting in java by using sort()  method which is available under Collections  class as well as by using Comparable  and Comparator  interfaces. Comparable  and Comparator  are two interfaces in java used to sort list of objects. These interfaces are available under java.util  package along with Collections  class and other classes and interfaces.   Comparable  interface contains the method of         public int compareTo(Object obj)   Comparator  interface contains the method of         public int compare(Object obj1, Object obj2)   The compare()  and compareTo()  methods will return negative integer(-1), or zero(0) or positive integer(1). When the first obj1 is less than obj2 method will return negative integer. When obj1 is equals to obj2 will return zero and when obj1 is grater than obj2 it will return positive integer.   If it's objects are stored in any Collection  classes like ArrayList, H...








Read more










String interview questions and answers





















 String interview questions and answers are placed the current post as of my experience in interviews. This will helps who are trying to attend interview as fresher as well as experience. If any one is facing any other questions which are not present in the current page, please drop me an email to " subbareddynallamachu@gmail.com ".    Q1:  String is a class or data type? A: String is a class in java.lang package. But, in java, all classes are also are considered as data types. So we can take String as data type also. Q2:  What is the difference between == and equals() methods in java? A: == operator compares the references of the String object. It does not compare the content of the object. equals() method compares the contents. While comparing the Strings, equals method should be used as it yields the correct result. Q3:  What is String constant pool? A: String constant pool is a separate block of memory where the String objects are held by JVM....








Read more










Exception in thread "main" java.lang.NoClassDefFoundError: javax/transaction/SystemException





















 Exception in thread "main" java.lang.NoClassDefFoundError: javax/transaction/SystemException error we got in Hibernate 4.3 to work with my MySQL database. We are using hibernate code generation tool in Eclipse and we are able to connect to the database using the Hibernate configuration file.   When we try to run code in my Main class application is connecting to the database, but transaction is failing and we got the following error:     1  2  3  4  5  6  7  8  9 10 11 12 13 14 15 16 17 18  Exception in thread "main"  java . lang . NoClassDefFoundError :  javax / transaction / SystemException at java . lang . Class . forName0 ( Native Method )  at java . lang . Class . forName ( Unknown Source )  at org . jboss . logging . Logger . getMessageLogger ( Logger . java : 2248 )  at org . jboss . logging . Logger . getMessageLogger ( Logger . java : 2214 )  at org . hibernate . cfg . Configuration .< clinit >( Configuration . java : 184 )  at be . comp . permanenti...








Read more










Store file into table by using JDBC with example





















  To store large data files or text files into database table, we will use CLOB (Charecter Large Object)  datatype of SQL . By using CLOB  it is possible to save entire text book or a file or resume into a column of data table. If your using MySQL  database instead of CLOB  use LONGTEXT  to save file into datatable.     For saving files into a data table, we need to create one table which will contains a column type as CLOB  to store files. Here, is the query to create a data table.      1 2 3 4  create  table  myfiles( file_id int ( 10 ), file_name varchar ( 30 ), file_type LONGTEXT);       Once table creation completes, these table contains the 3 columns one is file_id  represents the file id, file_name  represents the name of the file and finally file_type  will get save entire file into the table column.     Now, we will move to write a JDBC program which will saves the file into the newly creating table. Here is the JDBC program,      1  2  3  4  5  6  7  8  9 10 11 12 13 14 15 16...








Read more