Rollback in multiples querys using JDBC spring

Question

i have this problem, when i execute two querys in same function, if the second query throw exception and not working, the first query keep yor result in database, both querys are insert in ddbb EXAMPLE:

public void myFunction(){
  query1(); //insert data in ddbb
  query2(); // also try to insert data in ddbb but not working and throw exception
}

in this case i need do rollback in both querys but currently the query1 doesn't rollback and keep his insert in datbase.

I am using spring data JDBC

thanks and sorry for my english, not is my native language

the @Transactional solution works but only if I comment on the class where I have the aspects, do you know why? — roberto fernandez, Jun 25 '20 at 14:19

Tim Biegeleisen · Accepted Answer · 2020-06-26T16:53:49.547

2

You could annotate your method with @Transactional, which would instruct Spring to rollback the entire method in the event of an exception:

@Transactional
public void myFunction(){
    // insert data in ddbb
    // also try to insert data in ddbb but not working and throw exception
}

edited Jun 26 '20 at 16:53

answered Jun 25 '20 at 11:01

Tim Biegeleisen

502,043
27
286
360

Your solution works but only if I comment on the class where I have the aspects, do you know why? – roberto fernandez Jun 25 '20 at 14:18
This doesn't work, the annotation needs to be on the method or class calling these two methods. – Mark Rotteveel Jun 26 '20 at 14:01
the Annotation needs to be on the first method which init the querys to envelop all queries and allow rollback – roberto fernandez Jul 02 '20 at 08:09

Rollback in multiples querys using JDBC spring

1 Answers1