You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@isis.apache.org by ke...@apache.org on 2011/04/27 17:45:56 UTC

svn commit: r1097154 - /incubator/isis/trunk/runtimes/dflt/objectstores/sql/src/docbkx/guide/isis-sql-objectstore.xml

Author: kevin
Date: Wed Apr 27 15:45:55 2011
New Revision: 1097154

URL: http://svn.apache.org/viewvc?rev=1097154&view=rev
Log:
Updating documentaton

Modified:
    incubator/isis/trunk/runtimes/dflt/objectstores/sql/src/docbkx/guide/isis-sql-objectstore.xml

Modified: incubator/isis/trunk/runtimes/dflt/objectstores/sql/src/docbkx/guide/isis-sql-objectstore.xml
URL: http://svn.apache.org/viewvc/incubator/isis/trunk/runtimes/dflt/objectstores/sql/src/docbkx/guide/isis-sql-objectstore.xml?rev=1097154&r1=1097153&r2=1097154&view=diff
==============================================================================
--- incubator/isis/trunk/runtimes/dflt/objectstores/sql/src/docbkx/guide/isis-sql-objectstore.xml (original)
+++ incubator/isis/trunk/runtimes/dflt/objectstores/sql/src/docbkx/guide/isis-sql-objectstore.xml Wed Apr 27 15:45:55 2011
@@ -146,8 +146,8 @@
       <title>Mappers</title>
 
       <para>The mappers take care of mapping a value type onto a SQL data
-      type. Default mappers are provided by JdbcFieldMappingFactoryInstaller.
-      </para>
+      type. Default mappers are provided by
+      JdbcFieldMappingFactoryInstaller.</para>
 
       <sect2>
         <title>Modifiable values</title>
@@ -231,6 +231,17 @@
       </sect2>
 
       <sect2>
+        <title>Floating Point Value Limits</title>
+
+        <para><emphasis>Caution:</emphasis> Testing on certain database
+        servers (MySQL and PostgreSQL) has shown that <code>float</code>s and
+        <code>double</code>s (stored as <code>FLOAT</code> or <code>DOUBLE
+        PRECISION</code> respectively) are not stored to the same resolution
+        as supported by Java. The tested range of float is 1E-37 to 1E38, and
+        the tested range of double is 1E-307 to 1E308.</para>
+      </sect2>
+
+      <sect2>
         <title>Fixed values</title>
 
         <para>The following classes are not modifiable:</para>
@@ -378,9 +389,11 @@
         replaced with the following properties file entries:</para>
 
         <blockquote>
-          <para>isis.persistor.sql.datatypes.timestamp=TIMESTAMP </para>
+          <para>isis.persistor.sql.datatypes.timestamp=TIMESTAMP</para>
 
           <para>isis.persistor.sql.datatypes.datetime=TIMESTAMP</para>
+
+          <para>isis.persistor.sql.datatypes.double=DOUBLE PRECISION</para>
         </blockquote>
 
         <para></para>
@@ -392,12 +405,21 @@
         <para>There was an issue with storing and correctly retrieving date
         (time) values - a special "try .. catch" has been used to ensure that
         UTC temporal values are correctly retrieved.</para>
+
+        <para>The following data type overrides may be required:</para>
+
+        <blockquote>
+          <para>isis.persistor.sql.datatypes.double=DOUBLE PRECISION</para>
+        </blockquote>
+
+        <para></para>
       </sect2>
 
       <sect2>
         <title>Microsoft SQL Server 2008</title>
 
-        <para></para>
+        <para>Missing. Tested at the office, documentation at home!
+        Argh.</para>
       </sect2>
 
       <sect2>
@@ -560,7 +582,7 @@
     <sect1>
       <title>Edit History</title>
 
-      <para>Last editted: Kevin, 21/04/2011.<!--dd/mm/yyyy--></para>
+      <para>Last editted: Kevin, 27/04/2011.<!--dd/mm/yyyy--></para>
     </sect1>
   </appendix>
 </book>