Hibernate one -to -one mapping for Oracle auto-increment key

1. DB table create
 
The parent table
 

create table stock (
stock_id number(10)  not null,
stock_code varchar2(10) not null,
stock_name varchar2(10) not null,
primary key (stock_id)
);
  the child table
 
 

create table stock_detail(
stock_id number(10) not null,
comp_name varchar2(100) not null,
comp_desc varchar2(100) not null,
remark_desc varchar2(100) not null,
listed_date date not null,
primary key (stock_id),
foreign key(stock_id) references stock(stock_id)
)
 below is create the sequence for the parent table for the primary key
 
 

create sequence stock_seq start with 1 increment by 1 nomaxvalue;
 below trigger auto-update the primary key for the parent table
 
 

create or replace trigger stock_trigger
before insert on stock
for each row
begin
select stock_seq.nextval into:new.stock_id from dual;
end;
/   
 below is test for above code, don't need in the demo, u can ignore
 
 

insert into stock(stock_code,stock_name) values('112','112_com')
insert into stock_detail(stock_id,comp_name,comp_desc,remark_desc,listed_date)
values(4,'111','111','111',to_date('2013-04-05','yyyy-mm-dd'))
desc stock;
desc stock_detail;
select * from stock;   
select * from stock_detail;  
create or replace procedure proc_dropifexist(
p_table in varchar2
) is
v_count number(10);
begin
select count(*)
into v_count
from user_tables
where table_name = upper(p_table);
if v_count > 0 then
execute immediate 'drop table ' || p_table ||' purge';
end if;
end proc_dropifexist;         
exec proc_dropifexist('stock');

 
 
2. pojo & sessionFactory
 
1. Stock:
 

public class Stock implements java.io.Serializable {
private int stockId;
private String stockCode;
private String stockName;
private StockDetail stockDetail;
...
//ignore the constructor & getter/setter
}
 2. StockDetail:
 
 

public class StockDetail implements java.io.Serializable {
private int stockId;
private Stock stock;
private String compName;
private String compDesc;
private String remarkDesc;
private Date listedDate;
...
//ingore the constructor & getter/setter
}
 
3. SesstionFactory get via HibernateUtil

import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class HibernateUtil {
private static final SessionFactory sessionFactory = buildSessionFactory();
private static SessionFactory buildSessionFactory() {
try {
//create SessionFactory from hibernate.cfg.xml
return new Configuration().configure().buildSessionFactory();
} catch(Throwable ex) {
System.err.println("Initial SessionFactory creation failed: " + ex);
throw new ExceptionInInitializerError(ex);
}
}
public static SessionFactory getSessionFactory() {
return sessionFactory;
}
public static void shutdown() {
getSessionFactory().close();
}
}

 
4. xml config file:
 
Stock.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="net.codercn.module.Stock" table="stock">
<id name="stockId" type="int">
<column name="stock_id"/>
<generator class="sequence">
<param name="sequence">stock_seq</param>
</generator>
</id>
<property name="stockCode" type="string">
<column name="stock_code" length="10" not-null="true"/>
</property>
<property name="stockName" type="string">
<column name="stock_name" length="10" not-null="true"/>
</property>
<one-to-one name="stockDetail" class="net.codercn.module.StockDetail" cascade="save-update"></one-to-one>
</class>
</hibernate-mapping>


StockDetail.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="net.codercn.module.StockDetail" table="stock_detail">
<id name="stockId" type="int">
<column name="stock_id"/>
<generator class="foreign">
<param name="property">stock</param>
</generator>
</id>
<one-to-one name="stock" class="net.codercn.module.Stock" constrained="true"></one-to-one>
<property name="compName" type="string">
<column name="comp_name" length="100" not-null="true"/>
</property>
<property name="compDesc" type="string">
<column name="comp_desc" length="100" not-null="true"/>
</property>
<property name="remarkDesc" type="string">
<column name="remark_desc" length="100" not-null="true"/>
</property>
<property name="listedDate" type="date">
<column name="listed_date" length="10" not-null="true"/>
</property>
</class>
</hibernate-mapping>

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">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@~~~</property>
<property name="hibernate.connection.username">~~~</property>
<property name="hibernate.connection.password">~~</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="hibernate.default_schema">~~~</property>
<mapping resource="hibernate/Stock.hbm.xml" />
<mapping resource="hibernate/StockDetail.hbm.xml" />
</session-factory>
</hibernate-configuration>

 
5. test

