Stephen and all torque team, for DB2 there are also some other mappings that are correct, but I was not sure how they would work for Torque, due to the generation - ie
BINARY(n) = CHAR(n) FOR BIT DATA VARBINARY(n) = VARCHAR(n) FOR BIT DATA The problem is where the "(n)" part needs to be between the type name and the "FOR BIT DATA" part, which I do not think that the current templates can handle. If you can think of or know a way that this can be described in the current template system, please let me know and I will compile the needed data > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 5:46 AM > To: [EMAIL PROTECTED] > Subject: cvs commit: jakarta-turbine-torque/src/templates/sql/base/db2 > db.props > > > stephenh 2002/09/05 05:46:05 > > Modified: src/templates/sql/base/db2 db.props > Log: > Better DB2 values submitted by J. Russell Smyth <[EMAIL PROTECTED]>. > > Revision Changes Path > 1.4 +19 -18 > jakarta-turbine-torque/src/templates/sql/base/db2/db.props > > Index: db.props > =================================================================== > RCS file: > /home/cvs/jakarta-turbine-torque/src/templates/sql/base/db2/db.props,v > retrieving revision 1.3 > retrieving revision 1.4 > diff -u -r1.3 -r1.4 > --- db.props 23 Oct 2001 21:19:52 -0000 1.3 > +++ db.props 5 Sep 2002 12:46:05 -0000 1.4 > @@ -1,34 +1,34 @@ > # Taken from java.sql.Types in the IBM 1.3 JDK > -# JDBC to Oracle mappings. > +# JDBC to DB2 mappings. > > BIT = > TINYINT = > -SMALLINT = > -INTEGER = INT > -BIGINT = > -FLOAT = > -REAL = > -DOUBLE = > -NUMERIC = > -DECIMAL = > +SMALLINT = SMALLINT > +INTEGER = INTEGER > +BIGINT = BIGINT > +FLOAT = FLOAT > +REAL = REAL > +DOUBLE = DOUBLE > +NUMERIC = NUMERIC > +DECIMAL = DECIMAL > CHAR = VARCHAR > VARCHAR = VARCHAR > LONGVARCHAR = VARCHAR > -DATE = > -TIME = > -TIMESTAMP = DATE > -BINARY = > +DATE = DATE > +TIME = TIME > +TIMESTAMP = TIMESTAMP > +BINARY = > # For DB2/400, VARBINARY must be changed to VARCHAR > (32000) FOR BIT DATA > -VARBINARY = BLOB (16777215) > +VARBINARY = > LONGVARBINARY = > -NULL = > +NULL = NULL > OTHER = > JAVA_OBJECT = > -DISTINCT = > +DISTINCT = DISTINCT > STRUCT = > ARRAY = > -BLOB = > -CLOB = > +BLOB = BLOB > +CLOB = CLOB > REF = > > AUTOINCREMENT = GENERATED ALWAYS AS IDENTITY > @@ -38,3 +38,4 @@ > > suppressDefaults = false > maxColumnNameLength = 18 > + > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
