[Erp5-report] r24279 - /erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/Catalo...

[nobody at svn.erp5.org]

Author: vincent
Date: Wed Oct 22 10:33:14 2008
New Revision: 24279

URL: http://svn.erp5.org?rev=24279&view=rev
Log:
Creating a table commits transaction implicitely. But when there are rows to insert, that transaction never gets commited (since we are using a non-transactionnal connector - on purpose). So we must manually commit here.

Modified:
    erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_portal_ids.xml

Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_portal_ids.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_portal_ids.xml?rev=24279&r1=24278&r2=24279&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_portal_ids.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_portal_ids.xml Wed Oct 22 10:33:14 2008
@@ -99,7 +99,8 @@
 <dtml-in expr="getPortalObject().portal_ids.getDictLengthIdsItems()">\n
 INSERT INTO `portal_ids` (`id_group`, `last_id`) VALUES (<dtml-sqlvar sequence-key type="string">, <dtml-sqlvar sequence-item type="int">)\n
 <dtml-var sql_delimiter>\n
-</dtml-in>
+</dtml-in>\n
+COMMIT
 
 ]]></string> </value>
         </item>
@@ -148,7 +149,8 @@
 <dtml-in expr="getPortalObject().portal_ids.getDictLengthIdsItems()">\n
 INSERT INTO `portal_ids` (`id_group`, `last_id`) VALUES (<dtml-sqlvar sequence-key type="string">, <dtml-sqlvar sequence-item type="int">)\n
 <dtml-var sql_delimiter>\n
-</dtml-in>
+</dtml-in>\n
+COMMIT
 
 ]]></string> </value>
                     </item>