Menu
▾
▴
[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml
|
From: Heiko W.R. <pi...@us...> - 2003-09-09 01:13:07
|
User: pilhuhn
Date: 03/09/08 07:20:58
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Escape reserved words in table names by prepending an X.
This should fix bug 555070.
The list of reserved words is in standardjbosscmp-jdbc.xml and can
thus be changed by the user.
SQLUtil.java also included the fix from patches-793328
Revision Changes Path
No revision
No revision
1.39.2.25 +31 -2 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.39.2.24
retrieving revision 1.39.2.25
diff -u -r1.39.2.24 -r1.39.2.25
--- standardjbosscmp-jdbc.xml 24 Aug 2003 18:06:37 -0000 1.39.2.24
+++ standardjbosscmp-jdbc.xml 8 Sep 2003 14:20:58 -0000 1.39.2.25
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.24 2003/08/24 18:06:37 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.25 2003/09/08 14:20:58 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -40,7 +40,9 @@
</unknown-pk>
<entity-command name="default"/>
-
+
+
+
</defaults>
<type-mappings>
@@ -2413,4 +2415,31 @@
class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBC30GeneratedKeysCreateCommand"/>
</entity-commands>
+ <!-- reserved words that should not be used as table names -->
+ <!-- JBoss will escape them by prepending a 'X' -->
+ <reserved-words>
+ <word>create</word>
+ <word>table</word>
+ <word>alter</word>
+ <word>on</word>
+ <word>column</word>
+ <word>index</word>
+ <word>set</word>
+ <word>select</word>
+ <word>update</word>
+ <word>delete</word>
+ <word>from</word>
+ <word>view</word>
+ <word>trigger</word>
+ <word>commit></word>
+ <word>rollback</word>
+ <word>drop</word>
+ <word>grant</word>
+ <word>revoke</word>
+ <word>group</word>
+ <word>between</word>
+ <word>join</word>
+ <word>unique</word>
+ <word>primary</word>
+ </reserved-words>
</jbosscmp-jdbc>
|
