[JBoss-dev] CVS update: jboss/src/etc/conf/default standardjbosscmp-jdbc.xml
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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