Menu
▾
▴
jboss-cvs-commits
|
From: Alexey L. <lou...@us...> - 2002-12-18 07:32:14
|
User: loubyansky
Date: 02/12/17 23:32:14
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
fixed bug [638804] Invalid JDBC type mapping for MSSQL 2000
Revision Changes Path
No revision
No revision
1.23.2.24 +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.23.2.23
retrieving revision 1.23.2.24
diff -u -r1.23.2.23 -r1.23.2.24
--- standardjbosscmp-jdbc.xml 31 Oct 2002 23:40:16 -0000 1.23.2.23
+++ standardjbosscmp-jdbc.xml 18 Dec 2002 07:32:13 -0000 1.23.2.24
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.23 2002/10/31 23:40:16 scoy Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.24 2002/12/18 07:32:13 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1596,7 +1596,7 @@
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>LONGVARBINARY</jdbc-type>
<sql-type>IMAGE</sql-type>
</mapping>
|
|
From: Alexey L. <lou...@us...> - 2002-12-18 07:34:33
|
User: loubyansky
Date: 02/12/17 23:34:32
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
fixed bug [638804] Invalid JDBC type mapping for MSSQL 2000
Revision Changes Path
No revision
No revision
1.39.2.10 +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.9
retrieving revision 1.39.2.10
diff -u -r1.39.2.9 -r1.39.2.10
--- standardjbosscmp-jdbc.xml 31 Oct 2002 23:39:14 -0000 1.39.2.9
+++ standardjbosscmp-jdbc.xml 18 Dec 2002 07:34:32 -0000 1.39.2.10
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.9 2002/10/31 23:39:14 scoy Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.10 2002/12/18 07:34:32 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1690,7 +1690,7 @@
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>LONGVARBINARY</jdbc-type>
<sql-type>IMAGE</sql-type>
</mapping>
|
|
From: Alexey L. <lou...@us...> - 2002-12-18 07:36:39
|
User: loubyansky
Date: 02/12/17 23:36:38
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
fixed bug [638804] Invalid JDBC type mapping for MSSQL 2000
Revision Changes Path
1.53 +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.52
retrieving revision 1.53
diff -u -r1.52 -r1.53
--- standardjbosscmp-jdbc.xml 31 Oct 2002 23:38:01 -0000 1.52
+++ standardjbosscmp-jdbc.xml 18 Dec 2002 07:36:32 -0000 1.53
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.52 2002/10/31 23:38:01 scoy Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.53 2002/12/18 07:36:32 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1690,7 +1690,7 @@
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>LONGVARBINARY</jdbc-type>
<sql-type>IMAGE</sql-type>
</mapping>
|
|
From: Jeffrey W. <bin...@us...> - 2003-01-27 22:08:45
|
User: binaryfeed
Date: 03/01/27 14:08:44
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Fixing PointBase mappings.
Revision Changes Path
1.54 +13 -4 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.53
retrieving revision 1.54
diff -u -r1.53 -r1.54
--- standardjbosscmp-jdbc.xml 18 Dec 2002 07:36:32 -0000 1.53
+++ standardjbosscmp-jdbc.xml 27 Jan 2003 22:08:41 -0000 1.54
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.53 2002/12/18 07:36:32 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.54 2003/01/27 22:08:41 binaryfeed Exp $ -->
<jbosscmp-jdbc>
@@ -1217,8 +1217,17 @@
<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>
+ <true-mapping>TRUE</true-mapping>
+ <false-mapping>FALSE</false-mapping>
+
+ <function-mapping>
+ <function-name>lcase</function-name>
+ <function-sql>lower(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>ucase</function-name>
+ <function-sql>upper(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Character</java-type>
@@ -1247,7 +1256,7 @@
</mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
- <jdbc-type>BINARY</jdbc-type>
+ <jdbc-type>BIT</jdbc-type>
<sql-type>BOOLEAN</sql-type>
</mapping>
<mapping>
|
|
From: Jeffrey W. <bin...@us...> - 2003-01-27 22:09:03
|
User: binaryfeed
Date: 03/01/27 14:09:02
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Fixing PointBase mappings.
Revision Changes Path
No revision
No revision
1.39.2.11 +13 -4 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.10
retrieving revision 1.39.2.11
diff -u -r1.39.2.10 -r1.39.2.11
--- standardjbosscmp-jdbc.xml 18 Dec 2002 07:34:32 -0000 1.39.2.10
+++ standardjbosscmp-jdbc.xml 27 Jan 2003 22:08:58 -0000 1.39.2.11
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.10 2002/12/18 07:34:32 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.11 2003/01/27 22:08:58 binaryfeed Exp $ -->
<jbosscmp-jdbc>
@@ -1217,8 +1217,17 @@
<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>
+ <true-mapping>TRUE</true-mapping>
+ <false-mapping>FALSE</false-mapping>
+
+ <function-mapping>
+ <function-name>lcase</function-name>
+ <function-sql>lower(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>ucase</function-name>
+ <function-sql>upper(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Character</java-type>
@@ -1247,7 +1256,7 @@
</mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
- <jdbc-type>BINARY</jdbc-type>
+ <jdbc-type>BIT</jdbc-type>
<sql-type>BOOLEAN</sql-type>
</mapping>
<mapping>
|
|
From: Jeffrey W. <bin...@us...> - 2003-01-27 22:29:14
|
User: binaryfeed
Date: 03/01/27 14:29:14
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Fixing PointBase mappings.
Revision Changes Path
No revision
No revision
1.23.2.25 +13 -4 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.23.2.24
retrieving revision 1.23.2.25
diff -u -r1.23.2.24 -r1.23.2.25
--- standardjbosscmp-jdbc.xml 18 Dec 2002 07:32:13 -0000 1.23.2.24
+++ standardjbosscmp-jdbc.xml 27 Jan 2003 22:29:13 -0000 1.23.2.25
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.24 2002/12/18 07:32:13 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.25 2003/01/27 22:29:13 binaryfeed Exp $ -->
<jbosscmp-jdbc>
@@ -1124,8 +1124,17 @@
<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>
+ <true-mapping>TRUE</true-mapping>
+ <false-mapping>FALSE</false-mapping>
+
+ <function-mapping>
+ <function-name>lcase</function-name>
+ <function-sql>lower(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>ucase</function-name>
+ <function-sql>upper(?1)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Character</java-type>
@@ -1154,7 +1163,7 @@
</mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
- <jdbc-type>BINARY</jdbc-type>
+ <jdbc-type>BIT</jdbc-type>
<sql-type>BOOLEAN</sql-type>
</mapping>
<mapping>
|
|
From: Julien V. <coo...@us...> - 2003-03-02 10:39:43
|
User: cooperfbi
Date: 03/03/02 02:39:42
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
added informix and sybase JDBC create command implementations
Revision Changes Path
1.55 +13 -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.54
retrieving revision 1.55
diff -u -r1.54 -r1.55
--- standardjbosscmp-jdbc.xml 27 Jan 2003 22:08:41 -0000 1.54
+++ standardjbosscmp-jdbc.xml 2 Mar 2003 10:39:42 -0000 1.55
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.54 2003/01/27 22:08:41 binaryfeed Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.55 2003/03/02 10:39:42 cooperfbi Exp $ -->
<jbosscmp-jdbc>
@@ -2120,6 +2120,18 @@
<!-- this command requires auto-increment element for unknown-pk -->
<entity-command name="mysql-get-generated-keys"
class="org.jboss.ejb.plugins.cmp.jdbc.mysql.JDBCMySQLCreateCommand"/>
+
+ <!-- retrieves generated key of the record inserted into hsql db -->
+ <entity-command name="hsqldb-fetch-key"
+ class="org.jboss.ejb.plugins.cmp.jdbc.hsqldb.JDBCHsqldbCreateCommand"/>
+
+ <!-- retrieves generated key of the record inserted into sybase db -->
+ <entity-command name="sybase-fetch-key"
+ class="org.jboss.ejb.plugins.cmp.jdbc.sybase.JDBCSybaseCreateCommand"/>
+
+ <!-- retrieves serial value of the record inserted into informix db -->
+ <entity-command name="informix-serial"
+ class="org.jboss.ejb.plugins.cmp.jdbc.informix.JDBCInformixCreateCommand"/>
<!-- uses key generator to fetch the next key value -->
<entity-command name="key-generator"
|
|
From: Julien V. <coo...@us...> - 2003-03-02 13:43:34
|
User: cooperfbi
Date: 03/03/02 05:43:33
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
backported various vendor create commands to Branch_3_2
Revision Changes Path
No revision
No revision
1.39.2.12 +14 -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.11
retrieving revision 1.39.2.12
diff -u -r1.39.2.11 -r1.39.2.12
--- standardjbosscmp-jdbc.xml 27 Jan 2003 22:08:58 -0000 1.39.2.11
+++ standardjbosscmp-jdbc.xml 2 Mar 2003 13:43:33 -0000 1.39.2.12
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.11 2003/01/27 22:08:58 binaryfeed Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.12 2003/03/02 13:43:33 cooperfbi Exp $ -->
<jbosscmp-jdbc>
@@ -2121,6 +2121,18 @@
<entity-command name="mysql-get-generated-keys"
class="org.jboss.ejb.plugins.cmp.jdbc.mysql.JDBCMySQLCreateCommand"/>
+ <!-- retrieves generated key of the record inserted into hsql db -->
+ <entity-command name="hsqldb-fetch-key"
+ class="org.jboss.ejb.plugins.cmp.jdbc.hsqldb.JDBCHsqldbCreateCommand"/>
+
+ <!-- retrieves generated key of the record inserted into sybase db -->
+ <entity-command name="sybase-fetch-key"
+ class="org.jboss.ejb.plugins.cmp.jdbc.sybase.JDBCSybaseCreateCommand"/>
+
+ <!-- retrieves serial value of the record inserted into informix db -->
+ <entity-command name="informix-serial"
+ class="org.jboss.ejb.plugins.cmp.jdbc.informix.JDBCInformixCreateCommand"/>
+
<!-- uses key generator to fetch the next key value -->
<entity-command name="key-generator"
class="org.jboss.ejb.plugins.cmp.jdbc.JDBCKeyGeneratorCreateCommand">
@@ -2132,5 +2144,6 @@
class="org.jboss.ejb.plugins.cmp.jdbc.jdbc3.JDBCGetGeneratedKeysCreateCommand"/>
-->
</entity-commands>
+
</jbosscmp-jdbc>
|
|
From: Michael N. <mne...@us...> - 2003-03-19 16:43:29
|
User: mnewcomb
Date: 03/03/19 08:43:27
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
- since JBoss 4 now requires JDK 1.4, enabling the 'get-generated-keys' entity-command which relies on JDBC 3.0
Revision Changes Path
1.56 +1 -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.55
retrieving revision 1.56
diff -u -r1.55 -r1.56
--- standardjbosscmp-jdbc.xml 2 Mar 2003 10:39:42 -0000 1.55
+++ standardjbosscmp-jdbc.xml 19 Mar 2003 16:43:25 -0000 1.56
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.55 2003/03/02 10:39:42 cooperfbi Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.56 2003/03/19 16:43:25 mnewcomb Exp $ -->
<jbosscmp-jdbc>
@@ -2139,10 +2139,8 @@
<attribute name="key-generator-factory">UUIDKeyGeneratorFactory</attribute>
</entity-command>
-<!-- JDK1.4
<entity-command name="get-generated-keys"
class="org.jboss.ejb.plugins.cmp.jdbc.jdbc3.JDBCGetGeneratedKeysCreateCommand"/>
--->
</entity-commands>
</jbosscmp-jdbc>
|
|
From: Jeremy B. <jb...@us...> - 2003-04-27 21:36:33
|
User: jboynes
Date: 03/04/27 14:36:31
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Fix for 723908 CMP Performs Unnecessary Check - plus other related stuff :-)
Added a service MBean that can be used to classify SQLExceptions from the JDBC driver.
Implemented check based on standard SQLState for unique constraint violation
Modified JDBCCreate command to skip SELECT if an exception processor is defined
To avoid migration issues, this is <b>not</b> the default behaviour - exmaple configuration is contained in standardjbosscmp-jdbc.xml
Added test case for DuplicateKeyException
Cleaned up UUID and PkSql create commands
Added test cases for UUID and PkSql Key generation
Revision Changes Path
No revision
No revision
1.39.2.13 +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.12
retrieving revision 1.39.2.13
diff -u -r1.39.2.12 -r1.39.2.13
--- standardjbosscmp-jdbc.xml 2 Mar 2003 13:43:33 -0000 1.39.2.12
+++ standardjbosscmp-jdbc.xml 27 Apr 2003 21:36:31 -0000 1.39.2.13
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.12 2003/03/02 13:43:33 cooperfbi Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.13 2003/04/27 21:36:31 jboynes Exp $ -->
<jbosscmp-jdbc>
@@ -2110,6 +2110,12 @@
<!-- default command; doesn't support unknown-pk -->
<entity-command name="default"
class="org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand"/>
+
+ <!-- variation on default that skips select before insert -->
+ <entity-command name="no-select-before-insert"
+ class="org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand">
+ <attribute name="SQLExceptionProcessor">jboss.jdbc:service=SQLExceptionProcessor</attribute>
+ </entity-command>
<!-- fetches next key value with the specified sql statement -->
<entity-command name="pk-sql"
|
|
From: Sacha L. <sla...@us...> - 2003-05-03 11:02:58
|
User: slaboure
Date: 03/05/03 04:02:56
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Fix for bug 677196
Revision Changes Path
No revision
No revision
1.23.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.23.2.25
retrieving revision 1.23.2.26
diff -u -r1.23.2.25 -r1.23.2.26
--- standardjbosscmp-jdbc.xml 27 Jan 2003 22:29:13 -0000 1.23.2.25
+++ standardjbosscmp-jdbc.xml 3 May 2003 11:02:56 -0000 1.23.2.26
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.25 2003/01/27 22:29:13 binaryfeed Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.26 2003/05/03 11:02:56 slaboure Exp $ -->
<jbosscmp-jdbc>
@@ -1747,7 +1747,7 @@
<name>SapDB</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 CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-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>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
|
|
From: Sacha L. <sla...@us...> - 2003-05-03 11:03:41
|
User: slaboure
Date: 03/05/03 04:03:40
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Fix for bug 677196
Revision Changes Path
No revision
No revision
1.39.2.14 +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.13
retrieving revision 1.39.2.14
diff -u -r1.39.2.13 -r1.39.2.14
--- standardjbosscmp-jdbc.xml 27 Apr 2003 21:36:31 -0000 1.39.2.13
+++ standardjbosscmp-jdbc.xml 3 May 2003 11:03:40 -0000 1.39.2.14
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.13 2003/04/27 21:36:31 jboynes Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.14 2003/05/03 11:03:40 slaboure Exp $ -->
<jbosscmp-jdbc>
@@ -1841,7 +1841,7 @@
<name>SapDB</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 CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-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>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
|
|
From: Jeremy B. <jb...@us...> - 2003-05-06 17:32:13
|
User: jboynes
Date: 03/05/06 10:32:12
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Refactoring of CMP2 ejbCreate implementation
Simplified structure of per-database plugin modules to use common code
Eliminated bugs related to audit and optimistic locking with generated keys
Added tests for key generation methods supported by hsqldb
Revision Changes Path
No revision
No revision
1.39.2.15 +30 -12 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.14
retrieving revision 1.39.2.15
diff -u -r1.39.2.14 -r1.39.2.15
--- standardjbosscmp-jdbc.xml 3 May 2003 11:03:40 -0000 1.39.2.14
+++ standardjbosscmp-jdbc.xml 6 May 2003 17:32:11 -0000 1.39.2.15
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.14 2003/05/03 11:03:40 slaboure Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.15 2003/05/06 17:32:11 jboynes Exp $ -->
<jbosscmp-jdbc>
@@ -1090,6 +1090,7 @@
<row-locking-template/>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template/>
+ <auto-increment-template>?1 IDENTITY</auto-increment-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
@@ -1495,6 +1496,7 @@
<row-locking-template>SELECT ?1 FROM ?2 with (rowlock) WHERE ?3</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>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
@@ -1621,6 +1623,7 @@
<row-locking-template>SELECT ?1 FROM ?2 with (rowlock) WHERE ?3</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>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
@@ -2113,43 +2116,58 @@
<!-- variation on default that skips select before insert -->
<entity-command name="no-select-before-insert"
- class="org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand">
+ class="org.jboss.ejb.plugins.cmp.jdbc.JDBCInsertPKCreateCommand">
<attribute name="SQLExceptionProcessor">jboss.jdbc:service=SQLExceptionProcessor</attribute>
</entity-command>
<!-- fetches next key value with the specified sql statement -->
<entity-command name="pk-sql"
- class="org.jboss.ejb.plugins.cmp.jdbc.JDBCPkSqlCreateCommand">
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCPkSqlCreateCommand">
+ <!-- change to define SQL used to obtain key prior to insert -->
<attribute name="pk-sql">SELECT CURRENT_TIMESTAMP</attribute>
</entity-command>
<!-- this command requires auto-increment element for unknown-pk -->
<entity-command name="mysql-get-generated-keys"
- class="org.jboss.ejb.plugins.cmp.jdbc.mysql.JDBCMySQLCreateCommand"/>
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCMySQLCreateCommand"/>
<!-- retrieves generated key of the record inserted into hsql db -->
<entity-command name="hsqldb-fetch-key"
- class="org.jboss.ejb.plugins.cmp.jdbc.hsqldb.JDBCHsqldbCreateCommand"/>
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCHsqldbCreateCommand">
+ <!-- uncomment to change SQL statement used to obtain identity
+ <attribute name="pk-sql">CALL IDENTITY()</attribute>
+ -->
+ </entity-command>
<!-- retrieves generated key of the record inserted into sybase db -->
<entity-command name="sybase-fetch-key"
- class="org.jboss.ejb.plugins.cmp.jdbc.sybase.JDBCSybaseCreateCommand"/>
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCSybaseCreateCommand"/>
+
+ <!-- retrieves generated key of the record inserted into SQLServer db -->
+ <entity-command name="mssql-fetch-key"
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCSQLServerCreateCommand">
+ <!-- uncomment for versions prior to SQL Server 2000
+ <attribute name="pk-sql">SELECT @@IDENTITY</attribute>
+ -->
+ </entity-command>
<!-- retrieves serial value of the record inserted into informix db -->
<entity-command name="informix-serial"
- class="org.jboss.ejb.plugins.cmp.jdbc.informix.JDBCInformixCreateCommand"/>
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand">
+ <!-- uncomment to use with SERIAL8 column
+ <attribute name="method">getSerial8</attribute>
+ -->
+ </entity-command>
<!-- uses key generator to fetch the next key value -->
<entity-command name="key-generator"
- class="org.jboss.ejb.plugins.cmp.jdbc.JDBCKeyGeneratorCreateCommand">
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCKeyGeneratorCreateCommand">
<attribute name="key-generator-factory">UUIDKeyGeneratorFactory</attribute>
</entity-command>
-<!-- JDK1.4
+ <!-- uses JDBC 3.0 getGeneratedKeys() method -->
<entity-command name="get-generated-keys"
- class="org.jboss.ejb.plugins.cmp.jdbc.jdbc3.JDBCGetGeneratedKeysCreateCommand"/>
--->
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBC30GeneratedKeysCreateCommand"/>
</entity-commands>
-
</jbosscmp-jdbc>
|
|
From: Jeremy B. <jb...@us...> - 2003-05-07 05:43:45
|
User: jboynes
Date: 03/05/06 22:43:44
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Added a key generator for Oracle using a sequence with insert returning
Revision Changes Path
No revision
No revision
1.39.2.16 +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.15
retrieving revision 1.39.2.16
diff -u -r1.39.2.15 -r1.39.2.16
--- standardjbosscmp-jdbc.xml 6 May 2003 17:32:11 -0000 1.39.2.15
+++ standardjbosscmp-jdbc.xml 7 May 2003 05:43:44 -0000 1.39.2.16
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.15 2003/05/06 17:32:11 jboynes Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.16 2003/05/07 05:43:44 jboynes Exp $ -->
<jbosscmp-jdbc>
@@ -2130,6 +2130,12 @@
<!-- this command requires auto-increment element for unknown-pk -->
<entity-command name="mysql-get-generated-keys"
class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCMySQLCreateCommand"/>
+
+ <!-- this command requires the specified sequence to have been created -->
+ <entity-command name="oracle-sequence"
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand">
+ <attribute name="sequence">TEST_SEQUENCE</attribute>
+ </entity-command>
<!-- retrieves generated key of the record inserted into hsql db -->
<entity-command name="hsqldb-fetch-key"
|
|
From: Jeremy B. <jb...@us...> - 2003-05-10 18:07:54
|
User: jboynes
Date: 03/05/10 11:07:53
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Support for PostgreSQL serial columns with no driver dependencies
Simplified initialization
Revision Changes Path
No revision
No revision
1.39.2.17 +280 -270 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.16
retrieving revision 1.39.2.17
diff -u -r1.39.2.16 -r1.39.2.17
--- standardjbosscmp-jdbc.xml 7 May 2003 05:43:44 -0000 1.39.2.16
+++ standardjbosscmp-jdbc.xml 10 May 2003 18:07:52 -0000 1.39.2.17
@@ -7,14 +7,14 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.16 2003/05/07 05:43:44 jboynes Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.17 2003/05/10 18:07:52 jboynes Exp $ -->
<jbosscmp-jdbc>
-
+
<defaults>
<datasource>java:/DefaultDS</datasource>
<datasource-mapping>@default.type.mapping@</datasource-mapping>
-
+
<create-table>true</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
@@ -123,8 +123,8 @@
<type-mapping>
<name>Firebird</name>
- <!-- For use with the Firebirdsql jca-jdbc driver.
- A version after Beta 1 is strongly recommended,
+ <!-- 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>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
@@ -369,7 +369,7 @@
<name>Oracle9i</name>
<!--
| Make sure that you have the Oracle 9i version of classes12.jar
- | or you will suffer
+ | or you will suffer
-->
<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>
@@ -384,35 +384,35 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substr(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>instr(?2, ?1, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -510,35 +510,35 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substr(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>instr(?2, ?1, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -644,35 +644,35 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substr(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>instr(?2, ?1, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -846,6 +846,7 @@
<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 CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
+ <auto-increment-template>?1</auto-increment-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
@@ -856,36 +857,36 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>(CASE position(?1 in substring(?2 from ?3)) WHEN 0 THEN 0 ELSE position(?1 in substring(?2 from ?3)) + ?3 - 1 END)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
-
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>CHAR</jdbc-type>
@@ -968,6 +969,7 @@
<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 CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
+ <auto-increment-template>?1</auto-increment-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
@@ -978,36 +980,36 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>(CASE position(?1 in substring(?2 from ?3)) WHEN 0 THEN 0 ELSE position(?1 in substring(?2 from ?3)) + ?3 - 1 END)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
-
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>CHAR</jdbc-type>
@@ -1087,7 +1089,7 @@
<type-mapping>
<name>Hypersonic SQL</name>
- <row-locking-template/>
+ <row-locking-template/>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template/>
<auto-increment-template>?1 IDENTITY</auto-increment-template>
@@ -1101,35 +1103,35 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>SUBSTRING(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lcase(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>LENGTH(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>LOCATE(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>ABS(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>SQRT(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>ucase(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
@@ -1224,7 +1226,7 @@
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
@@ -1372,35 +1374,35 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>concat(?1, ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>locate(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<mapping>
<java-type>java.lang.Float</java-type>
@@ -1446,7 +1448,7 @@
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
<!--
- | This type is problematical because mysql does not have any
+ | This type is problematical because mysql does not have any
| date/time types that store milliseconds. You should avoid it.
-->
</mapping>
@@ -1507,36 +1509,36 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 + ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substring(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>len(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>charindex(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
-
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
@@ -1618,8 +1620,8 @@
</mapping>
</type-mapping>
- <type-mapping>
- <name>MS SQLSERVER2000</name>
+ <type-mapping>
+ <name>MS SQLSERVER2000</name>
<row-locking-template>SELECT ?1 FROM ?2 with (rowlock) WHERE ?3</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>
@@ -1634,131 +1636,131 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 + ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substring(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>len(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>charindex(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-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.Character</java-type>
- <jdbc-type>CHAR</jdbc-type>
- <sql-type>CHAR</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.Long</java-type>
- <jdbc-type>BIGINT</jdbc-type>
- <sql-type>BIGINT</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.math.BigDecimal</java-type>
- <jdbc-type>VARCHAR</jdbc-type>
- <sql-type>VARCHAR(256)</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.String</java-type>
- <jdbc-type>VARCHAR</jdbc-type>
- <sql-type>VARCHAR(256)</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.Object</java-type>
- <jdbc-type>LONGVARBINARY</jdbc-type>
- <sql-type>IMAGE</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.Byte</java-type>
- <jdbc-type>TINYINT</jdbc-type>
- <sql-type>TINYINT</sql-type>
- </mapping>
-
- <mapping>
+ </function-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.Character</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR</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.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>BIGINT</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(256)</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(256)</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>LONGVARBINARY</jdbc-type>
+ <sql-type>IMAGE</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>TINYINT</sql-type>
+ </mapping>
+
+ <mapping>
<!--
| Note that you lose granularity here
| Use a numeric type and store milliseconds if you really need it
-->
- <java-type>java.sql.Timestamp</java-type>
- <jdbc-type>TIMESTAMP</jdbc-type>
- <sql-type>DATETIME</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.sql.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATETIME</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.sql.Time</java-type>
- <jdbc-type>TIME</jdbc-type>
- <sql-type>DATETIME</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.util.Date</java-type>
- <jdbc-type>TIMESTAMP</jdbc-type>
- <sql-type>DATETIME</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.Boolean</java-type>
- <jdbc-type>BIT</jdbc-type>
- <sql-type>BIT</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>FLOAT</sql-type>
- </mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATETIME</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.sql.Date</java-type>
+ <jdbc-type>DATE</jdbc-type>
+ <sql-type>DATETIME</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.sql.Time</java-type>
+ <jdbc-type>TIME</jdbc-type>
+ <sql-type>DATETIME</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.util.Date</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATETIME</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>BIT</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>FLOAT</sql-type>
+ </mapping>
</type-mapping>
-
+
<type-mapping>
<name>DB2/400</name>
<row-locking-template/>
@@ -2003,9 +2005,9 @@
</mapping>
</type-mapping>
-
- <type-mapping>
- <name>InformixDB</name>
+
+ <type-mapping>
+ <name>InformixDB</name>
<row-locking-template>select ?1 from ?2 where ?3 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>
@@ -2016,96 +2018,96 @@
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
- <mapping>
- <java-type>java.lang.Character</java-type>
- <jdbc-type>CHAR</jdbc-type>
- <sql-type>CHAR(1)</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.String</java-type>
- <jdbc-type>VARCHAR</jdbc-type>
- <sql-type>VARCHAR(255,0)</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.math.BigDecimal</java-type>
- <jdbc-type>NUMERIC</jdbc-type>
- <sql-type>DECIMAL</sql-type>
- </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.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>NUMERIC(18,0)</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.Float</java-type>
- <jdbc-type>REAL</jdbc-type>
- <sql-type>FLOAT</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.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.util.Date</java-type>
- <jdbc-type>TIMESTAMP</jdbc-type>
- <sql-type>DATETIME YEAR TO FRACTION(3)</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>DATETIME YEAR TO FRACTION(3)</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>BYTE</sql-type>
- </mapping>
- </type-mapping>
+ <mapping>
+ <java-type>java.lang.Character</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR(1)</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(255,0)</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>NUMERIC</jdbc-type>
+ <sql-type>DECIMAL</sql-type>
+ </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.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>NUMERIC(18,0)</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>REAL</jdbc-type>
+ <sql-type>FLOAT</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.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.util.Date</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATETIME YEAR TO FRACTION(3)</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>DATETIME YEAR TO FRACTION(3)</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <sql-type>BYTE</sql-type>
+ </mapping>
+ </type-mapping>
</type-mappings>
@@ -2162,6 +2164,14 @@
class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand">
<!-- uncomment to use with SERIAL8 column
<attribute name="method">getSerial8</attribute>
+ -->
+ </entity-command>
+
+ <!-- retrieves the currval of the the sequence associated with a PostgreSQL SERIAL column -->
+ <entity-command name="postgresql-fetch-seq"
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCPostgreSQLCreateCommand">
+ <!-- uncomment to change the name of the sequence; default is ${table}_${pkColumn}_seq
+ <attribute name="sequence"></attribute>
-->
</entity-command>
|
|
From: Jeremy B. <jb...@us...> - 2003-05-22 21:22:23
|
User: jboynes
Date: 03/05/22 14:22:22
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Use right command when skipping select before insert
Revision Changes Path
No revision
No revision
1.39.2.18 +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.17
retrieving revision 1.39.2.18
diff -u -r1.39.2.17 -r1.39.2.18
--- standardjbosscmp-jdbc.xml 10 May 2003 18:07:52 -0000 1.39.2.17
+++ standardjbosscmp-jdbc.xml 22 May 2003 21:22:21 -0000 1.39.2.18
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.17 2003/05/10 18:07:52 jboynes Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.18 2003/05/22 21:22:21 jboynes Exp $ -->
<jbosscmp-jdbc>
@@ -2118,7 +2118,7 @@
<!-- variation on default that skips select before insert -->
<entity-command name="no-select-before-insert"
- class="org.jboss.ejb.plugins.cmp.jdbc.JDBCInsertPKCreateCommand">
+ class="org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand">
<attribute name="SQLExceptionProcessor">jboss.jdbc:service=SQLExceptionProcessor</attribute>
</entity-command>
|
|
From: Heiko W.R. <pi...@us...> - 2003-05-23 15:32:27
|
User: pilhuhn
Date: 03/05/23 08:32:24
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Add fk-constraint-template for hsqldb, as this db supports it.
Still the user needs to enable it in his entity settings.
Revision Changes Path
No revision
No revision
1.39.2.19 +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.18
retrieving revision 1.39.2.19
diff -u -r1.39.2.18 -r1.39.2.19
--- standardjbosscmp-jdbc.xml 22 May 2003 21:22:21 -0000 1.39.2.18
+++ standardjbosscmp-jdbc.xml 23 May 2003 15:32:23 -0000 1.39.2.19
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.18 2003/05/22 21:22:21 jboynes Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.19 2003/05/23 15:32:23 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -1091,7 +1091,7 @@
<name>Hypersonic SQL</name>
<row-locking-template/>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
- <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 IDENTITY</auto-increment-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
|
|
From: Dain S. <dsu...@us...> - 2003-06-08 01:58:37
|
User: dsundstrom
Date: 03/06/07 18:58:35
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Changed SQLServer 2000 rowlock template to use xlock instead of rowlock.
According to the SQL Server docs a rowlock only tells the lock manager to
use a rowlock instead of more corse grained page or table locks. This
does not result in an exclusive lock, just a normal shared lock. The
xlock flag results in a real exclusive lock, which is what we really
wanted.
Revision Changes Path
No revision
No revision
1.39.2.20 +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.19
retrieving revision 1.39.2.20
diff -u -r1.39.2.19 -r1.39.2.20
--- standardjbosscmp-jdbc.xml 23 May 2003 15:32:23 -0000 1.39.2.19
+++ standardjbosscmp-jdbc.xml 8 Jun 2003 01:58:35 -0000 1.39.2.20
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.19 2003/05/23 15:32:23 pilhuhn Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.20 2003/06/08 01:58:35 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -1622,7 +1622,7 @@
<type-mapping>
<name>MS SQLSERVER2000</name>
- <row-locking-template>SELECT ?1 FROM ?2 with (rowlock) WHERE ?3</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 with (xlock) WHERE ?3</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>
|
|
From: Dain S. <dsu...@us...> - 2003-06-08 02:02:04
|
User: dsundstrom
Date: 03/06/07 19:02:03
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Changed SQLServer 2000 rowlock template to use xlock instead of rowlock.
According to the SQL Server docs a rowlock only tells the lock manager to
use a rowlock instead of more corse grained page or table locks. This
does not result in an exclusive lock, just a normal shared lock. The xlock
flag results in a real exclusive lock, which is what we really wanted.
Revision Changes Path
No revision
No revision
1.23.2.27 +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.23.2.26
retrieving revision 1.23.2.27
diff -u -r1.23.2.26 -r1.23.2.27
--- standardjbosscmp-jdbc.xml 3 May 2003 11:02:56 -0000 1.23.2.26
+++ standardjbosscmp-jdbc.xml 8 Jun 2003 02:02:03 -0000 1.23.2.27
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.26 2003/05/03 11:02:56 slaboure Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.27 2003/06/08 02:02:03 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -1524,7 +1524,7 @@
<type-mapping>
<name>MS SQLSERVER2000</name>
- <row-locking-template>SELECT ?1 FROM ?2 with (rowlock) WHERE ?3</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 with (xlock) WHERE ?3</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>
|
|
From: Dain S. <dsu...@us...> - 2003-06-08 02:07:12
|
User: dsundstrom
Date: 03/06/07 19:07:11
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Changed SQLServer 2000 rowlock template to use xlock instead of rowlock.
According to the SQL Server docs a rowlock only tells the lock manager to
use a rowlock instead of more corse grained page or table locks. This
does not result in an exclusive lock, just a normal shared lock. The xlock
flag results in a real exclusive lock, which is what we really wanted.
Revision Changes Path
1.57 +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.56
retrieving revision 1.57
diff -u -r1.56 -r1.57
--- standardjbosscmp-jdbc.xml 19 Mar 2003 16:43:25 -0000 1.56
+++ standardjbosscmp-jdbc.xml 8 Jun 2003 02:07:11 -0000 1.57
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.56 2003/03/19 16:43:25 mnewcomb Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.57 2003/06/08 02:07:11 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -1618,7 +1618,7 @@
<type-mapping>
<name>MS SQLSERVER2000</name>
- <row-locking-template>SELECT ?1 FROM ?2 with (rowlock) WHERE ?3</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 with (xlock) WHERE ?3</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>
|
|
From: Dain S. <dsu...@us...> - 2003-06-08 19:01:46
|
User: dsundstrom
Date: 03/06/08 12:01:45
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Changed SQL Server 7 rowlock to updlock. The updlock flag is simmilar to
oracle for update, in that it is not an exclusive lock, but works as long
as all readers use updlock.
Revision Changes Path
1.58 +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.57
retrieving revision 1.58
diff -u -r1.57 -r1.58
--- standardjbosscmp-jdbc.xml 8 Jun 2003 02:07:11 -0000 1.57
+++ standardjbosscmp-jdbc.xml 8 Jun 2003 19:01:45 -0000 1.58
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.57 2003/06/08 02:07:11 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.58 2003/06/08 19:01:45 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -1492,7 +1492,7 @@
<type-mapping>
<name>MS SQLSERVER</name>
- <row-locking-template>SELECT ?1 FROM ?2 with (rowlock) WHERE ?3</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 with (updlock) WHERE ?3</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>
|
|
From: Dain S. <dsu...@us...> - 2003-06-08 19:02:34
|
User: dsundstrom
Date: 03/06/08 12:02:33
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Changed SQL Server 7 rowlock to updlock. The updlock flag is simmilar to
oracle for update, in that it is not an exclusive lock, but works as long
as all readers use updlock.
Revision Changes Path
No revision
No revision
1.39.2.21 +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.20
retrieving revision 1.39.2.21
diff -u -r1.39.2.20 -r1.39.2.21
--- standardjbosscmp-jdbc.xml 8 Jun 2003 01:58:35 -0000 1.39.2.20
+++ standardjbosscmp-jdbc.xml 8 Jun 2003 19:02:32 -0000 1.39.2.21
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.20 2003/06/08 01:58:35 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.21 2003/06/08 19:02:32 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -1495,7 +1495,7 @@
<type-mapping>
<name>MS SQLSERVER</name>
- <row-locking-template>SELECT ?1 FROM ?2 with (rowlock) WHERE ?3</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 with (updlock) WHERE ?3</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>
|
|
From: Dain S. <dsu...@us...> - 2003-06-08 19:04:06
|
User: dsundstrom
Date: 03/06/08 12:04:05
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Changed SQL Server 7 rowlock to updlock. The updlock flag is simmilar to
oracle for update, in that it is not an exclusive lock, but works as long
as all readers use updlock.
Revision Changes Path
No revision
No revision
1.23.2.28 +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.23.2.27
retrieving revision 1.23.2.28
diff -u -r1.23.2.27 -r1.23.2.28
--- standardjbosscmp-jdbc.xml 8 Jun 2003 02:02:03 -0000 1.23.2.27
+++ standardjbosscmp-jdbc.xml 8 Jun 2003 19:04:05 -0000 1.23.2.28
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.27 2003/06/08 02:02:03 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.28 2003/06/08 19:04:05 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -1398,7 +1398,7 @@
<type-mapping>
<name>MS SQLSERVER</name>
- <row-locking-template>SELECT ?1 FROM ?2 with (rowlock) WHERE ?3</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 with (updlock) WHERE ?3</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>
|
|
From: Scott M S. <st...@us...> - 2003-06-25 19:50:04
|
User: starksm
Date: 03/06/25 12:50:03
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Add the full doctype declaration and start to fix some of the errors.
Revision Changes Path
No revision
No revision
1.39.2.23 +9 -7 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.22
retrieving revision 1.39.2.23
diff -u -r1.39.2.22 -r1.39.2.23
--- standardjbosscmp-jdbc.xml 22 Jun 2003 22:00:26 -0000 1.39.2.22
+++ standardjbosscmp-jdbc.xml 25 Jun 2003 19:50:02 -0000 1.39.2.23
@@ -1,5 +1,7 @@
<?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE jbosscmp-jdbc>
+<!DOCTYPE jbosscmp-jdbc PUBLIC
+ "-//JBoss//DTD JBOSSCMP-JDBC 3.2//EN"
+ "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd">
<!-- ===================================================================== -->
<!-- -->
@@ -7,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.22 2003/06/22 22:00:26 patriot1burke Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.23 2003/06/25 19:50:02 starksm Exp $ -->
<jbosscmp-jdbc>
@@ -18,15 +20,15 @@
<create-table>true</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
- <time-out>300</time-out>
+ <read-time-out>300000</read-time-out>
+ <row-locking>false</row-locking>
<pk-constraint>true</pk-constraint>
<fk-constraint>false</fk-constraint>
- <row-locking>false</row-locking>
<preferred-relation-mapping>foreign-key</preferred-relation-mapping>
<read-ahead>
- <strategy>on-load</strategy>
- <page-size>1000</page-size>
- <eager-load-group>*</eager-load-group>
+ <strategy>on-load</strategy>
+ <page-size>1000</page-size>
+ <eager-load-group>*</eager-load-group>
</read-ahead>
<list-cache-max>1000</list-cache-max>
|
|
From: Alexey L. <lou...@us...> - 2003-06-26 15:50:32
|
User: loubyansky
Date: 03/06/26 08:50:31
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
changed time-out to read-time-out
Revision Changes Path
1.59 +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.58
retrieving revision 1.59
diff -u -r1.58 -r1.59
--- standardjbosscmp-jdbc.xml 8 Jun 2003 19:01:45 -0000 1.58
+++ standardjbosscmp-jdbc.xml 26 Jun 2003 15:50:31 -0000 1.59
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.58 2003/06/08 19:01:45 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.59 2003/06/26 15:50:31 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -18,7 +18,7 @@
<create-table>true</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
- <time-out>300</time-out>
+ <read-time-out>300000</read-time-out>
<pk-constraint>true</pk-constraint>
<fk-constraint>false</fk-constraint>
<row-locking>false</row-locking>
|
×
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