Hibernate Criteria Ambiguos

[Rendi Artha]

Dear all myfrind,
I have some ambiguous using criteria Hibernate.

check my code here.
hibernate.cfg.xml

   
<hibernate-configuration>

    <session-factory>
        <!-- Database connection settings -->
        <property name="connection.driver_class">
            com.mysql.jdbc.Driver
        </property>
        <property name="connection.url">
            jdbc:mysql://localhost:3306/hibernatemapping
        </property>
        <property name="connection.username">
            root
        </property>
        <property name="connection.password">
            adminadmin
        </property>
        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>

        <!-- SQL dialect -->
        <property name="dialect">
            org.hibernate.dialect.MySQLDialect
        </property>
        <!-- Enable Hibernate's automatic session context mgmt -->
        <property name="current_session_context_class">
            thread
        </property>
        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">
            org.hibernate.cache.NoCacheProvider
        </property>

        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>

        <!-- Drop and re-create the database schema on startup
     options: validate | update | create | create-drop
        -->
        <property name="hbm2ddl.auto">update</property>

        <!-- reference to the mapping files -->
        <mapping resource="com/mycompany/model/DeptEmployee.hbm.xml"/>
    </session-factory>

</hibernate-configuration>
 

DeptEmployee.hbm.xml

    
<class name="Dept" table="tbl_department">
    <id name="deptId" column="dept_id">
      <generator class="assigned"/>
    </id>
    <property name="deptName" column="dept_name" type="java.lang.String"/>
    <set name="employees" table="tbl_employee" cascade="persist,delete">
      <key column="dept_id" />
      <one-to-many class="Employee"/>
    </set>
  </class>
  <class name="Employee" table="tbl_employee">
    <id name="employeeId" column="employee_id">
      <generator class="assigned"/>
    </id>
    <property name="employeeName" column="employee_name" type="java.lang.String"/>
    <one-to-one name="dept" class="Dept" />
  </class>

Test Code :

    
public class TestOneToMany {

    public SessionFactory findSession() {
        SessionFactory sessionFactory;
        Configuration conf = new Configuration();
        sessionFactory = conf.configure("hibernate.cfg.xml").buildSessionFactory();
        return sessionFactory;
    }

    public void TestOneToMany() {
        SessionFactory sessionFactory = findSession();
        if (sessionFactory != null) {
            Session session = sessionFactory.getCurrentSession();
            Transaction trans = session.getTransaction();
            trans.begin();
            Employee emp1 = new Employee();
            emp1.setEmployeeId(1001);
            emp1.setEmployeeName("test1");

            Employee emp2 = new Employee();
            emp2.setEmployeeId(1002);
            emp2.setEmployeeName("test2");
            Employee emp3 = new Employee();
            emp3.setEmployeeId(1003);
            emp3.setEmployeeName("test3");

            Set emps = new HashSet();
            emps.add(emp1);
            emps.add(emp2);
            emps.add(emp3);
            Dept dept = new Dept();
            dept.setDeptId(1001);
            dept.setDeptName("test dept1");
            dept.setEmployees(emps);
            session.persist(dept);
            trans.commit();
        }
    }

    public List<Employee> criteriaFindAllEmployee() {
        SessionFactory sessionFactory = findSession();
        List<Employee> listEmp = null;
        if (sessionFactory != null) {
            Session session = sessionFactory.openSession();
            Criteria criteria = session.createCriteria(Employee.class);
            listEmp = criteria.list();
        }
        return listEmp;
    }

    public void printList(List<Employee> list) {
        System.out.println("EmpNO \t EmpName \t Dept ID");
        for (Employee e : list) {
            System.out.println(e.getEmployeeId() + "\t" + e.getEmployeeName() + "\t" + e.getDept().getDeptName());
        }

    }

    public static void main(String[] args) {
        TestOneToMany test = new TestOneToMany();
        //test.TestOneToMany();
        List<Employee> listEmp = test.criteriaFindAllEmployee();
        System.out.println(listEmp); //-------------------------------------------------------->> this return 3 record "[1001-test1, 1002-test2, 1003-test3]"
        test.printList(listEmp);
    }
}

When i check on DB i found :
3 record on tbl_employee
1 record on tbl_department

Unfortunately when I run those Test Code something happens with message indicate that something throws NullPointerException.
I found that when execute listEmp = criteria.list() it return list employee such this :

1001 | test1 | 1001
1002 | test2 | null
1003 | test3 | null

The question is how can it be since record in tbl_employee indicate no NULL appears on column tbl_employee.departmentId .

Any help would be appreciate a lot.

Thanks in advance,

CriterionNewbie A.K.A. (Rendi Artawijaya)

[Rendi Artha]

Still in unsolve matter.. any help would be appreciate.

Rgds,
Rendi (Criterionnewbi)