JOOQ and autoCommit on false

[FB]

Hi,

I read on the documentation that JOOQ doesn't provide transaction
management and I have to take care of that.
So to start a transaction and commit/rollback the data I was thinking
to do:


    datasourse.setAutoCommit(false)   //this set
connection.setAutoCommit(false)

    factory.insertInto(T, T.FIRST_NAME, T.LAST_NAME)
                    .values("laura", "natali")
                    .execute();

    datasourse.commit();


The problem is the factory inserts the data before the .commit()
command.
Is there another way to do that?

Thanks. F.