Kopie von DB2

Owned by RapidClipse Translator Services
Apr 23, 2017
4 min read
DatentypRapidClipse Standard MappingGenerierter Javacode - 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;
}

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.

<sql-type jdbc-type="CLOB" hibernate-type="java.lang.String"></sql-type>
visitor.addPropertyColumnDefinitionFix(new PropertyColumnDefinitionFix(new String[]{"CLOB"},new String[]
        {"java.lang.String"},"clob").addLobAnnotation());
private String clobtest;


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

DATE

DATE. A date is a three-part value representing a year, month, and day in the range of 0001-01-01 to 9999-12-31.

Hibernate Standard Mapping
private Date datetest;


@Temporal(TemporalType.DATE)
@Column(name = "DATETEST", nullable = false, length = 10)
public Date getDatetest() {
    return this.datetest;
}

DECIMAL

DECIMAL. A decimal number is a packed decimal number with an implicit decimal point.
The position of the decimal point is determined by the precision and the scale of the number.
The scale, which is the number of digits in the fractional part of the number, cannot be
negative or greater than the precision. The maximum precision is 31 digits. All values of a decimal column have the same precision and scale. The range of a decimal variable or the numbers in a decimal column is -n to +n, where n is the largest positive number that can be represented with the applicable precision and scale. The maximum range is 1 - 10³¹ to 10³¹ - 1.

visitor.addPropertyColumnDefinitionFix(new PropertyColumnDefinitionFix(
    new String[]{"DECIMAL"},new String[]{"java.math.BigDecimal"},"decimal"));
private BigDecimal decimaltest;


@Column(name = "DECIMALTEST", nullable = false, precision = 6, columnDefinition = "decimal")
public BigDecimal getDecimaltest() {
    return this.decimaltest;
}
private double decimaltest;


@Column(name = "DECIMALTEST", nullable = false, precision = 6, columnDefinition = "decimal")
public double getDecimaltest() {
    return this.decimaltest;
}

DOUBLE

DOUBLE. A double-precision floating-point number is a long floating-point number of 64-bits. The range of double-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.

Hibernate Standard Mapping
private double doubletest;

@Column(name = "DOUBLETEST", nullable = false, precision = 53, scale = 0)
public double getDoubletest() {
    return this.doubletest;
}

SMALLINT

Small integers. A small integer is binary integer with a precision of 15 bits. The range is -32768 to +32767.

Hibernate Standard Mapping
private short smallinttest;

@Column(name = "SMALLINTTEST", nullable = false)
public short getSmallinttest() {
    return this.smallinttest;
}

TIME

TIME. A time is a three-part value representing a time of day in hours, minutes, and seconds,
in the range of 00.00.00 to 24.00.00.

Hibernate Standard Mapping
private Date timetest;





@Temporal(TemporalType.TIME)
@Column(name = "TIMETEST", nullable = false, length = 8)
public Date getTimetest() {
    return this.timetest;
}

TIMESTAMP

TIMESTAMP. A timestamp is a seven-part value representing a date and time byyear, month, day,hour, minute, second, and microsecond, in the range of 0001-01-01-00.00.00.000000000 to 9999-12-31-24.00.00.000000000 with nanosecond precision. Timestamps canalso hold timezone information.

Hibernate Standard Mapping






private Date timestamptest;





@Temporal(TemporalType.TIMESTAMP)
@Column(name = "TIMESTAMPTEST", nullable = false, length = 26)
public Date getTimestamptest() {
    return this.timestamptest;
}

VARCHAR

VARCHAR. Varying-length character strings with a maximum length of n bytes. n must be greater than 0 and less than a number that depends on the page size of the table space. The maximum length is 32704.

Hibernate Standard Mapping
private String varchartest;





@Column(name = "VARCHARTEST", nullable = false, length = 10)
public String getVarchartest() {
    return this.varchartest;
}

XDEV Software Corp. - One Embarcadero Center, San Francisco, CA 94111, US
Copyright © 2015. XDEV Software Corp. All rights reserved.