Using transaction on Joomla

[saferamirez]

Hi!

I want to know how I can make multiple entries in the database through a transaction. I need to ensure that all inserts are executed.

I tried using the JDatabase class methods, which allows you to create transactions, the method is BeginTrans the problem is that by default is configured autocomit BD so that any decision I make is reflected in the bd. How can I temporarily disable this property from the joomla code?

Thanks...

[Ratmil]

Code: Select all

$db =& JFactory::getDBO();
$db->setQuery("START TRANSACTION");
$db->query();

....

Code: Select all

if($result)
{
    $db->setQuery("COMMIT");
    $result = $db->query();
}
else
{
    $db->setQuery("ROLLBACK");
    $db->query();
}

Have you noticed that the BeginTrans method in JDatabase is empty?
Your tables have to be of type InnoDB for transactions to work.