Author: shawkins Date: 2010-06-22 15:08:30 -0400 (Tue, 22 Jun 2010) New Revision: 2277 Modified: branches/7.0.x/documentation/reference/src/main/docbook/en-US/content/translators.xml Log: TEIID-1131 adding a note about oracle sequence handling to the reference Modified: branches/7.0.x/documentation/reference/src/main/docbook/en-US/content/translators.xml =================================================================== --- branches/7.0.x/documentation/reference/src/main/docbook/en-US/content/translators.xml 2010-06-22 18:58:30 UTC (rev 2276) +++ branches/7.0.x/documentation/reference/src/main/docbook/en-US/content/translators.xml 2010-06-22 19:08:30 UTC (rev 2277) @@ -143,7 +143,9 @@ <para><emphasis>mysql5</emphasis> - for use with MySQL version 5 or later.</para> </listitem> <listitem> -<para><emphasis>oracle</emphasis> - for use with Oracle 9i or later.</para> +<para><emphasis>oracle</emphasis> - for use with Oracle 9i or later. Sequences may be used with the Oracle translator. +A sequence may be modeled as a table with a name in source of DUAL and columns with the name in source set to &lt;sequencesequence name&gt;.[nextval|currentval]. +You can use a sequence as the default value for insert columns by setting the column to autoincrement and the name in source to &lt;element name&gt;:SEQUENCE=&lt;sequence name&gt;.&lt;sequence value&gt;.</para> </listitem> <listitem> <para><emphasis>postgresql</emphasis> - for use with 8.0 or later clients and 7.1 or later server. Setting the specific 8.x version improves pushdown support - see the DatabaseVersion execution property.</para>