Skip to main content

Hibernate- Defining table and columns for mapping

If you want to define customized name for the table and column, you have to use @Table and @Column annotations. @Table allows you to define the table, catalog, and schema names for your entity mapping.
If no @Table is defined the default values are used: the unqualified class name of the entity.

You can also define unique constraints to the table using the @UniqueConstraint annotation in conjunction with @Table

uniqueConstraints = {@UniqueConstraint(columnNames={"country", "state"})}

@Column annotation allows you to specify the column name to be pointed out in table.
Following are attribute of the @Column annotation
boolean unique() default false;
boolean nullable() default true;
boolean insertable() default true;
boolean updatable() default true;
String columnDefinition() default "";
String table() default "";
int length() default 255;
int precision() default 0;
int scale() default 0;

example :
@Column(updatable = false, name = "fullname", nullable = false, length=50)
public String getName() { ... }

package domain;

import java.util.Date;

import javax.persistence.*;
import javax.persistence.Id;

public class Profile {
    private int id;
    private String name;
    private String email;
    private Date dateOfBirth;
    private long phone;

    public Profile() {


    public Profile(int id, String name, String email, Date dateOfBirth,
            long phone) {
        super(); = id; = name; = email;
        this.dateOfBirth = dateOfBirth; = phone;

    public int getId() {
        return id;

    public void setId(int id) { = id;
    public String getName() {
        return name;

    public void setName(String name) { = name;
    public String getEmail() {
        return email;

    public void setEmail(String email) { = email;
    public Date getDateOfBirth() {
        return dateOfBirth;

    public void setDateOfBirth(Date dateOfBirth) {
        this.dateOfBirth = dateOfBirth;
    public long getPhone() {
        return phone;

    public void setPhone(long phone) { = phone;

 <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        <!-- Database connection settings -->
        <property name="connection.driver_class">org.h2.Driver</property>
        <property name="connection.url">jdbc:h2:~/test;TRACE_LEVEL_FILE=3</property>
        <property name="connection.username">sa</property>
        <property name="connection.password" />
        <property name="connection.pool_size">1</property>
        <property name="dialect">org.hibernate.dialect.H2Dialect</property>
        <property name="current_session_context_class">thread</property>
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
        <property name="show_sql">true</property>
        <property name="" >update</property>
        <mapping class="domain.Profile"/>

import java.util.Calendar;
import org.hibernate.Session;
import org.hibernate.cfg.AnnotationConfiguration;

import domain.Profile;

public class Operations {
    public static void main(String[] args) {
        Session session = new AnnotationConfiguration().configure()
        //create the date object to represent date, use calendar classes to do that
        Calendar date=Calendar.getInstance();
        Profile profile=new Profile(1,"abc","",date.getTime(),983234923);;


Popular posts from this blog

Using HyperSQL (HSQLDB)

HSQLDB is a portable RDBMS implemented in pure java. It can be embedded with your application as well as can be used separately. It is very a small database that supports almost all features of the standard database system. It comes with small jar file that can be found in lib folder. The HSQLDB jar package is located in the /lib directory of the ZIP package and contains several components and programs. Core components of jar file are : HyperSQL RDBMS Engine (HSQLDB), HyperSQL JDBC Driver, Database Manager, and Sql Tool. Installing and Using Download: download latest release of HyperSQL database from website and extract it. You will see following contents. Here "bin" directory contains some batch files those can be used to run a swing based GUI tool. You can use runManagerSwing.bat to connect to database, but database must be on before running it. Directory lib contains File hsqldb.jar . It is the database to be used by you. Running database First

In Process Mode of HSQLDB in web application.

If you want to use the database into your web application, you can use the HSQLDB in In_Process mode. In this mode, you can embed the HSQLDB into your web application and it runs as a part of your web application programm in the same JVM. In this mode, the database does not open any port to connect to the application on the hosing machine and you don't need to configure anything to access it. Database is not expposed to other application and can not be accessed from any dabase tools like dbVisualizer etc. In this mode ,database will be unknown from any other person except you. But in the 1.8.0 version, you can use Server intance for external as well as in process access.  To close the databse, you can issue SHUTDOWN command as an SQL query.   In the in-process mode, database starts from JDBC with the associated databse file provided through  connection URL. for example   DriverManager.getConnection("jdbc:hsqldb:mydatabase","SA","");   Here myd

Write a code for servlet which will display all the fields of Employee table in tabular form.MCS-051,Dec09-3a

import javax.servlet.*; import*; import java.sql.*;   import javax.servlet.http.*;   public class Employee extends HttpServlet   {   public void doGet(HttpServletRequest req, HttpServletResponse res) throws IOException,      ServletException   {   res.setContentType("text/Html");   PrintWriter pw = res.getWriter();   try   {   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");   Connection con=DriverManager.getConnection("jdbc:odbc:dsn");   Statement st=con.createStatement();   ResultSet rs=st.executeQuery("select emp_id,emp_name,emp_dob,mob_no,email from employee");   String tr="";   while({   tr=tr+"<tr>";   tr=tr+"<td>"+rs.getString(1)+"</td>";   tr=tr+"<td>"+rs.getString(2)+"</td>";   tr=tr+"<td>"+rs.getString(3)+"</td>";   tr=tr+"<td>"+rs.getString(4)+"</td>&