Author: mikedd
Date: Tue Feb 19 09:32:05 2008
New Revision: 629168
URL: http://svn.apache.org/viewvc?rev=629168&view=rev
Log:
OPENJPA-517
Modified:
openjpa/branches/1.0.x/openjpa-jdbc/src/main/java/org/apache/
openjpa/jdbc/sql/DBDictionary.java
openjpa/branches/1.0.x/openjpa-jdbc/src/main/java/org/apache/
openjpa/jdbc/sql/OracleDictionary.java
openjpa/branches/1.0.x/openjpa-project/src/doc/manual/
ref_guide_dbsetup.xml
Modified: openjpa/branches/1.0.x/openjpa-jdbc/src/main/java/org/
apache/openjpa/jdbc/sql/DBDictionary.java
URL:
http://svn.apache.org/viewvc/openjpa/branches/1.0.x/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DBDictionary.java?rev=629168&r1=629167&r2=629168&view=diff
=
=
=
=
=
=
=
=
=
=====================================================================
--- openjpa/branches/1.0.x/openjpa-jdbc/src/main/java/org/apache/
openjpa/jdbc/sql/DBDictionary.java (original)
+++ openjpa/branches/1.0.x/openjpa-jdbc/src/main/java/org/apache/
openjpa/jdbc/sql/DBDictionary.java Tue Feb 19 09:32:05 2008
@@ -174,6 +174,7 @@
public String reservedWords = null;
public String systemSchemas = null;
public String systemTables = null;
+ public String selectWords = null;
public String fixedSizeTypeNames = null;
public String schemaCase = SCHEMA_CASE_UPPER;
@@ -3876,10 +3877,14 @@
if (fixedSizeTypeNames != null)
fixedSizeTypeNameSet.addAll(Arrays.asList(Strings.split
(fixedSizeTypeNames.toUpperCase(), ",", 0)));
-
+
// if user has unset sequence sql, null it out so we know
sequences
// aren't supported
nextSequenceQuery =
StringUtils.trimToNull(nextSequenceQuery);
+
+ if (selectWords != null)
+
selectWordSet.addAll(Arrays.asList(Strings.split(selectWords
+ .toUpperCase(), ",", 0)));
}
//////////////////////////////////////
Modified: openjpa/branches/1.0.x/openjpa-jdbc/src/main/java/org/
apache/openjpa/jdbc/sql/OracleDictionary.java
URL:
http://svn.apache.org/viewvc/openjpa/branches/1.0.x/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/OracleDictionary.java?rev=629168&r1=629167&r2=629168&view=diff
=
=
=
=
=
=
=
=
=
=====================================================================
--- openjpa/branches/1.0.x/openjpa-jdbc/src/main/java/org/apache/
openjpa/jdbc/sql/OracleDictionary.java (original)
+++ openjpa/branches/1.0.x/openjpa-jdbc/src/main/java/org/apache/
openjpa/jdbc/sql/OracleDictionary.java Tue Feb 19 09:32:05 2008
@@ -155,6 +155,9 @@
"LONG", "MAXEXTENTS", "MINUS", "MODE", "NOAUDIT",
"NOCOMPRESS",
"NOWAIT", "OFFLINE", "ONLINE", "PCTFREE", "ROW",
}));
+
+ selectWordSet.add("WITH");
+ selectWordSet.add("WITH");
}
public void endConfiguration() {
Modified: openjpa/branches/1.0.x/openjpa-project/src/doc/manual/
ref_guide_dbsetup.xml
URL:
http://svn.apache.org/viewvc/openjpa/branches/1.0.x/openjpa-project/src/doc/manual/ref_guide_dbsetup.xml?rev=629168&r1=629167&r2=629168&view=diff
=
=
=
=
=
=
=
=
=
=====================================================================
--- openjpa/branches/1.0.x/openjpa-project/src/doc/manual/
ref_guide_dbsetup.xml (original)
+++ openjpa/branches/1.0.x/openjpa-project/src/doc/manual/
ref_guide_dbsetup.xml Tue Feb 19 09:32:05 2008
@@ -1009,6 +1009,22 @@
this database, beyond the standard SQL92 keywords.
</para>
</listitem>
+ <listitem id="DBDictionary.SelectWords">
+ <para>
+ <indexterm>
+ <primary>
+ SQL
+ </primary>
+ <secondary>
+ SelectWords
+ </secondary>
+ </indexterm>
+<literal>SelectWords</literal>: A comma-separated list of keywords
which may be
+used to start a SELECT statement for this database. If an
application executes
+a native SQL statement which begins with SelectWords OpenJPA will
treat the
+statement as a SELECT statement rather than an UPDATE statement.
+ </para>
+ </listitem>
<listitem id="DBDictionary.SystemTables">
<para>
<indexterm>