this is my sql query see what wrong in this and reply to me it is very urgent.i have to complete this task i am struggling in this exception for the past two days.
i have try the outer join query.
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";
advance thanks those who reply to me.
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();
}
}
}
this is my pojo class: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;
}
}
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;
}
}
contact.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="sample.Employee" table="empmail">
<id name="empid" type="int" column="Empid" >
<generator class="increment"/>
</id>
<property name="firstname">
<column name="firstname" />
</property>
<property name="email">
<column name="email"/>
</property>
</class>
</hibernate-mapping>
insurance.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="sample.EmpDetail" table="empdet">
<id name="empid" column ="Empid" type="int">
<generator class="increment"/>
</id>
<property name="firstname">
<column name="firstname" />
</property>
<property name="city">
<column name="city"/>
</property>
</class>
hibernate.cfg.xml
</hibernate-mapping>
<?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">true</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.hbm2ddl.auto">value="update"</property>
<!-- Mapping files -->
<mapping resource="contact.hbm.xml"/>
<mapping resource="insurance.hbm.xml"/>
</session-factory>
</hibernate-configuration>
Login
FAQ
Search
