JavaTBrains

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.  W e 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 ;

Hibernate is ORM(Object Relational Mapping) framework for mapping java object with database table. A brief description about Configuration, SessionFactory, Session, Query, Criteria, Transaction and follow the same for sample application creation using hibernate. Configuration:   Configuration is that the initial object you wish to make any of hibernate application and typically making one time throughout the applying initialization. It represents the configuration or properties file providing by hibernate. SessionFactory:   Configuration object is employed to make SessionFactory instance that intern configures hibernate for the applying. SessionFactory object is significant weight part, it's created throughout application start up time and unbroken for later use. The way to do this we are going to see in below application. We would like one SessionFactory object per info employing a separate configuration. Therefore if you victimization multiple databases then you'd ou

SQL stands for 'Structured Query Language', which will use to interact with database to perform Create, Read, Update, Delete operations on database tables. SQL is also a language, where as SQL server is a database. To work on SQL, a Database software RDBMS is required. RDBMS stands as Relation Data Base Management System. SQL is not case sensitive. If your using Oracle SQL, you may get the below errors. If your using MySQL, you forget about this errors and move further for commands. Troubleshooting Oracle Error1. The account is locked Steps to rectify the error Login as username - 'system' & password - 'manager' or password - 'tiger' SQL> show user;        User is 'SYSTEM'         SQL> ALTER user<username> account unblock;        Ex:  ALTER  user scott account unlock;        User altered.        To close/exit the SQL command prompt usually we will use EXIT command.        SQL> exit; Error2. TNS: prot