fetch as {select|join} not working as expected - hibrnate3

[Naresh Chaurasia]

I have following code:

package net.viralpatel.hibernate.oneone;

import java.io.Serializable;
import java.sql.Date;

public class Employee implements Serializable {

	private Long employeeId;

	private String firstname;

	private String lastname;

	private Date birthDate;

	private String cellphone;

	private EmployeeDetail employeeDetail;

	public Employee() {

	}

	public Employee(String firstname, String lastname, Date birthdate,
			String phone) {
		this.firstname = firstname;
		this.lastname = lastname;
		this.birthDate = birthdate;
		this.cellphone = phone;
	}

	public Long getEmployeeId() {
		return employeeId;
	}

	public void setEmployeeId(Long employeeId) {
		this.employeeId = employeeId;
	}

	public String getFirstname() {
		return firstname;
	}

	public void setFirstname(String firstname) {
		this.firstname = firstname;
	}

	public String getLastname() {
		return lastname;
	}

	public void setLastname(String lastname) {
		this.lastname = lastname;
	}

	public Date getBirthDate() {
		return birthDate;
	}

	public void setBirthDate(Date birthDate) {
		this.birthDate = birthDate;
	}

	public String getCellphone() {
		return cellphone;
	}

	public void setCellphone(String cellphone) {
		this.cellphone = cellphone;
	}

	public EmployeeDetail getEmployeeDetail() {
		return employeeDetail;
	}

	public void setEmployeeDetail(EmployeeDetail employeeDetail) {
		this.employeeDetail = employeeDetail;
	}

	
}


package net.viralpatel.hibernate.oneone;

import java.io.Serializable;

public class EmployeeDetail implements Serializable {

	private Long employeeId;
	private String street;
	private String city;
	private String state;
	private String country;

	private Employee employee;

	public EmployeeDetail() {

	}

	public EmployeeDetail(String street, String city, String state, String country) {
		this.street = street;
		this.city = city;
		this.state = state;
		this.country = country;
	}

	public Employee getEmployee() {
		return employee;
	}

	public void setEmployee(Employee employee) {
		this.employee = employee;
	}

	public String getStreet() {
		return street;
	}

	public void setStreet(String street) {
		this.street = street;
	}

	public String getCity() {
		return city;
	}

	public void setCity(String city) {
		this.city = city;
	}

	public String getState() {
		return state;
	}

	public void setState(String state) {
		this.state = state;
	}

	public String getCountry() {
		return country;
	}

	public void setCountry(String country) {
		this.country = country;
	}

	public Long getEmployeeId() {
		return employeeId;
	}

	public void setEmployeeId(Long employeeId) {
		this.employeeId = employeeId;
	}
}


package net.viralpatel.hibernate.oneone;
 
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
 
public class HibernateUtil {
 
    private static final SessionFactory sessionFactory = buildSessionFactory();
 
    private static SessionFactory buildSessionFactory() {
        try {
            // Create the SessionFactory from hibernate.cfg.xml
            return new Configuration()
            		.configure("hibernate-oneone-viral.cfg.xml")
                    .buildSessionFactory();
        } catch (Throwable ex) {
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        }
    }
 
    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }
}



package net.viralpatel.hibernate.oneone;

import java.sql.Date;
import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;

public class Main {

	public static void main(String[] args) {
		select();
		//insert();
	}
	
	
	static void select(){


		SessionFactory sf = HibernateUtil.getSessionFactory();
		Session session = sf.openSession();
		
		Employee e2 = (Employee)session.load(Employee.class,1l);
		if(e2!=null)
		{
			System.out.println("not null");
			System.out.println(e2.getFirstname());
		}
		else
			System.out.println("null");
		
	
	}
}


<?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 package="net.viralpatel.hibernate.oneone">

	<class name="Employee" table="t_EMPLOYEE">
		<id name="employeeId" column="EMPLOYEE_ID">
			<generator class="native" />
		</id>
		<one-to-one name="employeeDetail" class="EmployeeDetail" fetch="join"></one-to-one>
		
		<property name="firstname" column="firstname"/>
		<property name="lastname" column="lastname"/>
		<property name="birthDate" type="date" column="birthDate"/>
		<property name="cellphone" column="cellphone"/>

	</class>
</hibernate-mapping>


<?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 package="net.viralpatel.hibernate.oneone">

    <class name="EmployeeDetail" table="t_EMPLOYEEDETAIL">

 		<id name="employeeId" type="java.lang.Long">
			<column name="EMPLOYEE_ID" />
			<generator class="foreign">
				<param name="property">employee</param>
			</generator>
		</id>
		<one-to-one name="employee" class="Employee"
			constrained="true"></one-to-one>
		
        <property name="street" column="STREET"/>
        <property name="city" column="CITY"/>
        <property name="state" column="STATE"/>
        <property name="country" column="COUNTRY"/>
	</class>

