Framework: DB::transaction does not work when using DB::connection()

[hfmikep]

• Laravel Version: 5.4.#
• PHP Version: 7.1.5
• Database Driver & Version: MySQL 5.6.36

Description:

DB::transactions do not work when using DB::connection()

Steps To Reproduce:

Create a non-default config for a mysql database.

Attempt to run the following code:

````
DB::beginTransaction();

try {

    DB::connection('newdb')->table('users')->where('id', 2)->update(['status' => 'VALIDATED']);
    throw new \Exception('Some new exception');
    DB::commit();

} catch ( Exception $ex ){

    DB::rollBack();

}
````

The DB transaction is immediately committed at the update statement and can not be rolled back.

[themsaid]

Start the transaction on the same connection your query will run on.

[hfmikep]

Duh... Thank you!

[happytodev]

@themsaid thank you very much. I think this specific point with multi database connections could be added in documentation.
Can I help for that @taylorotwell ?