Created with Raphaël 2.1.0
    Loading...
Skip to end of metadata
Go to start of metadata


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.

Icon

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.

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

  • No labels