mpoeschl 2002/09/01 23:51:00 Modified: src/templates/sql/base/sapdb db.props Log: From: [EMAIL PROTECTED] add some mappings for sapdb Revision Changes Path 1.4 +22 -20 jakarta-turbine-torque/src/templates/sql/base/sapdb/db.props Index: db.props =================================================================== RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/base/sapdb/db.props,v retrieving revision 1.3 retrieving revision 1.4 diff -u -r1.3 -r1.4 --- db.props 6 May 2002 23:49:31 -0000 1.3 +++ db.props 2 Sep 2002 06:51:00 -0000 1.4 @@ -1,36 +1,38 @@ # Taken from java.sql.Types in the IBM 1.3 JDK # JDBC to SapDB mappings. -BIT = -TINYINT = -SMALLINT = -INTEGER = INT -BIGINT = -FLOAT = -REAL = -DOUBLE = -NUMERIC = -DECIMAL = +BIT = FIXED(1,0) +TINYINT = CHAR BYTE +SMALLINT = SMALLINT +INTEGER = INTEGER +BIGINT = FIXED(38,0) +FLOAT = FLOAT +REAL = REAL +DOUBLE = DOUBLE PRECISION +NUMERIC = DECIMAL +DECIMAL = DECIMAL CHAR = CHAR VARCHAR = VARCHAR LONGVARCHAR = LONG VARCHAR DATE = DATE -TIME = -TIMESTAMP = DATE -BINARY = -VARBINARY = LONG RAW -LONGVARBINARY = -NULL = +TIME = TIME +TIMESTAMP = TIMESTAMP +BINARY = CHAR(254) BYTE +VARBINARY = LONG BYTE +LONGVARBINARY = LONG BYTE +NULL = NULL OTHER = -JAVA_OBJECT = +JAVA_OBJECT = LONG BYTE DISTINCT = STRUCT = ARRAY = -BLOB = -CLOB = +BLOB = LONG BYTE +CLOB = LONG UNICODE REF = +BOOLEAN = BOOLEAN -AUTOINCREMENT = AUTO_INCREMENT + +AUTOINCREMENT = DEFAULT SERIAL NOTNULL = NOT NULL primaryKeyInsideTableDirective = true
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
