Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

DatentypRapidClipse Standard MappingJava Example

CHARACTER(n)

Character. Fixed-length character strings
with a length of n bytes. n must be greater than 0 and not greater than 255. The
default length is 1.

visitor.addPropertyColumnDefinitionFix(new PropertyColumnDefinitionFix(
    new String[]{"CHARACTER"},new String[]{"java.lang.String"},"CHARACTER"));
private String charactertest;


@Column(name = "CHARACTERTEST", nullable = false, 
            length = 10, columnDefinition = "CHARACTER")
public String getCharactertest() {
    return this.charactertest;
}

LONG VARCHAR

Long Varchar. Specifies a varying-length column for character string data. The maximum
length of a column of this type is 32700 characters.

visitor.addPropertyColumnDefinitionFix(new PropertyColumnDefinitionFix(
    new String[]{"LONG VARCHAR"},new String[]{"java.lang.String"},"LONG VARCHAR"));
private String longvarchartest;


@Column(name = "LONGVARCHARTEST", nullable = false, 
            length = 32700, columnDefinition = "LONG VARCHAR")
public String getLongvarchartest() {
    return this.longvarchartest;
}

REAL

Real. A single-precision floating-point number is a short floating-point number of 32 bits. The range of single-precision floating-point numbers is approximately -7.2E+75 to 7.2E+75. In this range, the largest negative value is about -5.4E-79, and the smallest positive value is about 5.4E-079.

visitor.addPropertyColumnDefinitionFix(new PropertyColumnDefinitionFix(
    new String[]{"REAL"},new String[]{"java.lang.Float","float"},"REAL"));
private float realtest;


@Column(name = "REALTEST", nullable = false, 
            precision = 24, scale = 0, columnDefinition = "REAL")
public float getRealtest() {
    return this.realtest;
}

INTEGER

Large integers. A large integer is binary integer with a precision of 31 bits. The range is -2147483648 to +2147483647.

Hibernate Standard Mapping
pivate int inttest;


@Column(name = "INTTEST", unique = true, 
            nullable = false)
public int getInttest() {
    return this.inttest;
}

BIGINT

Big integers. A big integer is a binary integer with a precision of 63 bits. The range of big integers is -9223372036854775808 to +9223372036854775807.

Hibernate Standard Mapping
pivate int inttest;


@Column(name = "INTTEST", unique = true, 
            nullable = false)
public int getInttest() {
    return this.inttest;
}

BLOB

BLOB. Data type to store large amounts of noncharacter data, such as pictures, voice, and mixed media.

<sql-type jdbc-type="BLOB" hibernate-type="byte[]"></sql-type>
visitor.addPropertyColumnDefinitionFix(
    new PropertyColumnDefinitionFix(new String[]{"BLOB"},new String[]{"byte[]"},"blob")
        .addLobAnnotation());
private byte[] blobtest;


@Lob
@Column(name = "BLOBTEST", columnDefinition = "blob")
public byte[] getBlobtest() {
    return this.blobtest;
}



  • No labels