I forgot to give the class and mapping files:
The client class is :MasterForSaveUpdate.java
--------------------------------------------
package com.save.hibernate;
import java.io.Serializable;
import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import com.save.beans.Details;
import com.save.beans.Master;
public class MasterForSaveUpdate {
public static void main(String[] args)
{
Configuration cfg = new Configuration();
cfg.configure("hibernate.cfg.xml");
SessionFactory factory = cfg.buildSessionFactory();
Session session = factory.openSession();
Transaction tx;
try {
tx = session.beginTransaction();
Master master = new Master();
master.setCRET_ID("Hi");
//
DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
long currentDate = System.currentTimeMillis();
master.setCRET_TS(new Timestamp(currentDate));
master.setEXP_DT(new Date(currentDate));
master.setAGT_AUTH_CD('x');
master.setCUR_CD('c');
master.setCUR_STAT("Inval");
master.setNBR(new Integer(6));
master.setVRSN(new Integer(100));
master.setMAINT_ID("HiMai");
master.setMAINT_TS(new Timestamp(currentDate));
master.setACS_CD('d');
master.setACS_CMNT("cmnt");
master.setACS_NME("Indra");
master.setHAZ_DVN_ACS_CD('h');
master.setMOD_ACS_CD('w');
master.setTOOL_ACS_CMNT("webtool");
master.setTOOL_NME("webtoolname");
Details details = new Details();
details.setCo_633("COORG");
details.setMaint_id("MaintID");
details.setMaster(master);
details.setMaint_ts(new Timestamp(currentDate));
session.saveOrUpdate(details);
tx.commit();
System.out.println("Stored Master: " + master);
System.out.println("Stored Details: " + details);
session.flush();
}
// catch (ConstraintViolationException ce){
// System.out.println("Constraint Name : $$$$$$$$$$$$$$$$$$$$$$$: "+ce.getConstraintName());
// }
catch (HibernateException e) {
throw new HibernateException(e);
}
finally {
session.close();
//factory.close();
}
}
}
And My bean classes:-------------------------
/**
*
*/
package com.save.beans;
import java.io.Serializable;
import java.sql.Timestamp;
import java.util.Date;
/**
* @author indramohan_G
*
*/
public class Master implements Serializable{
int ID;
int VRSN;
char CUR_CD;
String CUR_STAT;
char AGT_AUTH_CD;
int NBR;
char MOD_ACS_CD;
char HAZ_DVN_ACS_CD;
String TOOL_NME;
String TOOL_ACS_CMNT;
char ACS_CD;
String ACS_NME;
String ACS_CMNT;
String CRET_ID;
Timestamp CRET_TS;
Date EXP_DT;
String MAINT_ID;
Timestamp MAINT_TS;
Details details;
public Master() {
}
public Details getDetails() {
return details;
}
public void setDetails(LOA3PLDetails details) {
this.details = details;
}
public int getID() {
return ID;
}
public void setID(int id) {
ID = id;
}
public int getVRSN() {
return VRSN;
}
public void setVRSN(int vrsn) {
VRSN = vrsn;
}
public char getCUR_CD() {
return CUR_CD;
}
public void setCUR_CD(char cur_cd) {
CUR_CD = cur_cd;
}
public String getCUR_STAT() {
return CUR_STAT;
}
public void setCUR_STAT(String cur_stat) {
CUR_STAT = cur_stat;
}
public char getAGT_AUTH_CD() {
return AGT_AUTH_CD;
}
public void setAGT_AUTH_CD(char agt_auth_cd) {
AGT_AUTH_CD = agt_auth_cd;
}
public int getNBR() {
return NBR;
}
public void setNBR(int nbr) {
NBR = nbr;
}
public char getMOD_ACS_CD() {
return MOD_ACS_CD;
}
public void setMOD_ACS_CD(char mod_acs_cd) {
MOD_ACS_CD = mod_acs_cd;
}
public char getHAZ_DVN_ACS_CD() {
return HAZ_DVN_ACS_CD;
}
public void setHAZ_DVN_ACS_CD(char haz_dvn_acs_cd) {
HAZ_DVN_ACS_CD = haz_dvn_acs_cd;
}
public String getTOOL_NME() {
return TOOL_NME;
}
public void setTOOL_NME(String tool_nme) {
TOOL_NME = tool_nme;
}
public String getTOOL_ACS_CMNT() {
return TOOL_ACS_CMNT;
}
public void setTOOL_ACS_CMNT(String tool_acs_cmnt) {
TOOL_ACS_CMNT = tool_acs_cmnt;
}
public char getACS_CD() {
return ACS_CD;
}
public void setACS_CD(char acs_cd) {
ACS_CD = acs_cd;
}
public String getACS_NME() {
return ACS_NME;
}
public void setACS_NME(String acs_nme) {
ACS_NME = acs_nme;
}
public String getACS_CMNT() {
return ACS_CMNT;
}
public void setACS_CMNT(String acs_cmnt) {
ACS_CMNT = acs_cmnt;
}
public String getCRET_ID() {
return CRET_ID;
}
public void setCRET_ID(String cret_id) {
CRET_ID = cret_id;
}
public Timestamp getCRET_TS() {
return CRET_TS;
}
public void setCRET_TS(Timestamp cret_ts) {
CRET_TS = cret_ts;
}
public Date getEXP_DT() {
return EXP_DT;
}
public void setEXP_DT(Date exp_dt) {
EXP_DT = exp_dt;
}
public String getMAINT_ID() {
return MAINT_ID;
}
public void setMAINT_ID(String maint_id) {
MAINT_ID = maint_id;
}
public Timestamp getMAINT_TS() {
return MAINT_TS;
}
public void setMAINT_TS(Timestamp maint_ts) {
MAINT_TS = maint_ts;
}
}
package com.save.beans;
import java.sql.Timestamp;
public class Details {
private int id;
private int pl_id;
private String co_633;
private String maint_id;
private Timestamp maint_ts;
private Master master;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getPl_id() {
return pl_id;
}
public void setPl_id(int pl_id) {
this.plid = pl_id;
}
public String getCo_633() {
return co_633;
}
public void setCo_633(String co_633) {
this.co_633 = co_633;
}
public String getMaint_id() {
return maint_id;
}
public void setMaint_id(String maint_id) {
this.maint_id = maint_id;
}
public Timestamp getMaint_ts() {
return maint_ts;
}
public void setMaint_ts(Timestamp maint_ts) {
this.maint_ts = maint_ts;
}
public Master getMaster() {
return master;
}
public void setMaster(Master master) {
this.master = master;
}
}
Mapping files:Master.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="com.save.beans.Master" table="MSTR">
<meta attribute="class-description">
This class contains Details about the
</meta>
<id name="ID" column="ID" type="integer">
<generator class="native"/>
</id>
<property name="VRSN" column="VRSN" type="integer"/>
<property name="CUR_CD" column="CUR_CD" type="char"/>
<property name="CUR_STAT" column="CUR_STAT" type="string"/>
<property name="AGT_AUTH_CD" column="AGT_AUTH_CD" type="char"/>
<property name="NBR" column="NBR" type="integer"/>
<property name="MOD_ACS_CD" column="MOD_ACS_CD" type="char"/>
<property name="HAZ_DVN_ACS_CD" column="HAZ_DVN_ACS_CD" type="char"/>
<property name="TOOL_NME" column="TOOL_NME" type="string"/>
<property name="TOOL_ACS_CMNT" column="TOOL_ACS_CMNT" type="string"/>
<property name="ACS_CD" column="ACS_CD" type="char"/>
<property name="USER_ACS_NME" column="ACS_NME" type="string"/>
<property name="ACS_CMNT" column="ACS_CMNT" type="string"/>
<property name="CRET_ID" column="CRET_ID" type="string"/>
<property name="CRET_TS" column="CRET_TS" type="timestamp"/>
<property name="EXP_DT" column="EXP_DT" type="date"/>
<property name="MAINT_ID" column="MAINT_ID" type="string"/>
<property name="MAINT_TS" column="MAINT_TS" type="timestamp"/>
</class>
</hibernate-mapping>
Details.hbm.xml file:
-----------------------
<?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="com.save.beans.Details" table="PL_DTL">
<meta attribute="class-description">
This class contains Details about the.
</meta>
<id name="pl_id" column="PL_ID" type="int">
<generator class="native"/>
</id>
<property name="co_633" column="CO_633" type="string"/>
<property name="maint_id" column="MAINT_ID" type="string"/>
<property name="maint_ts" column="MAINT_TS" type="timestamp"/>
<many-to-one name="master" class="com.save.beans.Master" column="ID" cascade="save-update"/>
</class>
</hibernate-mapping>
Config xml file:
---------------
<?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>
<!-- Database connection settings -->
<property name="connection.driver_class">com.ibm.db2.jcc.DB2Driver</property>
<property name="connection.url">jdbc:db2://171.4.10.55:3700/DB</property>
<property name="connection.username">bupbup</property>
<property name="connection.password">ert5ert5</property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.DB2Dialect</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<property name="current_session_context_class">thread</property>
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<property name="use_sql_comments">true</property>
<property name="hbm2ddl.auto">update</property>
<mapping resource="Master.hbm.xml"/>
<mapping resource="Details.hbm.xml"/>
</session-factory>
</hibernate-configuration>
Please give me the solution. I am not able fix this for last two days.Thanks in Advance.
Login
FAQ
Search
