Java type corresponds to JDBC type table

Source: Internet
Author: User
Tags ibm db2

Java.sql.Types value Java type IBM DB2 Oracle Sybase Sql Informix IBM Content Manager
BIGINT Java.lang.long BIGINT Number (38, 0) BIGINT BIGINT INT8 Dk_cm_bigint
BINARY Byte[] CHAR for BIT DATA RAW BINARY IMAGE BYTE Dk_cm_blob
BIT Java.lang.Boolean N/A BIT BIT BIT BIT Dk_cm_smallint
Blob Byte[] Blob Blob Blob Blob Blob Dk_cm_blob
CHAR Java.lang.String CHAR, GRAPHIC CHAR CHAR CHAR CHAR Dk_cm_char
Clob Java.lang.String CLOB, Dbclob Clob Clob Clob Clob Dk_cm_clob
DATE Java.sql.Date DATE DATE DATE DATE DATE Dk_cm_date
DECIMAL Java.math.BigDecimal DECIMAL Number DECIMAL, Money, smallmoney DECIMAL DECIMAL Dk_cm_decimal
DOUBLE Java.lang.Double DOUBLE DOUBLE PRECISION DOUBLE PRECISION DOUBLE PRECISION DOUBLE PRECISION Dk_cm_double
FLOAT Java.lang.Double FLOAT FLOAT FLOAT FLOAT FLOAT Dk_cm_double
INTEGER Java.lang.Integer INTEGER INTEGER Int INTEGER INTEGER Dk_cm_integer
Java_object Java.lang.Object Java_object Java_object Java_object Java_object OPAQUE N/A
LongVarBinary Byte[] LONG VARCHAR for BIT DATA LONG RAW IMAGE IMAGE BYTE Dk_cm_blob
LongVarChar Java.lang.String Long VARCHAR, Long vargraphic LONG TEXT TEXT TEXT Dk_cm_varchar (3500)
NUMERIC Java.math.BigDecimal NUMERIC Number NUMERIC NUMERIC NUMERIC Dk_cm_decimal
Other Java.lang.Object Other Other Other Other Other N/A
REAL Java.lang.Float REAL REAL REAL REAL REAL Dk_cm_double
SMALLINT Java.lang.Integer SMALLINT SMALLINT SMALLINT SMALLINT SMALLINT Dk_cm_integer
Time Java.sql.Time Time DATE Time Time DATETIME HOUR to SECOND Dk_cm_time
TIMESTAMP Java.sql.Timestamp TIMESTAMP DATE DATETIME, smalldatetime Datetime DATETIME year to fraction (5) Dk_cm_timestamp
TINYINT Java.lang.Bute SMALLINT

TINYINT

TINYINT

TINYINT TINYINT Dk_cm_integer
VARBINARY Byte[] VARCHAR for BIT DATA RAW VARBINARY IMAGE BYTE Dk_cm_blob
VARCHAR Java.lang.String VARCHAR, Vargraphic VARCHAR VARCHAR VARCHAR VARCHAR Dk_cm_varchar

Java type corresponds to JDBC type table

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.