dlr 01/06/12 17:13:12
Modified: conf/torque/templates/sql/base/oracle db.props
Log:
* Provided Oracle mappings for BIT, TINYINT, SMALLINT, BIGINT, FLOAT,
DOUBLE, NUMERIC, and DECIMAL.
* Changed the JDBC data types BLOB and CLOB to the BLOB and CLOB
provided by Oracle (which I didn't know about, but found at
http://technet.oracle.com/docs/tech/migration/workbench/doc_library/MSAccess/ch3.htm).
Revision Changes Path
1.7 +10 -10 jakarta-turbine/conf/torque/templates/sql/base/oracle/db.props
Index: db.props
===================================================================
RCS file: /home/cvs/jakarta-turbine/conf/torque/templates/sql/base/oracle/db.props,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- db.props 2001/06/12 23:35:22 1.6
+++ db.props 2001/06/13 00:13:12 1.7
@@ -1,16 +1,16 @@
# Taken from java.sql.Types in the IBM 1.3 JDK
# JDBC to Oracle mappings.
-BIT =
-TINYINT =
-SMALLINT =
+BIT = NUMBER (1, 0)
+TINYINT = NUMBER (3, 0)
+SMALLINT = NUMBER (5, 0)
INTEGER = INT
-BIGINT =
-FLOAT =
+BIGINT = NUMBER (20, 0)
+FLOAT = FLOAT
REAL =
-DOUBLE =
-NUMERIC =
-DECIMAL =
+DOUBLE = FLOAT
+NUMERIC = NUMBER
+DECIMAL = NUMBER
CHAR = VARCHAR2
VARCHAR = VARCHAR2
LONGVARCHAR = VARCHAR2 (2000)
@@ -26,8 +26,8 @@
DISTINCT =
STRUCT =
ARRAY =
-BLOB = LONG RAW
-CLOB = LONG
+BLOB = BLOB
+CLOB = CLOB
REF =
AUTOINCREMENT = AUTO_INCREMENT
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
