Overview | Package | Class | Use | Tree | Deprecated | Index | Help
| JavaTM 2 Platform Std. Ed. v1.3.1
PREV NEXT | FRAMES NO FRAMES

## Uses of Class
java.sql.SQLException

Packages that use SQLException
java.sql | Provides the API for accessing and processing data in a data source using the JavaTM programming language.

Uses of SQLException in java.sql

Subclasses of SQLException in java.sql
`class` | `BatchUpdateException` An exception thrown when an error occurs during a batch update operation.
`class` | `DataTruncation` An exception that reports a DataTruncation warning (on reads) or throws a DataTruncation exception (on writes) when JDBC unexpectedly truncates a data value.
`class` | `SQLWarning` An exception that provides information on database access warnings.

Methods in java.sql that return SQLException
`SQLException` | `SQLException.getNextException()` Retrieves the exception chained to this `SQLException` object.

Methods in java.sql with parameters of type SQLException
`void` | `SQLException.setNextException(SQLException ex)` Adds an `SQLException` object to the end of the chain.

Methods in java.sql that throw SQLException
`ResultSet` | `Statement.executeQuery(String sql)` Executes an SQL statement that returns a single `ResultSet` object.
`int` | `Statement.executeUpdate(String sql)` Executes an SQL `INSERT`, `UPDATE` or `DELETE` statement.
`void` | `Statement.close()` Releases this `Statement` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
`int` | `Statement.getMaxFieldSize()` Returns the maximum number of bytes allowed for any column value.
`void` | `Statement.setMaxFieldSize(int max)` Sets the limit for the maximum number of bytes in a column to the given number of bytes.
`int` | `Statement.getMaxRows()` Retrieves the maximum number of rows that a `ResultSet` object can contain.
`void` | `Statement.setMaxRows(int max)` Sets the limit for the maximum number of rows that any `ResultSet` object can contain to the given number.
`void` | `Statement.setEscapeProcessing(boolean enable)` Sets escape processing on or off.
`int` | `Statement.getQueryTimeout()` Retrieves the number of seconds the driver will wait for a `Statement` object to execute.
`void` | `Statement.setQueryTimeout(int seconds)` Sets the number of seconds the driver will wait for a `Statement` object to execute to the given number of seconds.
`void` | `Statement.cancel()` Cancels this `Statement` object if both the DBMS and driver support aborting an SQL statement.
`SQLWarning` | `Statement.getWarnings()` Retrieves the first warning reported by calls on this `Statement` object.
`void` | `Statement.clearWarnings()` Clears all the warnings reported on this `Statement` object.
`void` | `Statement.setCursorName(String name)` Defines the SQL cursor name that will be used by subsequent `Statement` object `execute` methods.
`boolean` | `Statement.execute(String sql)` Executes an SQL statement that may return multiple results.
`ResultSet` | `Statement.getResultSet()` Returns the current result as a `ResultSet` object.
`int` | `Statement.getUpdateCount()` Returns the current result as an update count; if the result is a `ResultSet` object or there are no more results, -1 is returned.
`boolean` | `Statement.getMoreResults()` Moves to a `Statement` object's next result.
`void` | `Statement.setFetchDirection(int direction)` Gives the driver a hint as to the direction in which the rows in a result set will be processed.
`int` | `Statement.getFetchDirection()` Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this `Statement` object.
`void` | `Statement.setFetchSize(int rows)` Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.
`int` | `Statement.getFetchSize()` Retrieves the number of result set rows that is the default fetch size for result sets generated from this `Statement` object.
`int` | `Statement.getResultSetConcurrency()` Retrieves the result set concurrency for `ResultSet` objects generated by this `Statement` object.
`int` | `Statement.getResultSetType()` Retrieves the result set type for `ResultSet` objects generated by this `Statement` object.
`void` | `Statement.addBatch(String sql)` Adds an SQL command to the current batch of commmands for this `Statement` object.
`void` | `Statement.clearBatch()` Makes the set of commands in the current batch empty.
`int[]` | `Statement.executeBatch()` Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
`Connection` | `Statement.getConnection()` Returns the `Connection` object that produced this `Statement` object.
`ResultSet` | `PreparedStatement.executeQuery()` Executes the SQL query in this `PreparedStatement` object and returns the result set generated by the query.
`int` | `PreparedStatement.executeUpdate()` Executes the SQL INSERT, UPDATE or DELETE statement in this `PreparedStatement` object.
`void` | `PreparedStatement.setNull(int parameterIndex, int sqlType)` Sets the designated parameter to SQL `NULL`.
`void` | `PreparedStatement.setBoolean(int parameterIndex, boolean x)` Sets the designated parameter to a Java `boolean` value.
`void` | `PreparedStatement.setByte(int parameterIndex, byte x)` Sets the designated parameter to a Java `byte` value.
`void` | `PreparedStatement.setShort(int parameterIndex, short x)` Sets the designated parameter to a Java `short` value.
`void` | `PreparedStatement.setInt(int parameterIndex, int x)` Sets the designated parameter to a Java `int` value.
`void` | `PreparedStatement.setLong(int parameterIndex, long x)` Sets the designated parameter to a Java `long` value.
`void` | `PreparedStatement.setFloat(int parameterIndex, float x)` Sets the designated parameter to a Java `float` value.
`void` | `PreparedStatement.setDouble(int parameterIndex, double x)` Sets the designated parameter to a Java `double` value.
`void` | `PreparedStatement.setBigDecimal(int parameterIndex, BigDecimal x)` Sets the designated parameter to a `java.math.BigDecimal` value.
`void` | `PreparedStatement.setString(int parameterIndex, String x)` Sets the designated parameter to a Java `String` value.
`void` | `PreparedStatement.setBytes(int parameterIndex, byte[] x)` Sets the designated parameter to a Java array of bytes.
`void` | `PreparedStatement.setDate(int parameterIndex, Date x)` Sets the designated parameter to a value.
`void` | `PreparedStatement.setTime(int parameterIndex, Time x)` Sets the designated parameter to a `java.sql.Time` value.
`void` | `PreparedStatement.setTimestamp(int parameterIndex, Timestamp x)` Sets the designated parameter to a `java.sql.Timestamp` value.
`void` | `PreparedStatement.setAsciiStream(int parameterIndex, InputStream x, int length)` Sets the designated parameter to the given input stream, which will have the specified number of bytes.
`void` | `PreparedStatement.setUnicodeStream(int parameterIndex, InputStream x, int length)` Deprecated.
`void` | `PreparedStatement.setBinaryStream(int parameterIndex, InputStream x, int length)` Sets the designated parameter to the given input stream, which will have the specified number of bytes.
`void` | `PreparedStatement.clearParameters()` Clears the current parameter values immediately.
`void` | `PreparedStatement.setObject(int parameterIndex, Object x, int targetSqlType, int scale)` Sets the value of the designated parameter with the given object.
`void` | `PreparedStatement.setObject(int parameterIndex, Object x, int targetSqlType)` Sets the value of the designated parameter with the given object.
`void` | `PreparedStatement.setObject(int parameterIndex, Object x)` Sets the value of the designated parameter using the given object.
`boolean` | `PreparedStatement.execute()` Executes any kind of SQL statement.
`void` | `PreparedStatement.addBatch()` Adds a set of parameters to this `PreparedStatement` object's batch of commands.
`void` | `PreparedStatement.setCharacterStream(int parameterIndex, Reader reader, int length)` Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
`void` | `PreparedStatement.setRef(int i, Ref x)` Sets the designated parameter to the given `REF(<structured-type>)` value.
`void` | `PreparedStatement.setBlob(int i, Blob x)` Sets the designated parameter to the given `Blob` object.
`void` | `PreparedStatement.setClob(int i, Clob x)` Sets the designated parameter to the given `Clob` object.
`void` | `PreparedStatement.setArray(int i, Array x)` Sets the designated parameter to the given `Array` object.
`ResultSetMetaData` | `PreparedStatement.getMetaData()` Gets the number, types and properties of a `ResultSet` object's columns.
`void` | `PreparedStatement.setDate(int parameterIndex, Date x, Calendar cal)` Sets the designated parameter to the given `java.sql.Date` value, using the given `Calendar` object.
`void` | `PreparedStatement.setTime(int parameterIndex, Time x, Calendar cal)` Sets the designated parameter to the given `java.sql.Time` value, using the given `Calendar` object.
`void` | `PreparedStatement.setTimestamp(int parameterIndex, Timestamp x, Calendar cal)` Sets the designated parameter to the given `java.sql.Timestamp` value, using the given `Calendar` object.
`void` | `PreparedStatement.setNull(int paramIndex, int sqlType, String typeName)` Sets the designated parameter to SQL `NULL`.
`String` | `SQLData.getSQLTypeName()` Returns the fully-qualified name of the SQL user-defined type that this object represents.
`void` | `SQLData.readSQL(SQLInput stream, String typeName)` Populates this object with data read from the database.
`void` | `SQLData.writeSQL(SQLOutput stream)` Writes this object to the given SQL data stream, converting it back to its SQL value in the data source.
`Connection` | `Driver.connect(String url, Properties info)` Attempts to make a database connection to the given URL.
`boolean` | `Driver.acceptsURL(String url)` Returns true if the driver thinks that it can open a connection to the given URL.
`DriverPropertyInfo[]` | `Driver.getPropertyInfo(String url, Properties info)` Gets information about the possible properties for this driver.
`Statement` | `Connection.createStatement()` Creates a `Statement` object for sending SQL statements to the database.
`PreparedStatement` | `Connection.prepareStatement(String sql)` Creates a `PreparedStatement` object for sending parameterized SQL statements to the database.
`CallableStatement` | `Connection.prepareCall(String sql)` Creates a `CallableStatement` object for calling database stored procedures.
`String` | `Connection.nativeSQL(String sql)` Converts the given SQL statement into the system's native SQL grammar.
`void` | `Connection.setAutoCommit(boolean autoCommit)` Sets this connection's auto-commit mode.
`boolean` | `Connection.getAutoCommit()` Gets the current auto-commit state.
`void` | `Connection.commit()` Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.
`void` | `Connection.rollback()` Drops all changes made since the previous commit/rollback and releases any database locks currently held by this Connection.
`void` | `Connection.close()` Releases a Connection's database and JDBC resources immediately instead of waiting for them to be automatically released.
`boolean` | `Connection.isClosed()` Tests to see if a Connection is closed.
`DatabaseMetaData` | `Connection.getMetaData()` Gets the metadata regarding this connection's database.
`void` | `Connection.setReadOnly(boolean readOnly)` Puts this connection in read-only mode as a hint to enable database optimizations.
`boolean` | `Connection.isReadOnly()` Tests to see if the connection is in read-only mode.
`void` | `Connection.setCatalog(String catalog)` Sets a catalog name in order to select a subspace of this Connection's database in which to work.
`String` | `Connection.getCatalog()` Returns the Connection's current catalog name.
`void` | `Connection.setTransactionIsolation(int level)` Attempts to change the transaction isolation level to the one given.
`int` | `Connection.getTransactionIsolation()` Gets this Connection's current transaction isolation level.
`SQLWarning` | `Connection.getWarnings()` Returns the first warning reported by calls on this Connection.
`void` | `Connection.clearWarnings()` Clears all warnings reported for this `Connection` object.
`Statement` | `Connection.createStatement(int resultSetType, int resultSetConcurrency)` Creates a `Statement` object that will generate `ResultSet` objects with the given type and concurrency.
`PreparedStatement` | `Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency)` Creates a `PreparedStatement` object that will generate `ResultSet` objects with the given type and concurrency.
`CallableStatement` | `Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency)` Creates a `CallableStatement` object that will generate `ResultSet` objects with the given type and concurrency.
`Map` | `Connection.getTypeMap()` Gets the type map object associated with this connection.
`void` | `Connection.setTypeMap(Map map)` Installs the given type map as the type map for this connection.
`void` | `SQLOutput.writeString(String x)` Writes the next attribute to the stream as a `String` in the Java programming language.
`void` | `SQLOutput.writeBoolean(boolean x)` Writes the next attribute to the stream as a Java boolean.
`void` | `SQLOutput.writeByte(byte x)` Writes the next attribute to the stream as a Java byte.
`void` | `SQLOutput.writeShort(short x)` Writes the next attribute to the stream as a Java short.
`void` | `SQLOutput.writeInt(int x)` Writes the next attribute to the stream as a Java int.
`void` | `SQLOutput.writeLong(long x)` Writes the next attribute to the stream as a Java long.
`void` | `SQLOutput.writeFloat(float x)` Writes the next attribute to the stream as a Java float.
`void` | `SQLOutput.writeDouble(double x)` Writes the next attribute to the stream as a Java double.
`void` | `SQLOutput.writeBigDecimal(BigDecimal x)` Writes the next attribute to the stream as a java.math.BigDecimal object.
`void` | `SQLOutput.writeBytes(byte[] x)` Writes the next attribute to the stream as an array of bytes.
`void` | `SQLOutput.writeDate(Date x)` Writes the next attribute to the stream as a java.sql.Date object.
`void` | `SQLOutput.writeTime(Time x)` Writes the next attribute to the stream as a java.sql.Time object.
`void` | `SQLOutput.writeTimestamp(Timestamp x)` Writes the next attribute to the stream as a java.sql.Timestamp object.
`void` | `SQLOutput.writeCharacterStream(Reader x)` Writes the next attribute to the stream as a stream of Unicode characters.
`void` | `SQLOutput.writeAsciiStream(InputStream x)` Writes the next attribute to the stream as a stream of ASCII characters.
`void` | `SQLOutput.writeBinaryStream(InputStream x)` Writes the next attribute to the stream as a stream of uninterpreted bytes.
`void` | `SQLOutput.writeObject(SQLData x)` Writes to the stream the data contained in the given `SQLData` object.
`void` | `SQLOutput.writeRef(Ref x)` Writes an SQL `REF` value to the stream.
`void` | `SQLOutput.writeBlob(Blob x)` Writes an SQL `BLOB` value to the stream.
`void` | `SQLOutput.writeClob(Clob x)` Writes an SQL `CLOB` value to the stream.
`void` | `SQLOutput.writeStruct(Struct x)` Writes an SQL structured type value to the stream.
`void` | `SQLOutput.writeArray(Array x)` Writes an SQL `ARRAY` value to the stream.
`static Connection` | `DriverManager.getConnection(String url, Properties info)` Attempts to establish a connection to the given database URL.
`static Connection` | `DriverManager.getConnection(String url, String user, String password)` Attempts to establish a connection to the given database URL.
`static Connection` | `DriverManager.getConnection(String url)` Attempts to establish a connection to the given database URL.
`static Driver` | `DriverManager.getDriver(String url)` Attempts to locate a driver that understands the given URL.
`static void` | `DriverManager.registerDriver(Driver driver)` Registers the given driver with the `DriverManager`.
`static void` | `DriverManager.deregisterDriver(Driver driver)` Drops a Driver from the `DriverManager`'s list.
`long` | `Blob.length()` Returns the number of bytes in the `BLOB` value designated by this `Blob` object.
`byte[]` | `Blob.getBytes(long pos, int length)` Returns as an array of bytes, part or all of the `BLOB` value that this `Blob` object designates.
`InputStream` | `Blob.getBinaryStream()` Retrieves the `BLOB` designated by this `Blob` instance as a stream.
`long` | `Blob.position(byte[] pattern, long start)` Determines the byte position at which the specified byte `pattern` begins within the `BLOB` value that this `Blob` object represents.
`long` | `Blob.position(Blob pattern, long start)` Determines the byte position in the `BLOB` value designated by this `Blob` object at which `pattern` begins.
`void` | `CallableStatement.registerOutParameter(int parameterIndex, int sqlType)` Registers the OUT parameter in ordinal position `parameterIndex` to the JDBC type `sqlType`.
`void` | `CallableStatement.registerOutParameter(int parameterIndex, int sqlType, int scale)` Registers the parameter in ordinal position `parameterIndex` to be of JDBC type `sqlType`.
`boolean` | `CallableStatement.wasNull()` Indicates whether or not the last OUT parameter read had the value of SQL `NULL`.
`String` | `CallableStatement.getString(int parameterIndex)` Retrieves the value of a JDBC `CHAR`, `VARCHAR`, or `LONGVARCHAR` parameter as a `String` in the Java programming language.
`boolean` | `CallableStatement.getBoolean(int parameterIndex)` Gets the value of a JDBC `BIT` parameter as a `boolean` in the Java programming language.
`byte` | `CallableStatement.getByte(int parameterIndex)` Gets the value of a JDBC `TINYINT` parameter as a `byte` in the Java programming language.
`short` | `CallableStatement.getShort(int parameterIndex)` Gets the value of a JDBC `SMALLINT` parameter as a `short` in the Java programming language.
`int` | `CallableStatement.getInt(int parameterIndex)` Gets the value of a JDBC `INTEGER` parameter as an `int` in the Java programming language.
`long` | `CallableStatement.getLong(int parameterIndex)` Gets the value of a JDBC `BIGINT` parameter as a `long` in the Java programming language.
`float` | `CallableStatement.getFloat(int parameterIndex)` Gets the value of a JDBC `FLOAT` parameter as a `float` in the Java programming language.
`double` | `CallableStatement.getDouble(int parameterIndex)` Gets the value of a JDBC `DOUBLE` parameter as a `double` in the Java programming language.
`BigDecimal` | `CallableStatement.getBigDecimal(int parameterIndex, int scale)` Deprecated.
`byte[]` | `CallableStatement.getBytes(int parameterIndex)` Gets the value of a JDBC `BINARY` or `VARBINARY` parameter as an array of `byte` values in the Java programming language.
`Date` | `CallableStatement.getDate(int parameterIndex)` Gets the value of a JDBC `DATE` parameter as a `java.sql.Date` object.
`Time` | `CallableStatement.getTime(int parameterIndex)` Get the value of a JDBC `TIME` parameter as a `java.sql.Time` object.
`Timestamp` | `CallableStatement.getTimestamp(int parameterIndex)` Gets the value of a JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object.
`Object` | `CallableStatement.getObject(int parameterIndex)` Gets the value of a parameter as an `Object` in the Java programming language.
`BigDecimal` | `CallableStatement.getBigDecimal(int parameterIndex)` Gets the value of a JDBC `NUMERIC` parameter as a `java.math.BigDecimal` object with as many digits to the right of the decimal point as the value contains.
`Object` | `CallableStatement.getObject(int i, Map map)` Returns an object representing the value of OUT parameter `i` and uses `map` for the custom mapping of the parameter value.
`Ref` | `CallableStatement.getRef(int i)` Gets the value of a JDBC `REF(<structured-type>)` parameter as a `Ref` object in the Java programming language.
`Blob` | `CallableStatement.getBlob(int i)` Gets the value of a JDBC `BLOB` parameter as a `Blob` object in the Java programming language.
`Clob` | `CallableStatement.getClob(int i)` Gets the value of a JDBC `CLOB` parameter as a `Clob` object in the Java programming language.
`Array` | `CallableStatement.getArray(int i)` Gets the value of a JDBC `ARRAY` parameter as an `Array` object in the Java programming language.
`Date` | `CallableStatement.getDate(int parameterIndex, Calendar cal)` Gets the value of a JDBC `DATE` parameter as a `java.sql.Date` object, using the given `Calendar` object to construct the date.
`Time` | `CallableStatement.getTime(int parameterIndex, Calendar cal)` Gets the value of a JDBC `TIME` parameter as a `java.sql.Time` object, using the given `Calendar` object to construct the time.
`Timestamp` | `CallableStatement.getTimestamp(int parameterIndex, Calendar cal)` Gets the value of a JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object, using the given `Calendar` object to construct the `Timestamp` object.
`void` | `CallableStatement.registerOutParameter(int paramIndex, int sqlType, String typeName)` Registers the designated output parameter.
`String` | `Struct.getSQLTypeName()` Retrieves the SQL type name of the SQL structured type that this `Struct` object represents.
`Object[]` | `Struct.getAttributes()` Produces the ordered values of the attributes of the SQL structurec type that this `Struct` object represents.
`Object[]` | `Struct.getAttributes(Map map)` Produces the ordered values of the attributes of the SQL structurec type that this `Struct` object represents.
`boolean` | `DatabaseMetaData.allProceduresAreCallable()` Can all the procedures returned by getProcedures be called by the current user?
`boolean` | `DatabaseMetaData.allTablesAreSelectable()` Can all the tables returned by getTable be SELECTed by the current user?
`String` | `DatabaseMetaData.getURL()` What's the url for this database?
`String` | `DatabaseMetaData.getUserName()` What's our user name as known to the database?
`boolean` | `DatabaseMetaData.isReadOnly()` Is the database in read-only mode?
`boolean` | `DatabaseMetaData.nullsAreSortedHigh()` Are NULL values sorted high?
`boolean` | `DatabaseMetaData.nullsAreSortedLow()` Are NULL values sorted low?
`boolean` | `DatabaseMetaData.nullsAreSortedAtStart()` Are NULL values sorted at the start regardless of sort order?
`boolean` | `DatabaseMetaData.nullsAreSortedAtEnd()` Are NULL values sorted at the end regardless of sort order?
`String` | `DatabaseMetaData.getDatabaseProductName()` What's the name of this database product?
`String` | `DatabaseMetaData.getDatabaseProductVersion()` What's the version of this database product?
`String` | `DatabaseMetaData.getDriverName()` What's the name of this JDBC driver?
`String` | `DatabaseMetaData.getDriverVersion()` What's the version of this JDBC driver?
`boolean` | `DatabaseMetaData.usesLocalFiles()` Does the database store tables in a local file?
`boolean` | `DatabaseMetaData.usesLocalFilePerTable()` Does the database use a file for each table?
`boolean` | `DatabaseMetaData.supportsMixedCaseIdentifiers()` Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC CompliantTM driver will always return false.
`boolean` | `DatabaseMetaData.storesUpperCaseIdentifiers()` Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in upper case?
`boolean` | `DatabaseMetaData.storesLowerCaseIdentifiers()` Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in lower case?
`boolean` | `DatabaseMetaData.storesMixedCaseIdentifiers()` Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in mixed case?
`boolean` | `DatabaseMetaData.supportsMixedCaseQuotedIdentifiers()` Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC CompliantTM driver will always return true.
`boolean` | `DatabaseMetaData.storesUpperCaseQuotedIdentifiers()` Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in upper case?
`boolean` | `DatabaseMetaData.storesLowerCaseQuotedIdentifiers()` Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in lower case?
`boolean` | `DatabaseMetaData.storesMixedCaseQuotedIdentifiers()` Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in mixed case?
`String` | `DatabaseMetaData.getIdentifierQuoteString()` What's the string used to quote SQL identifiers? This returns a space " " if identifier quoting isn't supported.
`String` | `DatabaseMetaData.getSQLKeywords()` Gets a comma-separated list of all a database's SQL keywords that are NOT also SQL92 keywords.
`String` | `DatabaseMetaData.getNumericFunctions()` Gets a comma-separated list of math functions.
`String` | `DatabaseMetaData.getStringFunctions()` Gets a comma-separated list of string functions.
`String` | `DatabaseMetaData.getSystemFunctions()` Gets a comma-separated list of system functions.
`String` | `DatabaseMetaData.getTimeDateFunctions()` Gets a comma-separated list of time and date functions.
`String` | `DatabaseMetaData.getSearchStringEscape()` Gets the string that can be used to escape wildcard characters.
`String` | `DatabaseMetaData.getExtraNameCharacters()` Gets all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
`boolean` | `DatabaseMetaData.supportsAlterTableWithAddColumn()` Is "ALTER TABLE" with add column supported?
`boolean` | `DatabaseMetaData.supportsAlterTableWithDropColumn()` Is "ALTER TABLE" with drop column supported?
`boolean` | `DatabaseMetaData.supportsColumnAliasing()` Is column aliasing supported?
`boolean` | `DatabaseMetaData.nullPlusNonNullIsNull()` Are concatenations between NULL and non-NULL values NULL? For SQL-92 compliance, a JDBC technology-enabled driver will return `true`.
`boolean` | `DatabaseMetaData.supportsConvert()` Is the CONVERT function between SQL types supported?
`boolean` | `DatabaseMetaData.supportsConvert(int fromType, int toType)` Is CONVERT between the given SQL types supported?
`boolean` | `DatabaseMetaData.supportsTableCorrelationNames()` Are table correlation names supported? A JDBC CompliantTM driver always returns true.
`boolean` | `DatabaseMetaData.supportsDifferentTableCorrelationNames()` If table correlation names are supported, are they restricted to be different from the names of the tables?
`boolean` | `DatabaseMetaData.supportsExpressionsInOrderBy()` Are expressions in "ORDER BY" lists supported?
`boolean` | `DatabaseMetaData.supportsOrderByUnrelated()` Can an "ORDER BY" clause use columns not in the SELECT statement?
`boolean` | `DatabaseMetaData.supportsGroupBy()` Is some form of "GROUP BY" clause supported?
`boolean` | `DatabaseMetaData.supportsGroupByUnrelated()` Can a "GROUP BY" clause use columns not in the SELECT?
`boolean` | `DatabaseMetaData.supportsGroupByBeyondSelect()` Can a "GROUP BY" clause add columns not in the SELECT provided it specifies all the columns in the SELECT?
`boolean` | `DatabaseMetaData.supportsLikeEscapeClause()` Is the escape character in "LIKE" clauses supported? A JDBC CompliantTM driver always returns true.
`boolean` | `DatabaseMetaData.supportsMultipleResultSets()` Are multiple `ResultSet` from a single execute supported?
`boolean` | `DatabaseMetaData.supportsMultipleTransactions()` Can we have multiple transactions open at once (on different connections)?
`boolean` | `DatabaseMetaData.supportsNonNullableColumns()` Can columns be defined as non-nullable? A JDBC CompliantTM driver always returns true.
`boolean` | `DatabaseMetaData.supportsMinimumSQLGrammar()` Is the ODBC Minimum SQL grammar supported? All JDBC CompliantTM drivers must return true.
`boolean` | `DatabaseMetaData.supportsCoreSQLGrammar()` Is the ODBC Core SQL grammar supported?
`boolean` | `DatabaseMetaData.supportsExtendedSQLGrammar()` Is the ODBC Extended SQL grammar supported?
`boolean` | `DatabaseMetaData.supportsANSI92EntryLevelSQL()` Is the ANSI92 entry level SQL grammar supported? All JDBC CompliantTM drivers must return true.
`boolean` | `DatabaseMetaData.supportsANSI92IntermediateSQL()` Is the ANSI92 intermediate SQL grammar supported?
`boolean` | `DatabaseMetaData.supportsANSI92FullSQL()` Is the ANSI92 full SQL grammar supported?
`boolean` | `DatabaseMetaData.supportsIntegrityEnhancementFacility()` Is the SQL Integrity Enhancement Facility supported?
`boolean` | `DatabaseMetaData.supportsOuterJoins()` Is some form of outer join supported?
`boolean` | `DatabaseMetaData.supportsFullOuterJoins()` Are full nested outer joins supported?
`boolean` | `DatabaseMetaData.supportsLimitedOuterJoins()` Is there limited support for outer joins? (This will be true if supportFullOuterJoins is true.)
`String` | `DatabaseMetaData.getSchemaTerm()` What's the database vendor's preferred term for "schema"?
`String` | `DatabaseMetaData.getProcedureTerm()` What's the database vendor's preferred term for "procedure"?
`String` | `DatabaseMetaData.getCatalogTerm()` What's the database vendor's preferred term for "catalog"?
`boolean` | `DatabaseMetaData.isCatalogAtStart()` Does a catalog appear at the start of a qualified table name? (Otherwise it appears at the end)
`String` | `DatabaseMetaData.getCatalogSeparator()` What's the separator between catalog and table name?
`boolean` | `DatabaseMetaData.supportsSchemasInDataManipulation()` Can a schema name be used in a data manipulation statement?
`boolean` | `DatabaseMetaData.supportsSchemasInProcedureCalls()` Can a schema name be used in a procedure call statement?
`boolean` | `DatabaseMetaData.supportsSchemasInTableDefinitions()` Can a schema name be used in a table definition statement?
`boolean` | `DatabaseMetaData.supportsSchemasInIndexDefinitions()` Can a schema name be used in an index definition statement?
`boolean` | `DatabaseMetaData.supportsSchemasInPrivilegeDefinitions()` Can a schema name be used in a privilege definition statement?
`boolean` | `DatabaseMetaData.supportsCatalogsInDataManipulation()` Can a catalog name be used in a data manipulation statement?
`boolean` | `DatabaseMetaData.supportsCatalogsInProcedureCalls()` Can a catalog name be used in a procedure call statement?
`boolean` | `DatabaseMetaData.supportsCatalogsInTableDefinitions()` Can a catalog name be used in a table definition statement?
`boolean` | `DatabaseMetaData.supportsCatalogsInIndexDefinitions()` Can a catalog name be used in an index definition statement?
`boolean` | `DatabaseMetaData.supportsCatalogsInPrivilegeDefinitions()` Can a catalog name be used in a privilege definition statement?
`boolean` | `DatabaseMetaData.supportsPositionedDelete()` Is positioned DELETE supported?
`boolean` | `DatabaseMetaData.supportsPositionedUpdate()` Is positioned UPDATE supported?
`boolean` | `DatabaseMetaData.supportsSelectForUpdate()` Is SELECT for UPDATE supported?
`boolean` | `DatabaseMetaData.supportsStoredProcedures()` Are stored procedure calls using the stored procedure escape syntax supported?
`boolean` | `DatabaseMetaData.supportsSubqueriesInComparisons()` Are subqueries in comparison expressions supported? A JDBC CompliantTM driver always returns true.
`boolean` | `DatabaseMetaData.supportsSubqueriesInExists()` Are subqueries in 'exists' expressions supported? A JDBC CompliantTM driver always returns true.
`boolean` | `DatabaseMetaData.supportsSubqueriesInIns()` Are subqueries in 'in' statements supported? A JDBC CompliantTM driver always returns true.
`boolean` | `DatabaseMetaData.supportsSubqueriesInQuantifieds()` Are subqueries in quantified expressions supported? A JDBC CompliantTM driver always returns true.
`boolean` | `DatabaseMetaData.supportsCorrelatedSubqueries()` Are correlated subqueries supported? A JDBC CompliantTM driver always returns true.
`boolean` | `DatabaseMetaData.supportsUnion()` Is SQL UNION supported?
`boolean` | `DatabaseMetaData.supportsUnionAll()` Is SQL UNION ALL supported?
`boolean` | `DatabaseMetaData.supportsOpenCursorsAcrossCommit()` Can cursors remain open across commits?
`boolean` | `DatabaseMetaData.supportsOpenCursorsAcrossRollback()` Can cursors remain open across rollbacks?
`boolean` | `DatabaseMetaData.supportsOpenStatementsAcrossCommit()` Can statements remain open across commits?
`boolean` | `DatabaseMetaData.supportsOpenStatementsAcrossRollback()` Can statements remain open across rollbacks?
`int` | `DatabaseMetaData.getMaxBinaryLiteralLength()` How many hex characters can you have in an inline binary literal?
`int` | `DatabaseMetaData.getMaxCharLiteralLength()` What's the max length for a character literal?
`int` | `DatabaseMetaData.getMaxColumnNameLength()` What's the limit on column name length?
`int` | `DatabaseMetaData.getMaxColumnsInGroupBy()` What's the maximum number of columns in a "GROUP BY" clause?
`int` | `DatabaseMetaData.getMaxColumnsInIndex()` What's the maximum number of columns allowed in an index?
`int` | `DatabaseMetaData.getMaxColumnsInOrderBy()` What's the maximum number of columns in an "ORDER BY" clause?
`int` | `DatabaseMetaData.getMaxColumnsInSelect()` What's the maximum number of columns in a "SELECT" list?
`int` | `DatabaseMetaData.getMaxColumnsInTable()` What's the maximum number of columns in a table?
`int` | `DatabaseMetaData.getMaxConnections()` How many active connections can we have at a time to this database?
`int` | `DatabaseMetaData.getMaxCursorNameLength()` What's the maximum cursor name length?
`int` | `DatabaseMetaData.getMaxIndexLength()` Retrieves the maximum number of bytes for an index, including all of the parts of the index.
`int` | `DatabaseMetaData.getMaxSchemaNameLength()` What's the maximum length allowed for a schema name?
`int` | `DatabaseMetaData.getMaxProcedureNameLength()` What's the maximum length of a procedure name?
`int` | `DatabaseMetaData.getMaxCatalogNameLength()` What's the maximum length of a catalog name?
`int` | `DatabaseMetaData.getMaxRowSize()` What's the maximum length of a single row?
`boolean` | `DatabaseMetaData.doesMaxRowSizeIncludeBlobs()` Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
`int` | `DatabaseMetaData.getMaxStatementLength()` What's the maximum length of an SQL statement?
`int` | `DatabaseMetaData.getMaxStatements()` How many active statements can we have open at one time to this database?
`int` | `DatabaseMetaData.getMaxTableNameLength()` What's the maximum length of a table name?
`int` | `DatabaseMetaData.getMaxTablesInSelect()` What's the maximum number of tables in a SELECT statement?
`int` | `DatabaseMetaData.getMaxUserNameLength()` What's the maximum length of a user name?
`int` | `DatabaseMetaData.getDefaultTransactionIsolation()` What's the database's default transaction isolation level? The values are defined in `java.sql.Connection`.
`boolean` | `DatabaseMetaData.supportsTransactions()` Are transactions supported? If not, invoking the method `commit` is a noop and the isolation level is TRANSACTION_NONE.
`boolean` | `DatabaseMetaData.supportsTransactionIsolationLevel(int level)` Does this database support the given transaction isolation level?
`boolean` | `DatabaseMetaData.supportsDataDefinitionAndDataManipulationTransactions()` Are both data definition and data manipulation statements within a transaction supported?
`boolean` | `DatabaseMetaData.supportsDataManipulationTransactionsOnly()` Are only data manipulation statements within a transaction supported?
`boolean` | `DatabaseMetaData.dataDefinitionCausesTransactionCommit()` Does a data definition statement within a transaction force the transaction to commit?
`boolean` | `DatabaseMetaData.dataDefinitionIgnoredInTransactions()` Is a data definition statement within a transaction ignored?
`ResultSet` | `DatabaseMetaData.getProcedures(String catalog, String schemaPattern, String procedureNamePattern)` Gets a description of the stored procedures available in a catalog.
`ResultSet` | `DatabaseMetaData.getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)` Gets a description of a catalog's stored procedure parameters and result columns.
`ResultSet` | `DatabaseMetaData.getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)` Gets a description of tables available in a catalog.
`ResultSet` | `DatabaseMetaData.getSchemas()` Gets the schema names available in this database.
`ResultSet` | `DatabaseMetaData.getCatalogs()` Gets the catalog names available in this database.
`ResultSet` | `DatabaseMetaData.getTableTypes()` Gets the table types available in this database.
`ResultSet` | `DatabaseMetaData.getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)` Gets a description of table columns available in the specified catalog.
`ResultSet` | `DatabaseMetaData.getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)` Gets a description of the access rights for a table's columns.
`ResultSet` | `DatabaseMetaData.getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)` Gets a description of the access rights for each table available in a catalog.
`ResultSet` | `DatabaseMetaData.getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)` Gets a description of a table's optimal set of columns that uniquely identifies a row.
`ResultSet` | `DatabaseMetaData.getVersionColumns(String catalog, String schema, String table)` Gets a description of a table's columns that are automatically updated when any value in a row is updated.
`ResultSet` | `DatabaseMetaData.getPrimaryKeys(String catalog, String schema, String table)` Gets a description of a table's primary key columns.
`ResultSet` | `DatabaseMetaData.getImportedKeys(String catalog, String schema, String table)` Gets a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table).
`ResultSet` | `DatabaseMetaData.getExportedKeys(String catalog, String schema, String table)` Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table).
`ResultSet` | `DatabaseMetaData.getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)` Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.) This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
`ResultSet` | `DatabaseMetaData.getTypeInfo()` Gets a description of all the standard SQL types supported by this database.
`ResultSet` | `DatabaseMetaData.getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)` Gets a description of a table's indices and statistics.
`boolean` | `DatabaseMetaData.supportsResultSetType(int type)` Does the database support the given result set type?
`boolean` | `DatabaseMetaData.supportsResultSetConcurrency(int type, int concurrency)` Does the database support the concurrency type in combination with the given result set type?
`boolean` | `DatabaseMetaData.ownUpdatesAreVisible(int type)` Indicates whether a result set's own updates are visible.
`boolean` | `DatabaseMetaData.ownDeletesAreVisible(int type)` Indicates whether a result set's own deletes are visible.
`boolean` | `DatabaseMetaData.ownInsertsAreVisible(int type)` Indicates whether a result set's own inserts are visible.
`boolean` | `DatabaseMetaData.othersUpdatesAreVisible(int type)` Indicates whether updates made by others are visible.
`boolean` | `DatabaseMetaData.othersDeletesAreVisible(int type)` Indicates whether deletes made by others are visible.
`boolean` | `DatabaseMetaData.othersInsertsAreVisible(int type)` Indicates whether inserts made by others are visible.
`boolean` | `DatabaseMetaData.updatesAreDetected(int type)` Indicates whether or not a visible row update can be detected by calling the method `ResultSet.rowUpdated`.
`boolean` | `DatabaseMetaData.deletesAreDetected(int type)` Indicates whether or not a visible row delete can be detected by calling ResultSet.rowDeleted().
`boolean` | `DatabaseMetaData.insertsAreDetected(int type)` Indicates whether or not a visible row insert can be detected by calling ResultSet.rowInserted().
`boolean` | `DatabaseMetaData.supportsBatchUpdates()` Indicates whether the driver supports batch updates.
`ResultSet` | `DatabaseMetaData.getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)` Gets a description of the user-defined types defined in a particular schema.
`Connection` | `DatabaseMetaData.getConnection()` Retrieves the connection that produced this metadata object.
`String` | `Array.getBaseTypeName()` Returns the SQL type name of the elements in the array designated by this `Array` object.
`int` | `Array.getBaseType()` Returns the JDBC type of the elements in the array designated by this `Array` object.
`Object` | `Array.getArray()` Retrieves the contents of the SQL `ARRAY` value designated by this `Array` object in the form of an array in the Java programming language.
`Object` | `Array.getArray(Map map)` Retrieves the contents of the SQL array designated by this `Array` object.
`Object` | `Array.getArray(long index, int count)` Returns an array containing a slice of the SQL `ARRAY` value designated by this `Array` object, beginning with the specified `index` and containing up to `count` successive elements of the SQL array.
`Object` | `Array.getArray(long index, int count, Map map)` Returns an array containing a slice of the SQL array object designated by this `Array` object, beginning with the specified `index` and containing up to `count` successive elements of the SQL array.
`ResultSet` | `Array.getResultSet()` Returns a result set that contains the elements of the SQL `ARRAY` value designated by this `Array` object.
`ResultSet` | `Array.getResultSet(Map map)` Returns a result set that contains the elements of the SQL `ARRAY` value designated by this `Array` object.
`ResultSet` | `Array.getResultSet(long index, int count)` Returns a result set holding the elements of the subarray that starts at index `index` and contains up to `count` successive elements.
`ResultSet` | `Array.getResultSet(long index, int count, Map map)` Returns a result set holding the elements of the subarray that starts at index `index` and contains up to `count` successive elements.
`String` | `SQLInput.readString()` Reads the next attribute in the stream as a `String` in the Java programming language.
`boolean` | `SQLInput.readBoolean()` Reads the next attribute in the stream as a `boolean` in the Java programming language.
`byte` | `SQLInput.readByte()` Reads the next attribute in the stream as a `byte` in the Java programming language.
`short` | `SQLInput.readShort()` Reads the next attribute in the stream as a `short` in the Java programming language.
`int` | `SQLInput.readInt()` Reads the next attribute in the stream as an `int` in the Java programming language.
`long` | `SQLInput.readLong()` Reads the next attribute in the stream as a `long` in the Java programming language.
`float` | `SQLInput.readFloat()` Reads the next attribute in the stream as a `float` in the Java programming language.
`double` | `SQLInput.readDouble()` Reads the next attribute in the stream as a `double` in the Java programming language.
`BigDecimal` | `SQLInput.readBigDecimal()` Reads the next attribute in the stream as a `java.math.BigDecimal` object in the Java programming language.
`byte[]` | `SQLInput.readBytes()` Reads the next attribute in the stream as an array of bytes in the Java programming language.
`Date` | `SQLInput.readDate()` Reads the next attribute in the stream as a `java.sql.Date` object.
`Time` | `SQLInput.readTime()` Reads the next attribute in the stream as a `java.sql.Time` object.
`Timestamp` | `SQLInput.readTimestamp()` Reads the next attribute in the stream as a `java.sql.Timestamp` object.
`Reader` | `SQLInput.readCharacterStream()` Returns the next attribute in the stream as a stream of Unicode characters.
`InputStream` | `SQLInput.readAsciiStream()` Returns the next attribute in the stream as a stream of ASCII characters.
`InputStream` | `SQLInput.readBinaryStream()` Returns the next attribute in the stream as a stream of uninterpreted bytes.
`Object` | `SQLInput.readObject()` Returns the datum at the head of the stream as an `Object` in the Java programming language.
`Ref` | `SQLInput.readRef()` Reads an SQL `REF` value from the stream and returns it as a `Ref` object in the Java programming language.
`Blob` | `SQLInput.readBlob()` Reads an SQL `BLOB` value from the stream and returns it as a `Blob` object in the Java programming language.
`Clob` | `SQLInput.readClob()` Reads an SQL `CLOB` value from the stream and returns it as a `Clob` object in the Java programming language.
`Array` | `SQLInput.readArray()` Reads an SQL `ARRAY` value from the stream and returns it as an `Array` object in the Java programming language.
`boolean` | `SQLInput.wasNull()` Determines whether the last value read was SQL `NULL`.
`boolean` | `ResultSet.next()` Moves the cursor down one row from its current position.
`void` | `ResultSet.close()` Releases this `ResultSet` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
`boolean` | `ResultSet.wasNull()` Reports whether the last column read had a value of SQL `NULL`.
`String` | `ResultSet.getString(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`boolean` | `ResultSet.getBoolean(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `boolean` in the Java programming language.
`byte` | `ResultSet.getByte(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `byte` in the Java programming language.
`short` | `ResultSet.getShort(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `short` in the Java programming language.
`int` | `ResultSet.getInt(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as an `int` in the Java programming language.
`long` | `ResultSet.getLong(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `long` in the Java programming language.
`float` | `ResultSet.getFloat(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `float` in the Java programming language.
`double` | `ResultSet.getDouble(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `double` in the Java programming language.
`BigDecimal` | `ResultSet.getBigDecimal(int columnIndex, int scale)` Deprecated.
`byte[]` | `ResultSet.getBytes(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `byte` array in the Java programming language.
`Date` | `ResultSet.getDate(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`Time` | `ResultSet.getTime(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`Timestamp` | `ResultSet.getTimestamp(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`InputStream` | `ResultSet.getAsciiStream(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a stream of ASCII characters.
`InputStream` | `ResultSet.getUnicodeStream(int columnIndex)` Deprecated. use `getCharacterStream` in place of `getUnicodeStream`
`InputStream` | `ResultSet.getBinaryStream(int columnIndex)` Gets the value of a column in the current row as a stream of Gets the value of the designated column in the current row of this `ResultSet` object as a binary stream of uninterpreted bytes.
`String` | `ResultSet.getString(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`boolean` | `ResultSet.getBoolean(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `boolean` in the Java programming language.
`byte` | `ResultSet.getByte(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `byte` in the Java programming language.
`short` | `ResultSet.getShort(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `short` in the Java programming language.
`int` | `ResultSet.getInt(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as an `int` in the Java programming language.
`long` | `ResultSet.getLong(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `long` in the Java programming language.
`float` | `ResultSet.getFloat(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `float` in the Java programming language.
`double` | `ResultSet.getDouble(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `double` in the Java programming language.
`BigDecimal` | `ResultSet.getBigDecimal(String columnName, int scale)` Deprecated.
`byte[]` | `ResultSet.getBytes(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `byte` array in the Java programming language.
`Date` | `ResultSet.getDate(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`Time` | `ResultSet.getTime(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`Timestamp` | `ResultSet.getTimestamp(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object.
`InputStream` | `ResultSet.getAsciiStream(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a stream of ASCII characters.
`InputStream` | `ResultSet.getUnicodeStream(String columnName)` Deprecated.
`InputStream` | `ResultSet.getBinaryStream(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a stream of uninterpreted `byte`s.
`SQLWarning` | `ResultSet.getWarnings()` Returns the first warning reported by calls on this `ResultSet` object.
`void` | `ResultSet.clearWarnings()` Clears all warnings reported on this `ResultSet` object.
`String` | `ResultSet.getCursorName()` Gets the name of the SQL cursor used by this `ResultSet` object.
`ResultSetMetaData` | `ResultSet.getMetaData()` Retrieves the number, types and properties of this `ResultSet` object's columns.
`Object` | `ResultSet.getObject(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`Object` | `ResultSet.getObject(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`int` | `ResultSet.findColumn(String columnName)` Maps the given `ResultSet` column name to its `ResultSet` column index.
`Reader` | `ResultSet.getCharacterStream(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
`Reader` | `ResultSet.getCharacterStream(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
`BigDecimal` | `ResultSet.getBigDecimal(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
`BigDecimal` | `ResultSet.getBigDecimal(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
`boolean` | `ResultSet.isBeforeFirst()` Indicates whether the cursor is before the first row in this `ResultSet` object.
`boolean` | `ResultSet.isAfterLast()` Indicates whether the cursor is after the last row in this `ResultSet` object.
`boolean` | `ResultSet.isFirst()` Indicates whether the cursor is on the first row of this `ResultSet` object.
`boolean` | `ResultSet.isLast()` Indicates whether the cursor is on the last row of this `ResultSet` object.
`void` | `ResultSet.beforeFirst()` Moves the cursor to the front of this `ResultSet` object, just before the first row.
`void` | `ResultSet.afterLast()` Moves the cursor to the end of this `ResultSet` object, just after the last row.
`boolean` | `ResultSet.first()` Moves the cursor to the first row in this `ResultSet` object.
`boolean` | `ResultSet.last()` Moves the cursor to the last row in this `ResultSet` object.
`int` | `ResultSet.getRow()` Retrieves the current row number.
`boolean` | `ResultSet.absolute(int row)` Moves the cursor to the given row number in this `ResultSet` object.
`boolean` | `ResultSet.relative(int rows)` Moves the cursor a relative number of rows, either positive or negative.
`boolean` | `ResultSet.previous()` Moves the cursor to the previous row in this `ResultSet` object.
`void` | `ResultSet.setFetchDirection(int direction)` Gives a hint as to the direction in which the rows in this `ResultSet` object will be processed.
`int` | `ResultSet.getFetchDirection()` Returns the fetch direction for this `ResultSet` object.
`void` | `ResultSet.setFetchSize(int rows)` Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this `ResultSet` object.
`int` | `ResultSet.getFetchSize()` Returns the fetch size for this `ResultSet` object.
`int` | `ResultSet.getType()` Returns the type of this `ResultSet` object.
`int` | `ResultSet.getConcurrency()` Returns the concurrency mode of this `ResultSet` object.
`boolean` | `ResultSet.rowUpdated()` Indicates whether the current row has been updated.
`boolean` | `ResultSet.rowInserted()` Indicates whether the current row has had an insertion.
`boolean` | `ResultSet.rowDeleted()` Indicates whether a row has been deleted.
`void` | `ResultSet.updateNull(int columnIndex)` Gives a nullable column a null value.
`void` | `ResultSet.updateBoolean(int columnIndex, boolean x)` Updates the designated column with a `boolean` value.
`void` | `ResultSet.updateByte(int columnIndex, byte x)` Updates the designated column with a `byte` value.
`void` | `ResultSet.updateShort(int columnIndex, short x)` Updates the designated column with a `short` value.
`void` | `ResultSet.updateInt(int columnIndex, int x)` Updates the designated column with an `int` value.
`void` | `ResultSet.updateLong(int columnIndex, long x)` Updates the designated column with a `long` value.
`void` | `ResultSet.updateFloat(int columnIndex, float x)` Updates the designated column with a `float` value.
`void` | `ResultSet.updateDouble(int columnIndex, double x)` Updates the designated column with a `double` value.
`void` | `ResultSet.updateBigDecimal(int columnIndex, BigDecimal x)` Updates the designated column with a `java.math.BigDecimal` value.
`void` | `ResultSet.updateString(int columnIndex, String x)` Updates the designated column with a `String` value.
`void` | `ResultSet.updateBytes(int columnIndex, byte[] x)` Updates the designated column with a `byte` array value.
`void` | `ResultSet.updateDate(int columnIndex, Date x)` Updates the designated column with a `java.sql.Date` value.
`void` | `ResultSet.updateTime(int columnIndex, Time x)` Updates the designated column with a `java.sql.Time` value.
`void` | `ResultSet.updateTimestamp(int columnIndex, Timestamp x)` Updates the designated column with a `java.sql.Timestamp` value.
`void` | `ResultSet.updateAsciiStream(int columnIndex, InputStream x, int length)` Updates the designated column with an ascii stream value.
`void` | `ResultSet.updateBinaryStream(int columnIndex, InputStream x, int length)` Updates the designated column with a binary stream value.
`void` | `ResultSet.updateCharacterStream(int columnIndex, Reader x, int length)` Updates the designated column with a character stream value.
`void` | `ResultSet.updateObject(int columnIndex, Object x, int scale)` Updates the designated column with an `Object` value.
`void` | `ResultSet.updateObject(int columnIndex, Object x)` Updates the designated column with an `Object` value.
`void` | `ResultSet.updateNull(String columnName)` Updates the designated column with a `null` value.
`void` | `ResultSet.updateBoolean(String columnName, boolean x)` Updates the designated column with a `boolean` value.
`void` | `ResultSet.updateByte(String columnName, byte x)` Updates the designated column with a `byte` value.
`void` | `ResultSet.updateShort(String columnName, short x)` Updates the designated column with a `short` value.
`void` | `ResultSet.updateInt(String columnName, int x)` Updates the designated column with an `int` value.
`void` | `ResultSet.updateLong(String columnName, long x)` Updates the designated column with a `long` value.
`void` | `ResultSet.updateFloat(String columnName, float x)` Updates the designated column with a `float` value.
`void` | `ResultSet.updateDouble(String columnName, double x)` Updates the designated column with a `double` value.
`void` | `ResultSet.updateBigDecimal(String columnName, BigDecimal x)` Updates the designated column with a `java.sql.BigDecimal` value.
`void` | `ResultSet.updateString(String columnName, String x)` Updates the designated column with a `String` value.
`void` | `ResultSet.updateBytes(String columnName, byte[] x)` Updates the designated column with a `boolean` value.
`void` | `ResultSet.updateDate(String columnName, Date x)` Updates the designated column with a `java.sql.Date` value.
`void` | `ResultSet.updateTime(String columnName, Time x)` Updates the designated column with a `java.sql.Time` value.
`void` | `ResultSet.updateTimestamp(String columnName, Timestamp x)` Updates the designated column with a `java.sql.Timestamp` value.
`void` | `ResultSet.updateAsciiStream(String columnName, InputStream x, int length)` Updates the designated column with an ascii stream value.
`void` | `ResultSet.updateBinaryStream(String columnName, InputStream x, int length)` Updates the designated column with a binary stream value.
`void` | `ResultSet.updateCharacterStream(String columnName, Reader reader, int length)` Updates the designated column with a character stream value.
`void` | `ResultSet.updateObject(String columnName, Object x, int scale)` Updates the designated column with an `Object` value.
`void` | `ResultSet.updateObject(String columnName, Object x)` Updates the designated column with an `Object` value.
`void` | `ResultSet.insertRow()` Inserts the contents of the insert row into this `ResultSet` objaect and into the database.
`void` | `ResultSet.updateRow()` Updates the underlying database with the new contents of the current row of this `ResultSet` object.
`void` | `ResultSet.deleteRow()` Deletes the current row from this `ResultSet` object and from the underlying database.
`void` | `ResultSet.refreshRow()` Refreshes the current row with its most recent value in the database.
`void` | `ResultSet.cancelRowUpdates()` Cancels the updates made to the current row in this `ResultSet` object.
`void` | `ResultSet.moveToInsertRow()` Moves the cursor to the insert row.
`void` | `ResultSet.moveToCurrentRow()` Moves the cursor to the remembered cursor position, usually the current row.
`Statement` | `ResultSet.getStatement()` Returns the `Statement` object that produced this `ResultSet` object.
`Object` | `ResultSet.getObject(int i, Map map)` Returns the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`Ref` | `ResultSet.getRef(int i)` Returns the value of the designated column in the current row of this `ResultSet` object as a `Ref` object in the Java programming language.
`Blob` | `ResultSet.getBlob(int i)` Returns the value of the designated column in the current row of this `ResultSet` object as a `Blob` object in the Java programming language.
`Clob` | `ResultSet.getClob(int i)` Returns the value of the designated column in the current row of this `ResultSet` object as a `Clob` object in the Java programming language.
`Array` | `ResultSet.getArray(int i)` Returns the value of the designated column in the current row of this `ResultSet` object as an `Array` object in the Java programming language.
`Object` | `ResultSet.getObject(String colName, Map map)` Returns the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`Ref` | `ResultSet.getRef(String colName)` Returns the value of the designated column in the current row of this `ResultSet` object as a `Ref` object in the Java programming language.
`Blob` | `ResultSet.getBlob(String colName)` Returns the value of the designated column in the current row of this `ResultSet` object as a `Blob` object in the Java programming language.
`Clob` | `ResultSet.getClob(String colName)` Returns the value of the designated column in the current row of this `ResultSet` object as a `Clob` object in the Java programming language.
`Array` | `ResultSet.getArray(String colName)` Returns the value of the designated column in the current row of this `ResultSet` object as an `Array` object in the Java programming language.
`Date` | `ResultSet.getDate(int columnIndex, Calendar cal)` Returns the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`Date` | `ResultSet.getDate(String columnName, Calendar cal)` Returns the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`Time` | `ResultSet.getTime(int columnIndex, Calendar cal)` Returns the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`Time` | `ResultSet.getTime(String columnName, Calendar cal)` Returns the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`Timestamp` | `ResultSet.getTimestamp(int columnIndex, Calendar cal)` Returns the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`Timestamp` | `ResultSet.getTimestamp(String columnName, Calendar cal)` Returns the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`int` | `ResultSetMetaData.getColumnCount()` Returns the number of columns in this `ResultSet` object.
`boolean` | `ResultSetMetaData.isAutoIncrement(int column)` Indicates whether the designated column is automatically numbered, thus read-only.
`boolean` | `ResultSetMetaData.isCaseSensitive(int column)` Indicates whether a column's case matters.
`boolean` | `ResultSetMetaData.isSearchable(int column)` Indicates whether the designated column can be used in a where clause.
`boolean` | `ResultSetMetaData.isCurrency(int column)` Indicates whether the designated column is a cash value.
`int` | `ResultSetMetaData.isNullable(int column)` Indicates the nullability of values in the designated column.
`boolean` | `ResultSetMetaData.isSigned(int column)` Indicates whether values in the designated column are signed numbers.
`int` | `ResultSetMetaData.getColumnDisplaySize(int column)` Indicates the designated column's normal maximum width in characters.
`String` | `ResultSetMetaData.getColumnLabel(int column)` Gets the designated column's suggested title for use in printouts and displays.
`String` | `ResultSetMetaData.getColumnName(int column)` Get the designated column's name.
`String` | `ResultSetMetaData.getSchemaName(int column)` Get the designated column's table's schema.
`int` | `ResultSetMetaData.getPrecision(int column)` Get the designated column's number of decimal digits.
`int` | `ResultSetMetaData.getScale(int column)` Gets the designated column's number of digits to right of the decimal point.
`String` | `ResultSetMetaData.getTableName(int column)` Gets the designated column's table name.
`String` | `ResultSetMetaData.getCatalogName(int column)` Gets the designated column's table's catalog name.
`int` | `ResultSetMetaData.getColumnType(int column)` Retrieves the designated column's SQL type.
`String` | `ResultSetMetaData.getColumnTypeName(int column)` Retrieves the designated column's database-specific type name.
`boolean` | `ResultSetMetaData.isReadOnly(int column)` Indicates whether the designated column is definitely not writable.
`boolean` | `ResultSetMetaData.isWritable(int column)` Indicates whether it is possible for a write on the designated column to succeed.
`boolean` | `ResultSetMetaData.isDefinitelyWritable(int column)` Indicates whether a write on the designated column will definitely succeed.
`String` | `ResultSetMetaData.getColumnClassName(int column)` Returns the fully-qualified name of the Java class whose instances are manufactured if the method `ResultSet.getObject` is called to retrieve a value from the column.
`String` | `Ref.getBaseTypeName()` Retrieves the fully-qualified SQL name of the SQL structured type that this `Ref` object references.
`long` | `Clob.length()` Returns the number of characters in the `CLOB` value designated by this `Clob` object.
`String` | `Clob.getSubString(long pos, int length)` Returns a copy of the specified substring in the `CLOB` value designated by this `Clob` object.
`Reader` | `Clob.getCharacterStream()` Gets the `CLOB` value designated by this `Clob` object as a Unicode stream.
`InputStream` | `Clob.getAsciiStream()` Gets the `CLOB` value designated by this `Clob` object as a stream of Ascii bytes.
`long` | `Clob.position(String searchstr, long start)` Determines the character position at which the specified substring `searchstr` appears in the SQL `CLOB` value represented by this `Clob` object.
`long` | `Clob.position(Clob searchstr, long start)` Determines the character position at which the specified `Clob` object `searchstr` appears in this `Clob` object.

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
| JavaTM 2 Platform Std. Ed. v1.3.1
PREV NEXT | FRAMES NO FRAMES

Submit a bug or feature
For further API reference and developer documentation, see Java 2 SDK SE Developer Documentation. That documentation contains more detailed, developer-targeted descriptions, with conceptual overviews, definitions of terms, workarounds, and working code examples.

Java, Java 2D, and JDBC are trademarks or registered trademarks of Sun Microsystems, Inc. in the US and other countries.
Copyright 1993-2001 Sun Microsystems, Inc. 901 San Antonio Road
Palo Alto, California, 94303, U.S.A. All Rights Reserved.