Multiple connections on rollback about laravel-oci8 HOT 5 CLOSED

would it be possible to paste here the actual/snippet of the transaction code?

On the other hand, based on examples, since you are using 2 connections, I think you should also make 2 transaction which depends on the other. Not sure though coz i haven't this scenario on actual.

Maybe try doing something like below:
[start db1 transaction]
[start db2 transaction]
[insert on db2]
[selec db1]
[insert db2]
[rollback if fails]

// default connection
DB::transaction(function($conn){
    DB::connection('db2')->transaction(function($conn){
        // do insert
        // do select
        // do insert
    });
});

Way back, I think i stumbled to an issue on laravel framework with nested transactions but can't seem to find it anymore since issues are now closed on it's github site.

Hope this helps!

from laravel-oci8.

You can also try playing with the PDO object

try {
    DB::connection()->getPdo()->beginTransaction();
    // database queries here
    DB::connection()->getPdo()->commit();
} catch (\PDOException $e) {
    // Woopsy
    DB::connection()->getPdo()->rollBack();
}

from laravel-oci8.

This is how I was trying to check the scenario, very basic, I'm gonna have some tests with your suggestions and let you know, thanks!

DB::transaction(function(){
            //RO connection
            //$company = Company::find(1);

            $username = array(
                'username' => 'alex.company'
            );
            //WO connection
            User::create($username);

            $company = Company::find(1);
            $username = array(
                //adding an error to rise an exception
                'usermame' => 'tom.company',
            );
            //WO connection
            User::create($username);

        });

from laravel-oci8.

Tried different scenarios and it seems your suggestion works flawlessy, tnx! :)
I'm a bit puzzled since in fact the default connection is the one on which I wanted the rollback and the only one declared.

// default connection
DB::transaction(function($conn){
    DB::connection('db2')->transaction(function($conn){
        // do insert
        // do select
        // do insert
    });
});

from laravel-oci8.

There seems to be no problem on your code but to be sure try enabling app.debug=true so you can further see the error logs.

Anyways, good to hear that my suggestion works! Closing this issue now. :)

from laravel-oci8.