[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-04-19 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 02/04/19 08:25:08

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Changed oracle max-alias-length to 30.
  
  Revision  ChangesPath
  1.25  +4 -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.24
  retrieving revision 1.25
  diff -u -r1.24 -r1.25
  --- standardjbosscmp-jdbc.xml 18 Apr 2002 19:22:35 -  1.24
  +++ standardjbosscmp-jdbc.xml 19 Apr 2002 15:24:50 -  1.25
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.24 2002/04/18 19:22:35 dsundstrom Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.25 2002/04/19 15:24:50 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -198,7 +198,7 @@
fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
alias-header-prefixt/alias-header-prefix
alias-header-suffix_/alias-header-suffix
  - alias-max-length32/alias-max-length
  + alias-max-length30/alias-max-length
subquery-supportedtrue/subquery-supported
function-mapping
   function-nameconcat/function-name
  @@ -321,7 +321,7 @@
fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
alias-header-prefixt/alias-header-prefix
alias-header-suffix_/alias-header-suffix
  - alias-max-length32/alias-max-length
  + alias-max-length30/alias-max-length
subquery-supportedtrue/subquery-supported
function-mapping
   function-nameconcat/function-name
  @@ -448,7 +448,7 @@
fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
alias-header-prefixt/alias-header-prefix
alias-header-suffix_/alias-header-suffix
  - alias-max-length32/alias-max-length
  + alias-max-length30/alias-max-length
subquery-supportedtrue/subquery-supported
function-mapping
   function-nameconcat/function-name
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-04-18 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 02/04/18 12:22:37

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Fixed bug [ 543255 ] SOLID DB and CONSTRAINT
  
  Solid DB doesn't use constraint name.
  
  Revision  ChangesPath
  1.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
  retrieving revision 1.24
  diff -u -r1.23 -r1.24
  --- standardjbosscmp-jdbc.xml 14 Apr 2002 17:35:31 -  1.23
  +++ standardjbosscmp-jdbc.xml 18 Apr 2002 19:22:35 -  1.24
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.23 2002/04/14 17:35:31 dsundstrom Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.24 2002/04/18 19:22:35 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -930,7 +930,7 @@
 type-mapping
nameSOLID/name
row-locking-template/
  - pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY 
(?2)/pk-constraint-template
  + pk-constraint-templatePRIMARY KEY (?2)/pk-constraint-template
fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
alias-header-prefixt/alias-header-prefix
alias-header-suffix_/alias-header-suffix
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-04-14 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 02/04/14 08:53:03

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Added Oracle9i type mapping.
  
  Revision  ChangesPath
  1.22  +138 -7jboss/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.21
  retrieving revision 1.22
  diff -u -r1.21 -r1.22
  --- standardjbosscmp-jdbc.xml 9 Apr 2002 15:43:21 -   1.21
  +++ standardjbosscmp-jdbc.xml 14 Apr 2002 15:53:02 -  1.22
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.21 2002/04/09 15:43:21 dsundstrom Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.22 2002/04/14 15:53:02 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -188,6 +188,125 @@
 /type-mapping
   
 type-mapping
  + nameOracle9i/name
  + !--
  + | Make sure that you have the Oracle 9i version of classes12.jar
  + | or you will suffer 
  + --
  + row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE/row-locking-template
  + pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY 
(?2)/pk-constraint-template
  + fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
  + alias-header-prefixt/alias-header-prefix
  + alias-header-suffix_/alias-header-suffix
  + alias-max-length32/alias-max-length
  + subquery-supportedtrue/subquery-supported
  + function-mapping
  +function-nameconcat/function-name
  +function-sql(?1 || ?2)/function-sql
  + /function-mapping
  + function-mapping
  +function-namesubstring/function-name
  +function-sqlsubstr(?1, ?2, ?3)/function-sql
  + /function-mapping
  + function-mapping
  +function-namelength/function-name
  +function-sqllen(?1)/function-sql
  + /function-mapping
  + function-mapping
  +function-namelocate/function-name
  +function-sqlinstr(?1, ?2, ?3)/function-sql
  + /function-mapping
  + function-mapping
  +function-nameabs/function-name
  +function-sqlabs(?1)/function-sql
  + /function-mapping
  + function-mapping
  +function-namesqrt/function-name
  +function-sqlsqrt(?1)/function-sql
  + /function-mapping
  +
  + mapping
  +java-typejava.lang.Boolean/java-type
  +jdbc-typeBIT/jdbc-type
  +sql-typeNUMBER(1)/sql-type
  + /mapping
  + mapping
  +java-typejava.lang.Byte/java-type
  +jdbc-typeSMALLINT/jdbc-type
  +sql-typeNUMBER(3)/sql-type
  + /mapping
  + mapping
  +java-typejava.lang.Short/java-type
  +jdbc-typeNUMERIC/jdbc-type
  +sql-typeNUMBER(5)/sql-type
  + /mapping
  + mapping
  +java-typejava.lang.Integer/java-type
  +jdbc-typeINTEGER/jdbc-type
  +sql-typeNUMBER(10)/sql-type
  + /mapping
  + mapping
  +java-typejava.lang.Long/java-type
  +jdbc-typeBIGINT/jdbc-type
  +sql-typeNUMBER(19)/sql-type
  + /mapping
  + mapping
  +java-typejava.lang.Float/java-type
  +jdbc-typeREAL/jdbc-type
  +sql-typeNUMBER(38,7)/sql-type
  + /mapping
  + mapping
  +java-typejava.math.BigDecimal/java-type
  +jdbc-typeDECIMAL/jdbc-type
  +sql-typeNUMBER(38,15)/sql-type
  + /mapping
  + mapping
  +java-typejava.lang.Double/java-type
  +jdbc-typeDOUBLE/jdbc-type
  +sql-typeNUMBER(38,15)/sql-type
  + /mapping
  + mapping
  +java-typejava.lang.Character/java-type
  +jdbc-typeCHAR/jdbc-type
  +sql-typeCHAR/sql-type
  + /mapping
  + mapping
  +java-typejava.lang.String/java-type
  +jdbc-typeVARCHAR/jdbc-type
  +sql-typeVARCHAR2(255)/sql-type
  + /mapping
  + mapping
  +java-typejava.util.Date/java-type
  +jdbc-typeTIMESTAMP/jdbc-type
  +sql-typeTIMESTAMP(3)/sql-type
  + /mapping
  + mapping
  +java-typejava.sql.Date/java-type
  +jdbc-typeDATE/jdbc-type
  +sql-typeDATE/sql-type
  + /mapping
  + mapping
  +java-typejava.sql.Time/java-type
  +

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-04-14 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 02/04/14 10:35:31

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Added mappings for LCase and UCase functions.
  
  Revision  ChangesPath
  1.23  +65 -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.22
  retrieving revision 1.23
  diff -u -r1.22 -r1.23
  --- standardjbosscmp-jdbc.xml 14 Apr 2002 15:53:02 -  1.22
  +++ standardjbosscmp-jdbc.xml 14 Apr 2002 17:35:31 -  1.23
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.22 2002/04/14 15:53:02 dsundstrom Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.23 2002/04/14 17:35:31 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -209,6 +209,10 @@
   function-sqlsubstr(?1, ?2, ?3)/function-sql
/function-mapping
function-mapping
  +function-namelcase/function-name
  +function-sqllower(?1)/function-sql
  + /function-mapping
  + function-mapping
   function-namelength/function-name
   function-sqllen(?1)/function-sql
/function-mapping
  @@ -224,6 +228,10 @@
   function-namesqrt/function-name
   function-sqlsqrt(?1)/function-sql
/function-mapping
  + function-mapping
  +function-nameucase/function-name
  +function-sqlupper(?1)/function-sql
  + /function-mapping
   
mapping
   java-typejava.lang.Boolean/java-type
  @@ -324,6 +332,10 @@
   function-sqlsubstr(?1, ?2, ?3)/function-sql
/function-mapping
function-mapping
  +function-namelcase/function-name
  +function-sqllower(?1)/function-sql
  + /function-mapping
  + function-mapping
   function-namelength/function-name
   function-sqllen(?1)/function-sql
/function-mapping
  @@ -339,6 +351,10 @@
   function-namesqrt/function-name
   function-sqlsqrt(?1)/function-sql
/function-mapping
  + function-mapping
  +function-nameucase/function-name
  +function-sqlupper(?1)/function-sql
  + /function-mapping
   
mapping
   java-typejava.lang.Boolean/java-type
  @@ -443,6 +459,10 @@
   function-sqlsubstr(?1, ?2, ?3)/function-sql
/function-mapping
function-mapping
  +function-namelcase/function-name
  +function-sqllower(?1)/function-sql
  + /function-mapping
  + function-mapping
   function-namelength/function-name
   function-sqllen(?1)/function-sql
/function-mapping
  @@ -458,6 +478,10 @@
   function-namesqrt/function-name
   function-sqlsqrt(?1)/function-sql
/function-mapping
  + function-mapping
  +function-nameucase/function-name
  +function-sqlupper(?1)/function-sql
  + /function-mapping
   
mapping
   java-typejava.lang.Boolean/java-type
  @@ -636,6 +660,10 @@
   function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
/function-mapping
function-mapping
  +function-namelcase/function-name
  +function-sqllower(?1)/function-sql
  + /function-mapping
  + function-mapping
   function-namelength/function-name
   function-sqllength(?1)/function-sql
/function-mapping
  @@ -651,6 +679,10 @@
   function-namesqrt/function-name
   function-sqlsqrt(?1)/function-sql
/function-mapping
  + function-mapping
  +function-nameucase/function-name
  +function-sqlupper(?1)/function-sql
  + /function-mapping
   
mapping
   java-typejava.lang.Boolean/java-type
  @@ -748,6 +780,10 @@
   function-sqlSUBSTRING(?1, ?2, ?3)/function-sql
/function-mapping
function-mapping
  +function-namelcase/function-name
  +function-sqllcase(?1)/function-sql
  + /function-mapping
  + function-mapping
   function-namelength/function-name
   function-sqlLENGTH(?1)/function-sql
/function-mapping
  @@ -763,6 +799,10 @@
   function-namesqrt/function-name
   function-sqlSQRT(?1)/function-sql
/function-mapping
  +

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-04-09 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 02/04/09 08:43:27

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Fixed bug [ 541507 ] Wrong PostgreSQL function mapping for locate.
  
  Revision  ChangesPath
  1.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.20
  retrieving revision 1.21
  diff -u -r1.20 -r1.21
  --- standardjbosscmp-jdbc.xml 24 Mar 2002 21:44:33 -  1.20
  +++ standardjbosscmp-jdbc.xml 9 Apr 2002 15:43:21 -   1.21
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.20 2002/03/24 21:44:33 d_jencks Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.21 2002/04/09 15:43:21 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -510,7 +510,7 @@
/function-mapping
function-mapping
   function-namelocate/function-name
  -function-sql(position(?2 in substring(?1 from ?3))+?3)/function-sql
  +function-sql(coalesce(nullif(position(?1 in substring(?2 from ?3)), 
0) + ?3 -1, 0))  /function-sql
/function-mapping
function-mapping
   function-nameabs/function-name
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-02-26 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 02/02/26 22:46:48

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Changed mySQL java.util.Date jdbc-type to TIMESTAMP. Bug #518197.
  
  Revision  ChangesPath
  1.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.18
  retrieving revision 1.19
  diff -u -r1.18 -r1.19
  --- standardjbosscmp-jdbc.xml 27 Feb 2002 00:11:04 -  1.18
  +++ standardjbosscmp-jdbc.xml 27 Feb 2002 06:46:48 -  1.19
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.18 2002/02/27 00:11:04 dsundstrom Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.19 2002/02/27 06:46:48 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -918,7 +918,7 @@
/mapping
mapping
   java-typejava.util.Date/java-type
  -jdbc-typeDATE/jdbc-type
  +jdbc-typeTIMESTAMP/jdbc-type
   sql-typeDATETIME/sql-type
/mapping
mapping
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-02-12 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 02/02/12 07:12:13

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Added java.util.Data mapping for PostgreSQL
  
  Revision  ChangesPath
  1.16  +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.15
  retrieving revision 1.16
  diff -u -r1.15 -r1.16
  --- standardjbosscmp-jdbc.xml 1 Feb 2002 01:26:58 -   1.15
  +++ standardjbosscmp-jdbc.xml 12 Feb 2002 15:12:11 -  1.16
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.15 2002/02/01 01:26:58 dsundstrom Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.16 2002/02/12 15:12:11 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -531,6 +531,11 @@
java-typejava.lang.String/java-type
jdbc-typeVARCHAR/jdbc-type
sql-typeTEXT/sql-type
  +  /mapping
  +  mapping
  + java-typejava.util.Date/java-type
  + jdbc-typeTIMESTAMP/jdbc-type
  + sql-typeTIMESTAMP/sql-type
 /mapping
 mapping
java-typejava.sql.Date/java-type
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Re: [JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-02-12 Thread David Budworth 

Should we have this mapping for all DB's?

Whenever I rebuild JBoss, I have to go add java.util.Date mapping
myself back in.

-David


On Tue, 12 Feb 2002, Dain Sundstrom wrote:

   User: dsundstrom
   Date: 02/02/12 07:12:13
 
   Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
   Log:
   Added java.util.Data mapping for PostgreSQL
   
   Revision  ChangesPath
   1.16  +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.15
   retrieving revision 1.16
   diff -u -r1.15 -r1.16
   --- standardjbosscmp-jdbc.xml   1 Feb 2002 01:26:58 -   1.15
   +++ standardjbosscmp-jdbc.xml   12 Feb 2002 15:12:11 -  1.16
   @@ -7,7 +7,7 @@
!--   --
!-- = --

   -!-- $Id: standardjbosscmp-jdbc.xml,v 1.15 2002/02/01 01:26:58 dsundstrom Exp $ 
--
   +!-- $Id: standardjbosscmp-jdbc.xml,v 1.16 2002/02/12 15:12:11 dsundstrom Exp $ 
--

jbosscmp-jdbc
   
   @@ -531,6 +531,11 @@
   java-typejava.lang.String/java-type
   jdbc-typeVARCHAR/jdbc-type
   sql-typeTEXT/sql-type
   +/mapping
   +mapping
   +   java-typejava.util.Date/java-type
   +   jdbc-typeTIMESTAMP/jdbc-type
   +   sql-typeTIMESTAMP/sql-type
/mapping
mapping
   java-typejava.sql.Date/java-type
   
   
   
 
 ___
 Jboss-development mailing list
 [EMAIL PROTECTED]
 https://lists.sourceforge.net/lists/listinfo/jboss-development

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Re: [JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-02-12 Thread Dain Sundstrom 

Sure, feel free to add them.

-dain

David Budworth wrote:

 Should we have this mapping for all DB's?
 
 Whenever I rebuild JBoss, I have to go add java.util.Date mapping
 myself back in.
 
 -David
 
 
 On Tue, 12 Feb 2002, Dain Sundstrom wrote:
 
 
  User: dsundstrom
  Date: 02/02/12 07:12:13

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Added java.util.Data mapping for PostgreSQL
  
  Revision  ChangesPath
  1.16  +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.15
  retrieving revision 1.16
  diff -u -r1.15 -r1.16
  --- standardjbosscmp-jdbc.xml   1 Feb 2002 01:26:58 -   1.15
  +++ standardjbosscmp-jdbc.xml   12 Feb 2002 15:12:11 -  1.16
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.15 2002/02/01 01:26:58 dsundstrom Exp $ 
--
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.16 2002/02/12 15:12:11 dsundstrom Exp $ 
--
   
   jbosscmp-jdbc
  
  @@ -531,6 +531,11 @@
  java-typejava.lang.String/java-type
  jdbc-typeVARCHAR/jdbc-type
  sql-typeTEXT/sql-type
  +/mapping
  +mapping
  +   java-typejava.util.Date/java-type
  +   jdbc-typeTIMESTAMP/jdbc-type
  +   sql-typeTIMESTAMP/sql-type
   /mapping
   mapping
  java-typejava.sql.Date/java-type
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

 
 ___
 Jboss-development mailing list
 [EMAIL PROTECTED]
 https://lists.sourceforge.net/lists/listinfo/jboss-development
 



___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-02-12 Thread David Budworth 

  User: dbudworth
  Date: 02/02/12 16:29:40

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Added java.util.Date type mapping for Oracle7 and Oracle8
  
  Revision  ChangesPath
  1.17  +11 -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.16
  retrieving revision 1.17
  diff -u -r1.16 -r1.17
  --- standardjbosscmp-jdbc.xml 12 Feb 2002 15:12:11 -  1.16
  +++ standardjbosscmp-jdbc.xml 13 Feb 2002 00:29:40 -  1.17
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.16 2002/02/12 15:12:11 dsundstrom Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.17 2002/02/13 00:29:40 dbudworth Exp $ --
   
   jbosscmp-jdbc
  
  @@ -260,6 +260,11 @@
sql-typeVARCHAR2(255)/sql-type
 /mapping
 mapping
  + java-typejava.util.Date/java-type
  + jdbc-typeTIMESTAMP/jdbc-type
  + sql-typeTIMESTAMP/sql-type
  +  /mapping
  +  mapping
java-typejava.sql.Date/java-type
jdbc-typeDATE/jdbc-type
sql-typeDATE/sql-type
  @@ -357,6 +362,11 @@
java-typejava.lang.String/java-type
jdbc-typeVARCHAR/jdbc-type
sql-typeVARCHAR2(255)/sql-type
  +  /mapping
  +  mapping
  + java-typejava.util.Date/java-type
  + jdbc-typeTIMESTAMP/jdbc-type
  + sql-typeTIMESTAMP/sql-type
 /mapping
 mapping
java-typejava.sql.Date/java-type
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-01-31 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 02/01/31 17:26:58

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Changed type-mapping element in defaults to datasource-mapping as is
  required in the new dtd.
  
  Revision  ChangesPath
  1.15  +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.14
  retrieving revision 1.15
  diff -u -r1.14 -r1.15
  --- standardjbosscmp-jdbc.xml 2002/01/15 23:17:09 1.14
  +++ standardjbosscmp-jdbc.xml 2002/02/01 01:26:58 1.15
  @@ -7,13 +7,13 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.14 2002/01/15 23:17:09 dsundstrom Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.15 2002/02/01 01:26:58 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  defaults
 datasourcejava:/DefaultDS/datasource
  -  type-mappingHypersonic SQL/type-mapping
  +  datasource-mappingHypersonic SQL/datasource-mapping
 
 create-tabletrue/create-table
 remove-tablefalse/remove-table
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-01-15 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 02/01/15 15:17:09

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Updated to new read-ahead style.
  Changed postgres Boolean type to sql-type BOOLEAN and jdbc-type CHAR.
  
  Revision  ChangesPath
  1.14  +9 -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.13
  retrieving revision 1.14
  diff -u -r1.13 -r1.14
  --- standardjbosscmp-jdbc.xml 2002/01/04 22:39:46 1.13
  +++ standardjbosscmp-jdbc.xml 2002/01/15 23:17:09 1.14
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.13 2002/01/04 22:39:46 dsundstrom Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.14 2002/01/15 23:17:09 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -23,6 +23,12 @@
 fk-constraintfalse/fk-constraint
 row-lockingfalse/row-locking
 preferred-relation-mappingforeign-key/preferred-relation-mapping
  +  read-ahead
  + strategyon-load/strategy
  + page-size1000/page-size
  + eager-load-group*/eager-load-group
  +  /read-ahead
  +  list-cache-max1000/list-cache-max
  /defaults
  
  type-mappings
  @@ -483,8 +489,8 @@
 
 mapping
java-typejava.lang.Boolean/java-type
  - jdbc-typeTINYINT/jdbc-type
  - sql-typeINT2/sql-type
  +   jdbc-typeCHAR/jdbc-type
  +   sql-typeBOOLEAN/sql-type
 /mapping
 mapping
java-typejava.lang.Byte/java-type
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2002-01-04 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 02/01/04 14:39:47

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Added BigDecimal mapping for PostgreSQL.
  
  Revision  ChangesPath
  1.13  +7 -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.12
  retrieving revision 1.13
  diff -u -r1.12 -r1.13
  --- standardjbosscmp-jdbc.xml 2001/12/30 19:09:39 1.12
  +++ standardjbosscmp-jdbc.xml 2002/01/04 22:39:46 1.13
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.12 2001/12/30 19:09:39 dsundstrom Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.13 2002/01/04 22:39:46 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -542,11 +542,16 @@
sql-typeTIMESTAMP/sql-type
 /mapping
 mapping
  + java-typejava.math.BigDecimal/java-type
  + jdbc-typeNUMERIC/jdbc-type
  + sql-typeNUMERIC/sql-type
  +  /mapping
  +  mapping
java-typejava.lang.Object/java-type
jdbc-typeJAVA_OBJECT/jdbc-type
sql-typeOID/sql-type
 /mapping
  -  /type-mapping
  +   /type-mapping
   
 type-mapping
 nameHypersonic SQL/name
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2001-12-30 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 01/12/30 11:09:39

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Added pk-constraint-tempate elements and fk-constraint-template elements.
  This was just a guess at most templates, I'll wait for messages on which
  ones are wrong. :)
  
  Revision  ChangesPath
  1.12  +33 -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.11
  retrieving revision 1.12
  diff -u -r1.11 -r1.12
  --- standardjbosscmp-jdbc.xml 2001/12/05 05:04:19 1.11
  +++ standardjbosscmp-jdbc.xml 2001/12/30 19:09:39 1.12
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.11 2001/12/05 05:04:19 patriot1burke Exp $ 
--
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.12 2001/12/30 19:09:39 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -29,6 +29,8 @@
 type-mapping
 nameInterBase/name
 row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE/row-locking-template
  +pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template
  +fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
 mapping
java-typejava.lang.Boolean/java-type
jdbc-typeBIT/jdbc-type
  @@ -99,6 +101,8 @@
 type-mapping
 nameDB2/name
 row-locking-template/
  +pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template
  +fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
 mapping
java-typejava.lang.Boolean/java-type
jdbc-typeBIT/jdbc-type
  @@ -172,6 +176,8 @@
 type-mapping
 nameOracle8/name
 row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE/row-locking-template
  +pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template
  +fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
 function-mapping
function-nameconcat/function-name
function-sql(?1 || ?2)/function-sql
  @@ -274,6 +280,8 @@
 type-mapping
 nameOracle7/name
 row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE/row-locking-template
  +pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template
  +fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
 function-mapping
function-nameconcat/function-name
function-sql(?1 || ?2)/function-sql
  @@ -371,6 +379,8 @@
 type-mapping
 nameSybase/name
 row-locking-template/
  +pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template
  +fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
 mapping
java-typejava.lang.Boolean/java-type
jdbc-typeBIT/jdbc-type
  @@ -444,6 +454,8 @@
 type-mapping
 namePostgreSQL/name
 row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE/row-locking-template
  +pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template
  +fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
 function-mapping
function-nameconcat/function-name
function-sql(?1 || ?2)/function-sql
  @@ -539,6 +551,8 @@
 type-mapping
 nameHypersonic SQL/name
 row-locking-template/ 
  +pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template
  +fk-constraint-template/
 mapping
java-typejava.lang.Byte/java-type
jdbc-typeSMALLINT/jdbc-type
  @@ -604,6 +618,8 @@
 type-mapping
 namePointBase/name
 row-locking-template/
  +pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template
  +fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
 mapping
java-typejava.lang.Character/java-type
jdbc-typeCHAR/jdbc-type
  @@ -659,6 +675,8 @@
 type-mapping
 nameSOLID/name
 row-locking-template/
  +pk-constraint-templateCONSTRAINT ?1 PRIMARY KEY (?2)/pk-constraint-template
  +fk-constraint-templateALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)/fk-constraint-template
 mapping

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2001-12-04 Thread Bill Burke 

  User: patriot1burke
  Date: 01/12/04 21:04:19

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  renamed select-for-update to row-locking
  
  Also defined row-locking-template to every type-mapping since it is now required
  for every datastore type.
  
  Revision  ChangesPath
  1.11  +18 -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.10
  retrieving revision 1.11
  diff -u -r1.10 -r1.11
  --- standardjbosscmp-jdbc.xml 2001/12/01 21:57:41 1.10
  +++ standardjbosscmp-jdbc.xml 2001/12/05 05:04:19 1.11
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.10 2001/12/01 21:57:41 dsundstrom Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.11 2001/12/05 05:04:19 patriot1burke Exp $ 
--
   
   jbosscmp-jdbc
  
  @@ -21,13 +21,14 @@
 time-out300/time-out
 pk-constrainttrue/pk-constraint
 fk-constraintfalse/fk-constraint
  -  select-for-updatefalse/select-for-update
  +  row-lockingfalse/row-locking
 preferred-relation-mappingforeign-key/preferred-relation-mapping
  /defaults
  
  type-mappings
 type-mapping
 nameInterBase/name
  +  row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE/row-locking-template
 mapping
java-typejava.lang.Boolean/java-type
jdbc-typeBIT/jdbc-type
  @@ -97,6 +98,7 @@
   
 type-mapping
 nameDB2/name
  +  row-locking-template/
 mapping
java-typejava.lang.Boolean/java-type
jdbc-typeBIT/jdbc-type
  @@ -169,7 +171,7 @@
   
 type-mapping
 nameOracle8/name
  -
  +  row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE/row-locking-template
 function-mapping
function-nameconcat/function-name
function-sql(?1 || ?2)/function-sql
  @@ -271,7 +273,7 @@
   
 type-mapping
 nameOracle7/name
  -
  +  row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE/row-locking-template
 function-mapping
function-nameconcat/function-name
function-sql(?1 || ?2)/function-sql
  @@ -368,6 +370,7 @@
   
 type-mapping
 nameSybase/name
  +  row-locking-template/
 mapping
java-typejava.lang.Boolean/java-type
jdbc-typeBIT/jdbc-type
  @@ -440,6 +443,7 @@
   
 type-mapping
 namePostgreSQL/name
  +  row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE/row-locking-template
 function-mapping
function-nameconcat/function-name
function-sql(?1 || ?2)/function-sql
  @@ -534,7 +538,7 @@
   
 type-mapping
 nameHypersonic SQL/name
  -  
  +  row-locking-template/ 
 mapping
java-typejava.lang.Byte/java-type
jdbc-typeSMALLINT/jdbc-type
  @@ -599,6 +603,7 @@
   
 type-mapping
 namePointBase/name
  +  row-locking-template/
 mapping
java-typejava.lang.Character/java-type
jdbc-typeCHAR/jdbc-type
  @@ -653,6 +658,7 @@
   
 type-mapping
 nameSOLID/name
  +  row-locking-template/
 mapping
java-typejava.lang.Character/java-type
jdbc-typeCHAR/jdbc-type
  @@ -717,7 +723,7 @@
   
 type-mapping
 namemySQL/name
  -
  +  row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE/row-locking-template
 function-mapping
function-nameconcat/function-name
function-sqlconcat(?1, ?2)/function-sql
  @@ -817,6 +823,7 @@
   
 type-mapping
 nameMS SQLSERVER/name
  +  row-locking-templateSELECT ?1 FROM ?2 with (rowlock) WHERE 
?3/row-locking-template
 function-mapping
function-nameconcat/function-name
function-sql(?1 + ?2)/function-sql
  @@ -921,7 +928,7 @@
   
 type-mapping 
 nameMS SQLSERVER2000/name 
  -  
  +  row-locking-templateSELECT ?1 FROM ?2 with (rowlock) WHERE 
?3/row-locking-template
 function-mapping
function-nameconcat/function-name
function-sql(?1 + ?2)/function-sql
  @@ -1040,6 +1047,7 @@
 
 type-mapping
 nameDB2/400/name
  +  row-locking-template/
 mapping
java-typejava.lang.Character/java-type
jdbc-typeCHAR/jdbc-type
  @@ -,6 +1119,7 @@
   
 type-mapping
 nameSapDB/name
  +  row-locking-templateSELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE/row-locking-template
 mapping

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2001-12-01 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 01/12/01 13:57:41

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Added default value for fk-constraint.
  Default is false because hypersonic db does not support the ALTER TABLE
  statement.
  
  Revision  ChangesPath
  1.10  +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.9
  retrieving revision 1.10
  diff -u -r1.9 -r1.10
  --- standardjbosscmp-jdbc.xml 2001/11/27 00:15:30 1.9
  +++ standardjbosscmp-jdbc.xml 2001/12/01 21:57:41 1.10
  @@ -7,7 +7,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.9 2001/11/27 00:15:30 peter_f Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.10 2001/12/01 21:57:41 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -19,6 +19,8 @@
 remove-tablefalse/remove-table
 read-onlyfalse/read-only
 time-out300/time-out
  +  pk-constrainttrue/pk-constraint
  +  fk-constraintfalse/fk-constraint
 select-for-updatefalse/select-for-update
 preferred-relation-mappingforeign-key/preferred-relation-mapping
  /defaults
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2001-08-20 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 01/08/20 10:19:40

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Added locate function mapping for PostgreSQL.
  
  Revision  ChangesPath
  1.5   +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.4
  retrieving revision 1.5
  diff -u -r1.4 -r1.5
  --- standardjbosscmp-jdbc.xml 2001/08/19 22:52:15 1.4
  +++ standardjbosscmp-jdbc.xml 2001/08/20 17:19:40 1.5
  @@ -6,7 +6,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.4 2001/08/19 22:52:15 dsundstrom Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.5 2001/08/20 17:19:40 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -449,6 +449,10 @@
 function-mapping
function-namelength/function-name
function-sqllength(?1)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namelocate/function-name
  + function-sql(position(?2 in substring(?1 from ?3))+?3)/function-sql
 /function-mapping 
 function-mapping
function-nameabs/function-name
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2001-08-19 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 01/08/19 15:52:16

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Added function mappings for MS SQLServer, Oracle, MySql and PostgreSQL.
  
  Revision  ChangesPath
  1.4   +151 -1jboss/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.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- standardjbosscmp-jdbc.xml 2001/08/06 22:52:22 1.3
  +++ standardjbosscmp-jdbc.xml 2001/08/19 22:52:15 1.4
  @@ -6,7 +6,7 @@
   !--   --
   !-- = --
   
  -!-- $Id: standardjbosscmp-jdbc.xml,v 1.3 2001/08/06 22:52:22 user57 Exp $ --
  +!-- $Id: standardjbosscmp-jdbc.xml,v 1.4 2001/08/19 22:52:15 dsundstrom Exp $ --
   
   jbosscmp-jdbc
  
  @@ -167,6 +167,32 @@
   
 type-mapping
 nameOracle8/name
  +
  +  function-mapping
  + function-nameconcat/function-name
  + function-sql(?1 || ?2)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namesubstring/function-name
  + function-sqlsubstr(?1, ?2, ?3)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namelength/function-name
  + function-sqllen(?1)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namelocate/function-name
  + function-sqlinstr(?1, ?2, ?3)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-nameabs/function-name
  + function-sqlabs(?1)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namesqrt/function-name
  + function-sqlsqrt(?1)/function-sql
  +  /function-mapping 
  +
 mapping
java-typejava.lang.Boolean/java-type
jdbc-typeBIT/jdbc-type
  @@ -243,6 +269,32 @@
   
 type-mapping
 nameOracle7/name
  +
  +  function-mapping
  + function-nameconcat/function-name
  + function-sql(?1 || ?2)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namesubstring/function-name
  + function-sqlsubstr(?1, ?2, ?3)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namelength/function-name
  + function-sqllen(?1)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namelocate/function-name
  + function-sqlinstr(?1, ?2, ?3)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-nameabs/function-name
  + function-sqlabs(?1)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namesqrt/function-name
  + function-sqlsqrt(?1)/function-sql
  +  /function-mapping 
  +
 mapping
java-typejava.lang.Boolean/java-type
jdbc-typeBIT/jdbc-type
  @@ -386,6 +438,27 @@
   
 type-mapping
 namePostgreSQL/name
  +  function-mapping
  + function-nameconcat/function-name
  + function-sql(?1 || ?2)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namesubstring/function-name
  + function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namelength/function-name
  + function-sqllength(?1)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-nameabs/function-name
  + function-sqlabs(?1)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namesqrt/function-name
  + function-sqlsqrt(?1)/function-sql
  +  /function-mapping 
  +  
 mapping
java-typejava.lang.Boolean/java-type
jdbc-typeTINYINT/jdbc-type
  @@ -519,6 +592,7 @@
   
 type-mapping
 nameHypersonic SQL/name
  +  
 mapping
java-typejava.lang.Byte/java-type
jdbc-typeSMALLINT/jdbc-type
  @@ -701,6 +775,32 @@
   
 type-mapping
 namemySQL/name
  +
  +  function-mapping
  + function-nameconcat/function-name
  + function-sqlconcat(?1, ?2)/function-sql
  +  /function-mapping 
  +  function-mapping
  + function-namesubstring/function-name
  + function-sqlsubstring(?1 FROM ?2 FOR ?3)/function-sql
  +  /function-mapping 
  +  function-mapping

[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

2001-07-25 Thread Dain Sundstrom 

  User: dsundstrom
  Date: 01/07/25 20:21:05

  Modified:src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Changed default-entity to defaults.
  Moved declaration of datasource and type mapping to defaults to allow overridingof 
the datasource and type mapping on a per bean/relation level.
  
  Revision  ChangesPath
  1.2   +16 -15jboss/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.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- standardjbosscmp-jdbc.xml 2001/06/24 01:22:32 1.1
  +++ standardjbosscmp-jdbc.xml 2001/07/26 03:21:05 1.2
  @@ -1,18 +1,19 @@
   ?xml version=1.0 encoding=UTF-8?
  -jaws
  -datasourcejava:/DefaultDS/datasource
  -type-mappingHypersonic SQL/type-mapping
  -debugtrue/debug
  -
  -default-entity
  -   create-tabletrue/create-table
  -   remove-tablefalse/remove-table
  -   tuned-updatesfalse/tuned-updates
  -   read-onlyfalse/read-only
  -   time-out300/time-out
  -   select-for-updatefalse/select-for-update
  -/default-entity
  -
  +jbosscmp-jdbc
  + 
  + defaults
  + datasourcejava:/DefaultDS/datasource
  + type-mappingHypersonic SQL/type-mapping
  + debugtrue/debug
  + 
  + create-tabletrue/create-table
  + remove-tablefalse/remove-table
  + read-onlyfalse/read-only
  + time-out300/time-out
  + select-for-updatefalse/select-for-update
  + preferred-relation-mappingforeign-key/preferred-relation-mapping
  + /defaults
  + 
   type-mappings
   type-mapping
   nameInterBase/name
  @@ -1245,4 +1246,4 @@
 /type-mapping 
   
   /type-mappings
  -/jaws
  +/jbosscmp-jdbc
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development