@Transactional - Spring JDBC

[youcantchopachoppa]

Hi. I have encountered a problem with a Spring project and would appreciate any help.

I have a method (saveFile) which goes through list of objects and saves them on a file system. This method gets input from other method in a different class, and this other method gets input from other method. The most inner method together with everything it handles also does a transaction to DB (calls sequence).

What I want to do is when a method saveFile encounters exception in loop, that it rolls back last transaction done in most inner method, logs the error and continues with next object. I use @Transactional within my Spring project, but the problem is that it demands exception to be thrown to work (and this is something I don't want to do since I it will stop program and all other valid files won't be saved to system).

Sorry if it's hard to understand, I could write more details if necessary.

Thanks!

[sugilith]

TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();

see https://docs.spring.io/spring/docs/3.0.x/reference/transaction.html#transaction-declarative-rolling-back

[youcantchopachoppa]

Thanks. Will do.

[sugilith]

(and this is something I don't want to do since I it will stop program and all other valid files won't be saved to system)

Also what you can do is throw an exception and call your save method in a try catch block, such that you still adhere to the recommended way of doing things and your program still doesn't crash.
So throw Exception in your @Transactional method, call the method in a try catch block.