Ticket #827 (new defect)

Opened 6 months ago

Last modified 6 months ago

Cached SQLMap Query within TDbTransaction cancels Transaction

Reported by: godzilla Owned by: xue
Priority: normal Milestone: 3.2
Component: Prado Framework v3 Version: 3.2
Severity: minor Keywords: TDbTransaction TSqlMapCache
Cc:

Description

try {
	$transaction = $con -> beginTransaction();

	$sqlMapResult = $sqlMap -> queryForList('StatementId', $param);

	$myActiveRecord1 -> value1 = $sqlMapResult -> value1;
	$myActiveRecord1 -> save();
	$myActiveRecord2 -> save();

	$transaction -> commit();
}
catch(Exception $e) {
	$transaction -> rollBack();
}

works fine until i add cacheModel attribute in SQLMap-XML.

For unkown reasons after performing "queryForList" $transaction -> commit() throws an PDOException "There is no active transaction".

Removing ActiveRecord? operations has no effects.

After removing cacheModel attribute commit works as expected.

I'm using following configuration: Apache/2.2.3 (Win32) PHP/5.2.4 MySql? 5.0.51 Prado 3.1.1

Change History

Changed 6 months ago by tof06

  • version changed from 3.1 to 3.2
  • milestone changed from 3.1.2 to 3.2
Note: See TracTickets for help on using tickets.