6. JDBC 4.2 API References#
java.sql.Connection#
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| createBlob() | 4.0 | X | Does not support creating LOB object in Connection phase | SQLFeatureNotSupported error occurred |
| createClob() | 4.0 | X | Does not support creating LOB object in Connection phase | SQLFeatureNotSupported error occurred |
| createNClob() | 4.0 | X | Does not support multinational language for CLOB object | SQLFeatureNotSupported error occurred |
| createSQLXML() | 4.0 | X | Does not support SQLXML type | SQLFeatureNotSupported error occurred |
| isValid(int timeout) | 4.0 | O | ||
| setClientInfo(String name, String value) | 4.0 | O | Altibase JDBC supports ApplicationName only among client attributes | |
| setClientInfo(Properties properties) | 4.0 | O | Supports ApplicationName only | |
| getClientInfo(String name) | 4.0 | O | Supports ApplicationName only | |
| getClientInfo() | 4.0 | O | Supports ApplicationName only | |
| createArrayOf(String typeName, Object[] elements) | 4.0 | X | Does not support Array type | SQLFeatureNotSupported error occurred |
| createStruct(String typeName, Object[] attributes) | 4.0 | X | Does not support Struct type | SQLFeatureNotSupported error occurred |
| setSchema(String schema) | 4.1 | X | Does not support schema | Can be just ignored without occurring an error according to specification |
| getSchema() | 4.1 | X | Does not support schema | Returns null instead of occurring an error |
| abort(Executor executor) | 4.1 | O | ||
| setNetworkTimeout(Executor executor, int milliseconds) | 4.1 | O | Executor can return NULL since SO_TIMEOUT socket option of TCP/IP connection is used internally | |
| getNetworkTimeout() | 4.1 | O | Synchronized with response_timeout property of JDBC and returns the property value of it |
java.sql.Wrapper#
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| unwrap(Class iface) | 4.0 | O | ||
| isWrapperFor(Class<?> iface) | 4.0 | O |
List of classes implementing java.sql.Wrapper interface in Altibase JDBC driver
- Altibase42Connection
- AltibaseStatement
- AltibaseResultSet
- AltibaseResultSetMetaData
- AltibaseDataSource
- AltibaseParameterMetaData
- Altibase42DatabaseMetaData
java.sql.Driver#
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| getParentLogger() | 4.1 | O |
java.sql.Statement#
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| setPoolable(boolean poolable) | 4.0 | O | Altibase JDBC does not support Statement Pool but flag setting is available | |
| isPoolable() | 4.0 | O | ||
| closeOnCompletion() | 4.1 | O | ||
| isCloseOnCompletion() | 4.1 | O | ||
| executeLargeBatch() | 4.2 | O | ||
| executeLargeUpdate(String sql) | 4.2 | O | ||
| getLargeMaxRows(long max) | 4.2 | O | ||
| setLargeMaxRows() | 4.2 | O | ||
| getLargeUpdateCount() | 4.2 | O |
java.sql.PreparedStatement#
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| setRowId(int parameterIndex, RowId x) | 4.0 | X | Does not support RowId | SQLFeatureNotSupported error occurred |
| setNString(int parameterIndex, String value) | 4.0 | O | ||
| setNClob(int parameterIndex, NClob value) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| setNClob(int parameterIndex, Reader reader) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| setNClob(int parameterIndex, Reader reader, long length) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| setClob(int parameterIndex, Reader reader) | 4.0 | O | ||
| setClob(int parameterIndex, Reader reader, long length) | 4.0 | O | ||
| setBlob(int parameterIndex, InputStream inputStream) | 4.0 | O | ||
| setBlob(int parameterIndex, InputStream inputStream, long length) | 4.0 | O | ||
| setSQLXML(int parameterIndex, SQLXML xmlObject) | 4.0 | X | Does not support XML type | SQLFeatureNotSupported error occurred |
| setNCharacterStream(int parameterIndex, Reader value) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| setNCharacterStream(int parameterIndex, Reader value, long length) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| setAsciiStream(int parameterIndex, InputStream x) | 4.0 | O | ||
| setAsciiStream(int parameterIndex, InputStream x, long length) | 4.0 | O | ||
| executeLargeUpdate() | 4.2 | O | ||
| setObject(int parameterIndex, Object x, SQLType targetSqlType) | 4.2 | O | ||
| setObject(int parameterIndex, Object x, SQLType targetSqlType, int scaleOrLength) | 4.2 | O |
java.sql.CallableStatement#
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| getRowId(int parameterIndex) | 4.0 | X | Does not support RowId | SQLFeatureNotSupported error occurred |
| getRowId(String parameterName) | 4.0 | X | Does not support RowId | SQLFeatureNotSupported error occurred |
| setRowId(String parameterName, RowId x) | 4.0 | X | Does not support RowId | SQLFeatureNotSupported error occurred |
| getNClob(int parameterIndex) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| getNClob(String parameterName) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| setNClob(String parameterName, NClob value) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| setNClob(String parameterName, Reader reader) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| setNClob(String parameterName, Reader reader, long length) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| setClob(String parameterName, Clob x) | 4.0 | O | ||
| setClob(String parameterName, Reader reader) | 4.0 | O | ||
| setClob(String parameterName, Reader reader, long length) | 4.0 | O | ||
| setBlob(String parameterName, Blob x) | 4.0 | O | ||
| setBlob(String parameterName, InputStream inputStream) | 4.0 | O | ||
| setBlob(String parameterName, InputStream inputStream, long, length) | 4.0 | O | ||
| setSQLXML(String parameterName, SQLXML xmlObject) | 4.0 | X | Does not support XML | SQLFeatureNotSupported error occurred |
| getSQLXML(int parameterIndex) | 4.0 | X | Does not support XML | SQLFeatureNotSupported error occurred |
| getSQLXML(String parameterName) | 4.0 | X | Does not support XML | SQLFeatureNotSupported error occurred |
| getNString(int parameterIndex) | 4.0 | O | ||
| getNString(String parameterName) | 4.0 | O | ||
| setNString(String parameterName, String value) | 4.0 | O | ||
| getNCharacterStream(int parameterIndex) | 4.0 | X | Does not support NClob type | SQLFeatureNotSupported error occurred |
| getNCharacterStream(String parameterName) | 4.0 | X | Does not support NClob type | SQLFeatureNotSupported error occurred |
| setNCharacterStream(String parameterName, Reader reader) | 4.0 | X | Does not support NClob type | SQLFeatureNotSupported error occurred |
| setNCharacterStream(String parameterName, Reader value, long length | 4.0 | X | Does not support NClob type | SQLFeatureNotSupported error occurred |
| getCharacterStream(int parameterIndex) | 4.0 | O | ||
| getCharacterStream(String parameterName) | 4.0 | O | ||
| setAsciiStream(String parameterName, InputStream x) | 4.0 | O | ||
| setAsciiStream(String parameterName, InputStream x, long length) | 4.0 | O | ||
| setBinaryStream(String parameterName, InputStream x) | 4.0 | O | ||
| setBinaryStream(String parameterName, InputStream x, long length) | 4.0 | O | ||
| setCharacterStream(String parameterName, Reader reader) | 4.0 | O | ||
| setCharacterStream(String parameterName, Reader reader, long length) | 4.0 | O | ||
| getObject(int parameterIndex, Class |
4.1 | O | ||
| getObject(String parameterName, Class |
4.1 | O | ||
| setObject(String parameterName, Object x, SQLType targetSqlType, int scaleOrLength) | 4.2 | O | ||
| setObject(String parameterName, Object x, SQLType targetSqlType) | 4.2 | O | ||
| registerOutParameter(int parameterIndex, SQLType sqlType) | 4.2 | O | ||
| registerOutParameter(int parameterIndex, SQLType sqlType, int scale) | 4.2 | O | ||
| registerOutParameter(int parameterIndex, SQLType sqlType, String typeName) | 4.2 | O | ||
| registerOutParameter(String parametername, SQLType sqlType | 4.2 | O | ||
| registerOutParameter(String parametername, SQLType sqlType, int scale) | 4.2 | O | ||
| registerOutParameter(String parametername, SQLType sqlType, String typeName) | 4.2 | O |
java.sql.PooledConnection#
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| addStatementEventListener(StatementEventListener listener) | 4.0 | X | Gets ignored because Statement Pool is not supported | |
| removeStatementEventListener(StatementEventListener listener) | 4.0 | X | Gets ignored because Statement Pool is not supported |
java.sql.ResultSet#
| Interface name | Specification Version | Supported | Details | Exception |
|---|---|---|---|---|
| getRowId(int columnIndex) | 4.0 | X | Does not support RowId | SQLFeatureNotSupported error occurred |
| getRowId(String columnLabel) | 4.0 | X | Does not support RowId | SQLFeatureNotSupported error occurred |
| updateRowId(int columnIndex, RowId x) | 4.0 | X | Does not support RowId | SQLFeatureNotSupported error occurred |
| updateRowId(String columnLabel, RowId x) | 4.0 | X | Does not support RowId | SQLFeatureNotSupported error occurred |
| updateNString(int columnIndex, String nString) | 4.0 | O | ||
| updateNString(String columnLabel, String nString) | 4.0 | O | ||
| updateNClob(int columnIndex, Reader reader) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| updateNClob(int columnIndex, Reader reader, long length) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| updateNClob(String columnLabel, Reader reader) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| updateNClob(String columnLabel, Reader reader, long length) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| updateNClob(int columnIndex, NClob nClob) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| updateNClob(String columnLabel, NClob nClob) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| getNClob(int columnIndex) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| getNClob(String columnLabel) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| getSQLXML(int columnIndex) | 4.0 | X | Does not support XML type | SQLFeatureNotSupported error occurred |
| getSQLXML(String columnLabel) | 4.0 | X | Does not support XML type | SQLFeatureNotSupported error occurred |
| updateSQLXML(int columnIndex, SQLXML xmlObject) | 4.0 | X | Does not support XML type | SQLFeatureNotSupported error occurred |
| updateSQLXML(String columnLabel, SQLXML xmlObject) | 4.0 | X | Does not support XML type | SQLFeatureNotSupported error occurred |
| getNString(int columnIndex) | 4.0 | O | ||
| getNString(String columnLabel) | 4.0 | O | ||
| getNCharacterStream(int columnIndex) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| getNCharacterStream(String columnLabel) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| updateNCharacterStream(int columnIndex, Reader x) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| updateNCharacterStream(int columnIndex, Reader x, long length) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| updateNCharacterStream(String columnLabel, Reader reader) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| updateNCharacterStream(String columnLabel, Reader reader, long length) | 4.0 | X | Does not support NCLOB type | SQLFeatureNotSupported error occurred |
| updateAsciiStream(int columnIndex, InputStream x) | 4.0 | O | ||
| updateAsciiStream(int columnIndex, InputStream x, long length) | 4.0 | O | ||
| updateAsciiStream(String columnLabel, InputStream x) | 4.0 | O | ||
| updateAsciiStream(String columnLabel, InputStream x, long length) | 4.0 | O | ||
| updateBinaryStream(int columnIndex, InputStream x) | 4.0 | O | ||
| updateBinaryStream(int columnIndex, InputStream x, long length) | 4.0 | O | ||
| updateBinaryStream(String columnLabel, InputStream x) | 4.0 | O | ||
| updateBinaryStream(String columnLabel, InputStream x, long length) | 4.0 | O | ||
| updateCharacterStream(int columnIndex, Reader x) | 4.0 | O | ||
| updateCharacterStream(int columnIndex, Reader x, long length) | 4.0 | O | ||
| updateCharacterStream(String columnLabel, Reader reader) | 4.0 | O | ||
| updateCharacterStream(String columnLabel, Reader reader, long length) | 4.0 | O | ||
| updateBlob(int columnIndex, InputStream inputStream) | 4.0 | O | ||
| updateBlob(int columnIndex, InputStream inputStream, long length) | 4.0 | O | ||
| updateBlob(String columnLabel, InputStream inputStream) | 4.0 | O | ||
| updateBlob(String columnLabel, InputStream inputStream, long length) | 4.0 | O | ||
| updateClob(int columnIndex, Reader reader) | 4.0 | O | ||
| updateClob(int columnIndex, Reader reader, long length) | 4.0 | O | ||
| updateClob(String columnLabel, Reader reader) | 4.0 | O | ||
| updateClob(String columnLabel, Reader reader, long length) | 4.0 | O | ||
| getObject(int columnIndex, Class |
4.1 | O | ||
| getObject(String columnLabel, Class |
4.1 | O |
javax.sql.CommonDataSource#
| Interface name | Specification Version | Supported | Details | Exception |
|---|---|---|---|---|
| getParentLogger() | 4.1 | O |
java.sql.DatabaseMetaData#
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| getRowIdLifetime() | 4.0 | X | Does not support RowId | SQLFeatureNotSupported error occurred |
| getSchemas(String catalog, String schemaPattern) | 4.0 | O | ||
| supportsStoredFunctionsUsingCallSyntax() | 4.0 | X | Returns false | |
| autoCommitFailureClosesAllResultSets() | 4.0 | X | Returns false | |
| getClientInfoProperties() | 4.0 | O | Supports ApplicationName only | |
| getFunctions(String catalog, String schemaPattern, String functionNamePattern) | 4.0 | O | ||
| getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern,String columnNamePattern) | 4.0 | O | ||
| getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) | 4.1 | X | SQLFeatureNotSupported error occurred | |
| generatedKeyAlwaysReturned() | 4.1 | X | Returns false |
java.sql.Blob#
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| getBinaryStream(long pos, long length) | 4.0 | O |
java.sql.Clob#
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| getCharacterStream(long pos, long length) | 4.0 | O |
java.sql.Types#
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| REF_CURSOR | 4.2 | X | Cannot use ref cursor as outbound parameter |
java.sql.DriverAction#
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| deregister() | 4.2 | x | Does not support releasing resources by deregister() |
java.sql.SQLTypes#
Altibase JDBC driver supports AltibaseJDBCType which implements java.sql.SQLTypes interface.
| Interface name | Specification Version | Supported | Details | Exceptions |
|---|---|---|---|---|
| getName() | 4.2 | O | ||
| getVendor() | 4.2 | O | ||
| getVendorTypeNumber() | 4.2 | O |
Java 8 Time API#
Altibase42.jar which supports JDBC 4.2 specification supports JAVA8 Time API by converting it to java.sql type as follows.
| Java 8 Time Class | Altibase JDBC |
|---|---|
| java.time.LocalDate | java.sql.Date |
| java.time.LocalTime | java.sql.Time |
| java.time.LocalDateTime | java.sql.TimeStamp |
| java.time.OffsetTime | Not supported |
| java.time.OffsetDateTime | Not supported |