You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openjpa.apache.org by al...@apache.org on 2011/03/30 23:09:37 UTC
svn commit: r1087074 - in /openjpa:
branches/2.1.x/openjpa-project/src/doc/manual/supported_databases.xml
trunk/openjpa-project/src/doc/manual/supported_databases.xml
Author: allee8285
Date: Wed Mar 30 21:09:37 2011
New Revision: 1087074
URL: http://svn.apache.org/viewvc?rev=1087074&view=rev
Log:
OPENJPA-1969 Document "Known Issues.." on DataDirect limitation on precision loss during prepared statement setTimestamp method call.
Modified:
openjpa/branches/2.1.x/openjpa-project/src/doc/manual/supported_databases.xml
openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml
Modified: openjpa/branches/2.1.x/openjpa-project/src/doc/manual/supported_databases.xml
URL: http://svn.apache.org/viewvc/openjpa/branches/2.1.x/openjpa-project/src/doc/manual/supported_databases.xml?rev=1087074&r1=1087073&r2=1087074&view=diff
==============================================================================
--- openjpa/branches/2.1.x/openjpa-project/src/doc/manual/supported_databases.xml (original)
+++ openjpa/branches/2.1.x/openjpa-project/src/doc/manual/supported_databases.xml Wed Mar 30 21:09:37 2011
@@ -1034,6 +1034,15 @@ When reading LOB data from the database,
actually load all the data into memory at the same time.
</para>
</listitem>
+ <listitem>
+ <para>
+The SQL Server 2008 DATETIME2 data type supports 7 digits sub-second precision.
+When DataDirect JDBC driver is used with SQL Server 2008, setTimestamp method call with
+a java.sql.Timestamp argument of more than 3 digits precision in a prepared statement
+will result in truncation. This may cause loss of data precision or
+optimistic lock exception if an entity uses Timestamp type as version field.
+ </para>
+ </listitem>
</itemizedlist>
</section>
</section>
Modified: openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml
URL: http://svn.apache.org/viewvc/openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml?rev=1087074&r1=1087073&r2=1087074&view=diff
==============================================================================
--- openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml (original)
+++ openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml Wed Mar 30 21:09:37 2011
@@ -1051,6 +1051,15 @@ When reading LOB data from the database,
actually load all the data into memory at the same time.
</para>
</listitem>
+ <listitem>
+ <para>
+The SQL Server 2008 DATETIME2 data type supports 7 digits sub-second precision.
+When DataDirect JDBC driver is used with SQL Server 2008, setTimestamp method call with
+a java.sql.Timestamp argument of more than 3 digits precision in a prepared statement
+will result in truncation. This may cause loss of data precision or
+optimistic lock exception if an entity uses Timestamp type as version field.
+ </para>
+ </listitem>
</itemizedlist>
</section>
</section>