15.00 - Data Type Mapping Between SQL and Java - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Data Type Mapping Between SQL and Java

When you create or replace an external Java procedure, the system converts all SQL data types to or from its corresponding Java data type based on the type of parameter mapping.

External procedures default to Simple Mapping, where the SQL data types map to Java primitives or, when an appropriate primitive does not exist, to Java classes. In other words, if there is a Java type in the Simple Mapping column, the default mapping maps to that type. If the Simple Mapping column has a not applicable entry for an SQL data type, then the default mapping maps to the Java class in the Object Mapping column.

If you create or replace a Java external procedure that permits nulls to be passed to or from it, you cannot use simple mapping. To override the default mapping, you must specify the appropriate Java class from the Object Mapping column in the parameter list of the EXTERNAL NAME clause.

The following table defines the data type mapping between SQL and Java.

 

SQL Data Type

 

 

Java Data Type

Simple Mapping

Simple Mapping Java Primitive Symbol

Object Mapping

BYTEINT

byte

B

java.lang.Byte

SMALLINT

short

S

java.lang.Short

INTEGER

int

I

java.lang.Integer

BIGINT

long

J

java.lang.Long

NUMERIC

not available

not available

java.math.BigDecimal

DECIMAL

not available

not available

java.math.BigDecimal

FLOAT

double

D

java.lang.Double

REAL

double

D

java.lang.Double

DOUBLE PRECISION

double

D

java.lang.Double

BYTE

not available

B

byte[]

VARBYTE

not available

B

byte[]

BLOB

not available

not available

java.sql.Blob

DATE

not available

not available

java.sql.Date

TIME

TIME does not support the full nanosecond time granularity provided by the Teradata Database.

not available

not available

java.sql.Time

TIMESTAMP

not available

not available

java.sql.Timestamp

INTERVAL

not available

not available

java.lang.String

CHARACTER

not available

not available

java.lang.String

VARCHAR

not available

not available

java.lang.String

CLOB

not available

not available

java.sql.Clob

GRAPHIC

not available

not available

not available

VARGRAPHIC

not available

not available

not available

UDT

not supported

not available

not supported