When retrieving values from a ResultSet in the Polypheny JDBC Driver, conversions occur from the Polypheny internal types to java native ones. Further, a secondary layer of conversion can be applied to interpret stored data as a certain java native type. For example, a double precision floating-point number might be retrieved as a string to offer a print friendly format.
The matrix below shows which getters of a ResultSet can be applied to values of different Polypheny internal types.
| Method | Enum Values |
|---|---|
| getString() | BOOLEAN, INTEGER, LONG, BIG_DECIMAL, FLOAT, DOUBLE, DATE, TIME, TIMESTAMP, INTERVAL, BINARY, NULL, LIST, FILE, DOCUMENT |
| getBoolean() | BOOLEAN, STRING (with values “0” or “1”), INTEGER (with values 0 or 1), LONG (with values 0 or 1) |
| getByte() | INTEGER, LONG |
| getShort() | INTEGER, LONG |
| getInt() | INTEGER, LONG, BIG_DECIMAL |
| getLong() | LONG, INTEGER |
| getFloat() | FLOAT, DOUBLE, BIG_DECIMAL |
| getDouble() | DOUBLE, FLOAT, BIG_DECIMAL |
| getBigDecimal() | BIG_DECIMAL |
| getBytes() | BINARY |
| getAsciiStream() | STRING |
| getUnicodeStream() | STRING |
| getBinaryStream() | FILE (Blob) |
| getDocument() | DOCUMENT |
| getInterval() | INTERVAL |
| getObject() | BOOLEAN, INTEGER, LONG, BIG_DECIMAL, FLOAT, DOUBLE, DATE, TIME, TIMESTAMP, INTERVAL, STRING, BINARY, NULL, LIST, DOCUMENT, FILE |
| getObject(Calendar calendar) | BOOLEAN, INTEGER, LONG, BIG_DECIMAL, FLOAT, DOUBLE, DATE, TIME, TIMESTAMP, INTERVAL, STRING, BINARY, NULL, LIST, DOCUMENT, FILE |
| getCharacterStream() | STRING |
| getBlob() | FILE (Blob) |
| getClob() | STRING |
| getArray() | LIST |
| getStruct() | None (throws exception) |
| getDate() | DATE |
| getDate(Calendar calendar) | DATE |
| getTime() | TIME |
| getTime(Calendar calendar) | TIME |
| getTimestamp() | TIMESTAMP |
| getTimestamp(Calendar calendar) | TIMESTAMP |
| getRef() | None (throws exception) |
| getRowId() | ROW_ID |
| getUrl() | None (throws exception) |
| getNClob() | STRING |
| getSQLXML() | None (throws exception) |
| getNString() | STRING |
| getNCharacterStream() | STRING |
© Polypheny GmbH. All Rights Reserved.