Page Comparison

Datentyp

RapidClipse Standard Mapping

Generierter Javacode

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.

Code Block

language	java
theme	Confluence

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

Code Block

language	java
theme	Confluence

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.

Code Block

language	java
theme	Confluence

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

Code Block

language	java
theme	Confluence

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.

Code Block

language	java
theme	Confluence

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

Code Block

language	java
theme	Confluence

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

Code Block

language	java
theme	Confluence

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

Code Block

language	java
theme	Confluence

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.

Code Block

language	xml
theme	Confluence

<sql-type jdbc-type="BLOB" hibernate-type="byte[]"></sql-type>

Code Block

language	java
theme	Confluence

visitor.addPropertyColumnDefinitionFix(
    new PropertyColumnDefinitionFix(new String[]{"BLOB"},new String[]{"byte[]"},"blob")
        .addLobAnnotation());

Code Block

language	java
theme	Confluence

private byte[] blobtest;


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

CLOB

Data type to store SBCS or mixed data, such as documents that contain single character set. Use this data type if your data is larger (or might grow larger) than the VARCHAR data type permits.

Code Block

language	xml
theme	Confluence

<sql-type jdbc-type="CLOB" hibernate-type="java.lang.String"></sql-type>

Code Block

language	java
theme	Confluence

visitor.addPropertyColumnDefinitionFix(new PropertyColumnDefinitionFix(new String[]{"CLOB"},new String[]
        {"java.lang.String"},"clob").addLobAnnotation());

Code Block

language	java
theme	Confluence

private String clobtest;


@Lob
@Column(name = "CLOBTEST", nullable = false, 
            columnDefinition = "clob")
public String getClobtest() {
    return this.clobtest;
}

Versions Compared

Old Version 9

New Version 10

Key