openjpa-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kwsut...@apache.org
Subject svn commit: r688855 - /openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml
Date Mon, 25 Aug 2008 20:02:23 GMT
Author: kwsutter
Date: Mon Aug 25 13:02:23 2008
New Revision: 688855

URL: http://svn.apache.org/viewvc?rev=688855&view=rev
Log:
OPENJPA-702.  Update documentation for the DESCSTAT parameter for DB2 on z/OS.

Modified:
    openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml

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=688855&r1=688854&r2=688855&view=diff
==============================================================================
--- openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml (original)
+++ openjpa/trunk/openjpa-project/src/doc/manual/supported_databases.xml Mon Aug 25 13:02:23
2008
@@ -429,20 +429,30 @@
 extending <classname>DB2Dictionary</classname>.
                     </para>
                 </listitem>
-                <listitem>
-                    <para>
-Explicit creation of indexes specified by the OpenJPA @Index annotation will 
-fail on DB2 for iSeries if the default schema used by the JDBC driver does not 
-exist.  If a default schema is not specified on the connection, the iSeries 
-will default to the user profile name.  If a schema of that name does not 
-exist, DB2 on iSeries will not create the schema, resulting in a failure when 
-creating the index.  The failure message will look similar to: "[SQL0204] 
-USERNAME in QSYS type *LIB not found."  To work around this issue, specify a 
-default schema on the JDBC URL or data source property and make sure that 
-schema exists or create a schema which matches the user profile of the 
-connection.
-                    </para>
-                </listitem>
+                <listitem>
+                    <para>
+Explicit creation of indexes specified by the OpenJPA @Index annotation will 
+fail on DB2 for iSeries if the default schema used by the JDBC driver does not 
+exist.  If a default schema is not specified on the connection, the iSeries 
+will default to the user profile name.  If a schema of that name does not 
+exist, DB2 on iSeries will not create the schema, resulting in a failure when 
+creating the index.  The failure message will look similar to: "[SQL0204] 
+USERNAME in QSYS type *LIB not found."  To work around this issue, specify a 
+default schema on the JDBC URL or data source property and make sure that 
+schema exists or create a schema which matches the user profile of the 
+connection.
+                    </para>
+                </listitem>
+                <listitem>
+                    <para>
+Use of DB2 on z/OS with the IBM JCC driver requires the DESCSTAT subsystem 
+parameter value to be set to 'YES'.  If this parameter is set to 'NO', the 
+mapping tool will fail with a persistence exception containing this text: 
+"Invalid parameter: Unknown column name TABLE_SCHEM".  After changing the value 
+of DESCSTAT, DB2 metadata tables must be recreated by running the DSNTIJMS job. 
+See DB2 for z/OS documentation for additional information.
+                    </para>
+                </listitem>
             </itemizedlist>
         </section>
     </section>
@@ -1004,19 +1014,19 @@
 procedure.</literal> ".
                     </para>
                 </listitem>
-                <listitem>
-                    <para> 
-Applications performing update/insert data of the BigDecimal java type may fail 
-with OptimisticException if the data exceeds the scale or precision of the
-column on Sybase. To avoid this problem, applications can specify the precision
-and scale for the numeric type by setting numericTypeName='NUMERIC(p,s)' for
-the column type mapped by the BigDecimal java type. See
-<link linkend="openjpa.jdbc.DBDictionary">openjpa.jdbc.DBDictionary</link> for
-more detail. Alternatively, application can set the precision and scale using
-the standard <classname>Column</classname> annotation, described in
-<xref linkend="jpa_overview_mapping_column"/>.
-                    </para>
-                </listitem>
+                <listitem>
+                    <para> 
+Applications performing update/insert data of the BigDecimal java type may fail 
+with OptimisticException if the data exceeds the scale or precision of the
+column on Sybase. To avoid this problem, applications can specify the precision
+and scale for the numeric type by setting numericTypeName='NUMERIC(p,s)' for
+the column type mapped by the BigDecimal java type. See
+<link linkend="openjpa.jdbc.DBDictionary">openjpa.jdbc.DBDictionary</link> for
+more detail. Alternatively, application can set the precision and scale using
+the standard <classname>Column</classname> annotation, described in
+<xref linkend="jpa_overview_mapping_column"/>.
+                    </para>
+                </listitem>
             </itemizedlist>
         </section>
     </section>



Mime
View raw message