ObJectRelationalBridge readme

ObJectRelationalBridge
BRIDGING JAVA OBJECTS AND RELATIONAL DATABASES

mapping of JDBC types to Java types

OJB implements the mapping conventions for JDBC and Java types as specified by the JDBC 2.0 specification.

See the table below for details.

JDBC Type	Java Type
`CHAR`	`String`
`VARCHAR`	`String`
`LONGVARCHAR`	`String`
`NUMERIC`	`java.math.BigDecimal`
`DECIMAL`	`java.math.BigDecimal`
`BIT`	`boolean`
`TINYINT`	`byte`
`SMALLINT`	`short`
`INTEGER`	`int`
`BIGINT`	`long`
`REAL`	`float`
`FLOAT`	`double`
`DOUBLE`	`double`
`BINARY`	`byte[]`
`VARBINARY`	`byte[]`
`LONGVARBINARY`	`byte[]`
`DATE`	`java.sql.Date`
`TIME`	`java.sql.Time`
`TIMESTAMP`	`java.sql.Timestamp`
CLOB	Clob
BLOB	Blob
ARRAY	Array
DISTINCT	mapping of underlying type
STRUCT	Struct
REF	Ref
JAVA_OBJECT	underlying Java class

JDBC Type

Java Type

CHAR

String

VARCHAR

String

LONGVARCHAR

String

NUMERIC

java.math.BigDecimal

DECIMAL

java.math.BigDecimal

BIT

boolean

TINYINT

byte

SMALLINT

short

INTEGER

int

BIGINT

long

REAL

float

FLOAT

double

DOUBLE

double

BINARY

byte[]

VARBINARY

byte[]

LONGVARBINARY

byte[]

DATE

java.sql.Date

TIME

java.sql.Time

TIMESTAMP

java.sql.Timestamp

CLOB

Clob

BLOB

Blob

ARRAY

Array

DISTINCT

mapping of underlying type

STRUCT

Struct

REF

Ref

JAVA_OBJECT

underlying Java class

$FOOTER$