CRNT-17107 - Added transaction and non-transactional behavior of MySQL

git-svn-id: http://emeafrazerg/svn/ipp/product/trunk/stardust/documentation@57010 8100b5e0-4d52-466c-ae9c-bdeccbdeaf6b

1 files changed, 11 insertions, 0 deletions

diff --git a/org.eclipse.stardust.docs.dev/html/handbooks/others/troubleshooting.html b/org.eclipse.stardust.docs.dev/html/handbooks/others/troubleshooting.html
index bb8f6f6..0fdf2a4 100644
--- a/org.eclipse.stardust.docs.dev/html/handbooks/others/troubleshooting.html
+++ b/org.eclipse.stardust.docs.dev/html/handbooks/others/troubleshooting.html
@@ -97,6 +97,7 @@
             <li><a href="#sybase">Sybase - failing invocation of parallel activities</a></li>

             <li><a href="#deadlock">Sybase - deadlock situations</a></li>

             <li><a href="#mysqlVersion">Some MySQL versions cause server crashes</a></li>

+            <li><a href="#tran">Mixing transactional and non-transactional behavior in MySQL</a></li>
         </ul></li>

         <li><a href="#dms">DMS</a>

         <ul>

@@ -787,6 +788,16 @@ operation guide, for information on this property.</p>
         http://bugs.mysql.com/bug.php?id=39320</a> for detailed information).</li>

 </ul>

 <p>All versions in between the ones mentioned above provide more stability.</p>

+
+<h4 id="tran">Mixing transactional and non-transactional behavior in MySQL</h4>
+<p>MySQL does not consider (some) errors as errors, if they happen on the second or subsequent row of a multi-row insert.
+Only if it happens on the first row, it is an error.
+To change this behavior so that every error is really an error, set:</p>
+<pre>SET SQL_MODE='STRICT_ALL_TABLES'</pre>
+
+
+
+
 <h3 id="dms">DMS</h3>

 <h4 id="typeMismatch">Mapping - Hidden Type Mismatch</h4>

 <p>Mapping types, which are different, but which are both represented as <tt>Number</tt>