How to Insert values through HQL Insert :-(

[Vijay Bhaskar]

HI Everybody,
Can any one of you help me,How to insert values in HQL Insert
Here i am providing sample code...and i am hard coding the values and insert the values in the table.Can anyone please change my code
so tht i can insert the values through HQL Insert(Provide the HQL in my code)

 
//package com.tnzi;
//
//public class main {
//
//}
package com.tnzi;
 
import org.hibernate.Session;
 
import java.util.Date;
import java.util.HashSet;
import java.util.Set;
 
import util.HibernateUtil;
 
public class Main {
 
public static void main(String[] args) {
try{
Set addSet = null;
//Employee_Business_Group employee_Business_Group = null;
Employee employee = null;
//Main mn = new Main();

employee = new Employee();
employee.setLogin_Id("2223");
employee.setEmployee_First_Name("aaaa");
employee.setEmployee_Last_Name("q");
employee.setEmployee_Status_Cd("A");
employee.setUpdate_User("Bhaskar");
employee.setGlobal_Site_Name("yahoo");
employee.setUpdate_Date(new Date());

employee = new Employee();
employee.setLogin_Id("7777");
employee.setEmployee_First_Name("tntntn");
employee.setEmployee_Last_Name("xq");
employee.setEmployee_Status_Cd("A");
employee.setUpdate_User("Bhaar");
employee.setGlobal_Site_Name("rediff");
employee.setUpdate_Date(new Date());

// for first person
addSet = new HashSet();
Employee_Business_Group employee_Business_Group = new Employee_Business_Group();
employee_Business_Group.setBusiness_Group_Id(1);
employee_Business_Group.setPrimary_Business_Group("F");
employee_Business_Group.setUpdate_User("T44444");
employee_Business_Group.setUpdate_Date(new Date());

addSet.add(employee_Business_Group);

employee_Business_Group = new Employee_Business_Group();
employee_Business_Group.setBusiness_Group_Id(2);
employee_Business_Group.setPrimary_Business_Group("B");
employee_Business_Group.setUpdate_User("T44444");
employee_Business_Group.setUpdate_Date(new Date());

addSet.add(employee_Business_Group);

employee.setEmployee_Business_Group(addSet);
System.out.println(employee);
createAndStoreEmployee(employee);

HibernateUtil.getSessionFactory().close();
}catch(Exception e){
e.printStackTrace();
}

}
 
private static void createAndStoreEmployee(Employee employee) throws Exception{

Session session = HibernateUtil.getSessionFactory().getCurrentSession();
 
session.beginTransaction();
System.out.println(employee);
session.save(employee);
 
session.getTransaction().commit();
}

}

Thanks & Regards,
Bhaskar

[Edited to use code tags - Paul Sturrock ]
[ June 19, 2007: Message edited by: Paul Sturrock ]

[Paul Sturrock]

Why do you want to do this using HQL? What happens when you run the code you posted above?

[Vijay Bhaskar]

My task is to insert the data through HibernateQueryLanguage thats why i requested for you people to help me.Can you please do that for me

[Paul Sturrock]

OK. Well the reason I ask why you want to do it in HQL, is because HQL only supports insert from another table, so:

Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();
String insertStatement = "insert into Object (id, name) select oo.id, oo.name from OtherObject oo";
s.createQuery( insertStatement ).executeUpdate();
tx.commit();
session.close(); 

would be how you do it.

Looking at your code above however there is no other table to select from.

[Mark Spritzler]

Originally posted by Vijay Bhaskar:
My task is to insert the data through HibernateQueryLanguage thats why i requested for you people to help me.Can you please do that for me

Please keep it nice. If read in the tone I think it is read it is being a bit bossy and not nice.

It also sounds to me if you have a task like this then it isn't a job related task, because the original code would be the way to do it, using the save() or persist() method. It sounds like a classroom or job interview task, which we don't give answers away for those.

Mark