| The Easysoft JDBC-ODBC Bridge supports the following JDBC 2.1 Core Classes: |
|
Driver Connection Statement ResultSet ResultSetMetaData DatabaseMetaData PreparedStatement CallableStatement |
| Methods that are currently not supported. Most of these methods relate to SQL 3 data types that are not supported by most current ODBC Drivers. |
|
Driver Connection Statement ResultSet ResultSetMetaData DatabaseMetaData PreparedStatement CallableStatement |
| SQL |
| JDBC 2 Supported Data Types JDBC 2 Unsupported Data Types |
| boolean | acceptsURL(String url) |
| Connection | connect(String url, Properties info) |
| int | getMajorVersion() |
| int | getMinorVersion() |
| DriverPropertyInfo[] | getPropertyInfo(String url, java.util.Properties info) |
| boolean | jdbcCompliant() |
| void | clearWarnings() |
| void | close() |
| void | commit() |
| Statement | createStatement() |
| Statement | createStatement(int resultSetType, int resultSetConcurrency) |
| boolean | getAutoCommit() |
| String | getCatalog() |
| DatabaseMetaData | getMetaData() |
| int | getTransactionIsolation() |
| SQLWarnings | getWarnings() |
| boolean | isClosed() |
| boolean | isReadOnly() |
| String | nativeSQL(String sql) |
| CallableStatement | prepareCall(String sql) |
| PreparedStatement | prepareStatement(String sql) |
| void | rollback() |
| void | setAutoCommit(boolean autoCommit) |
| void | setCatalog(String catalog) |
| void | setReadOnly(boolean readOnly) |
| void | setTransactionIsolation(int level) |
| void | cancel() |
| void | clearWarnings() |
| void | close() |
| boolean | execute(String sql) |
| ResultSet | executeQuery(String sql) |
| int | executeUpdate(String sql) |
| Connection | getConnection() |
| int | getFetchDirection() |
| int | getFetchSize() |
| int | getMaxFieldSize() |
| int | getMaxRows() |
| boolean | getMoreResults() |
| int | getQueryTimeout() |
| ResultSet | getResultSet() |
| int | getResultSetConcurrency() |
| int | getResultSetType() |
| int | getUpdateCount() |
| SQLWarning | getWarnings() |
| void | setCursorName(String name) |
| void | setEscapeProcessing(boolean enable) |
| void | setFetchDirection(int direction) |
| void | setFetchSize(int rows) |
| void | setMaxFieldSize(int max) |
| void | setMaxRows(int max) |
| void | setQueryTimeout() |
| boolean | absolute( int row ) |
| void | afterLast() |
| void | beforeFirst() |
| void | cancelRowUpdates () |
| void | clearWarnings() |
| void | close() |
| void | deleteRow() |
| int | findColumn(String columnName) |
| boolean | first() |
| InputStream | getAsciiStream() |
| InputStream | getAsciiStream(String columnName) |
| BigDecimal | getBigDecimal(int columnIndex) |
| BigDeciman | getBigDecimal(int columnIndex, int scale) |
| BigDecimal | getBigDecimal(String columnName) |
| BigDecimal | getBigDecimal(String columnName, int scale) |
| InputStream | getBinaryStream(int columnIndex) |
| InputStream | getBinaryStream(String columnName) |
| boolean | getBoolean(int columnIndex) |
| boolean | getBoolean(String columnName) |
| byte | getByte(int columnIndex) |
| byte | getByte(String columnName) |
| byte[] | getBytes(int columnIndex) |
| byte[] | getBytes(String columnName) |
| java.io.Reader | getCharacterStream(int columnIndex) |
| java.io.Reader | getCharacterStream(String columnName) |
| int | getConcurrency() |
| String | getCursorName() |
| java.sql.Date | getDate(int columnIndex) |
| Object | getObject(int i, java.util.Map map) |
| java.sql.Date | getDate(String columnName) |
| java.sql.Date | getDate(int columnIndex, Calendar cal) |
| double | getDouble(int columnIndex) |
| double | getDouble(String columnName) |
| int | getFetchDirection() |
| int | getFetchSize() |
| float | getFloat(int columnIndex) |
| float | getFloat(String columnName) |
| int | getInt(int columnIndex) |
| int | getInt(String columnName) |
| long | getLong(int columnIndex) |
| long | getLong(String columnName) |
| ResultSetMetaData | getMetaData() |
| Object | getObject(int columnIndex) |
| Object | getObject(int column, int type) |
| Object | getObject(String columnName) |
| int | getRow() |
| short | getShort(int columnIndex) |
| short | getShort(String columnName) |
| Statement | getStatement() |
| String | getString(int columnIndex) |
| String | getString(String columnName) |
| java.sql.Time | getTime(int columnIndex) |
| java.sql.Time | getTime(String columnName) |
| java.sql.Timestamp | getTimestamp(int columnIndex) |
| java.sql.Timestamp | getTimestamp(String columnName) |
| int | getType() |
| java.io.InputStream | getUnicodeStream(int columnIndex) |
| java.io.InputStream | getUnicodeStream(String columnName) |
| SQLWarning | getWarnings() |
| void | insertRow() |
| boolean | isAfterLast() |
| boolean | isBeforeFirst() |
| boolean | isFirst() |
| boolean | isLast() |
| boolean | last() |
| void | moveToCurrentRow() |
| void | moveToInsertRow() |
| boolean | next() |
| boolean | previous() |
| void | refreshRow() |
| boolean | rowUpdated() |
| void | setFetchDirection(int direction) |
| void | setFetchSize(int rows) |
| void | updateAsciiStream(String columnName, InputStream x, int length) |
| void | updateBigDecimal(int columnIndex, BigDecimal x) |
| void | updateBigDecimal(String columnName, BigDecimal x) |
| void | updateBinaryStream() |
| void | updateBoolean(int columnIndex, boolean x) |
| void | updateBoolean(String columnName, boolean x) |
| void | updateByte(int columnIndex, byte x) |
| void | updateByte(String columnName, byte x) |
| void | updateBytes(String columnName, byte x[]) |
| void | updateDate(int columnIndex, java.sql.Date x) |
| void | updateDouble(int columnIndex, double x) |
| void | updateDouble(String columnName, double x) |
| void | updateFloat(int columnIndex, float x) |
| void | updateFloat(String columnName, float x) |
| void | updateInt(int columnIndex, int x) |
| void | updateInt(String columnName, int x) |
| void | updateLong(int columnIndex, long x) |
| void | updateLong(String columnName, long x) |
| void | updateObject(int columnIndex, Object x) |
| void | updateObject(int columnIndex, Object x, int scale) |
| void | updateObject(String columnName, Object x) |
| void | updateObject(String columnName, Object x, int scale) |
| void | updateRow() |
| void | updateShort(int columnIndex, short x) |
| void | updateShort(String columnName, short x) |
| void | updateString(int columnIndex, String x) |
| void | updateString(String columnName, String x) |
| void | updateTime(int columnIndex, java.sql.Time x) |
| void | updateTime(String columnName, java.sql.Time x) |
| boolean | wasNull() |
| String | getCatalogName(int column) |
| int | getColumnCount() |
| int | getColumnDisplaySize(int column) |
| String | getColumnLabel(int column) |
| String | getColumnName(int column) |
| int | getColumnType(int column) |
| String | getColumnTypeName(int column) |
| int | getNumPrecRadix(int column) |
| int | getPrecision(int column) |
| int | getScale(int column) |
| String | getSchemaName(int column) |
| String | getTableName(int column) |
| boolean | isAutoIncrement(int column) |
| boolean | isCaseSensitive(int column) |
| boolean | isCurrency(int column) |
| boolean | isDefinitelyWritable(int column) |
| int | isNullable(int column) |
| boolean | isReadOnly(int column) |
| boolean | isSearchable(int column) |
| boolean | isSigned(int column) |
| boolean | isWritable(int column) |
| boolean | allProceduresAreCallable() |
| boolean | allTablesAreSelectable() |
| boolean | dataDefinitionCausesTransactionCommit() |
| boolean | dataDefinitionIgnoredInTransactions() |
| boolean | doesMaxRowSizeIncludeBlobs() |
| ResultSet | getBestRowIdentifier(...) |
| ResultSet | getCatalogs() |
| String | getCatalogSeparator() |
| String | getCatalogTerm() |
| ResultSet | getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) |
| ResultSet | getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) |
| Connection | getConnection() |
| ResultSet | getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) |
| String | getDatabaseProductName() |
| String | getDatabaseProductVersion() |
| int | getDefaultTransactionIsolation() |
| int | getDriverMajorVersion() |
| int | getDriverMinorVersion() |
| String | getDriverName() |
| String | getDriverVersion() |
| ResultSet | getExportedKeys(String catalog, String schema, String table) |
| String | getExtraNameCharacters() |
| String | getIdentifierQuoteString() |
| ResultSet | getImportedKeys(String catalog, String schema, String table) |
| ResultSet | getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) |
| int | getMaxBinaryLiteralLength() |
| int | getMaxCatalogNameLength() |
| int | getMaxCharLiteralLength() |
| int | getMaxColumnNameLength() |
| int | getMaxColumnsInGroupBy |
| int | getMaxColumnsInIndex() |
| int | getMaxColumnsInOrderBy() |
| int | getMaxColumnsInSelect() |
| int | getMaxColumnsInTable() |
| int | getMaxConnections() |
| int | getMaxCursorNameLength() |
| int | getMaxIndexLength() |
| int | getMaxProcedureNameLength() |
| int | getMaxRowSize() |
| int | getMaxSchemaNameLength() |
| int | getMaxStatementLength() |
| int | getMaxStatements() |
| int | getMaxTableNameLength() |
| int | getMaxTablesInSelect() |
| int | getMaxUserNameLength() |
| String | getNumericFunctions() |
| ResultSet | getPrimaryKeys(String catalog, String schema, String table) |
| ResultSet | getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) |
| ResultSet | getProcedures(String catalog, String schemaPattern, String procedureNamePattern) |
| String | getProcedureTerm() |
| ResultSet | getSchemas() |
| String | getSchemaTerm() |
| String | getSearchStringEscape() |
| String | getSQLKeywords() |
| String | getStringFunctions |
| String | getSystemFunctions() |
| ResultSet | getTablePrivileges(String catalog, String schemaPattern,String tableNamePattern) |
| ResultSet | getTables(String catalog, String schemaPattern, String tableNamePattern, String types[]) |
| ResultSet | getTableTypes() |
| String | getTimeDateFunctions() |
| ResultSet | getTypeInfo() |
| String | getURL() |
| String | getUserName() |
| ResultSet | getVersionColumnsString catalog, String schema, String table) |
| boolean | isCatalogAtStart() |
| boolean | isReadOnly() |
| boolean | nullPlusNonNullIsNull() |
| boolean | nullsAreSortedAtEnd() |
| boolean | nullsAreSortedAtStart() |
| boolean | nullsAreSortedHigh() |
| boolean | nullsAreSortedLow() |
| boolean | storesLowerCaseIdentifiers() |
| boolean | storesLowerCaseQuotedIdentifier() |
| boolean | storesMixedCaseIdentifiers() |
| boolean | storesMixedCaseQuotedIdentifiers() |
| boolean | storesUpperCaseIdentifiers() |
| boolean | storesUpperCaseQuotedIdentifiers() |
| boolean | supportsAlterTableWithAddColumn() |
| boolean | supportsAlterTableWithDropColumn() |
| boolean | supportsANSI92EntryLevelSQL() |
| boolean | supportsANSI92FullSQL() |
| boolean | supportsANSI92IntermediateSQL() |
| boolean | supportsBatchUpdates() |
| boolean | supportsCatalogsInDataManipulation() |
| boolean | supportsCatalogsInIndexDefinitions() |
| boolean | supportsCatalogsInPrivilegeDefinitions() |
| boolean | supportsCatalogsInProcedureCalls() |
| boolean | supportsCatalogsInTableDefinitions() |
| boolean | supportsColumnAliasing() |
| boolean | supportsConvert() |
| boolean | supportsConvert(int fromType, int toType) |
| boolean | supportsCoreSQLGrammar() |
| boolean | supportsCorrelatedSubqueries() |
| boolean | supportsDataDefinitionAndDataManipulationTransactions() |
| boolean | supportsDataManipulationTransactionsOnly() |
| boolean | supportsDifferentTableCorrelationNames() |
| boolean | supportsExpressionsInOrderBy |
| boolean | supportsExtendedSQLGrammar() |
| boolean | supportsFullOuterJoins() |
| boolean | supportsGroupBy() |
| boolean | supportsGroupByBeyondSelect() |
| boolean | supportsGroupByUnrelated() |
| boolean | supportsIntegrityEnhancementFacility() |
| boolean | supportsLikeEscapeClause() |
| boolean | supportsLimitedOuterJoins() |
| boolean | supportsMinimumSQLGrammar() |
| boolean | supportsMixedCaseIdentifiers() |
| boolean | supportsMixedCaseQuotedIdentifiers() |
| boolean | supportsMultipleResultSets() |
| boolean | supportsMultipleTransactions() |
| boolean | supportsNonNullableColumns() |
| boolean | supportsOpenCursorsAcrossCommit() |
| boolean | supportsOpenCursorsAcrossRollback() |
| boolean | supportsOpenStatementsAcrossCommit() |
| boolean | supportsOpenStatementsAcrossRollback() |
| boolean | supportsOrderByUnrelated() |
| boolean | supportsOuterJoins() |
| boolean | supportsPositionedDelete() |
| boolean | supportsPositionedUpdate() |
| boolean | supportsResultSetConcurrency(int type, int concurrency) |
| boolean | supportsResultSetType(int type) |
| boolean | supportsSchemasInDataManipulation() |
| boolean | supportsSchemasInIndexDefinitions() |
| boolean | supportsSchemasInPrivilegeDefinitions() |
| boolean | supportsSchemasInProcedureCalls() |
| boolean | supportsSchemasInTableDefinitions() |
| boolean | supportsSelectForUpdate() |
| boolean | supportsStoredProcedures() |
| boolean | supportsSubqueriesInComparisons() |
| boolean | supportsSubqueriesInExists() |
| boolean | supportsSubqueriesInIns() |
| boolean | supportsSubqueriesInQuantifieds() |
| boolean | supportsTableCorrelationNames() |
| boolean | supportsTransactionIsolationLevel(int level) |
| boolean | supportsTransactions() |
| boolean | supportsUnion() |
| boolean | supportsUnionAll() |
| boolean | usesLocalFilePerTable() |
| boolean | usesLocalFiles() |
| void | setCharacterStream(int parameterIndex, java.io.Reader reader, int length) |
| public | ResultSetMetaData getMetaData() |
| void | clearParameters() |
| boolean | execute() |
| ResultSet | executeQuery() |
| int | executeUpdate() |
| void | setAsciiStream(int parameterIndex, java.io.InputStream x, int length) |
| void | setBigDecimal(int parameterIndex, BigDecimal x) |
| void | setBinaryStream(int parameterIndex, java.io.InputStream x, int length) |
| void | setBoolean(int parameterIndex, boolean x) |
| void | setByte(int parameterIndex, byte x) |
| void | setBytes(int parameterIndex, byte x[]) |
| void | setDate(int parameterIndex, java.sql.Date x) |
| void | setDouble(int parameterIndex, double x) |
| void | setFloat(int parameterIndex, float x) |
| void | setInt(int parameterIndex, int x) |
| void | setLong(int parameterIndex, long x) |
| void | setNull(int parameterIndex, int sqlType) |
| void | setObject(int i, Object x) |
| void | setObject(int parameterIndex, Object x, int targetSqlType) |
| void | setObject(int parameterIndex, Object x, int targetSqlType, int scale) |
| void | setShort(int parameterIndex, short x) |
| void | setString(int parameterIndex, String x) |
| void | setTime(int parameterIndex, java.sql.Time x) |
| void | setTimestamp(int parameterIndex, java.sql.Timestamp x) |
| void | setUnicodeStream(int parameterIndex, java.io.InputStream x, int length) |
| BigDecimal | getBigDecimal(int parameterIndex) |
| Object | getObject (int i, java.util.Map map) |
| BigDecimal | getBigDecimal(int parameterIndex) |
| boolean | getBoolean(int parameterIndex) |
| byte | getByte(int parameterIndex) |
| byte[] | getBytes(int parameterIndex) |
| java.sql.Date | getDate(int parameterIndex) |
| double | getDouble(int parameterIndex) |
| float | getFloat(int parameterIndex) |
| int | getInt(int parameterIndex) |
| long | getLong(int parameterIndex) |
| Object | getObject(int parameterIndex) |
| short | getShort(int parameterIndex) |
| getString(int | parameterIndex) |
| java.sql.Time | getTime(int parameterIndex) |
| void | registerOutParameter(int parameterIndex, int sqlType, int scale) |
| boolean | wasNull() |
| void | registerOutParameter (int paramIndex, int sqlType, String typeName) |
| java.util.Map | getTypeMap() |
| void | setTypeMap(java.util.Map map) |
| CallableStatement | prepareCall(String sql, int resultSetType, int resultSetConcurrency) |
| PreparedStatement | prepareStatement(String sql, int resultSetType, int resultSetConcurrency) |
| void | addBatch( String sql ) |
| void | clearBatch() |
| int[] | executeBatch() |
| Ref | getRef(int i) |
| Blob | getBlob(int i) |
| Clob | getClob(int i) |
| Array | getArray(int i) |
| Object | getObject(String colName, java.util.Map map) |
| Ref | getRef(String colName) |
| Blob | getBlob(String colName) |
| Clob | getClob(String colName) |
| Array | getArray(String colName) |
| java.sql.Date | getDate(int columnIndex, Calendar cal) |
| java.sql.Time | getTime(int columnIndex, Calendar cal) |
| java.sql.Time | getTime(String columnName, Calendar cal) |
| java.sql.Timestamp | getTimestamp(int columnIndex, Calendar cal) |
| java.sql.Timestamp | getTimestamp(String columnName, Calendar cal) |
| boolean | rowDeleted() |
| boolean | rowInserted() |
| void | updateAsciiStream(int columnIndex, InputStream x, int length) |
| void | updateBinaryStream(int columnIndex, InputStream x, int length) |
| void | updateBytes(int columnIndex, byte x[]) |
| void | updateCharacterStream(int columnIndex, java.io.Reader x, int length) |
| void | updateCharacterStream(String columnName, java.io.Reader reader, int length) |
| void | updateDate(String columnName, java.sql.Date x) |
| void | updateNull(int columnIndex) |
| void | updateNull(String columnName) |
| void | updateTimestamp(int columnIndex, java.sql.Timestamp x) |
| void | updateTimestamp(String columnName, java.sql.Timestamp x) |
| String | getColumnClassName(int column) |
| boolean | deletesAreDetected(int type) |
| ResultSet | getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) |
| boolean | insertsAreDetected(int type) |
| boolean | othersDeletesAreVisible(int type) |
| boolean | othersInsertsAreVisible(int type) |
| boolean | othersUpdatesAreVisible(int type) |
| boolean | ownDeletesAreVisible(int type) |
| boolean | ownInsertsAreVisible(int type) |
| boolean | ownUpdatesAreVisible(int type) |
| boolean | updatesAreDetected(int type) |
| void | addBatch() |
| void | setRef (int i, Ref x) |
| void | setBlob (int i, Blob x) |
| void | setClob (int i, Clob x) |
| void | setArray (int i, Array x) |
| void | setDate(int parameterIndex, java.sql.Date x, Calendar cal) |
| void | setTime(int parameterIndex, java.sql.Time x, Calendar cal) |
| void | setTimestamp(int parameterIndex, java.sql.Timestamp x, Calendar cal) |
| void | setNull (int paramIndex, int sqlType, String typeName) |
| Ref | getRef (int i) |
| Blob | getBlob (int i) |
| Clob | getClob (int i) |
| Array | getArray (int i) |
| java.sql.Date | getDate(int parameterIndex, Calendar cal) |
| java.sql.Time | getTime(int parameterIndex, Calendar cal) |
| java.sql.Timestamp | getTimestamp(int parameterIndex, Calendar cal) |