1.2.4 Phalcon\Db\Adapter\Pdo\Postgresql transaction

Question

1.2.4 Phalcon\Db\Adapter\Pdo\Postgresql transaction

Farkhod Dec '13

Created Dec '13	Last Reply Dec '13	Replies 2	Views 931	Votes 0

Farkhod 42.1k

Dec '13

Hi all!!!

I use transaction:

try {
    $this->di->getDb()->begin();

    $this->di->getDb()->execute('...');
    $this->di->getDb()->execute('...');

    $this->di->getDb()->commit();
} catch(Exception $e) {
    $this->di->getDb()->rollback();
    echo $e->getMessage();
}

falls exception: Uncaught exception 'Phalcon\Db\Exception' with message 'There is no active transaction'

in Postgres logs: 2013-12-18 20:15:09 TJT ОТМЕТКА: оператор: BEGIN 2013-12-18 20:15:09 TJT ОТМЕТКА: оператор: ROLLBACK

????

Phalcon
98.9k

Accepted
answer

Dec '13

It must be shared, or every time you call $this->di->getDb() you will get a new connection

Phalcon · Answer 1 · 2013-12-18T08:31:10-07:00

Phalcon
98.9k

Dec '13

Are you registering the 'db' service as shared?

Farkhod · Answer 2 · 2013-12-18T08:48:49-07:00

/**
 * Database connection is created based in the parameters defined in the configuration file
 */
$di->set('db', function() use ($config) {
    return new Postgresql(array(
        'host' => $config->database->host,
        'username' => $config->database->username,
        'password' => $config->database->password,
        'dbname' => $config->database->dbname
    ));
});

Farkhod · Answer 3 · 2013-12-18T08:56:47-07:00

Farkhod
42.1k

Dec '13

sorry for my carelessness