how to write insertinto command in hibernate criteria

Question

I want to write the below InsertInto query in Hibernate Criteria. Any Suggestions .. thanks for help

        sql = "insert into selectedresumes  values('" + companyId + "','"
        + resumeId + "','" + resumeStatusId + "','" + jobId + "')";

Solution

Unfortunately, You can't do it.

According to Hibernate documentation

http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html_single/#batch-direct

Only the INSERT INTO ... SELECT ... form is supported; not the INSERT INTO ... VALUES ... form.

So you just need to create Object and save it using Hibernate and it should look something like that

Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();
Resume selectedresumes  = new Resume();
//set all resume values
session.save(selectedresumes);
tx.commit();
session.close();

Comments

[junaidp]

thanks for your help , i am doing this same thing but at this line tx.commit(); it throws exception org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update any idea what the reason. thanks