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.

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