Nonstop Database, HiRDB Version 9 UAP Development Guide
This section explains when overflow is set when a program uses a setXXX method to set a value, or uses a getXXX method to get a value.
The following tables show for each HiRDB data type whether overflow occurs when a setXXX method is used.
Table 18-73 Possibility of overflow when the setXXX method is used (1/2)
setXXX method | HiRDB data type | |||||
---|---|---|---|---|---|---|
SMALLINT | INTEGER | FLOAT | REAL | DECIMAL | Character string types | |
setByte | -- | -- | -- | -- | Y | -- |
setShort | -- | -- | -- | -- | Y | -- |
setInt | Y | -- | -- | -- | Y | -- |
setLong | Y | Y | -- | -- | Y | -- |
setFloat | Y | Y | -- | -- | Y | -- |
setDouble | Y | Y | -- | -- | Y | -- |
setBigDecimal | Y | Y | -- | -- | Y | -- |
setBoolean | -- | -- | -- | -- | Y | -- |
setString | Y | Y | -- | -- | Y | -- |
setBytes | N/A | N/A | N/A | N/A | N/A | N/A |
setDate | N/A | N/A | N/A | N/A | N/A | -- |
setTime | N/A | N/A | N/A | N/A | N/A | -- |
setTimestamp | N/A | N/A | N/A | N/A | N/A | -- |
setBlob | N/A | N/A | N/A | N/A | N/A | N/A |
setBinaryStream | N/A | N/A | N/A | N/A | N/A | N/A |
setAsciiStream | N/A | N/A | N/A | N/A | N/A | -- |
setArray | Y | Y | Y | Y | Y | -- |
setCharacterStream | N/A | N/A | N/A | N/A | N/A | -- |
Table 18-74 Possibility of overflow when the setXXX method is used (2/2)
setXXX method | HiRDB data type | ||||
---|---|---|---|---|---|
DATE# | TIME# | TIMESTAMP# | BINARY | BLOB | |
setByte | N/A | N/A | N/A | N/A | N/A |
setShort | N/A | N/A | N/A | N/A | N/A |
setInt | N/A | N/A | N/A | N/A | N/A |
setLong | N/A | N/A | N/A | N/A | N/A |
setFloat | N/A | N/A | N/A | N/A | N/A |
setDouble | N/A | N/A | N/A | N/A | N/A |
setBigDecimal | N/A | N/A | N/A | N/A | N/A |
setBoolean | N/A | N/A | N/A | N/A | N/A |
setString | Y | -- | Y | N/A | N/A |
setBytes | N/A | N/A | N/A | -- | -- |
setDate | Y | N/A | Y | N/A | N/A |
setTime | N/A | Y | Y | N/A | N/A |
setTimestamp | Y | N/A | Y | N/A | N/A |
setBlob | N/A | N/A | N/A | -- | -- |
setBinaryStream | N/A | N/A | N/A | -- | -- |
setAsciiStream | N/A | N/A | N/A | -- | -- |
setArray | Y | Y | Y | N/A | N/A |
setCharacterStream | N/A | N/A | N/A | -- | -- |
The following tables show whether overflow occurs for each HiRDB data type when a setObject method is used.
Table 18-75 Possibility of overflow when the setObject method is used (1/2)
setObject method | HiRDB data type | |||||
---|---|---|---|---|---|---|
SMALLINT | INTEGER | FLOAT | REAL | DECIMAL | Character string types | |
Byte | -- | -- | -- | -- | Y | -- |
Short | -- | -- | -- | -- | Y | -- |
Integer | Y | -- | -- | -- | Y | -- |
Long | Y | Y | -- | -- | Y | -- |
Decimal | Y | Y | -- | -- | Y | -- |
Float | Y | Y | -- | -- | Y | -- |
Double | Y | Y | -- | Y | Y | -- |
Boolean | -- | -- | -- | -- | Y | -- |
String | Y | Y | --- | -- | Y | -- |
Date | N/A | N/A | N/A | N/A | N/A | -- |
Time | N/A | N/A | N/A | N/A | N/A | -- |
Timestamp | N/A | N/A | N/A | N/A | N/A | -- |
byte[] | N/A | N/A | N/A | N/A | N/A | -- |
Blob | N/A | N/A | N/A | N/A | N/A | N/A |
Array | N/A | N/A | N/A | N/A | N/A | N/A |
Table 18-76 Possibility of overflow when the setObject method is used (2/2)
setObject method | HiRDB data type | ||||
---|---|---|---|---|---|
DATE# | TIME# | TIMESTAMP# | BINARY | BLOB | |
Byte | N/A | N/A | N/A | N/A | N/A |
Short | N/A | N/A | N/A | N/A | N/A |
Integer | N/A | N/A | N/A | N/A | N/A |
Long | N/A | N/A | N/A | N/A | N/A |
Decimal | N/A | N/A | N/A | N/A | N/A |
Float | N/A | N/A | N/A | N/A | N/A |
Double | N/A | N/A | N/A | N/A | N/A |
Boolean | N/A | N/A | N/A | N/A | N/A |
String | Y | -- | Y | N/A | N/A |
Date | Y | N/A | Y | N/A | N/A |
Time | N/A | Y | N/A | N/A | N/A |
Timestamp | Y | N/A | Y | N/A | N/A |
byte[] | N/A | N/A | N/A | -- | -- |
Blob | N/A | N/A | N/A | -- | -- |
Array | N/A | N/A | N/A | N/A | N/A |
The following tables show whether overflow occurs for each HiRDB data type when a getXXX method is used.
Table 18-77 Possibility of overflow when the getXXX method is used (1/2)
getXXX method | HiRDB data type | |||||
---|---|---|---|---|---|---|
SMALLINT | INTEGER | FLOAT | REAL | DECIMAL | Character string types | |
getByte | Y | Y | Y | Y | Y | Y |
getShort | -- | Y | Y | Y | Y | Y |
getInt | -- | -- | Y | Y | Y | Y |
getLong | -- | -- | Y | Y | Y | Y |
getFloat | -- | -- | -- | -- | -- | -- |
getDouble | -- | -- | -- | -- | -- | -- |
getBigDecimal | -- | -- | -- | -- | -- | -- |
getBoolean | -- | -- | -- | -- | -- | -- |
getString | -- | -- | -- | -- | -- | -- |
getBytes | N/A | N/A | N/A | N/A | N/A | N/A |
getDate | N/A | N/A | N/A | N/A | N/A | -- |
getTime | N/A | N/A | N/A | N/A | N/A | -- |
getTimestamp | N/A | N/A | N/A | N/A | N/A | -- |
getAsciiStream | N/A | N/A | N/A | N/A | N/A | -- |
getBinaryStream | N/A | N/A | N/A | N/A | N/A | N/A |
getCharacterStream | N/A | N/A | N/A | N/A | N/A | -- |
getArray | N/A | N/A | N/A | N/A | N/A | -- |
getBlob | N/A | N/A | N/A | N/A | N/A | N/A |
Table 18-78 Possibility of overflow when the getXXX method is used (2/2)
getXXX method | HiRDB data type | ||||
---|---|---|---|---|---|
DATE | TIME | TIMESTAMP | BINARY | BLOB | |
getByte | N/A | N/A | N/A | N/A | N/A |
getShort | N/A | N/A | N/A | N/A | N/A |
getInt | N/A | N/A | N/A | N/A | N/A |
getLong | N/A | N/A | N/A | N/A | N/A |
getFloat | N/A | N/A | N/A | N/A | N/A |
getDouble | N/A | N/A | N/A | N/A | N/A |
getBigDecimal | N/A | N/A | N/A | N/A | N/A |
getBoolean | N/A | N/A | N/A | N/A | N/A |
getString | -- | -- | -- | -- | -- |
getBytes | N/A | N/A | N/A | -- | -- |
getDate | -- | N/A | -- | N/A | N/A |
getTime | N/A | -- | -- | N/A | N/A |
getTimestamp | -- | N/A | -- | N/A | N/A |
getAsciiStream | N/A | N/A | N/A | -- | -- |
getBinaryStream | N/A | N/A | N/A | -- | -- |
getCharacterStream | N/A | N/A | N/A | -- | -- |
getArray | N/A | N/A | N/A | -- | -- |
getBlob | N/A | N/A | N/A | -- | -- |
The following tables show whether overflow occurs for each HiRDB data type when a getObject method is used.
Table 18-79 Possibility of overflow when the getObject method is used (1/2)
getObject method | HiRDB data type | |||||
---|---|---|---|---|---|---|
SMALLINT | INTEGER | FLOAT | REAL | DECIMAL | Character string type | |
Byte | Y | Y | Y | Y | Y | Y |
Short | -- | Y | Y | Y | Y | Y |
Int | -- | -- | Y | Y | Y | Y |
Long | -- | -- | Y | Y | Y | Y |
Float | -- | -- | Y | -- | Y | Y |
Double | -- | -- | -- | Y | Y | Y |
BigDecimal | -- | -- | -- | Y | Y | Y |
Boolean | -- | -- | -- | -- | -- | -- |
String | -- | -- | -- | -- | -- | -- |
Bytes | N/A | N/A | N/A | N/A | N/A | N/A |
Date | N/A | N/A | N/A | N/A | N/A | -- |
Time | N/A | N/A | N/A | N/A | N/A | -- |
Timestamp | N/A | N/A | N/A | N/A | N/A | -- |
AsciiStream | N/A | N/A | N/A | N/A | N/A | -- |
BinaryStream | N/A | N/A | N/A | N/A | N/A | N/A |
Object | -- | -- | -- | -- | -- | -- |
CharacterStream | N/A | N/A | N/A | N/A | N/A | -- |
Array | N/A | N/A | N/A | N/A | N/A | -- |
Blob | N/A | N/A | N/A | N/A | N/A | N/A |
Table 18-80 Possibility of overflow when the getObject method is used (2/2)
getObject method | HiRDB data type | ||||
---|---|---|---|---|---|
DATE | TIME | TIMESTAMP | BINARY | BLOB | |
Byte | N/A | N/A | N/A | N/A | N/A |
Short | N/A | N/A | N/A | N/A | N/A |
Int | N/A | N/A | N/A | N/A | N/A |
Long | N/A | N/A | N/A | N/A | N/A |
Float | N/A | N/A | N/A | N/A | N/A |
Double | N/A | N/A | N/A | N/A | N/A |
BigDecimal | N/A | N/A | N/A | N/A | N/A |
Boolean | N/A | N/A | N/A | N/A | N/A |
String | -- | -- | -- | N/A | N/A |
Bytes | N/A | N/A | N/A | -- | -- |
Date | -- | N/A | -- | N/A | N/A |
Time | N/A | -- | -- | N/A | N/A |
Timestamp | -- | N/A | -- | N/A | N/A |
AsciiStream | N/A | N/A | N/A | -- | -- |
BinaryStream | N/A | N/A | N/A | -- | -- |
Object | -- | -- | -- | -- | -- |
CharacterStream | N/A | N/A | N/A | -- | -- |
Array | N/A | N/A | N/A | -- | -- |
Blob | N/A | N/A | N/A | -- | -- |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.