Commit/rollback using querydsl sql

[Nono]

Hello

I'm looking at querydsl for a simple standalone project, with just 2 tables.

However, I need some transactional request to achieve something close to this pseudo code:

int max = select max(index) from tableA where  topic = "foo";

insert into tableB values (... , index = max +1);

I don't see how I can use jdbc commit/rollback, apart from falling back to the sql string and doing it myself.

What am I missing ?

thanks in advance

Best regards and thx for querydsl :)

nono

[Filipe Sousa]

Take a look at examples that implement the transactional part.

https://github.com/querydsl/querydsl/tree/master/querydsl-examples

[Nono]

Thanks for the hint Filipe

I actually plan to create a TransactionalDataSource wrapping a real one, the gist of the idea can be seen there https://gist.github.com/anonymous/29262201a65e9f1c36da

Do it looks sensible to you ?

Thanks again

best regards

nono

[timowest]

Is this DataSource supposed to be threadsafe? If yes, you should use a ThreadLocal to hold the connection.