package net.codercn;
import java.util.Date;
import net.codercn.module.Stock;
import net.codercn.module.StockDetail;
import net.codercn.util.HibernateUtil;
import org.hibernate.Session;
public class App {
public static void main(String[] args) {
System.out.println("Maven + Hibernate + Oracle");
Session session = HibernateUtil.getSessionFactory().openSession();
session.beginTransaction();
Stock stock = new Stock();
stock.setStockCode("111");
stock.setStockName("God");
StockDetail stockDetail = new StockDetail();
stockDetail.setCompName("God Internal");
stockDetail.setCompDesc("Greatest Company in heaven");
stockDetail.setRemarkDesc("Nothing Special");
stockDetail.setListedDate(new Date());
stock.setStockDetail(stockDetail);
stockDetail.setStock(stock);
session.save(stock);
session.getTransaction().commit();
System.out.println("insert a record into table");
}
}

 
6. maven pom.xml
 

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>net.codercn</groupId>
<artifactId>Hibernate</artifactId>
<packaging>jar</packaging>
<version>1.0-SNAPSHOT</version>
<name>Hibernate</name>
<url>http://maven.apache.org</url>
<repositories>
<repository>
<id>JBoss repository</id>
<url>http://repository.jboss.org/nexus/content/groups/public/</url>
</repository>
</repositories>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
<!--  Hibernate  -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>3.6.3.Final</version>
</dependency>
<dependency>
<groupId>javassist</groupId>
<artifactId>javassist</artifactId>
<version>3.12.1.GA</version>
</dependency>
<!--  oracle jdbc driver -->
<dependency>
<groupId>com.oracle</groupId>
<artifactId>oraclejdbc</artifactId>
<version>10.2.0.3.0</version>
</dependency>
</dependencies>
</project>

 
7. manually install  JDBC driver to local repository:

• get jdbc driver and put it in an folder(if installed oracle, it always locate at : D:\oracle\product\10.1.0\db_1\jdbc\lib\ojdbc14.jar)
  
• go to above jdbc driver folder, run below maven command:
  

mvn install:install-file -Dfile=ojdbc14.jar -DgroupId=com.oracle -DartifactId
=oraclejdbc -Dversion=10.1.0.2.0 -Dpackaging=jar -DgeneratePom=true
 check your maven local repository (~maven\repository\com\oracle\oracle\10.1.0.2.0), it will install the jdbc driver

 

Above is for XML style, annotation style as below:

package net.codercn.module;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.OneToOne;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;
@Entity
@Table(name = "stock",  uniqueConstraints ={
@UniqueConstraint(columnNames = "stock_name"),
@UniqueConstraint(columnNames = "stock_code")
})
public class Stock implements java.io.Serializable {
private int stockId;
private String stockCode;
private String stockName;
private StockDetail stockDetail;
public Stock(){}
@Id
@GeneratedValue(strategy = GenerationType.AUTO, generator = "my_entity_seq_generator")
@SequenceGenerator(name = "my_entity_seq_generator", sequenceName = "stock_seq")
@Column(name = "stock_id", unique = true, nullable = false)
public int getStockId() {
return stockId;
}
public void setStockId(int stockId) {
this.stockId = stockId;
}
@Column(name = "stock_code", unique = true, nullable = false, length = 10)
public String getStockCode() {
return stockCode;
}
public void setStockCode(String stockCode) {
this.stockCode = stockCode;
}
@Column(name = "stock_name", unique = true, nullable = false, length = 10)
public String getStockName() {
return stockName;
}
public void setStockName(String stockName) {
this.stockName = stockName;
}
@OneToOne(fetch = FetchType.LAZY, mappedBy = "stock", cascade = CascadeType.ALL)
public StockDetail getStockDetail() {
return stockDetail;
}
public void setStockDetail(StockDetail stockDetail) {
this.stockDetail = stockDetail;
}
}

 
 

package net.codercn.module;
import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.OneToOne;
import javax.persistence.PrimaryKeyJoinColumn;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import org.hibernate.annotations.GenericGenerator;
import org.hibernate.annotations.Parameter;
@Entity
@Table(name = "stock_detail")
public class StockDetail implements java.io.Serializable {
private int stockId;
private Stock stock;
private String compName;
private String compDesc;
private String remarkDesc;
private Date listedDate;
public StockDetail(){}
@GenericGenerator(name = "generator", strategy = "foreign",
parameters = @Parameter(name = "property", value = "stock"))
@Id
@GeneratedValue(generator = "generator")
@Column(name = "stock_id", unique = true, nullable = false)
public int getStockId() {
return stockId;
}
public void setStockId(int stockId) {
this.stockId = stockId;
}
@OneToOne(fetch = FetchType.LAZY)
@PrimaryKeyJoinColumn
public Stock getStock() {
return stock;
}
public void setStock(Stock stock) {
this.stock = stock;
}
@Column(name = "comp_name", nullable = false, length = 100)
public String getCompName() {
return compName;
}
public void setCompName(String compName) {
this.compName = compName;
}
@Column(name = "comp_desc", nullable = false)
public String getCompDesc() {
return compDesc;
}
public void setCompDesc(String compDesc) {
this.compDesc = compDesc;
}
@Column(name = "remark_desc", nullable = false)
public String getRemarkDesc() {
return remarkDesc;
}
public void setRemarkDesc(String remarkDesc) {
this.remarkDesc = remarkDesc;
}
@Temporal(TemporalType.DATE)
@Column(name = "listed_date", nullable = false, length = 10)
public Date getListedDate() {
return listedDate;
}
public void setListedDate(Date listedDate) {
this.listedDate = listedDate;
}

}