dlr 01/07/24 23:34:50
Modified: conf/torque/templates/sql/base/oracle Tag: T_2_1_BRANCH
db.props
Log:
Backported fixes from the HEAD.
Revision Changes Path
No revision
No revision
1.2.4.1 +21 -17
jakarta-turbine/conf/torque/templates/sql/base/oracle/Attic/db.props
Index: db.props
===================================================================
RCS file:
/home/cvs/jakarta-turbine/conf/torque/templates/sql/base/oracle/Attic/db.props,v
retrieving revision 1.2
retrieving revision 1.2.4.1
diff -u -u -r1.2 -r1.2.4.1
--- db.props 2001/04/03 20:23:14 1.2
+++ db.props 2001/07/25 06:34:49 1.2.4.1
@@ -1,33 +1,37 @@
# Taken from java.sql.Types in the IBM 1.3 JDK
# JDBC to Oracle mappings.
+#
+# Good Oracle resources for determining these mappings include:
+# http://technet.oracle.com/doc/oracle8i_816/java.816/a81354/basic3.htm
+#
http://technet.oracle.com/docs/tech/migration/workbench/doc_library/MSAccess/ch3.htm
-BIT =
-TINYINT =
-SMALLINT =
+BIT = NUMBER (1, 0)
+TINYINT = NUMBER (3, 0)
+SMALLINT = NUMBER (5, 0)
INTEGER = INT
-BIGINT =
-FLOAT =
-REAL =
-DOUBLE =
-NUMERIC =
-DECIMAL =
-CHAR = VARCHAR2
+BIGINT = NUMBER (20, 0)
+FLOAT = FLOAT
+REAL = NUMBER
+DOUBLE = FLOAT
+NUMERIC = NUMBER
+DECIMAL = NUMBER
+CHAR = CHAR
VARCHAR = VARCHAR2
-LONGVARCHAR = VARCHAR2
+LONGVARCHAR = VARCHAR2 (2000)
DATE = DATE
-TIME =
+TIME = DATE
TIMESTAMP = DATE
-BINARY =
-VARBINARY = LONG RAW
-LONGVARBINARY =
+BINARY = RAW
+VARBINARY = RAW
+LONGVARBINARY = LONG RAW
NULL =
OTHER =
JAVA_OBJECT =
DISTINCT =
STRUCT =
ARRAY =
-BLOB =
-CLOB =
+BLOB = BLOB
+CLOB = CLOB
REF =
AUTOINCREMENT = AUTO_INCREMENT
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
