Table of Contents |
---|
It is quite easy to convert java application from Oracle to ALTIBASE except SQL conversion
JDBC Driver
There're 4 types in JDBC driver.
Type | Comment |
---|---|
Type1 | JDBC-ODBC Bridge driver |
Type2 | Java + Native code driver |
Type3 | All Java + Middleware translation driver |
Type4 | Pure java driver |
ALTIBASE HDB only supports Type 4 JDBC Driver.
You can find ALTIBASE JDBC Driver, which is named "Altibase.jar" or "Altibase5.jar", in $ALTIBASE_HOME/lib.
Note |
---|
The drivers, Altibase.jar and Altibase5.jar, are totally identical except its package name. Altibase5.jar can be used if you have to connect to both ALTIBASE 4 and ALTIBASE 5. |
ALTIBASE JDBC Driver is compatible to JDBC 3.0 specification.
Connection
Here's are samples when you make a connection to ALTIBASE.
Code Block | ||
---|---|---|
| ||
try { /* Load ALTIBASE JDBC driver to JVM */ Class.forName("Altibase.jdbc.driver.AltibaseDriver"); /* Connect to ALTIBASE using url */ Connection cn = DriverManager.getConnection ("jdbc::Altibase:/127.0.0.1:20300/mydb?user=SYS&password=MANAGER&encoding=US7ASCII"); } catch (Exception ex ) { ex.printStackTrace(); } |
Type | value | Comment |
---|---|---|
Driver name | Altibase.jdbc.driver.AltibaseDriver | The driver used to connect to ALTIBASE |
URL | jdbc:Altibase://127.0.0.1:20300 | Connection string. It specifies the connecttion information |
ALTIBASE JDBC Driver Support
Followings are JDBC 3.0 specification.
Drivers
Return | Function Name | Support |
---|---|---|
boolean | acceptsURL(String url) | O |
Connection | connect(String url, Properties info) | O |
Int | getMajorversion() | O |
Int | getMinorVersion() | O |
DriverPropertyInfo[] | getPropertyInfo(String url, Properties info) | O |
boolean | jdbcCompliant() | O |
Connection
Return | Function Name | Support |
---|---|---|
void | clearWarnings() | O |
void | close() | O |
void | commit() | O |
Statement | createStatement() | O |
Statement | createStatement(int resultSetType, int resultSetConcurrency) | O |
Statement | createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) | X |
Boolean | getAutoCommit() | O |
String | getCatalog() |
|
int | getHoldability() | X |
DatabaseMetaData | getMetaData() | O |
int | getTransactionIsolation() | O |
Map | getTypeMap() | O |
SQLWarning | getWarnings() | O |
Boolean | isClosed() | O |
Boolean | isReadOnly() | O |
String | nativeSQL(String sql) | O |
CallableStatement | prepareCall(String sql) | O |
CallableStatement | prepareCall(String sql, int resultSetType, int resultSetConcurrency) | X |
CallableStatement | prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) | X |
PreparedStatement | prepareStatement(String sql) | X |
PreparedStatement | prepareStatement(String sql, int autoGeneratedKeys) |
|
PreparedStatement | prepareStatement(String sql, int[] columnIndexes) | X |
PreparedStatement | prepareStatement(String sql, int resultSetType, int resultSetConcurrency) | O |
PreparedStatement | prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) | X |
PreparedStatement | prepareStatement(String sql, String[] columnNames) | X |
void | releaseSavepoint(Savepoint savepoint) | O |
void | rollback() | O |
void | rollback(Savepoint savepoint) | O |
void | setAutoCommit(boolean autoCommit) | O |
void | setCatalog(String catalog) |
|
void | setHoldability(int holdability) | X |
void | setReadOnly(boolean readOnly | X |
Savepoint | setSavepoint() | O |
Savepoint | setSavepoint(String name) | O |
void | setTransactionIsolation(int level) | O |
void | setTypeMap(Map map) | X |
DatabaseMetaData
Return Type | Function Name | Support |
---|---|---|
Boolean | allProceduresAreCallable() | O |
Boolean | allTablesAreSelectable() | O |
Boolean | dataDefinitionCausesTransactionCommit() | O |
Boolean | dataDefinitionIgnoredInTransactions() | O |
Boolean | deletesAreDetected(int type) | O |
Boolean | doesMaxRowSizeIncludeBlobs() | O |
ResultSet | getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) Δ | |
ResultSet | getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) | O |
ResultSet | getCatalogs() | O |
String | getCatalogSeparator() | Δ |
String | getCatalogTerm() | Δ |
ResultSet | getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) | O |
ResultSet | getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) | O |
Connection | getConnection() | O |
ResultSet | getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) | O |
Int | getDatabaseMajorVersion() | O |
Int | getDatabaseMinorVersion() | O |
String | getDatabaseProductName() | O |
String | getDatabaseProductVersion() | O |
int | getDefaultTransactionIsolation() | O |
int | getDriverMajorVersion() | O |
int | getDriverMinorVersion() | O |
String | getDriverName() | O |
String | getDriverVersion() | O |
ResultSet | getExportedKeys(String catalog, String schema, String table) | O |
String | getExtraNameCharacters() Δ | |
String | getIdentifierQuoteString() Δ | |
ResultSet | getImportedKeys(String catalog, String schema, String table) | O |
ResultSet | getIndexInfo(String catalog, String schema, String table, Boolean unique, Boolean approximate) | O |
int | getJDBCMajorVersion() | O |
int | getJDBCMinorVersion() | O |
int | getMaxBinaryLiteralLength() | O |
int | getMaxCatalogNameLength() | O |
int | getMaxCharLiteralLength() | O |
int | getMaxColumnNameLength() | O |
Int | getMaxColumnsInGroupBy() | O |
Int | getMaxColumnsInIndex() | O |
int | getMaxColumnsInOrderBy() | O |
int | getMaxColumnsInSelect() | O |
int | getMaxColumnsInTable() | O |
int | getMaxConnections() | O |
int | getMaxCursorNameLength() | O |
int | getMaxIndexLength() | O |
int | getMaxProcedureNameLength() | O |
int | getMaxRowSize() | O |
int | getMaxSchemaNameLength() | O |
int | getMaxStatementLength() | O |
int | getMaxStatements() | O |
int | getMaxTableNameLength() | O |
int | getMaxTablesInSelect() | O |
int | getMaxUserNameLength() | O |
String | getNumericFunctions() | O |
ResultSet | getPrimaryKeys(String catalog, String schema, String table) | O |
ResultSet | getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) | O |
ResultSet | getProcedures(String catalog, String schemaPattern, String procedureNamePattern) | O |
String | getProcedureTerm() | O |
int | getResultSetHoldability() | O |
ResultSet | getSchemas() | O |
String | getSchemaTerm() | O |
String | getSearchStringEscape() | O |
String | getSQLKeywords() | O |
int | getSQLStateType() | O |
String | getStringFunctions() | O |
ResultSet | getSuperTables(String catalog, String schemaPattern, String tableNamePattern) X | |
ResultSet | getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) X | |
String | getSystemFunctions() | O |
ResultSet | getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) | O |
ResultSet | getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) | O |
ResultSet | getTableTypes() | O |
String | getTimeDateFunctions() | O |
ResultSet | getTypeInfo() | O |
ResultSet | getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) | O |
String | getURL() | O |
String | getUserName() | O |
ResultSet | getVersionColumns(String catalog, String schema, String table) X | |
boolean | insertsAreDetected(int type) | O |
boolean | isCatalogAtStart() | O |
boolean | isReadOnly() | O |
boolean | locatorsUpdateCopy() | O |
boolean | nullPlusNonNullIsNull() | O |
boolean | nullsAreSortedAtEnd() | O |
boolean | nullsAreSortedAtStart() | O |
boolean | nullsAreSortedHigh() | O |
boolean | nullsAreSortedLow() | O |
boolean | othersDeletesAreVisible(int type) | O |
boolean | othersInsertsAreVisible(int type) | O |
boolean | othersUpdatesAreVisible(int type) | O |
boolean | ownDeletesAreVisible(int type) | O |
boolean | ownInsertsAreVisible(int type) | O |
boolean | ownUpdatesAreVisible(int type) | O |
boolean | storesLowerCaseIdentifiers() | O |
boolean | storesLowerCaseQuotedIdentifiers() | O |
boolean | storesMixedCaseIdentifiers() | O |
boolean | storesMixedCaseQuotedIdentifiers() | O |
boolean | storesUpperCaseIdentifiers() | O |
boolean | storesUpperCaseQuotedIdentifiers() | O |
boolean | supportsAlterTableWithAddColumn() | O |
boolean | supportsAlterTableWithDropColumn() | O |
boolean | supportsANSI92EntryLevelSQL() | O |
boolean | supportsANSI92FullSQL() | O |
boolean | supportsANSI92IntermediateSQL() | O |
boolean | supportsBatchUpdates() | O |
boolean | supportsCatalogsInDataManipulation() | O |
boolean | supportsCatalogsInIndexDefinitions() | O |
boolean | supportsCatalogsInPrivilegeDefinitions() | O |
boolean | supportsCatalogsInProcedureCalls() | O |
boolean | supportsCatalogsInTableDefinitions() | O |
boolean | supportsColumnAliasing() | O |
boolean | supportsConvert() | O |
boolean | supportsConvert(int fromType, int toType) | O |
boolean | supportsCoreSQLGrammar() | O |
boolean | supportsCorrelatedSubqueries() | O |
boolean | supportsDataDefinitionAndDataManipulationTransactions() | O |
boolean | supportsDataManipulationTransactionsOnly() | O |
boolean | supportsDifferentTableCorrelationNames() | O |
boolean | supportsExpressionsInOrderBy() | O |
boolean | supportsExtendedSQLGrammar() | O |
boolean | supportsFullOuterJoins() | O |
boolean | supportsGetGeneratedKeys() | O |
boolean | supportsGroupBy() | O |
boolean | supportsGroupByBeyondSelect() | O |
boolean | supportsGroupByUnrelated() | O |
boolean | supportsIntegrityEnhancementFacility() | O |
boolean | supportsLikeEscapeClause() | O |
boolean | supportsLimitedOuterJoins() | O |
boolean | supportsMinimumSQLGrammar() | O |
boolean | supportsMixedCaseIdentifiers() | O |
boolean | supportsMixedCaseQuotedIdentifiers() | O |
boolean | supportsMultipleOpenResults() | O |
boolean | supportsMultipleResultSets() | O |
boolean | supportsMultipleTransactions() | O |
boolean | supportsNamedParameters() | O |
boolean | supportsNonNullableColumns() | O |
boolean | supportsOpenCursorsAcrossCommit() | O |
boolean | supportsOpenCursorsAcrossRollback() | O |
boolean | supportsOpenStatementsAcrossCommit() | O |
boolean | supportsOpenStatementsAcrossRollback() | O |
boolean | supportsOrderByUnrelated() | O |
boolean | supportsOuterJoins() | O |
boolean | supportsPositionedDelete() | O |
boolean | supportsPositionedUpdate() | O |
boolean | supportsResultSetConcurrency(int type, int concurrency) | O |
boolean | supportsResultSetHoldability(int holdability) | O |
boolean | supportsResultSetType(int type) | O |
boolean | supportsSavepoints() | O |
boolean | supportsSchemasInDataManipulation() | O |
boolean | supportsSchemasInIndexDefinitions() | O |
boolean | supportsSchemasInPrivilegeDefinitions() | O |
boolean | supportsSchemasInProcedureCalls() | O |
boolean | supportsSchemasInTableDefinitions() | O |
boolean | supportsSelectForUpdate() | O |
boolean | supportsStatementPooling() | O |
boolean | supportsStoredProcedures() | O |
boolean | supportsSubqueriesInComparisons() | O |
boolean | supportsSubqueriesInExists() | O |
boolean | supportsSubqueriesInIns() | O |
boolean | supportsSubqueriesInQuantifieds() | O |
boolean | supportsTableCorrelationNames() | O |
boolean | supportsTransactionIsolationLevel(int level) | O |
boolean | supportsTransactions() | O |
boolean | supportsUnion() | O |
boolean | supportsUnionAll() | O |
boolean | updatesAreDetected(int type) | O |
boolean | usesLocalFilePerTable() | O |
boolean | usesLocalFiles() | O |
ResultSet
Return | Function Name | Support |
---|---|---|
boolean | absolute(int row) | O |
void | afterLast() | O |
void | beforeFirst() | O |
void | cancelRowUpdates() | X |
void | clearWarnings() | O |
void | close() | O |
void | deleteRow() | X |
int | findColumn(String columnName) | O |
boolean | first() | O |
Array | getArray(int i) | X |
Array | getArray(String colName) | X |
InputStream | getAsciiStream(int columnIndex) | O |
InputStream | getAsciiStream(String columnName) | O |
BigDecimal | getBigDecimal(int columnIndex) | O |
BigDecimal | getBigDecimal(int columnIndex, int scale) | O |
BigDecimal | getBigDecimal(String columnName) | O |
BigDecimal | getBigDecimal(String columnName, int scale) | O |
InputStream | getBinaryStream(int columnIndex) | O |
InputStream | getBinaryStream(String columnName) | O |
Blob | getBlob(int i) | O |
Blob | getBlob(String colName) | O |
boolean | getBoolean(int columnIndex) | O |
boolean | getBoolean(String columnName) | O |
byte | getByte(int columnIndex) | O |
byte | getByte(String columnName) | O |
byte[] | getBytes(int columnIndex) | O |
byte[] | getBytes(String columnName) | O |
Reader | getCharacterStream(int columnIndex) | O |
Reader | getCharacterStream(String columnName) | O |
Clob | getClob(int i) | X |
Clob | getClob(String colName) | X |
int | getConcurrency() | O |
String | getCursorName() | X |
Date | getDate(int columnIndex) | O |
Date | getDate(int columnIndex, Calendar cal) | Δ |
Date | getDate(String columnName) | O |
Date | getDate(String columnName, Calendar cal) | Δ |
double | getDouble(int columnIndex) | O |
double | getDouble(String columnName) | O |
int | getFetchDirection() | O |
int | getFetchSize() | O |
float | getFloat(int columnIndex) | O |
float | getFloat(String columnName) | O |
int | getInt(int columnIndex) | O |
int | getInt(String columnName) | O |
long | getLong(int columnIndex) | O |
long | getLong(String columnName) | O |
ResultSetMetaData | getMetaData() | O |
Object | getObject(int columnIndex) | O |
Object | getObject(int i, Map map) | X |
Object | getObject(String columnName) | O |
Object | getObject(String colName, Map map) | X |
Ref | getRef(int i) | X |
Ref | getRef(String colName) | X |
int | getRow() | O |
short | getShort(int columnIndex) | O |
short | getShort(String columnName) | O |
Statement | getStatement() | O |
String | getString(int columnIndex) | O |
String | getString(String columnName) | O |
Time | getTime(int columnIndex) | O |
Time | getTime(int columnIndex, Calendar cal) | Δ |
Time | getTime(String columnName) | O |
Time | getTime(String columnName, Calendar cal) | Δ |
Timestamp | getTimestamp(int columnIndex) | O |
Timestamp | getTimestamp(int columnIndex, Calendar cal) | Δ |
Timestamp | getTimestamp(String columnName) | O |
Timestamp | getTimestamp(String columnName, Calendar cal) | Δ |
int | getType() | O |
InputStream | getUnicodeStream(int columnIndex) | X |
InputStream | getUnicodeStream(String columnName) | X |
URL | getURL(int columnIndex) | X |
URL | getURL(String columnName) | X |
SQLWarning | getWarnings() | O |
void | insertRow(). | X |
boolean | isAfterLast() | O |
boolean | isBeforeFirst() | O |
boolean | isFirst() | O |
boolean | isLast() | O |
boolean | last() | O |
void | moveToCurrentRow() | O |
void | moveToInsertRow() | X |
boolean | next() | O |
boolean | previous() | O |
void | refreshRow() | X |
boolean | relative(int rows) | O |
boolean | rowDeleted() | X |
boolean | rowInserted() | X |
boolean | rowUpdated() | X |
void | setFetchDirection(int direction) | Δ |
void | setFetchSize(int rows) | O |
void | updateArray(int columnIndex, Array x) | X |
void | updateArray(String columnName, Array x) | X |
void | updateAsciiStream(int columnIndex, InputStream x, int length) | X |
void | updateAsciiStream(String columnName, InputStream x, int length) | X |
void | updateBigDecimal(int columnIndex, BigDecimal x) | X |
void | updateBigDecimal(String columnName, BigDecimal x) | X |
void | updateBinaryStream(int columnIndex, InputStream x, int length) | X |
void | updateBinaryStream(String columnName, InputStream x, int length) | X |
void | updateBlob(int columnIndex, Blob x) | X |
void | updateBlob(String columnName, Blob x) | X |
void | updateBoolean(int columnIndex, Boolean x) | X |
void | updateBoolean(String columnName, Boolean x) | X |
void | updateByte(int columnIndex, byte x) | X |
void | updateByte(String columnName, byte x) | X |
void | updateBytes(int columnIndex, byte[] x) | X |
void | updateBytes(String columnName, byte[] x) | X |
void | updateCharacterStream(int columnIndex, Reader x, int length) | X |
void | updateCharacterStream(String columnName, Reader reader, int length) | X |
void | updateClob(int columnIndex, Clob x) | X |
void | updateClob(String columnName, Clob x) | X |
void | updateDate(int columnIndex, Date x) | X |
void | updateDate(String columnName, Date x) | X |
void | updateDouble(int columnIndex, double x) | X |
void | updateDouble(String columnName, double x) | X |
void | updateFloat(int columnIndex, float x) | X |
void | updateFloat(String columnName, float x) | X |
void | updateInt(int columnIndex, int x) | X |
void | updateInt(String columnName, int x) | X |
void | updateLong(int columnIndex, long x) | X |
void | updateLong(String columnName, long x) | X |
void | updateNull(int columnIndex) | X |
void | updateNull(String columnName) | X |
void | updateObject(int columnIndex, Object x) | X |
void | updateObject(int columnIndex, Object x, int scale) | X |
void | updateObject(String columnName, Object x) | X |
void | updateObject(String columnName, Object x, int scale) | X |
void | updateRef(int columnIndex, Ref x) | X |
void | updateRef(String columnName, Ref x) | X |
void | updateRow() | X |
void | updateShort(int columnIndex, short x) | X |
void | updateShort(String columnName, short x) | X |
void | updateString(int columnIndex, String x) | X |
void | updateString(String columnName, String x) | X |
void | updateTime(int columnIndex, Time x) | X |
void | updateTime(String columnName, Time x) | X |
void | updateTimestamp(int columnIndex, Timestamp x) | X |
void | updateTimestamp(String columnName, Timestamp x) | X |
boolean | wasNull() | O |
ResultSetMetaData
Return Type | Function Name | Support |
---|---|---|
String | getCatalogName(int column) | Δ |
String | getColumnClassName(int column) | O |
Int | getColumnCount() | O |
int | getColumnDisplaySize(int column) | O |
String | getColumnLabel(int column) | O |
String | getColumnName(int column) | O |
int | getColumnType(int column) | O |
String | getColumnTypeName(int column) | O |
int | getPrecision(int column) | O |
int | getScale(int column) | O |
String | getSchemaName(int column) | O |
String | getTableName(int column) | O |
boolean | isAutoIncrement(int column) | O |
boolean | isCaseSensitive(int column) | O |
boolean | isCurrency(int column) | O |
boolean | isDefinitelyWritable(int column) | O |
int | isNullable(int column) | O |
boolean | isReadOnly(int column) | O |
boolean | isSearchable(int column) | O |
boolean | isSigned(int column) | O |
boolean | isWritable(int column) | O |
Statement
Return Type | Function Name | Support |
---|---|---|
void | addBatch(String sql) | O |
void | cancel() | O |
void | clearBatch() | O |
void | clearWarnings() | O |
void | close() | O |
boolean | execute(String sql) | O |
boolean | execute(String sql, int autoGeneratedKeys) | Δ |
boolean | execute(String sql, int[] columnIndexes) | X |
boolean | execute(String sql, String[] columnNames) | X |
int[] | executeBatch() | O |
ResultSet | executeQuery(String sql) | O |
int | executeUpdate(String sql) | O |
int | executeUpdate(String sql, int autoGeneratedKeys) | X |
int | executeUpdate(String sql, int[] columnIndexes) | X |
int | executeUpdate(String sql, String[] columnNames) | X |
Connection | getConnection() | O |
int | getFetchDirection() | O |
int | getFetchSize() | O |
ResultSet | getGeneratedKeys() | X |
int | getMaxFieldSize() | O |
int | getMaxRows() | O |
boolean | getMoreResults() | O |
boolean | getMoreResults(int current) | O |
int | getQueryTimeout() | O |
ResultSet | getResultSet() | O |
int | getResultSetConcurrency() | O |
int | getResultSetHoldability() | O |
int | getResultSetType() | O |
int | getUpdateCount() | O |
SQLWarning | getWarnings() | O |
void | setCursorName(String name) | X |
void | setEscapeProcessing(Boolean enable) | X |
void | setFetchDirection(int direction) | Δ |
void | setFetchSize(int rows) | O |
void | setMaxFieldSize(int max) | O |
void | setMaxRows(int max) | O |
void | setQueryTimeout(int seconds) | O |
PreparedStatement
Return Type | Function Name | Support |
---|---|---|
void | addBatch() | O |
void | clearParameters() | O |
boolean | execute() | O |
ResultSet | executeQuery() | O |
int | executeUpdate() | O |
ResultSetMetaData | getMetaData() | O |
ParameterMetaData | getParameterMetaData() | X |
void | setArray(int i, Array x) | X |
void | setAsciiStream(int parameterIndex, InputStream x, int length) | O |
void | setBigDecimal(int parameterIndex, BigDecimal x) | O |
void | setBinaryStream(int parameterIndex, InputStream x, int length) | O |
void | setBlob(int i, Blob x) | O |
void | setBoolean(int parameterIndex, Boolean x) | O |
void | setByte(int parameterIndex, byte x) | O |
void | setBytes(int parameterIndex, byte[] x) | O |
void | setCharacterStream(int parameterIndex, Reader reader, int length) | O |
void | setClob(int i, Clob x) | X |
void | setDate(int parameterIndex, Date x) | O |
void | setDate(int parameterIndex, Date x, Calendar cal) | X |
void | setDouble(int parameterIndex, double x) | O |
void | setFloat(int parameterIndex, float x) | O |
void | setInt(int parameterIndex, int x) | O |
void | setLong(int parameterIndex, long x) | O |
void | setNull(int parameterIndex, int sqlType) | O |
Void | setNull(int paramIndex, int sqlType, String typeName) | O |
Void | setObject(int parameterIndex, Object x) | O |
Void | setObject(int parameterIndex, Object x, int targetSqlType) | O |
Void | setObject(int parameterIndex, Object x, int targetSqlType, int scale) | O |
void | setRef(int i, Ref x) | X |
void | setShort(int parameterIndex, short x) | O |
void | setString(int parameterIndex, String x) | O |
void | setTime(int parameterIndex, Time x) | O |
void | setTime(int parameterIndex, Time x, Calendar cal) | X |
void | setTimestamp(int parameterIndex, Timestamp x) | O |
void | setTimestamp(int parameterIndex, Timestamp x, Calendar cal) | X |
void | setUnicodeStream(int parameterIndex, InputStream x, int length) | X |
void | setURL(int parameterIndex, URL x) | X |
CallableStatement
Return Type | Function Name | Support |
---|---|---|
Array | getArray(int i) | X |
Array | getArray(String parameterName) | X |
BigDecimal | getBigDecimal(int parameterIndex) | O |
BigDecimal | getBigDecimal(int parameterIndex, int scale) | O |
BigDecimal | getBigDecimal(String parameterName) | X |
Blob | getBlob(int i) | O |
Blob | getBlob(String parameterName) | X |
boolean | getBoolean(int parameterIndex) | O |
boolean | getBoolean(String parameterName) | X |
byte | getByte(int parameterIndex) | O |
byte | getByte(String parameterName) | X |
byte[] | getBytes(int parameterIndex) | O |
byte[] | getBytes(String parameterName) | X |
Clob | getClob(int i) | X |
Clob | getClob(String parameterName) | X |
Date | getDate(int parameterIndex) | O |
Date | getDate(int parameterIndex, Calendar cal) | Δ |
Date | getDate(String parameterName) | O |
Date | getDate(String parameterName, Calendar cal) | Δ |
double | getDouble(int parameterIndex) | O |
double | getDouble(String parameterName) | X |
float | getFloat(int parameterIndex) | O |
float | getFloat(String parameterName) | X |
int | getInt(int parameterIndex) | O |
int | getInt(String parameterName) | X |
long | getLong(int parameterIndex) | O |
long | getLong(String parameterName) | X |
Object | getObject(int parameterIndex) | O |
Object | getObject(int i, Map map) | Δ |
Object | getObject(String parameterName) | X |
Object | getObject(String parameterName, Map map) | X |
Ref | getRef(int i) | X |
Ref | getRef(String parameterName) | X |
short | getShort(int parameterIndex) | O |
short | getShort(String parameterName) | X |
String | getString(int parameterIndex) | O |
String | getString(String parameterName) | X |
Time | getTime(int parameterIndex) | O |
Time | getTime(int parameterIndex, Calendar cal) | Δ |
Time | getTime(String parameterName) | X |
Time | getTime(String parameterName, Calendar cal) | X |
Timestamp | getTimestamp(int parameterIndex) | O |
Timestamp | getTimestamp(int parameterIndex, Calendar cal) | Δ |
Timestamp | getTimestamp(String parameterName) | X |
Timestamp | getTimestamp(String parameterName, Calendar cal) | X |
URL | getURL(int parameterIndex) | X |
URL | getURL(String parameterName) | X |
void | registerOutParameter(int parameterIndex, int sqlType) | O |
void | registerOutParameter(int parameterIndex, int sqlType, int scale) | O |
void | registerOutParameter(int paramIndex, int sqlType, String typeName) | O |
void | registerOutParameter(String parameterName, int sqlType) | X |
void | registerOutParameter(String parameterName, int sqlType, int scale) | X |
void | registerOutParameter(String parameterName, int sqlType, String typeName) | X |
void | setAsciiStream(String parameterName, InputStream x, int length) | X |
void | setBigDecimal(String parameterName, BigDecimal x) | X |
void | setBinaryStream(String parameterName, InputStream x, int length) | X |
void | setBoolean(String parameterName, Boolean x) | X |
void | setByte(String parameterName, byte x) | X |
void | setBytes(String parameterName, byte[] x) | X |
void | setCharacterStream(String parameterName, Reader reader, int length) | X |
void | setDate(String parameterName, Date x) | X |
void | setDate(String parameterName, Date x, Calendar cal) | X |
void | setDouble(String parameterName, double x) | X |
void | setFloat(String parameterName, float x) | X |
void | setInt(String parameterName, int x) | X |
void | setLong(String parameterName, long x) | X |
void | setNull(String parameterName, int sqlType) | X |
void | setNull(String parameterName, int sqlType, String typeName) | X |
void | setObject(String parameterName, Object x) | X |
void | setObject(String parameterName, Object x, int targetSqlType) | X |
void | setObject(String parameterName, Object x, int targetSqlType, int scale) | X |
void | setShort(String parameterName, short x) | X |
void | setString(String parameterName, String x) | X |
void | setTime(String parameterName, Time x) | X |
void | setTime(String parameterName, Time x, Calendar cal) | X |
void | setTimestamp(String parameterName, Timestamp x) | X |
void | setTimestamp(String parameterName, Timestamp x, Calendar cal) | X |
void | setURL(String parameterName, URL val) | X |
boolean | wasNull() | O |
Blob
Return Type | Function Name | Support |
---|---|---|
InputStream | getBinaryStream() | O |
byte[] | getBytes(long pos, int length) | O |
long | length() | O |
long | position(Blob pattern, long start) | X |
long | position(byte[] pattern, long start) | X |
OutputStream | setBinaryStream(long pos) | O |
int | setBytes(long pos, byte[] bytes) | O |
int | setBytes(long pos, byte[] bytes, int offset, int len) | O |
void | truncate(long len) | O |
Clob
Return Type | Function Name | Support |
---|---|---|
int | setString(long pos, String str) | O |
int | setString(long pos, String str, int offset, int len) | O |
SavePoint
Return Type | Function Name | Support |
---|---|---|
int | getSavepointId() | O |
String | getSavepointName() | O |
ConnectionPoolDataSource
Return Type | Function Name | Support |
---|---|---|
int | getLoginTimeout() | O |
PrintWriter | getLogWriter() | O |
PooledConnection | getPooledConnection() | O |
PooledConnection | getPooledConnection(String user, String password) | O |
void | setLoginTimeout(int seconds) | O |
void | setLogWriter(PrintWriter out) | O |
DataSource
Return Type | Function Name | Support |
---|---|---|
Connection | getConnection() | O |
Connection | getConnection(String username, String password) | O |
int | getLoginTimeout() | O |
PrintWriter | getLogWriter() | O |
void | setLoginTimeout(int seconds) | O |
void | setLogWriter(PrintWriter out) | O |
PooledConnection
Return Type | Function Name | Support |
---|---|---|
void | addConnectionEventListener(ConnectionEventListener listener) | O |
void | close() | O |
Connection | getConnection() | O |
void | removeConnectionEventListener(ConnectionEventListener listener) | O |
XAConnection
Return Type | Function Name | Support |
---|---|---|
XAResource | getXAResource() | O |
XADataSource
Return Type | Function Name | Support |
---|---|---|
int | getLoginTimeout() | X |
PrintWriter | getLogWriter() | O |
XAConnection | getXAConnection() | O |
XAConnection | getXAConnection(String user, String password) | O |
void | setLoginTimeout(int seconds) | X |
void | setLogWriter(PrintWriter out) | O |
XAResource
Return Type | Function Name | Support |
---|---|---|
void | commit(Xid xid, Boolean onePhase) | O |
void | end(Xid xid, int flags) | O |
void | forget(Xid xid) | O |
int | getTransactionTimeout() | O |
boolean | isSameRM(XAResource xares) | O |
int | prepare(Xid xid) | O |
Xid[] | recover(int flag) | O |
void | rollback(Xid xid) | O |
boolean | setTransactionTimeout(int seconds) | X |
void | start(Xid xid, int flags) | O |
Xid
Return Type | Function Name | Support |
---|---|---|
byte[ ] | getBranchQualfier() | O |
Int | getFormatId() | O |
byte[ ] | getGlobalTransactionId() | O |