[Erp5-report] r41603 seb - /erp5/trunk/products/CMFActivity/dtml/connectionAdd.dtml

Tue Dec 21 15:08:44 CET 2010

Author: seb
Date: Tue Dec 21 15:08:44 2010
New Revision: 41603

URL: http://svn.erp5.org?rev=41603&view=rev
Log:
Due to the sorting of database connectors during a transaction, the
ZMySQLDA connector for the activities database would finish its
commit procedure before ZODB, making the description of an activity
message in MySQL available before its respective data in the ZODB.

The fix consisted in replacing the ZMySQLDA connector with another
one based on ZMySQLDA but with a “sortKey()” method that forced it
to be sorted after both the ZODB connection and the ZMySQLDA
connection for ZSQLCatalog.

Analysis of issue was done by Sebastien and Julien.

This patch itself was done by Leonardo.

Added:
    erp5/trunk/products/CMFActivity/dtml/connectionAdd.dtml

Added: erp5/trunk/products/CMFActivity/dtml/connectionAdd.dtml
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/dtml/connectionAdd.dtml?rev=41603&view=auto
==============================================================================

--- erp5/trunk/products/CMFActivity/dtml/connectionAdd.dtml (added)
+++ erp5/trunk/products/CMFActivity/dtml/connectionAdd.dtml [utf8] Tue Dec 21 15:08:44 2010
@@ -0,0 +1,53 @@
+<html>
+  <head><title>Add CMFActivity Database Connection</title></head>
+  <body bgcolor="#FFFFFF" link="#000099" vlink="#555555" alink="#77003B">
+
+    <h2>Add CMFActivity Database Connection</h2>
+
+    <form action="manage_addActivityConnection" method="POST">
+      <table cellspacing="2">
+        <tr>
+          <th align="LEFT" valign="TOP">Id</th>
+          <td align="LEFT" valign="TOP">
+            <input type="TEXT" name="id" size="40"
+                value="cmf_activity_sql_connection">
+          </td>
+        </tr>
+        <tr>
+          <th align="LEFT" valign="TOP"><em>Title</em></th>
+          <td align="LEFT" valign="TOP">
+            <input type="TEXT" name="title" size="40"
+                value="CMFActivity Database Connection">
+          </td>
+        </tr>
+        <tr>
+          <th align="LEFT" valign="TOP">
+              Enter a Database Connection String
+              <a href="#1"><sup>1</sup></a></th>
+          <td align="LEFT" valign="TOP">
+            <input type="TEXT" name="connection_string" size="40">
+          </td>
+        </tr>
+        <tr>
+          <th align="LEFT" valign="TOP">Connect immediately</th>
+          <td align="LEFT" valign="TOP">
+            <input name="check" type="CHECKBOX" value="YES" CHECKED>
+          </td>
+        </tr>
+        <tr>
+          <td></td>
+          <td><br><input type="SUBMIT" value="Add"></td>
+        </tr>
+      </table>
+    </form>
+
+
+
+<dt><a hname="1"><sup>1</sup></a> Connection Strings</dt>
+<dd>
+    The connection string used for the CMFActivity Database Connection
+    has the same syntax as for ZMySQLDA.
+</dd></dl>
+
+  </body>
+</html>

