i am new to hibernate i try the example for foreign key mapping but it show the exception mentioned below.
i send the xml files and pojo classes. please reply me soon it is very urgent.
i have to finish this task.
advance thanks for those u reply to me.
contact.hbm.xml mapping.
<?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="join.Contact" table="emp">
<id name="id" type="int" column="ID" >
<generator class="increment"/>
</id>
<property name="firstName" column ="firstname"/>
<property name="lastName" column ="lastname"/>
<property name="insid" column ="InsID"/>
<bag name="insurance" inverse="
true" cascade="all,delete-orphan">
<key column="InsID"/>
<one-to-many class="
join.Insurance"/>
</bag>
</class>
</hibernate-mapping>
insurance.xml files
<?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="join.Insurance" table="Insurance">
<id name="id" column ="InsID" type="int">
<generator class="increment"/>
</id>
<property name="insuranceName" column="InsuranceName" type="String"/>
<property name="investementAmount" column="InvestmentAmount" type="double"/>
<many-to-one name="Contact" class="
join.Contact" column="InsID"
insert="false" update="false"/>
</class>
</hibernate-mapping>
hibernate .cfg.xml
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//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/sakthi</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">admin</property>
<property name="hibernate.connection.pool_size">10</property>
<property name="hibernate.jdbc.batch_size">50</property>
<property name="show_sql">true</property>
<property name="connection.autocommit">false</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- Mapping files -->
<mapping resource="contact.hbm.xml"/>
<mapping resource="insurance.hbm.xml"/>
</session-factory>
</hibernate-configuration>
EmpDetail.java
package sample;
public class EmpDetail{
private String firstname;
private String city;
private int empid;
public String getfirstname() {
return firstname;
}
public void setfirstname(String firstname) {
this.firstname =firstname;
}
public String getcity() {
return city;
}
public void setcity(String city) {
this.city = city;
}
public int getempid() {
return empid;
}
public void setempid(int Empid) {
this.empid =empid;
}
}
Employee.java
package sample;
public class Employee {
private String firstname;
private String email;
private int empid;
/**
* @return Email
*/
/**
* @return First Name
*/
public String getfirstname() {
return firstname;
}
public void setfirstname(String string) {
firstname = string;
}
public String getemail() {
return email;
}
/**
* @param string Sets the Email
*/
public void setemail(String string) {
email = string;
}
/**
* @param string Sets the First Name
*/
/**
* @param string sets the Last Name
*/
public int getempid() {
return empid;
}
/**
* @param l Sets the ID
*/
public void setempid(int i) {
empid = i;
}
}
my main class
package sample;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import java.util.*;
/*import java.util.List;
import java.util.ListIterator;*/
import sample.Employee;
import sample.EmpDetail;
public class Inner {
public static void main(String[] args) {
// TODO Auto-generated method stub
Session sess = null;
try{
SessionFactory fact = new
Configuration().configure().buildSessionFactory();
sess = fact.openSession();
String sql_query = " select empdet.firstname,empdet.city,empmail.firstname,empmail.email FROM sample.EmpDetail empdet left outer join fetch sample.Employee empmail where empdet.Empid = empmail.Empid";
Query query = sess.createQuery(sql_query);
Iterator ite = query.list().iterator();
System.out.println("FirstName\t"+"Email\t"+"FirstName\t"+"City");
while ( ite.hasNext() ) {
Object[] pair = (Object[]) ite.next();
Employee mail = (Employee) pair[0];
EmpDetail det = (EmpDetail) pair[1];
System.out.print(mail.getfirstname());
System.out.print(mail.getemail());
System.out.print("\t"+det.getfirstname());
System.out.print("\t\t"+det.getcity());
System.out.println();
}
sess.close();
}
catch(Exception e ){
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}
11:43:53,250 INFO Environment:456 -11:43:53,250 INFO Environment:469 -11:43:53,250 INFO Environment:502 -11:43:53,250 INFO Environment:532 -11:43:53,250 INFO Configuration:1228 -11:43:53,265 INFO Configuration:1199 -11:43:53,375 INFO Configuration:439 -11:43:53,484 INFO HbmBinder:256 -11:43:53,500 INFO Configuration:439 -11:43:53,546 INFO HbmBinder:256 -11:43:53,609 INFO Configuration:1340 -11:43:53,609 INFO Configuration:844 -11:43:53,609 INFO Configuration:848 -Association references unmapped class: join.Insurance
org.hibernate.MappingException: Association references unmapped class: join.Insurance
at org.hibernate.cfg.HbmBinder.bindCollectionSecondPass(HbmBinder.java:1946)
at org.hibernate.cfg.HbmBinder$CollectionSecondPass.secondPass(HbmBinder.java:2295)
at org.hibernate.cfg.HbmBinder$SecondPass.doSecondPass(HbmBinder.java:2266)
at org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:853)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1036)
at join.Inner.main(Inner.java:16)
Login
FAQ
Search
