Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
DatentypRapidClipse Standard MappingJava ExampleGenerierter 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
languagejava
themeConfluence
visitor.addPropertyColumnDefinitionFix(new PropertyColumnDefinitionFix(
    new String[]{"CHARACTER"},new String[]{"java.lang.String"},"CHARACTER"));
Code Block
languagejava
themeConfluence
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
languagejava
themeConfluence
visitor.addPropertyColumnDefinitionFix(new PropertyColumnDefinitionFix(
    new String[]{"LONG VARCHAR"},new String[]{"java.lang.String"},"LONG VARCHAR"));
Code Block
languagejava
themeConfluence
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
languagejava
themeConfluence
visitor.addPropertyColumnDefinitionFix(new PropertyColumnDefinitionFix(
    new String[]{"REAL"},new String[]{"java.lang.Float","float"},"REAL"));
Code Block
languagejava
themeConfluence
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
languagejava
themeConfluence
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
languagejava
themeConfluence
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
languagexml
themeConfluence
<sql-type jdbc-type="BLOB" hibernate-type="byte[]"></sql-type>
Code Block
languagejava
themeConfluence
visitor.addPropertyColumnDefinitionFix(
    new PropertyColumnDefinitionFix(new String[]{"BLOB"},new String[]{"byte[]"},"blob")
        .addLobAnnotation());
Code Block
languagejava
themeConfluence
private byte[] blobtest;


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