Menu
▾
▴
jboss-cvs-commits
|
From: Alexey L. <lou...@us...> - 2003-08-26 03:32:39
|
User: loubyansky
Date: 03/08/24 11:06:37
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
added count function mapping
Revision Changes Path
No revision
No revision
1.39.2.24 +95 -1 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.23
retrieving revision 1.39.2.24
diff -u -r1.39.2.23 -r1.39.2.24
--- standardjbosscmp-jdbc.xml 25 Jun 2003 19:50:02 -0000 1.39.2.23
+++ standardjbosscmp-jdbc.xml 24 Aug 2003 18:06:37 -0000 1.39.2.24
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.23 2003/06/25 19:50:02 starksm Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.24 2003/08/24 18:06:37 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -88,6 +88,10 @@
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
<!-- change from bit to integer , 10.12.2002 heb -->
<mapping>
@@ -187,6 +191,11 @@
<true-mapping>TRUE</true-mapping>
<false-mapping>FALSE</false-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
@@ -269,6 +278,11 @@
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
@@ -349,6 +363,11 @@
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
@@ -428,6 +447,11 @@
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
@@ -546,6 +570,10 @@
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -672,6 +700,10 @@
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -806,6 +838,10 @@
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -904,6 +940,11 @@
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
@@ -1019,6 +1060,10 @@
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -1142,6 +1187,10 @@
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -1265,6 +1314,10 @@
<function-name>ucase</function-name>
<function-sql>ucase(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
@@ -1364,6 +1417,10 @@
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Character</java-type>
@@ -1429,6 +1486,11 @@
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
@@ -1536,6 +1598,10 @@
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Float</java-type>
@@ -1671,6 +1737,10 @@
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
@@ -1798,6 +1868,10 @@
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
@@ -1906,6 +1980,11 @@
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
@@ -1987,6 +2066,11 @@
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
@@ -2066,6 +2150,11 @@
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
<mapping>
<java-type>java.math.BigDecimal</java-type>
<jdbc-type>LONGVARCHAR</jdbc-type>
@@ -2150,6 +2239,11 @@
<subquery-supported>true</subquery-supported>
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
+
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Character</java-type>
|
|
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>
|
|
From: Christian R. <lq...@us...> - 2003-09-09 13:02:26
|
User: lqd
Date: 03/09/09 06:02:18
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
- remove spurious '>' sign
Revision Changes Path
No revision
No revision
1.39.2.26 +2 -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.25
retrieving revision 1.39.2.26
diff -u -r1.39.2.25 -r1.39.2.26
--- standardjbosscmp-jdbc.xml 8 Sep 2003 14:20:58 -0000 1.39.2.25
+++ standardjbosscmp-jdbc.xml 9 Sep 2003 13:02:18 -0000 1.39.2.26
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.25 2003/09/08 14:20:58 pilhuhn Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.26 2003/09/09 13:02:18 lqd Exp $ -->
<jbosscmp-jdbc>
@@ -2431,7 +2431,7 @@
<word>from</word>
<word>view</word>
<word>trigger</word>
- <word>commit></word>
+ <word>commit</word>
<word>rollback</word>
<word>drop</word>
<word>grant</word>
|
|
From: Heiko W.R. <pi...@us...> - 2003-09-11 13:54:41
|
User: pilhuhn
Date: 03/09/11 06:54:38
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Pullup list of reserved words in DTD and standardjboss-jdbc.xml from
Branch_3_2. Changes in Java classes were already pulled up by Bill Burke.
See ChangeNotes-802557
Revision Changes Path
1.61 +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.60
retrieving revision 1.61
diff -u -r1.60 -r1.61
--- standardjbosscmp-jdbc.xml 27 Aug 2003 04:31:54 -0000 1.60
+++ standardjbosscmp-jdbc.xml 11 Sep 2003 13:54:38 -0000 1.61
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.60 2003/08/27 04:31:54 patriot1burke Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.61 2003/09/11 13:54:38 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>
|
|
From: Alexey L. <lou...@us...> - 2003-10-05 14:23:50
|
User: loubyansky
Date: 03/10/05 07:23:48
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Removed ADD INDEX from FK constraint template for mySQL. It does not work for compound keys.
Revision Changes Path
No revision
No revision
1.39.2.27 +3 -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.26
retrieving revision 1.39.2.27
diff -u -r1.39.2.26 -r1.39.2.27
--- standardjbosscmp-jdbc.xml 9 Sep 2003 13:02:18 -0000 1.39.2.26
+++ standardjbosscmp-jdbc.xml 5 Oct 2003 14:23:47 -0000 1.39.2.27
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.26 2003/09/09 13:02:18 lqd Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.27 2003/10/05 14:23:47 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1559,7 +1559,8 @@
<name>mySQL</name>
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
- <fk-constraint-template>ALTER TABLE ?1 ADD INDEX ind_?3 (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
+ <!-- does not work for compound keys <fk-constraint-template>ALTER TABLE ?1 ADD INDEX ind_?3 (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template> -->
+ <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1 auto_increment</auto-increment-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
|
|
From: Scott M S. <st...@us...> - 2003-10-22 06:39:05
|
User: starksm
Date: 03/10/21 18:40:48
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Add FirstSQL/J type mappings
Revision Changes Path
No revision
No revision
1.39.2.28 +129 -3 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.27
retrieving revision 1.39.2.28
diff -u -r1.39.2.27 -r1.39.2.28
--- standardjbosscmp-jdbc.xml 5 Oct 2003 14:23:47 -0000 1.39.2.27
+++ standardjbosscmp-jdbc.xml 22 Oct 2003 01:40:47 -0000 1.39.2.28
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.27 2003/10/05 14:23:47 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.28 2003/10/22 01:40:47 starksm Exp $ -->
<jbosscmp-jdbc>
@@ -40,12 +40,138 @@
</unknown-pk>
<entity-command name="default"/>
-
-
</defaults>
<type-mappings>
+ <type-mapping>
+ <name>FirstSQL/J</name>
+ <row-locking-template/>
+ <pk-constraint-template>PRIMARY KEY (?1)</pk-constraint-template>
+ <fk-constraint-template>FOREIGN KEY (?1) REFERENCES ?2 (?3)</fk-constraint-template>
+ <alias-header-prefix>t</alias-header-prefix>
+ <alias-header-suffix>_</alias-header-suffix>
+ <alias-max-length>32</alias-max-length>
+ <subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
+ <function-mapping>
+ <function-name>concat</function-name>
+ <function-sql>(?1 || ?2)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>substring</function-name>
+ <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>lcase</function-name>
+ <function-sql>lower(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>length</function-name>
+ <function-sql>char_length(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>locate</function-name>
+ <function-sql>position(?1 IN ?2)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>abs</function-name>
+ <function-sql>math.abs(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>sqrt</function-name>
+ <function-sql>math.sqrt(CAST(?1 AS DOUBLE))</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>ucase</function-name>
+ <function-sql>upper(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>TINYINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>TINYINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Short</java-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Integer</java-type>
+ <jdbc-type>INTEGER</jdbc-type>
+ <sql-type>INTEGER</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>BIGINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>REAL</jdbc-type>
+ <sql-type>REAL</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>DOUBLE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Character</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <!-- or <sql-type>VARCHAR(2147483500)</sql-type> -->
+ <sql-type>VARCHAR(256)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Date</java-type>
+ <jdbc-type>DATE</jdbc-type>
+ <sql-type>DATE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Time</java-type>
+ <jdbc-type>TIME</jdbc-type>
+ <sql-type>TIME</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.util.Date</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>DECIMAL</jdbc-type>
+ <sql-type>DECIMAL</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <!-- FirstSQL/J only supports directly serializable objects for classes declared with CREATE CLASS -->
+ <jdbc-type>LONGVARBINARY</jdbc-type>
+ <sql-type>VARCHAR(2147483500)</sql-type>
+ </mapping>
+ </type-mapping>
+
<type-mapping>
<name>Ingres</name>
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
|
|
From: Scott M S. <st...@us...> - 2003-10-22 17:05:48
|
User: starksm
Date: 03/10/21 18:42:03
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Add FirstSQL/J type mappings
Revision Changes Path
1.62 +129 -1 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.61
retrieving revision 1.62
diff -u -r1.61 -r1.62
--- standardjbosscmp-jdbc.xml 11 Sep 2003 13:54:38 -0000 1.61
+++ standardjbosscmp-jdbc.xml 22 Oct 2003 01:42:03 -0000 1.62
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.61 2003/09/11 13:54:38 pilhuhn Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.62 2003/10/22 01:42:03 starksm Exp $ -->
<jbosscmp-jdbc>
@@ -46,6 +46,134 @@
</defaults>
<type-mappings>
+ <type-mapping>
+ <name>FirstSQL/J</name>
+ <row-locking-template/>
+ <pk-constraint-template>PRIMARY KEY (?1)</pk-constraint-template>
+ <fk-constraint-template>FOREIGN KEY (?1) REFERENCES ?2 (?3)</fk-constraint-template>
+ <alias-header-prefix>t</alias-header-prefix>
+ <alias-header-suffix>_</alias-header-suffix>
+ <alias-max-length>32</alias-max-length>
+ <subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
+ <function-mapping>
+ <function-name>concat</function-name>
+ <function-sql>(?1 || ?2)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>substring</function-name>
+ <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>lcase</function-name>
+ <function-sql>lower(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>length</function-name>
+ <function-sql>char_length(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>locate</function-name>
+ <function-sql>position(?1 IN ?2)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>abs</function-name>
+ <function-sql>math.abs(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>sqrt</function-name>
+ <function-sql>math.sqrt(CAST(?1 AS DOUBLE))</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>ucase</function-name>
+ <function-sql>upper(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>TINYINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>TINYINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Short</java-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Integer</java-type>
+ <jdbc-type>INTEGER</jdbc-type>
+ <sql-type>INTEGER</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>BIGINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>REAL</jdbc-type>
+ <sql-type>REAL</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>DOUBLE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Character</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <!-- or <sql-type>VARCHAR(2147483500)</sql-type> -->
+ <sql-type>VARCHAR(256)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Date</java-type>
+ <jdbc-type>DATE</jdbc-type>
+ <sql-type>DATE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Time</java-type>
+ <jdbc-type>TIME</jdbc-type>
+ <sql-type>TIME</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.util.Date</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>DECIMAL</jdbc-type>
+ <sql-type>DECIMAL</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <!-- FirstSQL/J only supports directly serializable objects for classes declared with CREATE CLASS -->
+ <jdbc-type>LONGVARBINARY</jdbc-type>
+ <sql-type>VARCHAR(2147483500)</sql-type>
+ </mapping>
+ </type-mapping>
+
<type-mapping>
<name>Ingres</name>
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
|
|
From: Bill B. <pat...@us...> - 2003-10-25 08:23:39
|
User: patriot1burke
Date: 03/10/23 23:28:27
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
add an order by when doing a FOR UPDATE with an on-find to order calls to avoid deadlock
* added a new switch <check-exists-on-insert> to jbosscmp-jdbc.xml. This switch tells Entity creation
whether to do an exists SQL query before insertion. Setting to false will not do the SQL exists call.
This reduces SQL calls, so thus is a decent performance improvement
Revision Changes Path
No revision
No revision
1.39.2.29 +2 -1 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.28
retrieving revision 1.39.2.29
diff -u -r1.39.2.28 -r1.39.2.29
--- standardjbosscmp-jdbc.xml 22 Oct 2003 01:40:47 -0000 1.39.2.28
+++ standardjbosscmp-jdbc.xml 24 Oct 2003 06:28:27 -0000 1.39.2.29
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.28 2003/10/22 01:40:47 starksm Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.29 2003/10/24 06:28:27 patriot1burke Exp $ -->
<jbosscmp-jdbc>
@@ -22,6 +22,7 @@
<read-only>false</read-only>
<read-time-out>300000</read-time-out>
<row-locking>false</row-locking>
+ <check-exists-on-insert>true</check-exists-on-insert>
<pk-constraint>true</pk-constraint>
<fk-constraint>false</fk-constraint>
<preferred-relation-mapping>foreign-key</preferred-relation-mapping>
|
|
From: Adrian B. <ej...@us...> - 2003-10-26 15:52:03
|
User: ejort
Date: 03/10/26 07:49:42
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Add example mimer sql from fre...@up...
Revision Changes Path
1.63 +92 -1 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.62
retrieving revision 1.63
diff -u -r1.62 -r1.63
--- standardjbosscmp-jdbc.xml 22 Oct 2003 01:42:03 -0000 1.62
+++ standardjbosscmp-jdbc.xml 26 Oct 2003 15:49:42 -0000 1.63
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.62 2003/10/22 01:42:03 starksm Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.63 2003/10/26 15:49:42 ejort Exp $ -->
<jbosscmp-jdbc>
@@ -2465,6 +2465,97 @@
<sql-type>BYTE</sql-type>
</mapping>
</type-mapping>
+
+ <type-mapping>
+ <name>Mimer SQL</name>
+ <row-locking-template/>
+ <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
+ <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
+ <alias-header-prefix>t</alias-header-prefix>
+ <alias-header-suffix>_</alias-header-suffix>
+ <alias-max-length>32</alias-max-length>
+ <subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Short</java-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Integer</java-type>
+ <jdbc-type>INTEGER</jdbc-type>
+ <sql-type>INTEGER</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>BIGINT</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>REAL</jdbc-type>
+ <sql-type>REAL</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>DOUBLE PRECISION</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Character</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(5000)</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.sql.Date</java-type>
+ <jdbc-type>DATE</jdbc-type>
+ <sql-type>DATE</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.sql.Time</java-type>
+ <jdbc-type>TIME</jdbc-type>
+ <sql-type>TIME</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <sql-type>VARBINARY(5000)</sql-type>
+ </mapping>
+ </type-mapping>
</type-mappings>
|
|
From: Adrian B. <ej...@us...> - 2003-10-26 17:38:06
|
User: ejort
Date: 03/10/26 07:47:19
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Add example mimer sql from fre...@up...
Revision Changes Path
No revision
No revision
1.39.2.30 +91 -1 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.29
retrieving revision 1.39.2.30
diff -u -r1.39.2.29 -r1.39.2.30
--- standardjbosscmp-jdbc.xml 24 Oct 2003 06:28:27 -0000 1.39.2.29
+++ standardjbosscmp-jdbc.xml 26 Oct 2003 15:47:19 -0000 1.39.2.30
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.29 2003/10/24 06:28:27 patriot1burke Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.30 2003/10/26 15:47:19 ejort Exp $ -->
<jbosscmp-jdbc>
@@ -2466,6 +2466,96 @@
</mapping>
</type-mapping>
+ <type-mapping>
+ <name>Mimer SQL</name>
+ <row-locking-template/>
+ <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
+ <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
+ <alias-header-prefix>t</alias-header-prefix>
+ <alias-header-suffix>_</alias-header-suffix>
+ <alias-max-length>32</alias-max-length>
+ <subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Short</java-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Integer</java-type>
+ <jdbc-type>INTEGER</jdbc-type>
+ <sql-type>INTEGER</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>BIGINT</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>REAL</jdbc-type>
+ <sql-type>REAL</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>DOUBLE PRECISION</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Character</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(5000)</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.sql.Date</java-type>
+ <jdbc-type>DATE</jdbc-type>
+ <sql-type>DATE</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.sql.Time</java-type>
+ <jdbc-type>TIME</jdbc-type>
+ <sql-type>TIME</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <sql-type>VARBINARY(5000)</sql-type>
+ </mapping>
+ </type-mapping>
</type-mappings>
<entity-commands>
|
|
From: Alexey L. <lou...@us...> - 2003-10-28 12:04:16
|
User: loubyansky
Date: 03/10/28 04:03:38
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
rolled back check-exists-on-insert
Revision Changes Path
No revision
No revision
1.39.2.31 +1 -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.30
retrieving revision 1.39.2.31
diff -u -r1.39.2.30 -r1.39.2.31
--- standardjbosscmp-jdbc.xml 26 Oct 2003 15:47:19 -0000 1.39.2.30
+++ standardjbosscmp-jdbc.xml 28 Oct 2003 12:03:37 -0000 1.39.2.31
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.30 2003/10/26 15:47:19 ejort Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.31 2003/10/28 12:03:37 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -22,7 +22,6 @@
<read-only>false</read-only>
<read-time-out>300000</read-time-out>
<row-locking>false</row-locking>
- <check-exists-on-insert>true</check-exists-on-insert>
<pk-constraint>true</pk-constraint>
<fk-constraint>false</fk-constraint>
<preferred-relation-mapping>foreign-key</preferred-relation-mapping>
|
|
From: Heiko W.R. <pi...@us...> - 2003-11-12 12:23:40
|
User: pilhuhn
Date: 03/11/12 04:23:22
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Add a comment wrt SapDB 7.3. Closes Patches-678045
Revision Changes Path
No revision
No revision
1.39.2.32 +3 -1 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.31
retrieving revision 1.39.2.32
diff -u -r1.39.2.31 -r1.39.2.32
--- standardjbosscmp-jdbc.xml 28 Oct 2003 12:03:37 -0000 1.39.2.31
+++ standardjbosscmp-jdbc.xml 12 Nov 2003 12:23:21 -0000 1.39.2.32
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.31 2003/10/28 12:03:37 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.32 2003/11/12 12:23:21 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -2185,6 +2185,8 @@
<type-mapping>
<name>SapDB</name>
+ <!-- SapDB 7.3 might require '... UPDATE OF ?1' in the row-locking-template -->
+ <!-- as is works with SapDB 7.4 -->
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD FOREIGN KEY ?2 (?3) REFERENCES ?4 (?5)</fk-constraint-template>
|
|
From: Heiko W.R. <pi...@us...> - 2003-11-12 12:27:38
|
User: pilhuhn
Date: 03/11/12 04:27:17
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Add a comment wrt SapDB 7.3. Closes Patches-678045
Revision Changes Path
1.64 +3 -1 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.63
retrieving revision 1.64
diff -u -r1.63 -r1.64
--- standardjbosscmp-jdbc.xml 26 Oct 2003 15:49:42 -0000 1.63
+++ standardjbosscmp-jdbc.xml 12 Nov 2003 12:27:17 -0000 1.64
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.63 2003/10/26 15:49:42 ejort Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.64 2003/11/12 12:27:17 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -2186,6 +2186,8 @@
<type-mapping>
<name>SapDB</name>
+ <!-- SapDB 7.3 might require '... UPDATE OF ?1' in the row-locking-template -->
+ <!-- as is works with SapDB 7.4 -->
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD FOREIGN KEY ?2 (?3) REFERENCES ?4 (?5)</fk-constraint-template>
|
|
From: Heiko W.R. <pi...@us...> - 2003-11-12 18:23:09
|
User: pilhuhn
Date: 03/11/12 10:23:07
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Length() function in sybase is calles char_length(). Fixes Bugs-716887.
Revision Changes Path
1.65 +6 -1 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.64
retrieving revision 1.65
diff -u -r1.64 -r1.65
--- standardjbosscmp-jdbc.xml 12 Nov 2003 12:27:17 -0000 1.64
+++ standardjbosscmp-jdbc.xml 12 Nov 2003 18:23:07 -0000 1.65
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.64 2003/11/12 12:27:17 pilhuhn Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.65 2003/11/12 18:23:07 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -1074,6 +1074,11 @@
<function-name>count</function-name>
<function-sql>count(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>length</function-name>
+ <function-sql>char_length(?1)</function-sql>
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
|
|
From: Heiko W.R. <pi...@us...> - 2003-11-12 18:24:33
|
User: pilhuhn
Date: 03/11/12 10:24:33
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Length() function in sybase is calles char_length(). Fixes Bugs-716887.
Revision Changes Path
No revision
No revision
1.39.2.33 +5 -1 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.32
retrieving revision 1.39.2.33
diff -u -r1.39.2.32 -r1.39.2.33
--- standardjbosscmp-jdbc.xml 12 Nov 2003 12:23:21 -0000 1.39.2.32
+++ standardjbosscmp-jdbc.xml 12 Nov 2003 18:24:32 -0000 1.39.2.33
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.32 2003/11/12 12:23:21 pilhuhn Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.33 2003/11/12 18:24:32 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -1071,6 +1071,10 @@
<function-mapping>
<function-name>count</function-name>
<function-sql>count(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>length</function-name>
+ <function-sql>char_length(?1)</function-sql>
</function-mapping>
<mapping>
|
|
From: Adrian B. <ej...@us...> - 2003-11-25 01:48:18
|
User: ejort
Date: 03/11/24 17:48:17
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Add an alternate String mapping for cloudscape (commented out). Resolves at least one problem reported in the forums. http://www.jboss.org/thread.jsp?forum=47&thread=41590
Revision Changes Path
No revision
No revision
1.39.2.34 +7 -1 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.33
retrieving revision 1.39.2.34
diff -u -r1.39.2.33 -r1.39.2.34
--- standardjbosscmp-jdbc.xml 12 Nov 2003 18:24:32 -0000 1.39.2.33
+++ standardjbosscmp-jdbc.xml 25 Nov 2003 01:48:16 -0000 1.39.2.34
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.33 2003/11/12 18:24:32 pilhuhn Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.34 2003/11/25 01:48:16 ejort Exp $ -->
<jbosscmp-jdbc>
@@ -2340,6 +2340,12 @@
<jdbc-type>LONGVARCHAR</jdbc-type>
<sql-type>LONG VARCHAR</sql-type>
</mapping>
+ <!-- NOTE: This alternative mapping has been suggested for cloudscape
+ <mapping>
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(256)</sql-type>
+ </mapping> -->
<mapping>
<java-type>java.sql.Date</java-type>
<jdbc-type>DATE</jdbc-type>
|
|
From: Heiko W.R. <pi...@us...> - 2003-12-08 16:32:21
|
User: pilhuhn
Date: 03/12/08 08:32:19
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Add some more reserved SQL words to the list of reserved words.
Revision Changes Path
No revision
No revision
1.39.2.35 +6 -1 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.34
retrieving revision 1.39.2.35
diff -u -r1.39.2.34 -r1.39.2.35
--- standardjbosscmp-jdbc.xml 25 Nov 2003 01:48:16 -0000 1.39.2.34
+++ standardjbosscmp-jdbc.xml 8 Dec 2003 16:32:18 -0000 1.39.2.35
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.34 2003/11/25 01:48:16 ejort Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.35 2003/12/08 16:32:18 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -2670,5 +2670,10 @@
<word>join</word>
<word>unique</word>
<word>primary</word>
+ <word>number</word>
+ <word>integer</word>
+ <word>varchar</word>
+ <word>char</word>
+ <word>user</word>
</reserved-words>
</jbosscmp-jdbc>
|
|
From: Heiko W.R. <pi...@us...> - 2003-12-08 16:33:47
|
User: pilhuhn
Date: 03/12/08 08:33:47
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Enter some entries to list of reserved sql words
Revision Changes Path
1.66 +6 -1 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.65
retrieving revision 1.66
diff -u -r1.65 -r1.66
--- standardjbosscmp-jdbc.xml 12 Nov 2003 18:23:07 -0000 1.65
+++ standardjbosscmp-jdbc.xml 8 Dec 2003 16:33:46 -0000 1.66
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.65 2003/11/12 18:23:07 pilhuhn Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.66 2003/12/08 16:33:46 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -2667,5 +2667,10 @@
<word>join</word>
<word>unique</word>
<word>primary</word>
+ <word>number</word>
+ <word>integer</word>
+ <word>varchar</word>
+ <word>char</word>
+ <word>user</word>
</reserved-words>
</jbosscmp-jdbc>
|
|
From: Alexey L. <lou...@us...> - 2003-12-12 18:57:17
|
User: loubyansky
Date: 03/12/12 10:57:15
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
updated row-locking-template's with ORDER BY parameter
Revision Changes Path
No revision
No revision
1.39.2.36 +15 -15 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.35
retrieving revision 1.39.2.36
diff -u -r1.39.2.35 -r1.39.2.36
--- standardjbosscmp-jdbc.xml 8 Dec 2003 16:32:18 -0000 1.39.2.35
+++ standardjbosscmp-jdbc.xml 12 Dec 2003 18:57:15 -0000 1.39.2.36
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.35 2003/12/08 16:32:18 pilhuhn Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.36 2003/12/12 18:57:15 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -174,7 +174,7 @@
<type-mapping>
<name>Ingres</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 PRIMARY KEY (?3)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -309,7 +309,7 @@
</type-mapping>
<type-mapping>
<name>McKoi</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -396,7 +396,7 @@
<!-- For use with the Firebirdsql jca-jdbc driver.
A version after Beta 1 is strongly recommended,
this may involve building from cvs -->
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -481,7 +481,7 @@
<type-mapping>
<name>InterBase</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -656,7 +656,7 @@
| Make sure that you have the Oracle 9i version of classes12.jar
| or you will suffer
-->
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -786,7 +786,7 @@
<type-mapping>
<name>Oracle8</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -924,7 +924,7 @@
<type-mapping>
<name>Oracle7</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -1149,7 +1149,7 @@
<type-mapping>
<name>PostgreSQL</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1</auto-increment-template>
@@ -1276,7 +1276,7 @@
<type-mapping>
<name>PostgreSQL 7.2</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1</auto-increment-template>
@@ -1687,7 +1687,7 @@
<type-mapping>
<name>mySQL</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<!-- does not work for compound keys <fk-constraint-template>ALTER TABLE ?1 ADD INDEX ind_?3 (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template> -->
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
@@ -1827,7 +1827,7 @@
<type-mapping>
<name>MS SQLSERVER</name>
- <row-locking-template>SELECT ?1 FROM ?2 with (updlock) WHERE ?3</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 with (updlock) WHERE ?3 ORDER BY ?4</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1 IDENTITY</auto-increment-template>
@@ -1958,7 +1958,7 @@
<type-mapping>
<name>MS SQLSERVER2000</name>
- <row-locking-template>SELECT ?1 FROM ?2 with (xlock) WHERE ?3</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 with (xlock) WHERE ?3 ORDER BY ?4</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1 IDENTITY</auto-increment-template>
@@ -2191,7 +2191,7 @@
<name>SapDB</name>
<!-- SapDB 7.3 might require '... UPDATE OF ?1' in the row-locking-template -->
<!-- as is works with SapDB 7.4 -->
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD FOREIGN KEY ?2 (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -2371,7 +2371,7 @@
<type-mapping>
<name>InformixDB</name>
- <row-locking-template>select ?1 from ?2 where ?3 for update</row-locking-template>
+ <row-locking-template>select ?1 from ?2 where ?3 order by ?4 for update</row-locking-template>
<pk-constraint-template>PRIMARY KEY (?2) CONSTRAINT ?1</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT FOREIGN KEY (?3) REFERENCES ?4 (?5) CONSTRAINT ?2</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
|
|
From: Alexey L. <lou...@us...> - 2003-12-20 20:22:22
|
User: loubyansky
Date: 03/12/20 12:22:21
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
ported left-join from Branch_3_2
Revision Changes Path
1.67 +28 -27 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.66
retrieving revision 1.67
diff -u -r1.66 -r1.67
--- standardjbosscmp-jdbc.xml 8 Dec 2003 16:33:46 -0000 1.66
+++ standardjbosscmp-jdbc.xml 20 Dec 2003 20:22:21 -0000 1.67
@@ -15,7 +15,7 @@
<defaults>
<datasource>java:/DefaultDS</datasource>
- <datasource-mapping>@default.type.mapping@</datasource-mapping>
+ <datasource-mapping>Hypersonic SQL</datasource-mapping>
<create-table>true</create-table>
<remove-table>false</remove-table>
@@ -40,9 +40,6 @@
</unknown-pk>
<entity-command name="default"/>
-
-
-
</defaults>
<type-mappings>
@@ -176,7 +173,7 @@
<type-mapping>
<name>Ingres</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 PRIMARY KEY (?3)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -311,7 +308,7 @@
</type-mapping>
<type-mapping>
<name>McKoi</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -398,7 +395,7 @@
<!-- For use with the Firebirdsql jca-jdbc driver.
A version after Beta 1 is strongly recommended,
this may involve building from cvs -->
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -483,7 +480,7 @@
<type-mapping>
<name>InterBase</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -658,7 +655,7 @@
| Make sure that you have the Oracle 9i version of classes12.jar
| or you will suffer
-->
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -788,7 +785,7 @@
<type-mapping>
<name>Oracle8</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -926,7 +923,7 @@
<type-mapping>
<name>Oracle7</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -1073,13 +1070,12 @@
<function-mapping>
<function-name>count</function-name>
<function-sql>count(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>char_length(?1)</function-sql>
</function-mapping>
-
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
@@ -1152,7 +1148,7 @@
<type-mapping>
<name>PostgreSQL</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1</auto-increment-template>
@@ -1279,7 +1275,7 @@
<type-mapping>
<name>PostgreSQL 7.2</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1</auto-increment-template>
@@ -1690,9 +1686,10 @@
<type-mapping>
<name>mySQL</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
- <fk-constraint-template>ALTER TABLE ?1 ADD INDEX ind_?3 (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
+ <!-- does not work for compound keys <fk-constraint-template>ALTER TABLE ?1 ADD INDEX ind_?3 (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template> -->
+ <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1 auto_increment</auto-increment-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
@@ -1829,7 +1826,7 @@
<type-mapping>
<name>MS SQLSERVER</name>
- <row-locking-template>SELECT ?1 FROM ?2 with (updlock) WHERE ?3</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 with (updlock) WHERE ?3 ORDER BY ?4</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1 IDENTITY</auto-increment-template>
@@ -1960,7 +1957,7 @@
<type-mapping>
<name>MS SQLSERVER2000</name>
- <row-locking-template>SELECT ?1 FROM ?2 with (xlock) WHERE ?3</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 with (xlock) WHERE ?3 ORDER BY ?4</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1 IDENTITY</auto-increment-template>
@@ -2192,8 +2189,8 @@
<type-mapping>
<name>SapDB</name>
<!-- SapDB 7.3 might require '... UPDATE OF ?1' in the row-locking-template -->
- <!-- as is works with SapDB 7.4 -->
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
+ <!-- as is works with SapDB 7.4 -->
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD FOREIGN KEY ?2 (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -2342,6 +2339,12 @@
<jdbc-type>LONGVARCHAR</jdbc-type>
<sql-type>LONG VARCHAR</sql-type>
</mapping>
+ <!-- NOTE: This alternative mapping has been suggested for cloudscape
+ <mapping>
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(256)</sql-type>
+ </mapping> -->
<mapping>
<java-type>java.sql.Date</java-type>
<jdbc-type>DATE</jdbc-type>
@@ -2364,10 +2367,9 @@
</mapping>
</type-mapping>
-
<type-mapping>
<name>InformixDB</name>
- <row-locking-template>select ?1 from ?2 where ?3 for update</row-locking-template>
+ <row-locking-template>select ?1 from ?2 where ?3 order by ?4 for update</row-locking-template>
<pk-constraint-template>PRIMARY KEY (?2) CONSTRAINT ?1</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT FOREIGN KEY (?3) REFERENCES ?4 (?5) CONSTRAINT ?2</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
@@ -2563,7 +2565,6 @@
<sql-type>VARBINARY(5000)</sql-type>
</mapping>
</type-mapping>
-
</type-mappings>
<entity-commands>
@@ -2657,7 +2658,7 @@
<word>from</word>
<word>view</word>
<word>trigger</word>
- <word>commit></word>
+ <word>commit</word>
<word>rollback</word>
<word>drop</word>
<word>grant</word>
@@ -2671,6 +2672,6 @@
<word>integer</word>
<word>varchar</word>
<word>char</word>
- <word>user</word>
+ <word>user</word>
</reserved-words>
</jbosscmp-jdbc>
|
|
From: Alexey L. <lou...@us...> - 2003-12-20 20:34:47
|
User: loubyansky
Date: 03/12/20 12:34:44
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
mistake... don't use hardcoded datasource-mapping
Revision Changes Path
1.68 +1 -1 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.67
retrieving revision 1.68
diff -u -r1.67 -r1.68
--- standardjbosscmp-jdbc.xml 20 Dec 2003 20:22:21 -0000 1.67
+++ standardjbosscmp-jdbc.xml 20 Dec 2003 20:34:44 -0000 1.68
@@ -15,7 +15,7 @@
<defaults>
<datasource>java:/DefaultDS</datasource>
- <datasource-mapping>Hypersonic SQL</datasource-mapping>
+ <datasource-mapping>@default.type.mapping@</datasource-mapping>
<create-table>true</create-table>
<remove-table>false</remove-table>
|
|
From: Adrian B. <ej...@us...> - 2003-12-31 15:41:28
|
User: ejort
Date: 03/12/31 07:41:26
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
The correct type for Short is SMALLINT. The new 9i driver no longer accepts NUMERIC
Revision Changes Path
No revision
No revision
1.39.2.37 +2 -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.36
retrieving revision 1.39.2.37
diff -u -r1.39.2.36 -r1.39.2.37
--- standardjbosscmp-jdbc.xml 12 Dec 2003 18:57:15 -0000 1.39.2.36
+++ standardjbosscmp-jdbc.xml 31 Dec 2003 15:41:26 -0000 1.39.2.37
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.36 2003/12/12 18:57:15 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.37 2003/12/31 15:41:26 ejort Exp $ -->
<jbosscmp-jdbc>
@@ -715,7 +715,7 @@
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
- <jdbc-type>NUMERIC</jdbc-type>
+ <jdbc-type>SMALLINT</jdbc-type>
<sql-type>NUMBER(5)</sql-type>
</mapping>
<mapping>
|
|
From: Adrian B. <ej...@us...> - 2003-12-31 15:42:40
|
User: ejort
Date: 03/12/31 07:42:39
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
The correct type for Short is SMALLINT
Revision Changes Path
1.69 +2 -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.68
retrieving revision 1.69
diff -u -r1.68 -r1.69
--- standardjbosscmp-jdbc.xml 20 Dec 2003 20:34:44 -0000 1.68
+++ standardjbosscmp-jdbc.xml 31 Dec 2003 15:42:39 -0000 1.69
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.68 2003/12/20 20:34:44 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.69 2003/12/31 15:42:39 ejort Exp $ -->
<jbosscmp-jdbc>
@@ -714,7 +714,7 @@
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
- <jdbc-type>NUMERIC</jdbc-type>
+ <jdbc-type>SMALLINT</jdbc-type>
<sql-type>NUMBER(5)</sql-type>
</mapping>
<mapping>
|
|
From: Heiko W.R. <pi...@us...> - 2004-01-12 15:37:32
|
User: pilhuhn
Date: 04/01/12 07:37:31
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
db2 complains about a bad parameter map when not casting the arguments.
When using blobs, db2 choked on jdbc-type JAVA_OBJECT.
Revision Changes Path
No revision
No revision
1.39.2.38 +15 -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.37
retrieving revision 1.39.2.38
diff -u -r1.39.2.37 -r1.39.2.38
--- standardjbosscmp-jdbc.xml 31 Dec 2003 15:41:26 -0000 1.39.2.37
+++ standardjbosscmp-jdbc.xml 12 Jan 2004 15:37:30 -0000 1.39.2.38
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.37 2003/12/31 15:41:26 ejort Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.38 2004/01/12 15:37:30 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -579,6 +579,11 @@
<function-name>count</function-name>
<function-sql>count(?1)</function-sql>
</function-mapping>
+ <function-mapping>
+ <function-name>locate</function-name>
+ <function-sql>locate(CAST(?1 as VARCHAR(254)),
+ CAST(?2 as VaRCHAR(254)),?3)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -643,13 +648,21 @@
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</mapping>
+ <!-- this one gives errors with DB2 V8.1
+ and at least the NET driver
<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>BLOB(2000)</sql-type>
</mapping>
+ -->
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>BLOB(2000)</sql-type>
+ </mapping>
</type-mapping>
-
+
<type-mapping>
<name>Oracle9i</name>
<!--
|
|
From: Heiko W.R. <pi...@us...> - 2004-01-12 15:42:42
|
User: pilhuhn
Date: 04/01/12 07:42:41
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
db2 complains about a bad parameter map when not casting the arguments.
When using blobs, db2 choked on jdbc-type JAVA_OBJECT.
Revision Changes Path
1.70 +15 -1 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.69
retrieving revision 1.70
diff -u -r1.69 -r1.70
--- standardjbosscmp-jdbc.xml 31 Dec 2003 15:42:39 -0000 1.69
+++ standardjbosscmp-jdbc.xml 12 Jan 2004 15:42:41 -0000 1.70
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.69 2003/12/31 15:42:39 ejort Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.70 2004/01/12 15:42:41 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -578,6 +578,12 @@
<function-name>count</function-name>
<function-sql>count(?1)</function-sql>
</function-mapping>
+
+ <function-mapping>
+ <function-name>locate</function-name>
+ <function-sql>locate(CAST(?1 as VARCHAR(254)),
+ CAST(?2 as VaRCHAR(254)),?3)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -642,11 +648,19 @@
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</mapping>
+ <!-- this one gives errors with DB2 V8.1
+ and at least the NET driver
<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>BLOB(2000)</sql-type>
</mapping>
+ -->
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>BLOB(2000)</sql-type>
+ </mapping>
</type-mapping>
<type-mapping>
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X