Using transaction now

Using transaction now

Changes to PreparedStatement: execute() will now automatically wrap itself in a transaction before committing changes, including an automatic rollback on failure.

If you want to send multiple queries at once, you should wrap the whole loop in a transaction and use executeUnbuffered() instead.

You SHOULD NOT use executeUnbuffered() without a transaction.