</hibernate-mapping>

<?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.username">tp2</property>
<property name="hibernate.connection.password">tp2</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:qadb7</property>
<property name="hibernate.default_schema">tp2</property>
<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
<property name="show_sql">true</property>
<!--property name="hbm2ddl.auto">create-drop</property-->
<mapping resource="net/viralpatel/hibernate/oneone/EmployeeDetail.hbm.xml"/>
<mapping resource="net/viralpatel/hibernate/oneone/Employee.hbm.xml"/>

</session-factory>
</hibernate-configuration>

I am setting fetch as {select|join}. In both cases the get the following output in the following loop:

if(e2!=null)
{
System.out.println("not null"); //line1
//System.out.println(e2.getFirstname()); //line2
}

and no select query is being fired on db.

My understanding is that in case of fetch="select", the proxy is loaded so the select query is not being fired. But in case fetch="join" eager loading should take place and select query should be fired immediately when instance is loaded from session. In none of the cases no selet query if fired.

Hibernate: select employee0_.EMPLOYEE_ID as EMPLOYEE1_0_1_, employee0_.firstname as firstnam2_0_1_, employee0_.lastname as lastname3_0_1_, employee0_.birthDate as birthDat4_0_1_, employee0_.cellphone as cellphon5_0_1_, employeede1_.EMPLOYEE_ID as EMPLOYEE1_1_0_, employeede1_.STREET as STREET2_1_0_, employeede1_.CITY as CITY3_1_0_, employeede1_.STATE as STATE4_1_0_, employeede1_.COUNTRY as COUNTRY5_1_0_ from tp2.t_EMPLOYEE employee0_, tp2.t_EMPLOYEEDETAIL employeede1_ where employee0_.EMPLOYEE_ID=employeede1_.EMPLOYEE_ID(+) and employee0_.EMPLOYEE_ID=?

Hibernate: select employee0_.EMPLOYEE_ID as EMPLOYEE1_0_1_, employee0_.firstname as firstnam2_0_1_, employee0_.lastname as lastname3_0_1_, employee0_.birthDate as birthDat4_0_1_, employee0_.cellphone as cellphon5_0_1_, employeede1_.EMPLOYEE_ID as EMPLOYEE1_1_0_, employeede1_.STREET as STREET2_1_0_, employeede1_.CITY as CITY3_1_0_, employeede1_.STATE as STATE4_1_0_, employeede1_.COUNTRY as COUNTRY5_1_0_ from tp2.t_EMPLOYEE employee0_, tp2.t_EMPLOYEEDETAIL employeede1_ where employee0_.EMPLOYEE_ID=employeede1_.EMPLOYEE_ID(+) and employee0_.EMPLOYEE_ID=?

Please clarify. Thanks.

[Naresh Chaurasia]

Hibernate: select employee0_.EMPLOYEE_ID as EMPLOYEE1_0_1_, employee0_.firstname as firstnam2_0_1_, employee0_.lastname as lastname3_0_1_, employee0_.birthDate as birthDat4_0_1_, employee0_.cellphone as cellphon5_0_1_, employeede1_.EMPLOYEE_ID as EMPLOYEE1_1_0_, employeede1_.STREET as STREET2_1_0_, employeede1_.CITY as CITY3_1_0_, employeede1_.STATE as STATE4_1_0_, employeede1_.COUNTRY as COUNTRY5_1_0_ from tp2.t_EMPLOYEE employee0_, tp2.t_EMPLOYEEDETAIL employeede1_ where employee0_.EMPLOYEE_ID=employeede1_.EMPLOYEE_ID(+) and employee0_.EMPLOYEE_ID=?

Hibernate: select employee0_.EMPLOYEE_ID as EMPLOYEE1_0_1_, employee0_.firstname as firstnam2_0_1_, employee0_.lastname as lastname3_0_1_, employee0_.birthDate as birthDat4_0_1_, employee0_.cellphone as cellphon5_0_1_, employeede1_.EMPLOYEE_ID as EMPLOYEE1_1_0_, employeede1_.STREET as STREET2_1_0_, employeede1_.CITY as CITY3_1_0_, employeede1_.STATE as STATE4_1_0_, employeede1_.COUNTRY as COUNTRY5_1_0_ from tp2.t_EMPLOYEE employee0_, tp2.t_EMPLOYEEDETAIL employeede1_ where employee0_.EMPLOYEE_ID=employeede1_.EMPLOYEE_ID(+) and employee0_.EMPLOYEE_ID=?

In case i uncomment line2 the following query is fired irrespective of fetch as {select|join}

System.out.println("not null"); //line1
System.out.println(e2.getFirstname()); //line2