[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 @@
   
  -
  -java:/DefaultDS
  -Hypersonic SQL
  -true
  -
  -
  -   true
  -   false
  -   false
  -   false
  -   300
  -   false
  -
  -
  +
  + 
  + 
  + java:/DefaultDS
  + Hypersonic SQL
  + true
  + 
  + true
  + false
  + false
  + 300
  + false
  + foreign-key
  + 
  + 
   
   
   InterBase
  @@ -1245,4 +1246,4 @@
  
   
   
  -
  +
  
  
  

___
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 @@
   
   
   
  -
  +
   
   
  
  @@ -167,6 +167,32 @@
   
 
 Oracle8
  +
  +  
  + concat
  + (?1 || ?2)
  +   
  +  
  + substring
  + substr(?1, ?2, ?3)
  +   
  +  
  + length
  + len(?1)
  +   
  +  
  + locate
  + instr(?1, ?2, ?3)
  +   
  +  
  + abs
  + abs(?1)
  +   
  +  
  + sqrt
  + sqrt(?1)
  +   
  +
 
java.lang.Boolean
BIT
  @@ -243,6 +269,32 @@
   
 
 Oracle7
  +
  +  
  + concat
  + (?1 || ?2)
  +   
  +  
  + substring
  + substr(?1, ?2, ?3)
  +   
  +  
  + length
  + len(?1)
  +   
  +  
  + locate
  + instr(?1, ?2, ?3)
  +   
  +  
  + abs
  + abs(?1)
  +   
  +  
  + sqrt
  + sqrt(?1)
  +   
  +
 
java.lang.Boolean
BIT
  @@ -386,6 +438,27 @@
   
 
 PostgreSQL
  +  
  + concat
  + (?1 || ?2)
  +   
  +  
  + substring
  + substring(?1 FROM ?2 FOR ?3)
  +   
  +  
  + length
  + length(?1)
  +   
  +  
  + abs
  + abs(?1)
  +   
  +  
  + sqrt
  + sqrt(?1)
  +   
  +  
 
java.lang.Boolean
TINYINT
  @@ -519,6 +592,7 @@
   
 
 Hypersonic SQL
  +  
 
java.lang.Byte
SMALLINT
  @@ -701,6 +775,32 @@
   
 
 mySQL
  +
  +  
  + concat
  + concat(?1, ?2)
  +   
  +  
  + substring
  + substring(?1 FROM ?2 FOR ?3)
  +   
  +  
  + length
  + length(?1)
  +   
  +  
  + locate
  + locate(?1, ?2, ?3)
  +   
  +  
  + abs
  + abs(?1)
  +   
  +  
  + sqrt
  + sqrt(?1)
  +   
  +
 
java.lang.Float
FLOAT
  @@ -775,6 +875,31 @@
   
 
 MS SQLSERVER
  +  
  + concat
  + (?1 + ?2)
  +   
  +  
  + substring
  + substring(?1 FROM ?2 FOR ?3)
  +   
  +  
  + length
  + len(?1)
  +   
  +  
  + locate
  + charindex(?1, ?2, ?3)
  +   
  +  
  + abs
  + abs(?1)
  +   
  +  
  + sqrt
  + sqrt(?1)
  +   
  +  
 
java.lang.Integer
INTEGER
  @@ -854,6 +979,31 @@
   
  
 MS SQLSERVER2000 
  +  
  +  
  + concat
  + (?1 + ?2)
  +   
  +  
  + substring
  + substring(?1 FROM ?2 FOR ?3)
  +   
  +  
  + length
  + len(?1)
  +   
  +  
  + locate
  + charindex(?1, ?2, ?3)
  +   
  +  
  + abs
  + abs(?1)
  +   
  +  
  + sqrt
  + sqrt(?1)
  +   
 
  
java.lang.Integer 
  
  
  

___
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-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 @@
   
   
   
  -
  +
   
   
  
  @@ -449,6 +449,10 @@
 
length
length(?1)
  +   
  +  
  + locate
  + (position(?2 in substring(?1 from ?3))+?3)
  
 
abs
  
  
  

___
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-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 @@
   
   
   
  -
  +
   
   
  
  @@ -19,6 +19,8 @@
 false
 false
 300
  +  true
  +  false
 false
 foreign-key
  
  
  
  

___
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-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 @@
   
   
   
  -
  +
   
   
  
  @@ -21,13 +21,14 @@
 300
 true
 false
  -  false
  +  false
 foreign-key
  
  
  
 
 InterBase
  +  SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
 
java.lang.Boolean
BIT
  @@ -97,6 +98,7 @@
   
 
 DB2
  +  
 
java.lang.Boolean
BIT
  @@ -169,7 +171,7 @@
   
 
 Oracle8
  -
  +  SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
 
concat
(?1 || ?2)
  @@ -271,7 +273,7 @@
   
 
 Oracle7
  -
  +  SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
 
concat
(?1 || ?2)
  @@ -368,6 +370,7 @@
   
 
 Sybase
  +  
 
java.lang.Boolean
BIT
  @@ -440,6 +443,7 @@
   
 
 PostgreSQL
  +  SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
 
concat
(?1 || ?2)
  @@ -534,7 +538,7 @@
   
 
 Hypersonic SQL
  -  
  +   
 
java.lang.Byte
SMALLINT
  @@ -599,6 +603,7 @@
   
 
 PointBase
  +  
 
java.lang.Character
CHAR
  @@ -653,6 +658,7 @@
   
 
 SOLID
  +  
 
java.lang.Character
CHAR
  @@ -717,7 +723,7 @@
   
 
 mySQL
  -
  +  SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
 
concat
concat(?1, ?2)
  @@ -817,6 +823,7 @@
   
 
 MS SQLSERVER
  +  SELECT ?1 FROM ?2 with (rowlock) WHERE 
?3
 
concat
(?1 + ?2)
  @@ -921,7 +928,7 @@
   
  
 MS SQLSERVER2000 
  -  
  +  SELECT ?1 FROM ?2 with (rowlock) WHERE 
?3
 
concat
(?1 + ?2)
  @@ -1040,6 +1047,7 @@
 
 
 DB2/400
  +  
 
java.lang.Character
CHAR
  @@ -,6 +1119,7 @@
   
 
 SapDB
  +  SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
 
java.lang.Integer
INTEGER
  @@ -1180,6 +1189,7 @@
   
 
 Cloudscape
  +  
 
java.math.BigDecimal
LONGVARCHAR
  @@ -1255,6 +1265,7 @@
 
  
 InformixDB 
  +  
  
java.lang.Character 
CHAR 
  
  
  

___
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 @@
   
   
   
  -
  +
   
   
  
  @@ -918,7 +918,7 @@


   java.util.Date
  -DATE
  +TIMESTAMP
   DATETIME


  
  
  

___
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-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 @@
   
   
   
  -
  +
   
   
  
  @@ -510,7 +510,7 @@


   locate
  -(position(?2 in substring(?1 from ?3))+?3)
  +(coalesce(nullif(position(?1 in substring(?2 from ?3)), 
0) + ?3 -1, 0))  


   abs
  
  
  

___
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 @@
   
   
   
  -
  +
   
   
  
  @@ -188,6 +188,125 @@
 
   
 
  + Oracle9i
  + 
  + SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
  + CONSTRAINT ?1 PRIMARY KEY 
(?2)
  + ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
  + t
  + _
  + 32
  + true
  + 
  +concat
  +(?1 || ?2)
  + 
  + 
  +substring
  +substr(?1, ?2, ?3)
  + 
  + 
  +length
  +len(?1)
  + 
  + 
  +locate
  +instr(?1, ?2, ?3)
  + 
  + 
  +abs
  +abs(?1)
  + 
  + 
  +sqrt
  +sqrt(?1)
  + 
  +
  + 
  +java.lang.Boolean
  +BIT
  +NUMBER(1)
  + 
  + 
  +java.lang.Byte
  +SMALLINT
  +NUMBER(3)
  + 
  + 
  +java.lang.Short
  +NUMERIC
  +NUMBER(5)
  + 
  + 
  +java.lang.Integer
  +INTEGER
  +NUMBER(10)
  + 
  + 
  +java.lang.Long
  +BIGINT
  +NUMBER(19)
  + 
  + 
  +java.lang.Float
  +REAL
  +NUMBER(38,7)
  + 
  + 
  +java.math.BigDecimal
  +DECIMAL
  +NUMBER(38,15)
  + 
  + 
  +java.lang.Double
  +DOUBLE
  +NUMBER(38,15)
  + 
  + 
  +java.lang.Character
  +CHAR
  +CHAR
  + 
  + 
  +java.lang.String
  +VARCHAR
  +VARCHAR2(255)
  + 
  + 
  +java.util.Date
  +TIMESTAMP
  +TIMESTAMP(3)
  + 
  + 
  +java.sql.Date
  +DATE
  +DATE
  + 
  + 
  +java.sql.Time
  +TIME
  +DATE
  + 
  + 
  +java.sql.Timestamp
  +TIMESTAMP
  +TIMESTAMP(9)
  + 
  + 
  +java.lang.Object
  +JAVA_OBJECT
  +BLOB
  +
  + 
  +  
  +
  +  
Oracle8
SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
CONSTRAINT ?1 PRIMARY KEY 
(?2)
  @@ -272,9 +391,13 @@
   VARCHAR2(255)


  +
   java.util.Date
   TIMESTAMP
  -TIMESTAMP
  +DATE


   java.sql.Date
  @@ -295,8 +418,10 @@
   java.lang.Object
   JAVA_OBJECT
   BLOB
  -   
  +

 
   
  @@ -380,9 +505,13 @@
   VARCHAR2(255)


  +
   java.util.Date
   TIMESTAMP
  -TIMESTAMP
  +DATE


   java.sql.Date
  @@ -403,8 +532,10 @@
   java.lang.Object
   JAVA_OBJECT
   LONG RAW
  -   
  +

 
   
  
  
  

___
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 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 @@
   
   
   
  -
  +
   
   
  
  @@ -209,6 +209,10 @@
   substr(?1, ?2, ?3)


  +lcase
  +lower(?1)
  + 
  + 
   length
   len(?1)

  @@ -224,6 +228,10 @@
   sqrt
   sqrt(?1)

  + 
  +ucase
  +upper(?1)
  + 
   

   java.lang.Boolean
  @@ -324,6 +332,10 @@
   substr(?1, ?2, ?3)


  +lcase
  +lower(?1)
  + 
  + 
   length
   len(?1)

  @@ -339,6 +351,10 @@
   sqrt
   sqrt(?1)

  + 
  +ucase
  +upper(?1)
  + 
   

   java.lang.Boolean
  @@ -443,6 +459,10 @@
   substr(?1, ?2, ?3)


  +lcase
  +lower(?1)
  + 
  + 
   length
   len(?1)

  @@ -458,6 +478,10 @@
   sqrt
   sqrt(?1)

  + 
  +ucase
  +upper(?1)
  + 
   

   java.lang.Boolean
  @@ -636,6 +660,10 @@
   substring(?1 FROM ?2 FOR ?3)


  +lcase
  +lower(?1)
  + 
  + 
   length
   length(?1)

  @@ -651,6 +679,10 @@
   sqrt
   sqrt(?1)

  + 
  +ucase
  +upper(?1)
  + 
   

   java.lang.Boolean
  @@ -748,6 +780,10 @@
   SUBSTRING(?1, ?2, ?3)


  +lcase
  +lcase(?1)
  + 
  + 
   length
   LENGTH(?1)

  @@ -763,6 +799,10 @@
   sqrt
   SQRT(?1)

  + 
  +ucase
  +ucase(?1)
  + 
   

   java.lang.Byte
  @@ -976,6 +1016,10 @@
   substring(?1 FROM ?2 FOR ?3)


  +lcase
  +lower(?1)
  + 
  + 
   length
   length(?1)

  @@ -991,6 +1035,10 @@
   sqrt
   sqrt(?1)

  + 
  +ucase
  +upper(?1)
  + 
   

   java.lang.Float
  @@ -1082,6 +1130,10 @@
   substring(?1 FROM ?2 FOR ?3)


  +lcase
  +lower(?1)
  + 
  + 
   length
   len(?1)

  @@ -1097,6 +1149,10 @@
   sqrt
   sqrt(?1)

  + 
  +ucase
  +upper(?1)
  + 
   

   java.lang.Integer
  @@ -1193,6 +1249,10 @@
   substring(?1 FROM ?2 FOR ?3)


  +lcase
  +lower(?1)
  + 
  + 
   length
   len(?1)

  @@ -1207,6 +1267,10 @@

   sqrt
   sqrt(?1)
  + 
  + 
  +ucase
  +upper(?1)

   
 
  
  
  

___
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:31:15

  Modified:src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
  Log:
  Fixed bug [ 543255 ] SOLID DB and CONSTRAINT
  
  Solid DB doesn't use constraint name.
  
  Revision  ChangesPath
  No   revision
  
  
  No   revision
  
  
  1.23.2.1  +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.23.2.1
  diff -u -r1.23 -r1.23.2.1
  --- standardjbosscmp-jdbc.xml 14 Apr 2002 17:35:31 -  1.23
  +++ standardjbosscmp-jdbc.xml 18 Apr 2002 19:31:14 -  1.23.2.1
  @@ -930,7 +930,7 @@
 
SOLID

  - CONSTRAINT ?1 PRIMARY KEY 
(?2)
  + PRIMARY KEY (?2)
ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
t
_
  
  
  

___
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 @@
   
   
   
  -
  +
   
   
  
  @@ -930,7 +930,7 @@
 
SOLID

  - CONSTRAINT ?1 PRIMARY KEY 
(?2)
  + PRIMARY KEY (?2)
ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
t
_
  
  
  

___
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-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 @@
   
   
   
  -
  +
   
   
  
  @@ -198,7 +198,7 @@
ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
t
_
  - 32
  + 30
true

   concat
  @@ -321,7 +321,7 @@
ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
t
_
  - 32
  + 30
true

   concat
  @@ -448,7 +448,7 @@
ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
t
_
  - 32
  + 30
true

   concat
  
  
  

___
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-19 Thread Dain Sundstrom

  User: dsundstrom
  Date: 02/04/19 08:27:15

  Modified:src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
  Log:
  Changed oracle max-alias-length to 30.
  
  Revision  ChangesPath
  No   revision
  
  
  No   revision
  
  
  1.23.2.2  +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.23.2.1
  retrieving revision 1.23.2.2
  diff -u -r1.23.2.1 -r1.23.2.2
  --- standardjbosscmp-jdbc.xml 18 Apr 2002 19:31:14 -  1.23.2.1
  +++ standardjbosscmp-jdbc.xml 19 Apr 2002 15:27:15 -  1.23.2.2
  @@ -198,7 +198,7 @@
ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
t
_
  - 32
  + 30
true

   concat
  @@ -321,7 +321,7 @@
ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
t
_
  - 32
  + 30
true

   concat
  @@ -448,7 +448,7 @@
ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
t
_
  - 32
  + 30
true

   concat
  
  
  

___
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 @@
   
   
   
  -
  +
   
   
  
  @@ -29,6 +29,8 @@
 
 InterBase
 SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
java.lang.Boolean
BIT
  @@ -99,6 +101,8 @@
 
 DB2
 
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
java.lang.Boolean
BIT
  @@ -172,6 +176,8 @@
 
 Oracle8
 SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
concat
(?1 || ?2)
  @@ -274,6 +280,8 @@
 
 Oracle7
 SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
concat
(?1 || ?2)
  @@ -371,6 +379,8 @@
 
 Sybase
 
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
java.lang.Boolean
BIT
  @@ -444,6 +454,8 @@
 
 PostgreSQL
 SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
concat
(?1 || ?2)
  @@ -539,6 +551,8 @@
 
 Hypersonic SQL
  
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +
 
java.lang.Byte
SMALLINT
  @@ -604,6 +618,8 @@
 
 PointBase
 
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
java.lang.Character
CHAR
  @@ -659,6 +675,8 @@
 
 SOLID
 
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
java.lang.Character
CHAR
  @@ -724,6 +742,8 @@
 
 mySQL
 SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
concat
concat(?1, ?2)
  @@ -824,6 +844,8 @@
 
 MS SQLSERVER
 SELECT ?1 FROM ?2 with (rowlock) WHERE 
?3
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
concat
(?1 + ?2)
  @@ -929,6 +951,8 @@
  
 MS SQLSERVER2000 
 SELECT ?1 FROM ?2 with (rowlock) WHERE 
?3
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
concat
(?1 + ?2)
  @@ -1048,6 +1072,8 @@
 
 DB2/400
 
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
java.lang.Character
CHAR
  @@ -1120,6 +1146,8 @@
 
 SapDB
 SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
java.lang.Integer
INTEGER
  @@ -1190,6 +1218,8 @@
 
 Cloudscape
 
  +CONSTRAINT ?1 PRIMARY KEY (?2)
  +ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
 
java.math.BigDecimal
LONGVARCHAR
  @@ -1266,6 +1296,8 @@
  
 InformixDB 
 
  +PRIMARY KEY (?2) CONSTRAINT ?1
  +ALTER TABLE ?1 ADD CONSTRAINT FOREIGN KEY (?3) 
REFERENCES ?4 (?5) CONSTRAINT ?2
  
java.lang.Character 
CHAR 
  
  
  

___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourcef

[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 @@
   
   
   
  -
  +
   
   
  
  @@ -542,11 +542,16 @@
TIMESTAMP
 
 
  + java.math.BigDecimal
  + NUMERIC
  + NUMERIC
  +  
  +  
java.lang.Object
JAVA_OBJECT
OID
 
  -  
  +   
   
 
 Hypersonic SQL
  
  
  

___
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 @@
   
   
   
  -
  +
   
   
  
  @@ -23,6 +23,12 @@
 false
 false
 foreign-key
  +  
  + on-load
  + 1000
  + *
  +  
  +  1000
  
  
  
  @@ -483,8 +489,8 @@
 
 
java.lang.Boolean
  - TINYINT
  - INT2
  +   CHAR
  +   BOOLEAN
 
 
java.lang.Byte
  
  
  

___
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 @@
   
   
   
  -
  +
   
   
  
  
 java:/DefaultDS
  -  Hypersonic SQL
  +  Hypersonic SQL
 
 true
 false
  
  
  

___
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 @@
   
   
   
  -
  +
   
   
  
  @@ -531,6 +531,11 @@
java.lang.String
VARCHAR
TEXT
  +  
  +  
  + java.util.Date
  + TIMESTAMP
  + TIMESTAMP
 
 
java.sql.Date
  
  
  

___
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 @@
   
   
   
  -
  +
   
   
  
  @@ -260,6 +260,11 @@
VARCHAR2(255)
 
 
  + java.util.Date
  + TIMESTAMP
  + TIMESTAMP
  +  
  +  
java.sql.Date
DATE
DATE
  @@ -357,6 +362,11 @@
java.lang.String
VARCHAR
VARCHAR2(255)
  +  
  +  
  + java.util.Date
  + TIMESTAMP
  + TIMESTAMP
 
 
java.sql.Date
  
  
  

___
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 @@
>
>
>
>   -
>   +
>
>
>   
>   @@ -531,6 +531,11 @@
>   java.lang.String
>   VARCHAR
>   TEXT
>   +
>   +
>   +   java.util.Date
>   +   TIMESTAMP
>   +   TIMESTAMP
>
>
>   java.sql.Date
>   
>   
>   
> 
> ___
> 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 @@
>>   
>>   
>>   
>>  -
>>  +
>>   
>>   
>>  
>>  @@ -531,6 +531,11 @@
>>  java.lang.String
>>  VARCHAR
>>  TEXT
>>  +
>>  +
>>  +   java.util.Date
>>  +   TIMESTAMP
>>  +   TIMESTAMP
>>   
>>   
>>  java.sql.Date
>>  
>>  
>>  
>>
>>___
>>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