Address:
Http://otndnld.Oracle.co.jp/document/products/oracle10g/102/doc_cd/Java.102/B19275-03/datacc.htm#BHCJBJCC
SQL data Type |
JDBC Type Code |
standard Java type |
types of Java extensions for Oracle |
|
1.0 Standard JDBC Type: |
|
|
CHAR
|
java.sql.Types.CHAR
|
java.lang.String
|
oracle.sql.CHAR
|
VARCHAR2
|
java.sql.Types.VARCHAR
|
java.lang.String
|
oracle.sql.CHAR
|
LONG
|
java.sql.Types.LONGVARCHAR
|
java.lang.String
|
oracle.sql.CHAR
|
NUMBER
|
java.sql.Types.NUMERIC
|
java.math.BigDecimal
|
oracle.sql.NUMBER
|
NUMBER
|
java.sql.Types.DECIMAL
|
java.math.BigDecimal
|
oracle.sql.NUMBER
|
NUMBER
|
java.sql.Types.BIT
|
boolean
|
oracle.sql.NUMBER
|
NUMBER
|
java.sql.Types.TINYINT
|
byte
|
oracle.sql.NUMBER
|
NUMBER
|
java.sql.Types.SMALLINT
|
short
|
oracle.sql.NUMBER
|
NUMBER
|
java.sql.Types.INTEGER
|
int
|
oracle.sql.NUMBER
|
NUMBER
|
java.sql.Types.BIGINT
|
long
|
oracle.sql.NUMBER
|
NUMBER
|
java.sql.Types.REAL
|
float
|
oracle.sql.NUMBER
|
NUMBER
|
java.sql.Types.FLOAT
|
double
|
oracle.sql.NUMBER
|
NUMBER
|
java.sql.Types.DOUBLE
|
double
|
oracle.sql.NUMBER
|
RAW
|
java.sql.Types.BINARY
|
byte[]
|
oracle.sql.RAW
|
RAW
|
java.sql.Types.VARBINARY
|
byte[]
|
oracle.sql.RAW
|
LONGRAW
|
java.sql.Types.LONGVARBINARY
|
byte[]
|
oracle.sql.RAW
|
DATE
|
java.sql.Types.DATE
|
java.sql.Date
|
oracle.sql.DATE
|
DATE
|
java.sql.Types.TIME
|
java.sql.Time
|
oracle.sql.DATE
|
TIMESTAMP
|
java.sql.Types.TIMESTAMP
|
javal.sql.Timestamp
|
oracle.sql.TIMESTAMP
|
|
2.0 Standard JDBC Type: |
|
|
BLOB
|
java.sql.Types.BLOB
|
java.sql.Blob
|
oracle.sql.BLOB
|
CLOB
|
java.sql.Types.CLOB
|
java.sql.Clob
|
oracle.sql.CLOB
|
User-defined objects |
java.sql.Types.STRUCT
|
java.sql.Struct
|
oracle.sql.STRUCT
|
User-defined reference |
java.sql.Types.REF
|
java.sql.Ref
|
oracle.sql.REF
|
User-defined Collections |
java.sql.Types.ARRAY
|
java.sql.Array
|
oracle.sql.ARRAY
|
|
Oracle Extensions: |
|
|
BFILE
|
oracle.jdbc.OracleTypes.BFILE
|
N/A |
oracle.sql.BFILE
|
ROWID
|
oracle.jdbc.OracleTypes.ROWID
|
N/A |
oracle.sql.ROWID
|
REF CURSOR
|
oracle.jdbc.OracleTypes.CURSOR
|
java.sql.ResultSet
|
oracle.jdbc.OracleResultSet
|
TIMESTAMP
|
oracle.jdbc.OracleTypes.TIMESTAMP
|
java.sql.Timestamp
|
oracle.sql.TIMESTAMP
|
TIMESTAMP WITH TIME ZONE
|
oracle.jdbc.OracleTypes.TIMESTAMPTZ
|
java.sql.Timestamp
|
oracle.sql.TIMESTAMPTZ
|
TIMESTAMP WITH LOCAL TIME ZONE
|
oracle.jdbc.OracleTypes.TIMESTAMPLTZ
|
java.sql.Timestamp
|
oracle.sql.TIMESTAMPLTZ
|
http://blog.csdn.net/perny/article/details/7971003
The fields in the database are number types, and the corresponding integers and bigdecimal in the Java type will appear;
The test found that when the database is SQL Server and DB2, the integer type is taken out with GetObject (), but the Oracle takes out an integer or BigDecimal type. The reason is that Oracle corresponds to the number length of the Java type.
If you encounter this type of problem, to determine the length of each database and database field is different from the Java data type is too cumbersome, you can use GetString () to take a value, unified first to string to determine
Also attached
Java.sql.Types, database field type, Java data type correspondence
Http://www.cnblogs.com/shishm/archive/2012/01/30/2332142.html
Data types in Oracle correspond to Java types