user manual

ManualsBrandsBorland Software ManualsHome Theater ServerHome Theater Server 6

148 BES Developer’s Guide

Setting Properties

The following table shows the Java to SQL type mapping for JDatastore,

Informix, and Interbase:

String VARCHAR(2000) TEXT VARCHAR(2000)

java.math.BigDecima

l

NUMBER(38) DECIMAL(28,28) DECIMAL

byte[] LONG RAW IMAGE BLOB

java.sql.Date DATE DATETIME DATE

java.sql.Time DATE DATETIME TIME

java.sql.Timestamp DATE DATETIME TIMESTAMP

java.util.Date DATE DATETIME TIMESTAMP

java.io.Serializabl

e

RAW(2000) IMAGE BLOB

Java types JDatastore Informix Interbase

boolean/Boolean BOOLEAN SMALLINT SMALLINT

byte/Byte SMALLINT SMALLINT SMALLINT

char/Character CHAR(1) CHAR(1) CHAR(1)

double/Double DOUBLE FLOAT DOUBLE PRECISION

float/Float FLOAT SMALLFLOAT FLOAT

int/Integer INTEGER INTEGER INTEGER

long/Long LONG DECIMAL(19,0) NUMBER(15,0)

short/Short SMALLINT SMALLINT SMALLINT

String VARCHAR VARCHAR(2000) VARCHAR(2000)

java.math.BigDecima

l

NUMERIC DECIMAL(32) NUMBER(15,15)

byte[] OBJECT BYTE BLOB

java.sql.Date DATE DATE DATE

java.sql.Time TIME DATE DATE

java.sql.Timestamp TIMESTAMP DATE DATE

java.util.Date TIMESTAMP DATE DATE

java.io.Serializabl

e

OBJECT BYTE BLOB

Java types Oracle Sybase/MSSQL DB2