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]>
