Hibernate delete query is not working?

Question

I use the following code to delete a record from table. I was able to successfully insert data to that table. But this delete operation does not work.

 @Override public int deleteButterflyCountData(int recordId) { Session session = this.sessionFactory.openSession(); session.beginTransaction(); String query = "delete FROM ButterflyCountData where record_id="+recordId+""; Query q = session.createQuery(query); int result = q.executeUpdate(); session.close(); return result; }

result also returns 1 but data table record is not be deleted. What is the issue in here?

I don't know how your getting result. Your query have syntax error... FORM is not valid with delete query... If you getting result then commit your session before close.... — Kanagaraj M
– Kanagaraj M, Commented Jul 13, 2015 at 15:41

Community · Accepted Answer · 2017-05-23 10:26:45Z

4

You have to commit the transaction:

Transaction transaction = session.beginTransaction(); ... transaction.commit(); session.close();

edited May 23, 2017 at 10:26

CommunityBot

11 silver badge

answered Jul 13, 2015 at 15:35

Dragan Bozanovic

23.6k5 gold badges50 silver badges117 bronze badges

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

Comments

Drew · Accepted Answer · 2015-07-13 15:23:54Z

 HQL Delete Query Example Delete a stock where stock code is “7277”. Query query = session.createQuery("delete Stock where stockCode = :stockCode"); query.setParameter("stockCode", "7277"); int result = query.executeUpdate(); Query query = session.createQuery("delete Stock where stockCode = '7277'"); int result = query.executeUpdate();

On top of syntax error you are not committing transaction if you ever get that far

davidvera · Accepted Answer · 2023-08-21 12:17:01Z

I replaced :

@Transactional public void deleteCustomer(Long customerId) { Session currentSession = sessionFactory.getCurrentSession(); Query<Customer> query= currentSession .createQuery("DELETE FROM Customer c where c.id =:customerId", Customer.class); query.setParameter("customerId", customerId); query.executeUpdate(); }

with: I also had the same issue with hibernate 6. You can do this way even if it adds a query:

@Transactional public void deleteCustomer(Long customerId) { Session currentSession = sessionFactory.getCurrentSession(); currentSession.remove(currentSession.get(Customer.class, customerId)); }

Collectives™ on Stack Overflow

Hibernate delete query is not working?

3 Answers 3

Comments

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Linked

Related