transaction vraci there is no transaction

Toto sa sprava extremne nekorektne a neviem preco.

• Vlozi do DB, ale nasledne pokus o commit hodi exception
• catch nasledkom toho vrati prazdny array jakoze sa nic nevlozilo
• rollback ale tiez nezbehne
• data zostanu vlozene

Vkladam array viece row v array na jeden insert,ale skusal som aj foreach radek po radku
Preco ten commit to hodi ???

'There is no active transaction'

pouzivam InnoDB + DBE dolu je Nette\Database\Explorer

			// DBE == Nette\Database\Explorer
			$this->DBE->beginTransaction();
            try {
                if (!$this->DBE->getConnection()->getPdo()->inTransaction()) {
                    throw new \ErrorException('Transaction not started successfully.');
                } else {
                    bdump('TRANSACTION READY'); // toto hodi ze OK
                }
                $this->DBE->query('LOCK TABLES ' . self::$table . ' WRITE');
                $this->DBE->table(self::$table)->insert($data); // Prebehne OK (zapise)
                $this->DBE->commit(); //  <--- TU HODI ERROR  'There is no active transaction'
                $this->DBE->query('UNLOCK TABLES');
                return $data;
            } catch (\Throwable $e) {
                bdump($e,'Error during transaction');
                if ($this->DBE->getConnection()->getPdo()->inTransaction()) {
					// TOTO NEZBEHNE LEBO UZ NEVIDI inTransaction,
					// ale bez toto if hodi pdo exception 'There is no active transaction'
                    $this->DBE->rollBack();
                }
                $this->DBE->query('UNLOCK TABLES');
                return [];
            }

Editoval pn-pm (28. 10. 12:33)