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

2

 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();

answered Jul 13, 2015 at 15:23

Drew

25k10 gold badges47 silver badges81 bronze badges

2 Comments

Shashika Over a year ago

Tried in all ways. Still has the same problem

Drew Over a year ago

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

0

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));
}

answered Aug 21, 2023 at 12:17

davidvera

1,5072 gold badges32 silver badges74 bronze badges

Collectives™ on Stack Overflow

Hibernate delete query is not working?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related