Insert Sql query not working with HQL

Question

I am trying to make a simple insert into a DB with HQlL by using native SQL code.

It doesn't give any error, it just doesn't work. Any help is appreciated.

Thanks.

public void AddMedicament(Medicament medicament) {
    System.out.println(medicament.getName());
    // open a database connection
    Session session = FarmacieHibernateUtil.getSessionFactory().openSession();
    Transaction transaction = session.beginTransaction();
    // prepare SQL insert command
    session.createSQLQuery("insert into Medicament(name) values('test')");

    // close the database connection
    session.close();
}

Ankit Bansal · Accepted Answer · 2013-03-25 19:09:42Z

2

You need to call

session.executeUpdate() 
transaction.commit();

before closing session.

answered Mar 25, 2013 at 19:09

Ankit Bansal

5,0921 gold badge25 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Adisesha Over a year ago

also transaction.commit();

evgenyl · Accepted Answer · 2013-03-25 19:09:03Z

2

I am not familar with Hibernate, but i dont see you sre running your command. You just create query and close session I think you need some statement to execute it.

answered Mar 25, 2013 at 19:09

evgenyl

8,1472 gold badges29 silver badges32 bronze badges

Comments

Gabi Carballo · Accepted Answer · 2013-03-25 19:12:12Z

2

If you use createSQLQuery this throw a native sql instruction

Your object table name is Medicament too?

answered Mar 25, 2013 at 19:12

Gabi Carballo

674 bronze badges

Comments

sunkara suresh · Accepted Answer · 2013-03-25 19:16:37Z

2

session.saveOrUpdate(medicament); tx.commit(); then it will insert if u r not setting the Primarykey, if u r setting the PK in the domain object then it will be updated.

no need to executeQuery in hibernate if you are using the Spring ORM.

answered Mar 25, 2013 at 19:16

sunkara suresh

191 bronze badge

Collectives™ on Stack Overflow

Insert Sql query not working with HQL

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related