About Suggested Type Mappings for CMP

The following shows suggested type mappings for container managed persistence. The left column shows the Java type to be used in the EJB field. The middle column shows the business components type to be used in the CMP persistence object field. The right column shows the PL/SQL type used in the table.

EJB Field Type

Persistence Object Field Type

Table Column Type

char

String

CHAR(1)

double

Double

FLOAT(126)

java.lang.Double

Double

FLOAT(126)

float

Float

FLOAT(126)

java.lang.Float

Float

FLOAT(126)

int

Integer

NUMBER(38)

java.lang.Integer

Integer

NUMBER(38)

long

Long

NUMBER(38)

java.lang.Long

Long

NUMBER(38)

boolean

Boolean

NUMBER(1)

java.lang.Boolean

Boolean

NUMBER(1)

java.lang.String

String

VARCHAR(255)