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.
ALTIBASE JDBC Driver is compatible to JDBC 3.0 specification.
Connection
Here's are samples when you make a connection to ALTIBASE.
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 |