FuelPHP Forums

soseki

Hello sir,

I have a question regarding transaction.

I have 2 db configurations and need to access all of them all the time.

So, in this case, is following correct?

try

{

DB::start_transaction();

$model = \Model_Base::query()->order_by('id', 'desc')->get_one();

$model->data = '1000';

if(!$model->save())

{

throw new Exception('Error1');

}

\Model_Base::set_connection('update');

$model = \Model_Base::query()->order_by('id', 'desc')->get_one();

$model->data = '2000';

if(!$model->save())

{

throw new Exception('Error2');

}

DB::commit_transaction();

}

catch(Exception $e)

{

DB::rollback_transaction();

}

Harro

What database are you using?

Not all support distributed transactions across databases, and if they do, they only support it in specific circumstances. Distributed transactions is something you would want to avoid.

The standard SQL command TRANSACTION, implemented by DB, only works for transactions within a single database.

If you need distributed transactions, read up on XA transactions. They are very specific depending on the platform you are using, and currently not implemented in the DB drivers.

soseki

Thanks for quick reply.

They are MySQL and innoDB is used.

Also, they are running on the same server.

Harro

It is not relevant if they are on the same server, it is relevant if both connections point to the same or to different databases.

see https://stackoverflow.com/questions/2239810/multiple-database-and-transactions for more info.

soseki

Okay thanks for that.

I tried nested transaction and it seems fine.

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion