Uses of Class
java.sql.SQLException

Packages that use SQLException
Package
Description
Provides the API for accessing and processing data stored in a data source (usually a relational database) using the Java programming language.
Provides the API for server side data source access and processing from the Java programming language.
Standard interfaces and base classes for JDBC RowSet implementations.
Provides utility classes to allow serializable mappings between SQL types and data types in the Java programming language.
The standard classes and interfaces that a third party vendor has to use in its implementation of a synchronization provider.
  • Uses of SQLException in java.sql

    Subclasses of SQLException in java.sql
    Modifier and Type
    Class
    Description
    class 
    The subclass of SQLException thrown when an error occurs during a batch update operation.
    class 
    An exception thrown as a DataTruncation exception (on writes) or reported as a DataTruncation warning (on reads) when a data values is unexpectedly truncated for reasons other than its having exceeded MaxFieldSize.
    class 
    The subclass of SQLException is thrown when one or more client info properties could not be set on a Connection.
    class 
    The subclass of SQLException thrown when the SQLState class value is '22', or under vendor-specified conditions.
    class 
    The subclass of SQLException thrown when the SQLState class value is '0A' ( the value is 'zero' A).
    class 
    The subclass of SQLException thrown when the SQLState class value is '23', or under vendor-specified conditions.
    class 
    The subclass of SQLException thrown when the SQLState class value is '28', or under vendor-specified conditions.
    class 
    The subclass of SQLException thrown for the SQLState class value '08', or under vendor-specified conditions.
    class 
    The subclass of SQLException thrown when an instance where a retry of the same operation would fail unless the cause of the SQLException is corrected.
    class 
    The subclass of SQLException thrown in situations where a previously failed operation might be able to succeed if the application performs some recovery steps and retries the entire transaction or in the case of a distributed transaction, the transaction branch.
    class 
    The subclass of SQLException thrown when the SQLState class value is '42', or under vendor-specified conditions.
    class 
    The subclass of SQLException thrown when the timeout specified by Statement.setQueryTimeout, DriverManager.setLoginTimeout, DataSource.setLoginTimeout,XADataSource.setLoginTimeout has expired.
    class 
    The subclass of SQLException thrown when the SQLState class value is '40', or under vendor-specified conditions.
    class 
    The subclass of SQLException for the SQLState class value '08', or under vendor-specified conditions.
    class 
    The subclass of SQLException is thrown in situations where a previously failed operation might be able to succeed when the operation is retried without any intervention by application-level functionality.
    class 
    An exception that provides information on database access warnings.
    Methods in java.sql that return SQLException
    Modifier and Type
    Method
    Description
    SQLException.getNextException()
    Retrieves the exception chained to this SQLException object by setNextException(SQLException ex).
    Methods in java.sql with parameters of type SQLException
    Modifier and Type
    Method
    Description
    void
    SQLException.setNextException(SQLException ex)
    Adds an SQLException object to the end of the chain.
    Methods in java.sql that throw SQLException
    Modifier and Type
    Method
    Description
    void
    Connection.abort(Executor executor)
    Terminates an open connection.
    boolean
    ResultSet.absolute(int row)
    Moves the cursor to the given row number in this ResultSet object.
    boolean
    Driver.acceptsURL(String url)
    Retrieves whether the driver thinks that it can open a connection to the given URL.
    void
    PreparedStatement.addBatch()
    Adds a set of parameters to this PreparedStatement object's batch of commands.
    void
    Statement.addBatch(String sql)
    Adds the given SQL command to the current list of commands for this Statement object.
    void
    ResultSet.afterLast()
    Moves the cursor to the end of this ResultSet object, just after the last row.
    boolean
    DatabaseMetaData.allProceduresAreCallable()
    Retrieves whether the current user can call all the procedures returned by the method getProcedures.
    boolean
    DatabaseMetaData.allTablesAreSelectable()
    Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT statement.
    boolean
    Retrieves whether a SQLException while autoCommit is true indicates that all open ResultSets are closed, even ones that are holdable.
    void
    ResultSet.beforeFirst()
    Moves the cursor to the front of this ResultSet object, just before the first row.
    default void
    Connection.beginRequest()
    Hints to the driver that a request, an independent unit of work, is beginning on this connection.
    ConnectionBuilder.build()
    Returns an instance of the object defined by this builder.
    ShardingKeyBuilder.build()
    Returns an instance of the object defined by this builder.
    void
    Statement.cancel()
    Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.
    void
    ResultSet.cancelRowUpdates()
    Cancels the updates made to the current row in this ResultSet object.
    void
    Statement.clearBatch()
    Empties this Statement object's current list of SQL commands.
    void
    PreparedStatement.clearParameters()
    Clears the current parameter values immediately.
    void
    Connection.clearWarnings()
    Clears all warnings reported for this Connection object.
    void
    ResultSet.clearWarnings()
    Clears all warnings reported on this ResultSet object.
    void
    Statement.clearWarnings()
    Clears all the warnings reported on this Statement object.
    void
    Connection.close()
    Releases this Connection object's database and JDBC resources immediately instead of waiting for them to be automatically released.
    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.
    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.
    void
    Statement.closeOnCompletion()
    Specifies that this Statement will be closed when all its dependent result sets are closed.
    void
    Connection.commit()
    Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by this Connection object.
    Driver.connect(String url, Properties info)
    Attempts to make a database connection to the given URL.
    Connection.createArrayOf(String typeName, Object[] elements)
    Factory method for creating Array objects.
    Connection.createBlob()
    Constructs an object that implements the Blob interface.
    Connection.createClob()
    Constructs an object that implements the Clob interface.
    Connection.createNClob()
    Constructs an object that implements the NClob interface.
    Connection.createSQLXML()
    Constructs an object that implements the SQLXML interface.
    Connection.createStatement()
    Creates a Statement object for sending SQL statements to the database.
    Connection.createStatement(int resultSetType, int resultSetConcurrency)
    Creates a Statement object that will generate ResultSet objects with the given type and concurrency.
    Connection.createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)
    Creates a Statement object that will generate ResultSet objects with the given type, concurrency, and holdability.
    Connection.createStruct(String typeName, Object[] attributes)
    Factory method for creating Struct objects.
    boolean
    Retrieves whether a data definition statement within a transaction forces the transaction to commit.
    boolean
    Retrieves whether this database ignores a data definition statement within a transaction.
    void
    ResultSet.deleteRow()
    Deletes the current row from this ResultSet object and from the underlying database.
    boolean
    DatabaseMetaData.deletesAreDetected(int type)
    Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted.
    static void
    DriverManager.deregisterDriver(Driver driver)
    Removes the specified driver from the DriverManager's list of registered drivers.
    boolean
    DatabaseMetaData.doesMaxRowSizeIncludeBlobs()
    Retrieves whether the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.
    default void
    Connection.endRequest()
    Hints to the driver that a request, an independent unit of work, has completed.
    default String
    Statement.enquoteIdentifier(String identifier, boolean alwaysQuote)
    Returns a SQL identifier.
    default String
    Statement.enquoteLiteral(String val)
    Returns a String enclosed in single quotes.
    default String
    Statement.enquoteNCharLiteral(String val)
    Returns a String representing a National Character Set Literal enclosed in single quotes and prefixed with a upper case letter N.
    boolean
    PreparedStatement.execute()
    Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.
    boolean
    Statement.execute(String sql)
    Executes the given SQL statement, which may return multiple results.
    boolean
    Statement.execute(String sql, int autoGeneratedKeys)
    Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval.
    boolean
    Statement.execute(String sql, int[] columnIndexes)
    Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
    boolean
    Statement.execute(String sql, String[] columnNames)
    Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
    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.
    default long[]
    Statement.executeLargeBatch()
    Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
    default long
    PreparedStatement.executeLargeUpdate()
    Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
    default long
    Statement.executeLargeUpdate(String sql)
    Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.
    default long
    Statement.executeLargeUpdate(String sql, int autoGeneratedKeys)
    Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval.
    default long
    Statement.executeLargeUpdate(String sql, int[] columnIndexes)
    Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
    default long
    Statement.executeLargeUpdate(String sql, String[] columnNames)
    Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
    PreparedStatement.executeQuery()
    Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.
    Statement.executeQuery(String sql)
    Executes the given SQL statement, which returns a single ResultSet object.
    int
    PreparedStatement.executeUpdate()
    Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
    int
    Statement.executeUpdate(String sql)
    Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.
    int
    Statement.executeUpdate(String sql, int autoGeneratedKeys)
    Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval.
    int
    Statement.executeUpdate(String sql, int[] columnIndexes)
    Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
    int
    Statement.executeUpdate(String sql, String[] columnNames)
    Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
    int
    ResultSet.findColumn(String columnLabel)
    Maps the given ResultSet column label to its ResultSet column index.
    boolean
    ResultSet.first()
    Moves the cursor to the first row in this ResultSet object.
    void
    Array.free()
    This method frees the Array object and releases the resources that it holds.
    void
    Blob.free()
    This method frees the Blob object and releases the resources that it holds.
    void
    Clob.free()
    This method releases the resources that the Clob object holds.
    void
    SQLXML.free()
    This method closes this object and releases the resources that it held.
    boolean
    DatabaseMetaData.generatedKeyAlwaysReturned()
    Retrieves whether a generated key will always be returned if the column name(s) or index(es) specified for the auto generated key column(s) are valid and the statement succeeds.
    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.
    Array.getArray(long index, int count)
    Retrieves 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.
    Array.getArray(long index, int count, Map<String,Class<?>> map)
    Retrieves 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.
    Array.getArray(Map<String,Class<?>> map)
    Retrieves the contents of the SQL ARRAY value designated by this Array object.
    CallableStatement.getArray(int parameterIndex)
    Retrieves the value of the designated JDBC ARRAY parameter as an Array object in the Java programming language.
    CallableStatement.getArray(String parameterName)
    Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language.
    ResultSet.getArray(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.
    ResultSet.getArray(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.
    Retrieves the CLOB value designated by this Clob object as an ascii stream.
    ResultSet.getAsciiStream(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.
    ResultSet.getAsciiStream(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.
    DatabaseMetaData.getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)
    Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog.
    Struct.getAttributes()
    Produces the ordered values of the attributes of the SQL structured type that this Struct object represents.
    Struct.getAttributes(Map<String,Class<?>> map)
    Produces the ordered values of the attributes of the SQL structured type that this Struct object represents.
    boolean
    Connection.getAutoCommit()
    Retrieves the current auto-commit mode for this Connection object.
    int
    Array.getBaseType()
    Retrieves the JDBC type of the elements in the array designated by this Array object.
    Retrieves the SQL type name of the elements in the array designated by this Array object.
    Retrieves the fully-qualified SQL name of the SQL structured type that this Ref object references.
    DatabaseMetaData.getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)
    Retrieves a description of a table's optimal set of columns that uniquely identifies a row.
    CallableStatement.getBigDecimal(int parameterIndex)
    Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.
    CallableStatement.getBigDecimal(int parameterIndex, int scale)
    Deprecated.
    use getBigDecimal(int parameterIndex) or getBigDecimal(String parameterName)
    CallableStatement.getBigDecimal(String parameterName)
    Retrieves 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.
    ResultSet.getBigDecimal(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.
    ResultSet.getBigDecimal(int columnIndex, int scale)
    Deprecated.
    Use getBigDecimal(int columnIndex) or getBigDecimal(String columnLabel)
    ResultSet.getBigDecimal(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.
    ResultSet.getBigDecimal(String columnLabel, int scale)
    Deprecated.
    Use getBigDecimal(int columnIndex) or getBigDecimal(String columnLabel)
    Retrieves the BLOB value designated by this Blob instance as a stream.
    Blob.getBinaryStream(long pos, long length)
    Returns an InputStream object that contains a partial Blob value, starting with the byte specified by pos, which is length bytes in length.
    ResultSet.getBinaryStream(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.
    ResultSet.getBinaryStream(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.
    Retrieves the XML value designated by this SQLXML instance as a stream.
    CallableStatement.getBlob(int parameterIndex)
    Retrieves the value of the designated JDBC BLOB parameter as a Blob object in the Java programming language.
    CallableStatement.getBlob(String parameterName)
    Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language.
    ResultSet.getBlob(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
    ResultSet.getBlob(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
    boolean
    CallableStatement.getBoolean(int parameterIndex)
    Retrieves the value of the designated JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.
    boolean
    CallableStatement.getBoolean(String parameterName)
    Retrieves the value of a JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.
    boolean
    ResultSet.getBoolean(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
    boolean
    ResultSet.getBoolean(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
    byte
    CallableStatement.getByte(int parameterIndex)
    Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.
    byte
    CallableStatement.getByte(String parameterName)
    Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.
    byte
    ResultSet.getByte(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
    byte
    ResultSet.getByte(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
    byte[]
    Blob.getBytes(long pos, int length)
    Retrieves all or part of the BLOB value that this Blob object represents, as an array of bytes.
    byte[]
    CallableStatement.getBytes(int parameterIndex)
    Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.
    byte[]
    CallableStatement.getBytes(String parameterName)
    Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.
    byte[]
    ResultSet.getBytes(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
    byte[]
    ResultSet.getBytes(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
    Connection.getCatalog()
    Retrieves this Connection object's current catalog name.
    ResultSetMetaData.getCatalogName(int column)
    Gets the designated column's table's catalog name.
    DatabaseMetaData.getCatalogs()
    Retrieves the catalog names available in this database.
    DatabaseMetaData.getCatalogSeparator()
    Retrieves the String that this database uses as the separator between a catalog and table name.
    DatabaseMetaData.getCatalogTerm()
    Retrieves the database vendor's preferred term for "catalog".
    CallableStatement.getCharacterStream(int parameterIndex)
    Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
    CallableStatement.getCharacterStream(String parameterName)
    Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
    Retrieves the CLOB value designated by this Clob object as a java.io.Reader object (or as a stream of characters).
    Clob.getCharacterStream(long pos, long length)
    Returns a Reader object that contains a partial Clob value, starting with the character specified by pos, which is length characters in length.
    ResultSet.getCharacterStream(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
    ResultSet.getCharacterStream(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
    Retrieves the XML value designated by this SQLXML instance as a java.io.Reader object.
    Connection.getClientInfo()
    Returns a list containing the name and current value of each client info property supported by the driver.
    Connection.getClientInfo(String name)
    Returns the value of the client info property specified by name.
    DatabaseMetaData.getClientInfoProperties()
    Retrieves a list of the client info properties that the driver supports.
    CallableStatement.getClob(int parameterIndex)
    Retrieves the value of the designated JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.
    CallableStatement.getClob(String parameterName)
    Retrieves the value of a JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.
    ResultSet.getClob(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.
    ResultSet.getClob(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.
    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.
    int
    ResultSetMetaData.getColumnCount()
    Returns the number of columns in this ResultSet object.
    int
    ResultSetMetaData.getColumnDisplaySize(int column)
    Indicates the designated column's normal maximum width in characters.
    ResultSetMetaData.getColumnLabel(int column)
    Gets the designated column's suggested title for use in printouts and displays.
    ResultSetMetaData.getColumnName(int column)
    Get the designated column's name.
    DatabaseMetaData.getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)
    Retrieves a description of the access rights for a table's columns.
    DatabaseMetaData.getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
    Retrieves a description of table columns available in the specified catalog.
    int
    ResultSetMetaData.getColumnType(int column)
    Retrieves the designated column's SQL type.
    ResultSetMetaData.getColumnTypeName(int column)
    Retrieves the designated column's database-specific type name.
    int
    ResultSet.getConcurrency()
    Retrieves the concurrency mode of this ResultSet object.
    DatabaseMetaData.getConnection()
    Retrieves the connection that produced this metadata object.
    static Connection
    DriverManager.getConnection(String url)
    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, Properties info)
    Attempts to establish a connection to the given database URL.
    Statement.getConnection()
    Retrieves the Connection object that produced this Statement object.
    DatabaseMetaData.getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable)
    Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table).
    ResultSet.getCursorName()
    Retrieves the name of the SQL cursor used by this ResultSet object.
    int
    DatabaseMetaData.getDatabaseMajorVersion()
    Retrieves the major version number of the underlying database.
    int
    DatabaseMetaData.getDatabaseMinorVersion()
    Retrieves the minor version number of the underlying database.
    DatabaseMetaData.getDatabaseProductName()
    Retrieves the name of this database product.
    DatabaseMetaData.getDatabaseProductVersion()
    Retrieves the version number of this database product.
    CallableStatement.getDate(int parameterIndex)
    Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object.
    CallableStatement.getDate(int parameterIndex, Calendar cal)
    Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.
    CallableStatement.getDate(String parameterName)
    Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.
    CallableStatement.getDate(String parameterName, Calendar cal)
    Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.
    ResultSet.getDate(int columnIndex)
    Retrieves 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.
    ResultSet.getDate(int columnIndex, Calendar cal)
    Retrieves 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.
    ResultSet.getDate(String columnLabel)
    Retrieves 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.
    ResultSet.getDate(String columnLabel, Calendar cal)
    Retrieves 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.
    int
    Retrieves this database's default transaction isolation level.
    double
    CallableStatement.getDouble(int parameterIndex)
    Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.
    double
    CallableStatement.getDouble(String parameterName)
    Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.
    double
    ResultSet.getDouble(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
    double
    ResultSet.getDouble(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
    static Driver
    DriverManager.getDriver(String url)
    Attempts to locate a driver that understands the given URL.
    DatabaseMetaData.getDriverName()
    Retrieves the name of this JDBC driver.
    DatabaseMetaData.getDriverVersion()
    Retrieves the version number of this JDBC driver as a String.
    DatabaseMetaData.getExportedKeys(String catalog, String schema, String table)
    Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).
    DatabaseMetaData.getExtraNameCharacters()
    Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
    int
    ResultSet.getFetchDirection()
    Retrieves the fetch direction for this ResultSet object.
    int
    Statement.getFetchDirection()
    Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object.
    int
    ResultSet.getFetchSize()
    Retrieves the fetch size for this ResultSet object.
    int
    Statement.getFetchSize()
    Retrieves the number of result set rows that is the default fetch size for ResultSet objects generated from this Statement object.
    float
    CallableStatement.getFloat(int parameterIndex)
    Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.
    float
    CallableStatement.getFloat(String parameterName)
    Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.
    float
    ResultSet.getFloat(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
    float
    ResultSet.getFloat(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
    DatabaseMetaData.getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern)
    Retrieves a description of the given catalog's system or user function parameters and return type.
    DatabaseMetaData.getFunctions(String catalog, String schemaPattern, String functionNamePattern)
    Retrieves a description of the system and user functions available in the given catalog.
    Statement.getGeneratedKeys()
    Retrieves any auto-generated keys created as a result of executing this Statement object.
    int
    Connection.getHoldability()
    Retrieves the current holdability of ResultSet objects created using this Connection object.
    int
    ResultSet.getHoldability()
    Retrieves the holdability of this ResultSet object
    DatabaseMetaData.getIdentifierQuoteString()
    Retrieves the string used to quote SQL identifiers.
    DatabaseMetaData.getImportedKeys(String catalog, String schema, String table)
    Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a table).
    DatabaseMetaData.getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)
    Retrieves a description of the given table's indices and statistics.
    int
    CallableStatement.getInt(int parameterIndex)
    Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.
    int
    CallableStatement.getInt(String parameterName)
    Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.
    int
    ResultSet.getInt(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
    int
    ResultSet.getInt(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
    int
    DatabaseMetaData.getJDBCMajorVersion()
    Retrieves the major JDBC version number for this driver.
    int
    DatabaseMetaData.getJDBCMinorVersion()
    Retrieves the minor JDBC version number for this driver.
    default long
    Statement.getLargeMaxRows()
    Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.
    default long
    Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.
    long
    CallableStatement.getLong(int parameterIndex)
    Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.
    long
    CallableStatement.getLong(String parameterName)
    Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.
    long
    ResultSet.getLong(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
    long
    ResultSet.getLong(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
    int
    DatabaseMetaData.getMaxBinaryLiteralLength()
    Retrieves the maximum number of hex characters this database allows in an inline binary literal.
    int
    DatabaseMetaData.getMaxCatalogNameLength()
    Retrieves the maximum number of characters that this database allows in a catalog name.
    int
    DatabaseMetaData.getMaxCharLiteralLength()
    Retrieves the maximum number of characters this database allows for a character literal.
    int
    DatabaseMetaData.getMaxColumnNameLength()
    Retrieves the maximum number of characters this database allows for a column name.
    int
    DatabaseMetaData.getMaxColumnsInGroupBy()
    Retrieves the maximum number of columns this database allows in a GROUP BY clause.
    int
    DatabaseMetaData.getMaxColumnsInIndex()
    Retrieves the maximum number of columns this database allows in an index.
    int
    DatabaseMetaData.getMaxColumnsInOrderBy()
    Retrieves the maximum number of columns this database allows in an ORDER BY clause.
    int
    DatabaseMetaData.getMaxColumnsInSelect()
    Retrieves the maximum number of columns this database allows in a SELECT list.
    int
    DatabaseMetaData.getMaxColumnsInTable()
    Retrieves the maximum number of columns this database allows in a table.
    int
    DatabaseMetaData.getMaxConnections()
    Retrieves the maximum number of concurrent connections to this database that are possible.
    int
    DatabaseMetaData.getMaxCursorNameLength()
    Retrieves the maximum number of characters that this database allows in a cursor name.
    int
    Statement.getMaxFieldSize()
    Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object.
    int
    DatabaseMetaData.getMaxIndexLength()
    Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.
    default long
    DatabaseMetaData.getMaxLogicalLobSize()
    Retrieves the maximum number of bytes this database allows for the logical size for a LOB.
    int
    DatabaseMetaData.getMaxProcedureNameLength()
    Retrieves the maximum number of characters that this database allows in a procedure name.
    int
    Statement.getMaxRows()
    Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.
    int
    DatabaseMetaData.getMaxRowSize()
    Retrieves the maximum number of bytes this database allows in a single row.
    int
    DatabaseMetaData.getMaxSchemaNameLength()
    Retrieves the maximum number of characters that this database allows in a schema name.
    int
    DatabaseMetaData.getMaxStatementLength()
    Retrieves the maximum number of characters this database allows in an SQL statement.
    int
    DatabaseMetaData.getMaxStatements()
    Retrieves the maximum number of active statements to this database that can be open at the same time.
    int
    DatabaseMetaData.getMaxTableNameLength()
    Retrieves the maximum number of characters this database allows in a table name.
    int
    DatabaseMetaData.getMaxTablesInSelect()
    Retrieves the maximum number of tables this database allows in a SELECT statement.
    int
    DatabaseMetaData.getMaxUserNameLength()
    Retrieves the maximum number of characters this database allows in a user name.
    Connection.getMetaData()
    Retrieves a DatabaseMetaData object that contains metadata about the database to which this Connection object represents a connection.
    PreparedStatement.getMetaData()
    Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet object that will be returned when this PreparedStatement object is executed.
    ResultSet.getMetaData()
    Retrieves the number, types and properties of this ResultSet object's columns.
    boolean
    Statement.getMoreResults()
    Moves to this Statement object's next result, returns true if it is a ResultSet object, and implicitly closes any current ResultSet object(s) obtained with the method getResultSet.
    boolean
    Statement.getMoreResults(int current)
    Moves to this Statement object's next result, deals with any current ResultSet object(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object.
    CallableStatement.getNCharacterStream(int parameterIndex)
    Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
    CallableStatement.getNCharacterStream(String parameterName)
    Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
    ResultSet.getNCharacterStream(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
    ResultSet.getNCharacterStream(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
    CallableStatement.getNClob(int parameterIndex)
    Retrieves the value of the designated JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.
    CallableStatement.getNClob(String parameterName)
    Retrieves the value of a JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.
    ResultSet.getNClob(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.
    ResultSet.getNClob(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.
    int
    Connection.getNetworkTimeout()
    Retrieves the number of milliseconds the driver will wait for a database request to complete.
    CallableStatement.getNString(int parameterIndex)
    Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.
    CallableStatement.getNString(String parameterName)
    Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.
    ResultSet.getNString(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
    ResultSet.getNString(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
    DatabaseMetaData.getNumericFunctions()
    Retrieves a comma-separated list of math functions available with this database.
    CallableStatement.getObject(int parameterIndex)
    Retrieves the value of the designated parameter as an Object in the Java programming language.
    <T> T
    CallableStatement.getObject(int parameterIndex, Class<T> type)
    Returns an object representing the value of OUT parameter parameterIndex and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
    CallableStatement.getObject(int parameterIndex, Map<String,Class<?>> map)
    Returns an object representing the value of OUT parameter parameterIndex and uses map for the custom mapping of the parameter value.
    CallableStatement.getObject(String parameterName)
    Retrieves the value of a parameter as an Object in the Java programming language.
    <T> T
    CallableStatement.getObject(String parameterName, Class<T> type)
    Returns an object representing the value of OUT parameter parameterName and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
    CallableStatement.getObject(String parameterName, Map<String,Class<?>> map)
    Returns an object representing the value of OUT parameter parameterName and uses map for the custom mapping of the parameter value.
    Ref.getObject()
    Retrieves the SQL structured type instance referenced by this Ref object.
    Ref.getObject(Map<String,Class<?>> map)
    Retrieves the referenced object and maps it to a Java type using the given type map.
    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.
    <T> T
    ResultSet.getObject(int columnIndex, Class<T> type)
    Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.
    ResultSet.getObject(int columnIndex, Map<String,Class<?>> map)
    Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
    ResultSet.getObject(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
    <T> T
    ResultSet.getObject(String columnLabel, Class<T> type)
    Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.
    ResultSet.getObject(String columnLabel, Map<String,Class<?>> map)
    Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
    ParameterMetaData.getParameterClassName(int param)
    Retrieves the fully-qualified name of the Java class whose instances should be passed to the method PreparedStatement.setObject.
    int
    ParameterMetaData.getParameterCount()
    Retrieves the number of parameters in the PreparedStatement object for which this ParameterMetaData object contains information.
    PreparedStatement.getParameterMetaData()
    Retrieves the number, types and properties of this PreparedStatement object's parameters.
    int
    ParameterMetaData.getParameterMode(int param)
    Retrieves the designated parameter's mode.
    int
    ParameterMetaData.getParameterType(int param)
    Retrieves the designated parameter's SQL type.
    ParameterMetaData.getParameterTypeName(int param)
    Retrieves the designated parameter's database-specific type name.
    int
    ParameterMetaData.getPrecision(int param)
    Retrieves the designated parameter's specified column size.
    int
    ResultSetMetaData.getPrecision(int column)
    Get the designated column's specified column size.
    DatabaseMetaData.getPrimaryKeys(String catalog, String schema, String table)
    Retrieves a description of the given table's primary key columns.
    DatabaseMetaData.getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)
    Retrieves a description of the given catalog's stored procedure parameter and result columns.
    DatabaseMetaData.getProcedures(String catalog, String schemaPattern, String procedureNamePattern)
    Retrieves a description of the stored procedures available in the given catalog.
    DatabaseMetaData.getProcedureTerm()
    Retrieves the database vendor's preferred term for "procedure".
    Driver.getPropertyInfo(String url, Properties info)
    Gets information about the possible properties for this driver.
    DatabaseMetaData.getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
    Retrieves a description of the pseudo or hidden columns available in a given table within the specified catalog and schema.
    int
    Statement.getQueryTimeout()
    Retrieves the number of seconds the driver will wait for a Statement object to execute.
    CallableStatement.getRef(int parameterIndex)
    Retrieves the value of the designated JDBC REF(<structured-type>) parameter as a Ref object in the Java programming language.
    CallableStatement.getRef(String parameterName)
    Retrieves the value of a JDBC REF(<structured-type>) parameter as a Ref object in the Java programming language.
    ResultSet.getRef(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.
    ResultSet.getRef(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.
    Array.getResultSet()
    Retrieves a result set that contains the elements of the SQL ARRAY value designated by this Array object.
    Array.getResultSet(long index, int count)
    Retrieves a result set holding the elements of the subarray that starts at index index and contains up to count successive elements.
    Array.getResultSet(long index, int count, Map<String,Class<?>> map)
    Retrieves a result set holding the elements of the subarray that starts at index index and contains up to count successive elements.
    Array.getResultSet(Map<String,Class<?>> map)
    Retrieves a result set that contains the elements of the SQL ARRAY value designated by this Array object.
    Statement.getResultSet()
    Retrieves the current result as a ResultSet object.
    int
    Retrieves the result set concurrency for ResultSet objects generated by this Statement object.
    int
    DatabaseMetaData.getResultSetHoldability()
    Retrieves this database's default holdability for ResultSet objects.
    int
    Retrieves the result set holdability for ResultSet objects generated by this Statement object.
    int
    Statement.getResultSetType()
    Retrieves the result set type for ResultSet objects generated by this Statement object.
    int
    ResultSet.getRow()
    Retrieves the current row number.
    CallableStatement.getRowId(int parameterIndex)
    Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.
    CallableStatement.getRowId(String parameterName)
    Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.
    ResultSet.getRowId(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.
    ResultSet.getRowId(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.
    DatabaseMetaData.getRowIdLifetime()
    Indicates whether this data source supports the SQL ROWID type, and the lifetime for which a RowId object remains valid.
    int
    Savepoint.getSavepointId()
    Retrieves the generated ID for the savepoint that this Savepoint object represents.
    Savepoint.getSavepointName()
    Retrieves the name of the savepoint that this Savepoint object represents.
    int
    ParameterMetaData.getScale(int param)
    Retrieves the designated parameter's number of digits to right of the decimal point. 0 is returned for data types where the scale is not applicable.
    int
    ResultSetMetaData.getScale(int column)
    Gets the designated column's number of digits to right of the decimal point. 0 is returned for data types where the scale is not applicable.
    Connection.getSchema()
    Retrieves this Connection object's current schema name.
    ResultSetMetaData.getSchemaName(int column)
    Get the designated column's table's schema.
    DatabaseMetaData.getSchemas()
    Retrieves the schema names available in this database.
    DatabaseMetaData.getSchemas(String catalog, String schemaPattern)
    Retrieves the schema names available in this database.
    DatabaseMetaData.getSchemaTerm()
    Retrieves the database vendor's preferred term for "schema".
    DatabaseMetaData.getSearchStringEscape()
    Retrieves the string that can be used to escape wildcard characters.
    short
    CallableStatement.getShort(int parameterIndex)
    Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.
    short
    CallableStatement.getShort(String parameterName)
    Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.
    short
    ResultSet.getShort(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
    short
    ResultSet.getShort(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
    <T extends Source>
    T
    SQLXML.getSource(Class<T> sourceClass)
    Returns a Source for reading the XML value designated by this SQLXML instance.
    DatabaseMetaData.getSQLKeywords()
    Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.
    int
    DatabaseMetaData.getSQLStateType()
    Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL:2003.
    SQLData.getSQLTypeName()
    Returns the fully-qualified name of the SQL user-defined type that this object represents.
    Retrieves the SQL type name of the SQL structured type that this Struct object represents.
    CallableStatement.getSQLXML(int parameterIndex)
    Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.
    CallableStatement.getSQLXML(String parameterName)
    Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.
    ResultSet.getSQLXML(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.
    ResultSet.getSQLXML(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.
    ResultSet.getStatement()
    Retrieves the Statement object that produced this ResultSet object.
    CallableStatement.getString(int parameterIndex)
    Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
    CallableStatement.getString(String parameterName)
    Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
    ResultSet.getString(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
    ResultSet.getString(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
    SQLXML.getString()
    Returns a string representation of the XML value designated by this SQLXML instance.
    DatabaseMetaData.getStringFunctions()
    Retrieves a comma-separated list of string functions available with this database.
    Clob.getSubString(long pos, int length)
    Retrieves a copy of the specified substring in the CLOB value designated by this Clob object.
    DatabaseMetaData.getSuperTables(String catalog, String schemaPattern, String tableNamePattern)
    Retrieves a description of the table hierarchies defined in a particular schema in this database.
    DatabaseMetaData.getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)
    Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database.
    DatabaseMetaData.getSystemFunctions()
    Retrieves a comma-separated list of system functions available with this database.
    ResultSetMetaData.getTableName(int column)
    Gets the designated column's table name.
    DatabaseMetaData.getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
    Retrieves a description of the access rights for each table available in a catalog.
    DatabaseMetaData.getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)
    Retrieves a description of the tables available in the given catalog.
    DatabaseMetaData.getTableTypes()
    Retrieves the table types available in this database.
    CallableStatement.getTime(int parameterIndex)
    Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object.
    CallableStatement.getTime(int parameterIndex, Calendar cal)
    Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.
    CallableStatement.getTime(String parameterName)
    Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.
    CallableStatement.getTime(String parameterName, Calendar cal)
    Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.
    ResultSet.getTime(int columnIndex)
    Retrieves 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.
    ResultSet.getTime(int columnIndex, Calendar cal)
    Retrieves 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.
    ResultSet.getTime(String columnLabel)
    Retrieves 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.
    ResultSet.getTime(String columnLabel, Calendar cal)
    Retrieves 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.
    DatabaseMetaData.getTimeDateFunctions()
    Retrieves a comma-separated list of the time and date functions available with this database.
    CallableStatement.getTimestamp(int parameterIndex)
    Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
    CallableStatement.getTimestamp(int parameterIndex, Calendar cal)
    Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.
    CallableStatement.getTimestamp(String parameterName)
    Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
    CallableStatement.getTimestamp(String parameterName, Calendar cal)
    Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.
    ResultSet.getTimestamp(int columnIndex)
    Retrieves 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.
    ResultSet.getTimestamp(int columnIndex, Calendar cal)
    Retrieves 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.
    ResultSet.getTimestamp(String columnLabel)
    Retrieves 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.
    ResultSet.getTimestamp(String columnLabel, Calendar cal)
    Retrieves 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
    Retrieves this Connection object's current transaction isolation level.
    int
    ResultSet.getType()
    Retrieves the type of this ResultSet object.
    DatabaseMetaData.getTypeInfo()
    Retrieves a description of all the data types supported by this database.
    Connection.getTypeMap()
    Retrieves the Map object associated with this Connection object.
    DatabaseMetaData.getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)
    Retrieves a description of the user-defined types (UDTs) defined in a particular schema.
    ResultSet.getUnicodeStream(int columnIndex)
    Deprecated.
    use getCharacterStream in place of getUnicodeStream
    ResultSet.getUnicodeStream(String columnLabel)
    Deprecated.
    use getCharacterStream instead
    int
    Statement.getUpdateCount()
    Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.
    CallableStatement.getURL(int parameterIndex)
    Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object.
    CallableStatement.getURL(String parameterName)
    Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.
    DatabaseMetaData.getURL()
    Retrieves the URL for this DBMS.
    ResultSet.getURL(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.
    ResultSet.getURL(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.
    DatabaseMetaData.getUserName()
    Retrieves the user name as known to this database.
    DatabaseMetaData.getVersionColumns(String catalog, String schema, String table)
    Retrieves a description of a table's columns that are automatically updated when any value in a row is updated.
    Connection.getWarnings()
    Retrieves the first warning reported by calls on this Connection object.
    ResultSet.getWarnings()
    Retrieves the first warning reported by calls on this ResultSet object.
    Statement.getWarnings()
    Retrieves the first warning reported by calls on this Statement object.
    void
    ResultSet.insertRow()
    Inserts the contents of the insert row into this ResultSet object and into the database.
    boolean
    DatabaseMetaData.insertsAreDetected(int type)
    Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.
    boolean
    ResultSet.isAfterLast()
    Retrieves whether the cursor is after the last row in this ResultSet object.
    boolean
    ResultSetMetaData.isAutoIncrement(int column)
    Indicates whether the designated column is automatically numbered.
    boolean
    ResultSet.isBeforeFirst()
    Retrieves whether the cursor is before the first row in this ResultSet object.
    boolean
    ResultSetMetaData.isCaseSensitive(int column)
    Indicates whether a column's case matters.
    boolean
    DatabaseMetaData.isCatalogAtStart()
    Retrieves whether a catalog appears at the start of a fully qualified table name.
    boolean
    Connection.isClosed()
    Retrieves whether this Connection object has been closed.
    boolean
    ResultSet.isClosed()
    Retrieves whether this ResultSet object has been closed.
    boolean
    Statement.isClosed()
    Retrieves whether this Statement object has been closed.
    boolean
    Returns a value indicating whether this Statement will be closed when all its dependent result sets are closed.
    boolean
    ResultSetMetaData.isCurrency(int column)
    Indicates whether the designated column is a cash value.
    boolean
    ResultSetMetaData.isDefinitelyWritable(int column)
    Indicates whether a write on the designated column will definitely succeed.
    boolean
    ResultSet.isFirst()
    Retrieves whether the cursor is on the first row of this ResultSet object.
    boolean
    ResultSet.isLast()
    Retrieves whether the cursor is on the last row of this ResultSet object.
    int
    ParameterMetaData.isNullable(int param)
    Retrieves whether null values are allowed in the designated parameter.
    int
    ResultSetMetaData.isNullable(int column)
    Indicates the nullability of values in the designated column.
    boolean
    Statement.isPoolable()
    Returns a value indicating whether the Statement is poolable or not.
    boolean
    Connection.isReadOnly()
    Retrieves whether this Connection object is in read-only mode.
    boolean
    DatabaseMetaData.isReadOnly()
    Retrieves whether this database is in read-only mode.
    boolean
    ResultSetMetaData.isReadOnly(int column)
    Indicates whether the designated column is definitely not writable.
    boolean
    ResultSetMetaData.isSearchable(int column)
    Indicates whether the designated column can be used in a where clause.
    boolean
    ParameterMetaData.isSigned(int param)
    Retrieves whether values for the designated parameter can be signed numbers.
    boolean
    ResultSetMetaData.isSigned(int column)
    Indicates whether values in the designated column are signed numbers.
    default boolean
    Statement.isSimpleIdentifier(String identifier)
    Retrieves whether identifier is a simple SQL identifier.
    boolean
    Connection.isValid(int timeout)
    Returns true if the connection has not been closed and is still valid.
    boolean
    Wrapper.isWrapperFor(Class<?> iface)
    Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
    boolean
    ResultSetMetaData.isWritable(int column)
    Indicates whether it is possible for a write on the designated column to succeed.
    boolean
    ResultSet.last()
    Moves the cursor to the last row in this ResultSet object.
    long
    Blob.length()
    Returns the number of bytes in the BLOB value designated by this Blob object.
    long
    Clob.length()
    Retrieves the number of characters in the CLOB value designated by this Clob object.
    boolean
    DatabaseMetaData.locatorsUpdateCopy()
    Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
    void
    ResultSet.moveToCurrentRow()
    Moves the cursor to the remembered cursor position, usually the current row.
    void
    ResultSet.moveToInsertRow()
    Moves the cursor to the insert row.
    Connection.nativeSQL(String sql)
    Converts the given SQL statement into the system's native SQL grammar.
    boolean
    ResultSet.next()
    Moves the cursor forward one row from its current position.
    boolean
    DatabaseMetaData.nullPlusNonNullIsNull()
    Retrieves whether this database supports concatenations between NULL and non-NULL values being NULL.
    boolean
    DatabaseMetaData.nullsAreSortedAtEnd()
    Retrieves whether NULL values are sorted at the end regardless of sort order.
    boolean
    DatabaseMetaData.nullsAreSortedAtStart()
    Retrieves whether NULL values are sorted at the start regardless of sort order.
    boolean
    DatabaseMetaData.nullsAreSortedHigh()
    Retrieves whether NULL values are sorted high.
    boolean
    DatabaseMetaData.nullsAreSortedLow()
    Retrieves whether NULL values are sorted low.
    boolean
    DatabaseMetaData.othersDeletesAreVisible(int type)
    Retrieves whether deletes made by others are visible.
    boolean
    DatabaseMetaData.othersInsertsAreVisible(int type)
    Retrieves whether inserts made by others are visible.
    boolean
    DatabaseMetaData.othersUpdatesAreVisible(int type)
    Retrieves whether updates made by others are visible.
    boolean
    DatabaseMetaData.ownDeletesAreVisible(int type)
    Retrieves whether a result set's own deletes are visible.
    boolean
    DatabaseMetaData.ownInsertsAreVisible(int type)
    Retrieves whether a result set's own inserts are visible.
    boolean
    DatabaseMetaData.ownUpdatesAreVisible(int type)
    Retrieves whether for the given type of ResultSet object, the result set's own updates are visible.
    long
    Blob.position(byte[] pattern, long start)
    Retrieves the byte position at which the specified byte array pattern begins within the BLOB value that this Blob object represents.
    long
    Blob.position(Blob pattern, long start)
    Retrieves the byte position in the BLOB value designated by this Blob object at which pattern begins.
    long
    Clob.position(String searchstr, long start)
    Retrieves 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)
    Retrieves the character position at which the specified Clob object searchstr appears in this Clob object.
    Connection.prepareCall(String sql)
    Creates a CallableStatement object for calling database stored procedures.
    Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency)
    Creates a CallableStatement object that will generate ResultSet objects with the given type and concurrency.
    Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
    Creates a CallableStatement object that will generate ResultSet objects with the given type and concurrency.
    Connection.prepareStatement(String sql)
    Creates a PreparedStatement object for sending parameterized SQL statements to the database.
    Connection.prepareStatement(String sql, int autoGeneratedKeys)
    Creates a default PreparedStatement object that has the capability to retrieve auto-generated keys.
    Connection.prepareStatement(String sql, int[] columnIndexes)
    Creates a default PreparedStatement object capable of returning the auto-generated keys designated by the given array.
    Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency)
    Creates a PreparedStatement object that will generate ResultSet objects with the given type and concurrency.
    Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
    Creates a PreparedStatement object that will generate ResultSet objects with the given type, concurrency, and holdability.
    Connection.prepareStatement(String sql, String[] columnNames)
    Creates a default PreparedStatement object capable of returning the auto-generated keys designated by the given array.
    boolean
    ResultSet.previous()
    Moves the cursor to the previous row in this ResultSet object.
    SQLInput.readArray()
    Reads an SQL ARRAY value from the stream and returns it as an Array object in the Java programming language.
    SQLInput.readAsciiStream()
    Reads the next attribute in the stream and returns it as a stream of ASCII characters.
    SQLInput.readBigDecimal()
    Reads the next attribute in the stream and returns it as a java.math.BigDecimal object in the Java programming language.
    SQLInput.readBinaryStream()
    Reads the next attribute in the stream and returns it as a stream of uninterpreted bytes.
    SQLInput.readBlob()
    Reads an SQL BLOB value from the stream and returns it as a Blob object in the Java programming language.
    boolean
    SQLInput.readBoolean()
    Reads the next attribute in the stream and returns it as a boolean in the Java programming language.
    byte
    SQLInput.readByte()
    Reads the next attribute in the stream and returns it as a byte in the Java programming language.
    byte[]
    SQLInput.readBytes()
    Reads the next attribute in the stream and returns it as an array of bytes in the Java programming language.
    Reads the next attribute in the stream and returns it as a stream of Unicode characters.
    SQLInput.readClob()
    Reads an SQL CLOB value from the stream and returns it as a Clob object in the Java programming language.
    SQLInput.readDate()
    Reads the next attribute in the stream and returns it as a java.sql.Date object.
    double
    SQLInput.readDouble()
    Reads the next attribute in the stream and returns it as a double in the Java programming language.
    float
    SQLInput.readFloat()
    Reads the next attribute in the stream and returns it as a float in the Java programming language.
    int
    SQLInput.readInt()
    Reads the next attribute in the stream and returns it as an int in the Java programming language.
    long
    SQLInput.readLong()
    Reads the next attribute in the stream and returns it as a long in the Java programming language.
    SQLInput.readNClob()
    Reads an SQL NCLOB value from the stream and returns it as a NClob object in the Java programming language.
    SQLInput.readNString()
    Reads the next attribute in the stream and returns it as a String in the Java programming language.
    SQLInput.readObject()
    Reads the datum at the head of the stream and returns it as an Object in the Java programming language.
    default <T> T
    SQLInput.readObject(Class<T> type)
    Reads the next attribute in the stream and returns it as an Object in the Java programming language.
    SQLInput.readRef()
    Reads an SQL REF value from the stream and returns it as a Ref object in the Java programming language.
    SQLInput.readRowId()
    Reads an SQL ROWID value from the stream and returns it as a RowId object in the Java programming language.
    short
    SQLInput.readShort()
    Reads the next attribute in the stream and returns it as a short in the Java programming language.
    void
    SQLData.readSQL(SQLInput stream, String typeName)
    Populates this object with data read from the database.
    SQLInput.readSQLXML()
    Reads an SQL XML value from the stream and returns it as a SQLXML object in the Java programming language.
    SQLInput.readString()
    Reads the next attribute in the stream and returns it as a String in the Java programming language.
    SQLInput.readTime()
    Reads the next attribute in the stream and returns it as a java.sql.Time object.
    SQLInput.readTimestamp()
    Reads the next attribute in the stream and returns it as a java.sql.Timestamp object.
    SQLInput.readURL()
    Reads an SQL DATALINK value from the stream and returns it as a java.net.URL object in the Java programming language.
    void
    ResultSet.refreshRow()
    Refreshes the current row with its most recent value in the database.
    static void
    DriverManager.registerDriver(Driver driver)
    Registers the given driver with the DriverManager.
    static void
    DriverManager.registerDriver(Driver driver, DriverAction da)
    Registers the given driver with the DriverManager.
    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.
    void
    CallableStatement.registerOutParameter(int parameterIndex, int sqlType, String typeName)
    Registers the designated output parameter.
    default void
    CallableStatement.registerOutParameter(int parameterIndex, SQLType sqlType)
    Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.
    default void
    CallableStatement.registerOutParameter(int parameterIndex, SQLType sqlType, int scale)
    Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.
    default void
    CallableStatement.registerOutParameter(int parameterIndex, SQLType sqlType, String typeName)
    Registers the designated output parameter.
    void
    CallableStatement.registerOutParameter(String parameterName, int sqlType)
    Registers the OUT parameter named parameterName to the JDBC type sqlType.
    void
    CallableStatement.registerOutParameter(String parameterName, int sqlType, int scale)
    Registers the parameter named parameterName to be of JDBC type sqlType.
    void
    CallableStatement.registerOutParameter(String parameterName, int sqlType, String typeName)
    Registers the designated output parameter.
    default void
    CallableStatement.registerOutParameter(String parameterName, SQLType sqlType)
    Registers the OUT parameter named parameterName to the JDBC type sqlType.
    default void
    CallableStatement.registerOutParameter(String parameterName, SQLType sqlType, int scale)
    Registers the parameter named parameterName to be of JDBC type sqlType.
    default void
    CallableStatement.registerOutParameter(String parameterName, SQLType sqlType, String typeName)
    Registers the designated output parameter.
    boolean
    ResultSet.relative(int rows)
    Moves the cursor a relative number of rows, either positive or negative.
    void
    Connection.releaseSavepoint(Savepoint savepoint)
    Removes the specified Savepoint and subsequent Savepoint objects from the current transaction.
    void
    Connection.rollback()
    Undoes all changes made in the current transaction and releases any database locks currently held by this Connection object.
    void
    Connection.rollback(Savepoint savepoint)
    Undoes all changes made after the given Savepoint object was set.
    boolean
    ResultSet.rowDeleted()
    Retrieves whether a row has been deleted.
    boolean
    ResultSet.rowInserted()
    Retrieves whether the current row has had an insertion.
    boolean
    ResultSet.rowUpdated()
    Retrieves whether the current row has been updated.
    void
    PreparedStatement.setArray(int parameterIndex, Array x)
    Sets the designated parameter to the given java.sql.Array object.
    void
    CallableStatement.setAsciiStream(String parameterName, InputStream x)
    Sets the designated parameter to the given input stream.
    void
    CallableStatement.setAsciiStream(String parameterName, InputStream x, int length)
    Sets the designated parameter to the given input stream, which will have the specified number of bytes.
    void
    CallableStatement.setAsciiStream(String parameterName, InputStream x, long length)
    Sets the designated parameter to the given input stream, which will have the specified number of bytes.
    Clob.setAsciiStream(long pos)
    Retrieves a stream to be used to write Ascii characters to the CLOB value that this Clob object represents, starting at position pos.
    void
    PreparedStatement.setAsciiStream(int parameterIndex, InputStream x)
    Sets the designated parameter to the given input stream.
    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.setAsciiStream(int parameterIndex, InputStream x, long length)
    Sets the designated parameter to the given input stream, which will have the specified number of bytes.
    void
    Connection.setAutoCommit(boolean autoCommit)
    Sets this connection's auto-commit mode to the given state.
    void
    CallableStatement.setBigDecimal(String parameterName, BigDecimal x)
    Sets the designated parameter to the given java.math.BigDecimal value.
    void
    PreparedStatement.setBigDecimal(int parameterIndex, BigDecimal x)
    Sets the designated parameter to the given java.math.BigDecimal value.
    Blob.setBinaryStream(long pos)
    Retrieves a stream that can be used to write to the BLOB value that this Blob object represents.
    void
    CallableStatement.setBinaryStream(String parameterName, InputStream x)
    Sets the designated parameter to the given input stream.
    void
    CallableStatement.setBinaryStream(String parameterName, InputStream x, int length)
    Sets the designated parameter to the given input stream, which will have the specified number of bytes.
    void
    CallableStatement.setBinaryStream(String parameterName, InputStream x, long length)
    Sets the designated parameter to the given input stream, which will have the specified number of bytes.
    void
    PreparedStatement.setBinaryStream(int parameterIndex, InputStream x)
    Sets the designated parameter to the given input stream.
    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.setBinaryStream(int parameterIndex, InputStream x, long length)
    Sets the designated parameter to the given input stream, which will have the specified number of bytes.
    Retrieves a stream that can be used to write the XML value that this SQLXML instance represents.
    void
    CallableStatement.setBlob(String parameterName, InputStream inputStream)
    Sets the designated parameter to an InputStream object.
    void
    CallableStatement.setBlob(String parameterName, InputStream inputStream, long length)
    Sets the designated parameter to an InputStream object.
    void
    CallableStatement.setBlob(String parameterName, Blob x)
    Sets the designated parameter to the given java.sql.Blob object.
    void
    PreparedStatement.setBlob(int parameterIndex, InputStream inputStream)
    Sets the designated parameter to a InputStream object.
    void
    PreparedStatement.setBlob(int parameterIndex, InputStream inputStream, long length)
    Sets the designated parameter to a InputStream object.
    void
    PreparedStatement.setBlob(int parameterIndex, Blob x)
    Sets the designated parameter to the given java.sql.Blob object.
    void
    CallableStatement.setBoolean(String parameterName, boolean x)
    Sets the designated parameter to the given Java boolean value.
    void
    PreparedStatement.setBoolean(int parameterIndex, boolean x)
    Sets the designated parameter to the given Java boolean value.
    void
    CallableStatement.setByte(String parameterName, byte x)
    Sets the designated parameter to the given Java byte value.
    void
    PreparedStatement.setByte(int parameterIndex, byte x)
    Sets the designated parameter to the given Java byte value.
    int
    Blob.setBytes(long pos, byte[] bytes)
    Writes the given array of bytes to the BLOB value that this Blob object represents, starting at position pos, and returns the number of bytes written.
    int
    Blob.setBytes(long pos, byte[] bytes, int offset, int len)
    Writes all or part of the given byte array to the BLOB value that this Blob object represents and returns the number of bytes written.
    void
    CallableStatement.setBytes(String parameterName, byte[] x)
    Sets the designated parameter to the given Java array of bytes.
    void
    PreparedStatement.setBytes(int parameterIndex, byte[] x)
    Sets the designated parameter to the given Java array of bytes.
    void
    Connection.setCatalog(String catalog)
    Sets the given catalog name in order to select a subspace of this Connection object's database in which to work.
    void
    CallableStatement.setCharacterStream(String parameterName, Reader reader)
    Sets the designated parameter to the given Reader object.
    void
    CallableStatement.setCharacterStream(String parameterName, Reader reader, int length)
    Sets the designated parameter to the given Reader object, which is the given number of characters long.
    void
    CallableStatement.setCharacterStream(String parameterName, Reader reader, long length)
    Sets the designated parameter to the given Reader object, which is the given number of characters long.
    Clob.setCharacterStream(long pos)
    Retrieves a stream to be used to write a stream of Unicode characters to the CLOB value that this Clob object represents, at position pos.
    void
    PreparedStatement.setCharacterStream(int parameterIndex, Reader reader)
    Sets the designated parameter to the given Reader object.
    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.setCharacterStream(int parameterIndex, Reader reader, long length)
    Sets the designated parameter to the given Reader object, which is the given number of characters long.
    Retrieves a stream to be used to write the XML value that this SQLXML instance represents.
    void
    CallableStatement.setClob(String parameterName, Reader reader)
    Sets the designated parameter to a Reader object.
    void
    CallableStatement.setClob(String parameterName, Reader reader, long length)
    Sets the designated parameter to a Reader object.
    void
    CallableStatement.setClob(String parameterName, Clob x)
    Sets the designated parameter to the given java.sql.Clob object.
    void
    PreparedStatement.setClob(int parameterIndex, Reader reader)
    Sets the designated parameter to a Reader object.
    void
    PreparedStatement.setClob(int parameterIndex, Reader reader, long length)
    Sets the designated parameter to a Reader object.
    void
    PreparedStatement.setClob(int parameterIndex, Clob x)
    Sets the designated parameter to the given java.sql.Clob object.
    void
    Statement.setCursorName(String name)
    Sets the SQL cursor name to the given String, which will be used by subsequent Statement object execute methods.
    void
    CallableStatement.setDate(String parameterName, Date x)
    Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.
    void
    CallableStatement.setDate(String parameterName, Date x, Calendar cal)
    Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
    void
    PreparedStatement.setDate(int parameterIndex, Date x)
    Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.
    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
    CallableStatement.setDouble(String parameterName, double x)
    Sets the designated parameter to the given Java double value.
    void
    PreparedStatement.setDouble(int parameterIndex, double x)
    Sets the designated parameter to the given Java double value.
    void
    Statement.setEscapeProcessing(boolean enable)
    Sets escape processing on or off.
    void
    ResultSet.setFetchDirection(int direction)
    Gives a hint as to the direction in which the rows in this ResultSet object will be processed.
    void
    Statement.setFetchDirection(int direction)
    Gives the driver a hint as to the direction in which rows will be processed in ResultSet objects created using this Statement 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.
    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 for ResultSet objects generated by this Statement.
    void
    CallableStatement.setFloat(String parameterName, float x)
    Sets the designated parameter to the given Java float value.
    void
    PreparedStatement.setFloat(int parameterIndex, float x)
    Sets the designated parameter to the given Java float value.
    void
    Connection.setHoldability(int holdability)
    Changes the default holdability of ResultSet objects created using this Connection object to the given holdability.
    void
    CallableStatement.setInt(String parameterName, int x)
    Sets the designated parameter to the given Java int value.
    void
    PreparedStatement.setInt(int parameterIndex, int x)
    Sets the designated parameter to the given Java int value.
    default void
    Statement.setLargeMaxRows(long max)
    Sets the limit for the maximum number of rows that any ResultSet object generated by this Statement object can contain to the given number.
    void
    CallableStatement.setLong(String parameterName, long x)
    Sets the designated parameter to the given Java long value.
    void
    PreparedStatement.setLong(int parameterIndex, long x)
    Sets the designated parameter to the given Java long value.
    void
    Statement.setMaxFieldSize(int max)
    Sets the limit for the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object.
    void
    Statement.setMaxRows(int max)
    Sets the limit for the maximum number of rows that any ResultSet object generated by this Statement object can contain to the given number.
    void
    CallableStatement.setNCharacterStream(String parameterName, Reader value)
    Sets the designated parameter to a Reader object.
    void
    CallableStatement.setNCharacterStream(String parameterName, Reader value, long length)
    Sets the designated parameter to a Reader object.
    void
    PreparedStatement.setNCharacterStream(int parameterIndex, Reader value)
    Sets the designated parameter to a Reader object.
    void
    PreparedStatement.setNCharacterStream(int parameterIndex, Reader value, long length)
    Sets the designated parameter to a Reader object.
    void
    CallableStatement.setNClob(String parameterName, Reader reader)
    Sets the designated parameter to a Reader object.
    void
    CallableStatement.setNClob(String parameterName, Reader reader, long length)
    Sets the designated parameter to a Reader object.
    void
    CallableStatement.setNClob(String parameterName, NClob value)
    Sets the designated parameter to a java.sql.NClob object.
    void
    PreparedStatement.setNClob(int parameterIndex, Reader reader)
    Sets the designated parameter to a Reader object.
    void
    PreparedStatement.setNClob(int parameterIndex, Reader reader, long length)
    Sets the designated parameter to a Reader object.
    void
    PreparedStatement.setNClob(int parameterIndex, NClob value)
    Sets the designated parameter to a java.sql.NClob object.
    void
    Connection.setNetworkTimeout(Executor executor, int milliseconds)
    Sets the maximum period a Connection or objects created from the Connection will wait for the database to reply to any one request.
    void
    CallableStatement.setNString(String parameterName, String value)
    Sets the designated parameter to the given String object.
    void
    PreparedStatement.setNString(int parameterIndex, String value)
    Sets the designated parameter to the given String object.
    void
    CallableStatement.setNull(String parameterName, int sqlType)
    Sets the designated parameter to SQL NULL.
    void
    CallableStatement.setNull(String parameterName, int sqlType, String typeName)
    Sets the designated parameter to SQL NULL.
    void
    PreparedStatement.setNull(int parameterIndex, int sqlType)
    Sets the designated parameter to SQL NULL.
    void
    PreparedStatement.setNull(int parameterIndex, int sqlType, String typeName)
    Sets the designated parameter to SQL NULL.
    void
    CallableStatement.setObject(String parameterName, Object x)
    Sets the value of the designated parameter with the given object.
    void
    CallableStatement.setObject(String parameterName, Object x, int targetSqlType)
    Sets the value of the designated parameter with the given object.
    void
    CallableStatement.setObject(String parameterName, Object x, int targetSqlType, int scale)
    Sets the value of the designated parameter with the given object.
    default void
    CallableStatement.setObject(String parameterName, Object x, SQLType targetSqlType)
    Sets the value of the designated parameter with the given object.
    default void
    CallableStatement.setObject(String parameterName, Object x, SQLType targetSqlType, int scaleOrLength)
    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.
    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, int targetSqlType, int scaleOrLength)
    Sets the value of the designated parameter with the given object.
    default void
    PreparedStatement.setObject(int parameterIndex, Object x, SQLType targetSqlType)
    Sets the value of the designated parameter with the given object.
    default void
    PreparedStatement.setObject(int parameterIndex, Object x, SQLType targetSqlType, int scaleOrLength)
    Sets the value of the designated parameter with the given object.
    void
    Ref.setObject(Object value)
    Sets the structured type value that this Ref object references to the given instance of Object.
    void
    Statement.setPoolable(boolean poolable)
    Requests that a Statement be pooled or not pooled.
    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
    Connection.setReadOnly(boolean readOnly)
    Puts this connection in read-only mode as a hint to the driver to enable database optimizations.
    void
    PreparedStatement.setRef(int parameterIndex, Ref x)
    Sets the designated parameter to the given REF(<structured-type>) value.
    <T extends Result>
    T
    SQLXML.setResult(Class<T> resultClass)
    Returns a Result for setting the XML value designated by this SQLXML instance.
    void
    CallableStatement.setRowId(String parameterName, RowId x)
    Sets the designated parameter to the given java.sql.RowId object.
    void
    PreparedStatement.setRowId(int parameterIndex, RowId x)
    Sets the designated parameter to the given java.sql.RowId object.
    Connection.setSavepoint()
    Creates an unnamed savepoint in the current transaction and returns the new Savepoint object that represents it.
    Connection.setSavepoint(String name)
    Creates a savepoint with the given name in the current transaction and returns the new Savepoint object that represents it.
    void
    Connection.setSchema(String schema)
    Sets the given schema name to access.
    default void
    Connection.setShardingKey(ShardingKey shardingKey)
    Specifies a shardingKey to use with this Connection
    default void
    Connection.setShardingKey(ShardingKey shardingKey, ShardingKey superShardingKey)
    Specifies a shardingKey and superShardingKey to use with this Connection
    default boolean
    Connection.setShardingKeyIfValid(ShardingKey shardingKey, int timeout)
    Sets and validates the sharding key for this connection.
    default boolean
    Connection.setShardingKeyIfValid(ShardingKey shardingKey, ShardingKey superShardingKey, int timeout)
    Sets and validates the sharding keys for this connection.
    void
    CallableStatement.setShort(String parameterName, short x)
    Sets the designated parameter to the given Java short value.
    void
    PreparedStatement.setShort(int parameterIndex, short x)
    Sets the designated parameter to the given Java short value.
    void
    CallableStatement.setSQLXML(String parameterName, SQLXML xmlObject)
    Sets the designated parameter to the given java.sql.SQLXML object.
    void
    PreparedStatement.setSQLXML(int parameterIndex, SQLXML xmlObject)
    Sets the designated parameter to the given java.sql.SQLXML object.
    void
    CallableStatement.setString(String parameterName, String x)
    Sets the designated parameter to the given Java String value.
    int
    Clob.setString(long pos, String str)
    Writes the given Java String to the CLOB value that this Clob object designates at the position pos.
    int
    Clob.setString(long pos, String str, int offset, int len)
    Writes len characters of str, starting at character offset, to the CLOB value that this Clob represents.
    void
    PreparedStatement.setString(int parameterIndex, String x)
    Sets the designated parameter to the given Java String value.
    void
    SQLXML.setString(String value)
    Sets the XML value designated by this SQLXML instance to the given String representation.
    void
    CallableStatement.setTime(String parameterName, Time x)
    Sets the designated parameter to the given java.sql.Time value.
    void
    CallableStatement.setTime(String parameterName, Time x, Calendar cal)
    Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.
    void
    PreparedStatement.setTime(int parameterIndex, Time x)
    Sets the designated parameter to the given java.sql.Time value.
    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
    CallableStatement.setTimestamp(String parameterName, Timestamp x)
    Sets the designated parameter to the given java.sql.Timestamp value.
    void
    CallableStatement.setTimestamp(String parameterName, Timestamp x, Calendar cal)
    Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.
    void
    PreparedStatement.setTimestamp(int parameterIndex, Timestamp x)
    Sets the designated parameter to the given java.sql.Timestamp value.
    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
    Connection.setTransactionIsolation(int level)
    Attempts to change the transaction isolation level for this Connection object to the one given.
    void
    Connection.setTypeMap(Map<String,Class<?>> map)
    Installs the given TypeMap object as the type map for this Connection object.
    void
    PreparedStatement.setUnicodeStream(int parameterIndex, InputStream x, int length)
    Deprecated.
    Use setCharacterStream
    void
    CallableStatement.setURL(String parameterName, URL val)
    Sets the designated parameter to the given java.net.URL object.
    void
    PreparedStatement.setURL(int parameterIndex, URL x)
    Sets the designated parameter to the given java.net.URL value.
    boolean
    DatabaseMetaData.storesLowerCaseIdentifiers()
    Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.
    boolean
    Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.
    boolean
    DatabaseMetaData.storesMixedCaseIdentifiers()
    Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.
    boolean
    Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.
    boolean
    DatabaseMetaData.storesUpperCaseIdentifiers()
    Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.
    boolean
    Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.
    boolean
    Retrieves whether this database supports ALTER TABLE with add column.
    boolean
    Retrieves whether this database supports ALTER TABLE with drop column.
    boolean
    DatabaseMetaData.supportsANSI92EntryLevelSQL()
    Retrieves whether this database supports the ANSI92 entry level SQL grammar.
    boolean
    DatabaseMetaData.supportsANSI92FullSQL()
    Retrieves whether this database supports the ANSI92 full SQL grammar supported.
    boolean
    Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.
    boolean
    DatabaseMetaData.supportsBatchUpdates()
    Retrieves whether this database supports batch updates.
    boolean
    Retrieves whether a catalog name can be used in a data manipulation statement.
    boolean
    Retrieves whether a catalog name can be used in an index definition statement.
    boolean
    Retrieves whether a catalog name can be used in a privilege definition statement.
    boolean
    Retrieves whether a catalog name can be used in a procedure call statement.
    boolean
    Retrieves whether a catalog name can be used in a table definition statement.
    boolean
    DatabaseMetaData.supportsColumnAliasing()
    Retrieves whether this database supports column aliasing.
    boolean
    DatabaseMetaData.supportsConvert()
    Retrieves whether this database supports the JDBC scalar function CONVERT for the conversion of one JDBC type to another.
    boolean
    DatabaseMetaData.supportsConvert(int fromType, int toType)
    Retrieves whether this database supports the JDBC scalar function CONVERT for conversions between the JDBC types fromType and toType.
    boolean
    DatabaseMetaData.supportsCoreSQLGrammar()
    Retrieves whether this database supports the ODBC Core SQL grammar.
    boolean
    DatabaseMetaData.supportsCorrelatedSubqueries()
    Retrieves whether this database supports correlated subqueries.
    boolean
    Retrieves whether this database supports both data definition and data manipulation statements within a transaction.
    boolean
    Retrieves whether this database supports only data manipulation statements within a transaction.
    boolean
    Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.
    boolean
    DatabaseMetaData.supportsExpressionsInOrderBy()
    Retrieves whether this database supports expressions in ORDER BY lists.
    boolean
    DatabaseMetaData.supportsExtendedSQLGrammar()
    Retrieves whether this database supports the ODBC Extended SQL grammar.
    boolean
    DatabaseMetaData.supportsFullOuterJoins()
    Retrieves whether this database supports full nested outer joins.
    boolean
    DatabaseMetaData.supportsGetGeneratedKeys()
    Retrieves whether auto-generated keys can be retrieved after a statement has been executed
    boolean
    DatabaseMetaData.supportsGroupBy()
    Retrieves whether this database supports some form of GROUP BY clause.
    boolean
    DatabaseMetaData.supportsGroupByBeyondSelect()
    Retrieves whether this database supports using columns not included in the SELECT statement in a GROUP BY clause provided that all of the columns in the SELECT statement are included in the GROUP BY clause.
    boolean
    DatabaseMetaData.supportsGroupByUnrelated()
    Retrieves whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause.
    boolean
    Retrieves whether this database supports the SQL Integrity Enhancement Facility.
    boolean
    DatabaseMetaData.supportsLikeEscapeClause()
    Retrieves whether this database supports specifying a LIKE escape clause.
    boolean
    DatabaseMetaData.supportsLimitedOuterJoins()
    Retrieves whether this database provides limited support for outer joins.
    boolean
    DatabaseMetaData.supportsMinimumSQLGrammar()
    Retrieves whether this database supports the ODBC Minimum SQL grammar.
    boolean
    DatabaseMetaData.supportsMixedCaseIdentifiers()
    Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.
    boolean
    Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.
    boolean
    DatabaseMetaData.supportsMultipleOpenResults()
    Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.
    boolean
    DatabaseMetaData.supportsMultipleResultSets()
    Retrieves whether this database supports getting multiple ResultSet objects from a single call to the method execute.
    boolean
    DatabaseMetaData.supportsMultipleTransactions()
    Retrieves whether this database allows having multiple transactions open at once (on different connections).
    boolean
    DatabaseMetaData.supportsNamedParameters()
    Retrieves whether this database supports named parameters to callable statements.
    boolean
    DatabaseMetaData.supportsNonNullableColumns()
    Retrieves whether columns in this database may be defined as non-nullable.
    boolean
    Retrieves whether this database supports keeping cursors open across commits.
    boolean
    Retrieves whether this database supports keeping cursors open across rollbacks.
    boolean
    Retrieves whether this database supports keeping statements open across commits.
    boolean
    Retrieves whether this database supports keeping statements open across rollbacks.
    boolean
    DatabaseMetaData.supportsOrderByUnrelated()
    Retrieves whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause.
    boolean
    DatabaseMetaData.supportsOuterJoins()
    Retrieves whether this database supports some form of outer join.
    boolean
    DatabaseMetaData.supportsPositionedDelete()
    Retrieves whether this database supports positioned DELETE statements.
    boolean
    DatabaseMetaData.supportsPositionedUpdate()
    Retrieves whether this database supports positioned UPDATE statements.
    default boolean
    DatabaseMetaData.supportsRefCursors()
    Retrieves whether this database supports REF CURSOR.
    boolean
    DatabaseMetaData.supportsResultSetConcurrency(int type, int concurrency)
    Retrieves whether this database supports the given concurrency type in combination with the given result set type.
    boolean
    DatabaseMetaData.supportsResultSetHoldability(int holdability)
    Retrieves whether this database supports the given result set holdability.
    boolean
    DatabaseMetaData.supportsResultSetType(int type)
    Retrieves whether this database supports the given result set type.
    boolean
    DatabaseMetaData.supportsSavepoints()
    Retrieves whether this database supports savepoints.
    boolean
    Retrieves whether a schema name can be used in a data manipulation statement.
    boolean
    Retrieves whether a schema name can be used in an index definition statement.
    boolean
    Retrieves whether a schema name can be used in a privilege definition statement.
    boolean
    Retrieves whether a schema name can be used in a procedure call statement.
    boolean
    Retrieves whether a schema name can be used in a table definition statement.
    boolean
    DatabaseMetaData.supportsSelectForUpdate()
    Retrieves whether this database supports SELECT FOR UPDATE statements.
    default boolean
    DatabaseMetaData.supportsSharding()
    Retrieves whether this database supports sharding.
    boolean
    DatabaseMetaData.supportsStatementPooling()
    Retrieves whether this database supports statement pooling.
    boolean
    Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.
    boolean
    DatabaseMetaData.supportsStoredProcedures()
    Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.
    boolean
    Retrieves whether this database supports subqueries in comparison expressions.
    boolean
    DatabaseMetaData.supportsSubqueriesInExists()
    Retrieves whether this database supports subqueries in EXISTS expressions.
    boolean
    DatabaseMetaData.supportsSubqueriesInIns()
    Retrieves whether this database supports subqueries in IN expressions.
    boolean
    Retrieves whether this database supports subqueries in quantified expressions.
    boolean
    Retrieves whether this database supports table correlation names.
    boolean
    DatabaseMetaData.supportsTransactionIsolationLevel(int level)
    Retrieves whether this database supports the given transaction isolation level.
    boolean
    DatabaseMetaData.supportsTransactions()
    Retrieves whether this database supports transactions.
    boolean
    DatabaseMetaData.supportsUnion()
    Retrieves whether this database supports SQL UNION.
    boolean
    DatabaseMetaData.supportsUnionAll()
    Retrieves whether this database supports SQL UNION ALL.
    void
    Blob.truncate(long len)
    Truncates the BLOB value that this Blob object represents to be len bytes in length.
    void
    Clob.truncate(long len)
    Truncates the CLOB value that this Clob designates to have a length of len characters.
    <T> T
    Wrapper.unwrap(Class<T> iface)
    Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
    void
    ResultSet.updateArray(int columnIndex, Array x)
    Updates the designated column with a java.sql.Array value.
    void
    ResultSet.updateArray(String columnLabel, Array x)
    Updates the designated column with a java.sql.Array value.
    void
    ResultSet.updateAsciiStream(int columnIndex, InputStream x)
    Updates the designated column with an ascii stream value.
    void
    ResultSet.updateAsciiStream(int columnIndex, InputStream x, int length)
    Updates the designated column with an ascii stream value, which will have the specified number of bytes.
    void
    ResultSet.updateAsciiStream(int columnIndex, InputStream x, long length)
    Updates the designated column with an ascii stream value, which will have the specified number of bytes.
    void
    ResultSet.updateAsciiStream(String columnLabel, InputStream x)
    Updates the designated column with an ascii stream value.
    void
    ResultSet.updateAsciiStream(String columnLabel, InputStream x, int length)
    Updates the designated column with an ascii stream value, which will have the specified number of bytes.
    void
    ResultSet.updateAsciiStream(String columnLabel, InputStream x, long length)
    Updates the designated column with an ascii stream value, which will have the specified number of bytes.
    void
    ResultSet.updateBigDecimal(int columnIndex, BigDecimal x)
    Updates the designated column with a java.math.BigDecimal value.
    void
    ResultSet.updateBigDecimal(String columnLabel, BigDecimal x)
    Updates the designated column with a java.sql.BigDecimal value.
    void
    ResultSet.updateBinaryStream(int columnIndex, InputStream x)
    Updates the designated column with a binary stream value.
    void
    ResultSet.updateBinaryStream(int columnIndex, InputStream x, int length)
    Updates the designated column with a binary stream value, which will have the specified number of bytes.
    void
    ResultSet.updateBinaryStream(int columnIndex, InputStream x, long length)
    Updates the designated column with a binary stream value, which will have the specified number of bytes.
    void
    ResultSet.updateBinaryStream(String columnLabel, InputStream x)
    Updates the designated column with a binary stream value.
    void
    ResultSet.updateBinaryStream(String columnLabel, InputStream x, int length)
    Updates the designated column with a binary stream value, which will have the specified number of bytes.
    void
    ResultSet.updateBinaryStream(String columnLabel, InputStream x, long length)
    Updates the designated column with a binary stream value, which will have the specified number of bytes.
    void
    ResultSet.updateBlob(int columnIndex, InputStream inputStream)
    Updates the designated column using the given input stream.
    void
    ResultSet.updateBlob(int columnIndex, InputStream inputStream, long length)
    Updates the designated column using the given input stream, which will have the specified number of bytes.
    void
    ResultSet.updateBlob(int columnIndex, Blob x)
    Updates the designated column with a java.sql.Blob value.
    void
    ResultSet.updateBlob(String columnLabel, InputStream inputStream)
    Updates the designated column using the given input stream.
    void
    ResultSet.updateBlob(String columnLabel, InputStream inputStream, long length)
    Updates the designated column using the given input stream, which will have the specified number of bytes.
    void
    ResultSet.updateBlob(String columnLabel, Blob x)
    Updates the designated column with a java.sql.Blob value.
    void
    ResultSet.updateBoolean(int columnIndex, boolean x)
    Updates the designated column with a boolean value.
    void
    ResultSet.updateBoolean(String columnLabel, 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.updateByte(String columnLabel, byte x)
    Updates the designated column with a byte value.
    void
    ResultSet.updateBytes(int columnIndex, byte[] x)
    Updates the designated column with a byte array value.
    void
    ResultSet.updateBytes(String columnLabel, byte[] x)
    Updates the designated column with a byte array value.
    void
    ResultSet.updateCharacterStream(int columnIndex, Reader x)
    Updates the designated column with a character stream value.
    void
    ResultSet.updateCharacterStream(int columnIndex, Reader x, int length)
    Updates the designated column with a character stream value, which will have the specified number of bytes.
    void
    ResultSet.updateCharacterStream(int columnIndex, Reader x, long length)
    Updates the designated column with a character stream value, which will have the specified number of bytes.
    void
    ResultSet.updateCharacterStream(String columnLabel, Reader reader)
    Updates the designated column with a character stream value.
    void
    ResultSet.updateCharacterStream(String columnLabel, Reader reader, int length)
    Updates the designated column with a character stream value, which will have the specified number of bytes.
    void
    ResultSet.updateCharacterStream(String columnLabel, Reader reader, long length)
    Updates the designated column with a character stream value, which will have the specified number of bytes.
    void
    ResultSet.updateClob(int columnIndex, Reader reader)
    Updates the designated column using the given Reader object.
    void
    ResultSet.updateClob(int columnIndex, Reader reader, long length)
    Updates the designated column using the given Reader object, which is the given number of characters long.
    void
    ResultSet.updateClob(int columnIndex, Clob x)
    Updates the designated column with a java.sql.Clob value.
    void
    ResultSet.updateClob(String columnLabel, Reader reader)
    Updates the designated column using the given Reader object.
    void
    ResultSet.updateClob(String columnLabel, Reader reader, long length)
    Updates the designated column using the given Reader object, which is the given number of characters long.
    void
    ResultSet.updateClob(String columnLabel, Clob x)
    Updates the designated column with a java.sql.Clob value.
    void
    ResultSet.updateDate(int columnIndex, Date x)
    Updates the designated column with a java.sql.Date value.
    void
    ResultSet.updateDate(String columnLabel, Date x)
    Updates the designated column with a java.sql.Date value.
    void
    ResultSet.updateDouble(int columnIndex, double x)
    Updates the designated column with a double value.
    void
    ResultSet.updateDouble(String columnLabel, double x)
    Updates the designated column with a double value.
    void
    ResultSet.updateFloat(int columnIndex, float x)
    Updates the designated column with a float value.
    void
    ResultSet.updateFloat(String columnLabel, float x)
    Updates the designated column with a float value.
    void
    ResultSet.updateInt(int columnIndex, int x)
    Updates the designated column with an int value.
    void
    ResultSet.updateInt(String columnLabel, 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.updateLong(String columnLabel, long x)
    Updates the designated column with a long value.
    void
    ResultSet.updateNCharacterStream(int columnIndex, Reader x)
    Updates the designated column with a character stream value.
    void
    ResultSet.updateNCharacterStream(int columnIndex, Reader x, long length)
    Updates the designated column with a character stream value, which will have the specified number of bytes.
    void
    ResultSet.updateNCharacterStream(String columnLabel, Reader reader)
    Updates the designated column with a character stream value.
    void
    ResultSet.updateNCharacterStream(String columnLabel, Reader reader, long length)
    Updates the designated column with a character stream value, which will have the specified number of bytes.
    void
    ResultSet.updateNClob(int columnIndex, Reader reader)
    Updates the designated column using the given Reader The data will be read from the stream as needed until end-of-stream is reached.
    void
    ResultSet.updateNClob(int columnIndex, Reader reader, long length)
    Updates the designated column using the given Reader object, which is the given number of characters long.
    void
    ResultSet.updateNClob(int columnIndex, NClob nClob)
    Updates the designated column with a java.sql.NClob value.
    void
    ResultSet.updateNClob(String columnLabel, Reader reader)
    Updates the designated column using the given Reader object.
    void
    ResultSet.updateNClob(String columnLabel, Reader reader, long length)
    Updates the designated column using the given Reader object, which is the given number of characters long.
    void
    ResultSet.updateNClob(String columnLabel, NClob nClob)
    Updates the designated column with a java.sql.NClob value.
    void
    ResultSet.updateNString(int columnIndex, String nString)
    Updates the designated column with a String value.
    void
    ResultSet.updateNString(String columnLabel, String nString)
    Updates the designated column with a String value.
    void
    ResultSet.updateNull(int columnIndex)
    Updates the designated column with a null value.
    void
    ResultSet.updateNull(String columnLabel)
    Updates the designated column with a null value.
    void
    ResultSet.updateObject(int columnIndex, Object x)
    Updates the designated column with an Object value.
    void
    ResultSet.updateObject(int columnIndex, Object x, int scaleOrLength)
    Updates the designated column with an Object value.
    default void
    ResultSet.updateObject(int columnIndex, Object x, SQLType targetSqlType)
    Updates the designated column with an Object value.
    default void
    ResultSet.updateObject(int columnIndex, Object x, SQLType targetSqlType, int scaleOrLength)
    Updates the designated column with an Object value.
    void
    ResultSet.updateObject(String columnLabel, Object x)
    Updates the designated column with an Object value.
    void
    ResultSet.updateObject(String columnLabel, Object x, int scaleOrLength)
    Updates the designated column with an Object value.
    default void
    ResultSet.updateObject(String columnLabel, Object x, SQLType targetSqlType)
    Updates the designated column with an Object value.
    default void
    ResultSet.updateObject(String columnLabel, Object x, SQLType targetSqlType, int scaleOrLength)
    Updates the designated column with an Object value.
    void
    ResultSet.updateRef(int columnIndex, Ref x)
    Updates the designated column with a java.sql.Ref value.
    void
    ResultSet.updateRef(String columnLabel, Ref x)
    Updates the designated column with a java.sql.Ref value.
    void
    ResultSet.updateRow()
    Updates the underlying database with the new contents of the current row of this ResultSet object.
    void
    ResultSet.updateRowId(int columnIndex, RowId x)
    Updates the designated column with a RowId value.
    void
    ResultSet.updateRowId(String columnLabel, RowId x)
    Updates the designated column with a RowId value.
    boolean
    DatabaseMetaData.updatesAreDetected(int type)
    Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.
    void
    ResultSet.updateShort(int columnIndex, short x)
    Updates the designated column with a short value.
    void
    ResultSet.updateShort(String columnLabel, short x)
    Updates the designated column with a short value.
    void
    ResultSet.updateSQLXML(int columnIndex, SQLXML xmlObject)
    Updates the designated column with a java.sql.SQLXML value.
    void
    ResultSet.updateSQLXML(String columnLabel, SQLXML xmlObject)
    Updates the designated column with a java.sql.SQLXML value.
    void
    ResultSet.updateString(int columnIndex, String x)
    Updates the designated column with a String value.
    void
    ResultSet.updateString(String columnLabel, String x)
    Updates the designated column with a String value.
    void
    ResultSet.updateTime(int columnIndex, Time x)
    Updates the designated column with a java.sql.Time value.
    void
    ResultSet.updateTime(String columnLabel, 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.updateTimestamp(String columnLabel, Timestamp x)
    Updates the designated column with a java.sql.Timestamp value.
    boolean
    DatabaseMetaData.usesLocalFilePerTable()
    Retrieves whether this database uses a file for each table.
    boolean
    DatabaseMetaData.usesLocalFiles()
    Retrieves whether this database stores tables in a local file.
    boolean
    CallableStatement.wasNull()
    Retrieves whether the last OUT parameter read had the value of SQL NULL.
    boolean
    ResultSet.wasNull()
    Reports whether the last column read had a value of SQL NULL.
    boolean
    SQLInput.wasNull()
    Retrieves whether the last value read was SQL NULL.
    void
    SQLOutput.writeArray(Array x)
    Writes an SQL ARRAY value to the stream.
    void
    Writes the next attribute to the stream as a stream of ASCII characters.
    void
    Writes the next attribute to the stream as a java.math.BigDecimal object.
    void
    Writes the next attribute to the stream as a stream of uninterpreted bytes.
    void
    SQLOutput.writeBlob(Blob x)
    Writes an SQL BLOB value to the stream.
    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.writeBytes(byte[] x)
    Writes the next attribute to the stream as an array of bytes.
    void
    Writes the next attribute to the stream as a stream of Unicode characters.
    void
    SQLOutput.writeClob(Clob x)
    Writes an SQL CLOB value to the stream.
    void
    SQLOutput.writeDate(Date x)
    Writes the next attribute to the stream as a java.sql.Date object.
    void
    SQLOutput.writeDouble(double x)
    Writes the next attribute to the stream as a Java double.
    void
    SQLOutput.writeFloat(float x)
    Writes the next attribute to the stream as a Java float.
    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.writeNClob(NClob x)
    Writes an SQL NCLOB value to the stream.
    void
    SQLOutput.writeNString(String x)
    Writes the next attribute to the stream as a String in the Java programming language.
    default void
    SQLOutput.writeObject(Object x, SQLType targetSqlType)
    Writes to the stream the data contained in the given object.
    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.writeRowId(RowId x)
    Writes an SQL ROWID value to the stream.
    void
    SQLOutput.writeShort(short x)
    Writes the next attribute to the stream as a Java short.
    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.
    void
    SQLOutput.writeSQLXML(SQLXML x)
    Writes an SQL XML value to the stream.
    void
    SQLOutput.writeString(String x)
    Writes the next attribute to the stream as a String in the Java programming language.
    void
    SQLOutput.writeStruct(Struct x)
    Writes an SQL structured type value to the stream.
    void
    SQLOutput.writeTime(Time x)
    Writes the next attribute to the stream as a java.sql.Time object.
    void
    Writes the next attribute to the stream as a java.sql.Timestamp object.
    void
    SQLOutput.writeURL(URL x)
    Writes a SQL DATALINK value to the stream.
  • Uses of SQLException in javax.sql

    Methods in javax.sql that return SQLException
    Modifier and Type
    Method
    Description
    ConnectionEvent.getSQLException()
    Retrieves the SQLException for this ConnectionEvent object.
    StatementEvent.getSQLException()
    Returns the SQLException the driver is about to throw
    Methods in javax.sql that throw SQLException
    Modifier and Type
    Method
    Description
    PooledConnectionBuilder.build()
    Returns an instance of the object defined by this builder.
    XAConnectionBuilder.build()
    Returns an instance of the object defined by this builder.
    void
    Clears the parameters set for this RowSet object's command.
    void
    PooledConnection.close()
    Closes the physical connection that this PooledConnection object represents.
    Create a new ConnectionBuilder instance
    ConnectionPoolDataSource.createPooledConnectionBuilder()
    Creates a new PooledConnectionBuilder instance
    CommonDataSource.createShardingKeyBuilder()
    Creates a new ShardingKeyBuilder instance
    Creates a new XAConnectionBuilder instance
    void
    RowSet.execute()
    Fills this RowSet object with data.
    DataSource.getConnection()
    Attempts to establish a connection with the data source that this DataSource object represents.
    DataSource.getConnection(String username, String password)
    Attempts to establish a connection with the data source that this DataSource object represents.
    PooledConnection.getConnection()
    Creates and returns a Connection object that is a handle for the physical connection that this PooledConnection object represents.
    RowSetInternal.getConnection()
    Retrieves the Connection object that was passed to this RowSet object.
    boolean
    Retrieves whether escape processing is enabled for this RowSet object.
    int
    CommonDataSource.getLoginTimeout()
    Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.
    int
    ConnectionPoolDataSource.getLoginTimeout()
    Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.
    int
    DataSource.getLoginTimeout()
    Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.
    int
    XADataSource.getLoginTimeout()
    Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.
    CommonDataSource.getLogWriter()
    Retrieves the log writer for this DataSource object.
    ConnectionPoolDataSource.getLogWriter()
    Retrieves the log writer for this DataSource object.
    DataSource.getLogWriter()
    Retrieves the log writer for this DataSource object.
    XADataSource.getLogWriter()
    Retrieves the log writer for this DataSource object.
    int
    Retrieves the maximum number of bytes that may be returned for certain column values.
    int
    RowSet.getMaxRows()
    Retrieves the maximum number of rows that this RowSet object can contain.
    RowSetInternal.getOriginal()
    Retrieves a ResultSet object containing the original value of this RowSet object.
    RowSetInternal.getOriginalRow()
    Retrieves a ResultSet object containing the original value of the current row only.
    RowSetInternal.getParams()
    Retrieves the parameters that have been set for this RowSet object's command.
    ConnectionPoolDataSource.getPooledConnection()
    Attempts to establish a physical database connection that can be used as a pooled connection.
    ConnectionPoolDataSource.getPooledConnection(String user, String password)
    Attempts to establish a physical database connection that can be used as a pooled connection.
    int
    Retrieves the maximum number of seconds the driver will wait for a statement to execute.
    RowSet.getTypeMap()
    Retrieves the Map object associated with this RowSet object, which specifies the custom mapping of SQL user-defined types, if any.
    RowSet.getUrl()
    Retrieves the url property this RowSet object will use to create a connection if it uses the DriverManager instead of a DataSource object to establish the connection.
    XADataSource.getXAConnection()
    Attempts to establish a physical database connection that can be used in a distributed transaction.
    XADataSource.getXAConnection(String user, String password)
    Attempts to establish a physical database connection, using the given user name and password.
    XAConnection.getXAResource()
    Retrieves an XAResource object that the transaction manager will use to manage this XAConnection object's participation in a distributed transaction.
    void
    RowSetReader.readData(RowSetInternal caller)
    Reads the new contents of the calling RowSet object.
    void
    RowSet.setArray(int i, Array x)
    Sets the designated parameter in this RowSet object's command with the given Array value.
    void
    RowSet.setAsciiStream(int parameterIndex, InputStream x)
    Sets the designated parameter in this RowSet object's command to the given input stream.
    void
    RowSet.setAsciiStream(int parameterIndex, InputStream x, int length)
    Sets the designated parameter in this RowSet object's command to the given java.io.InputStream value.
    void
    RowSet.setAsciiStream(String parameterName, InputStream x)
    Sets the designated parameter to the given input stream.
    void
    RowSet.setAsciiStream(String parameterName, InputStream x, int length)
    Sets the designated parameter to the given input stream, which will have the specified number of bytes.
    void
    RowSetMetaData.setAutoIncrement(int columnIndex, boolean property)
    Sets whether the designated column is automatically numbered, The default is for a RowSet object's columns not to be automatically numbered.
    void
    RowSet.setBigDecimal(int parameterIndex, BigDecimal x)
    Sets the designated parameter in this RowSet object's command to the given java.math.BigDecimal value.
    void
    RowSet.setBigDecimal(String parameterName, BigDecimal x)
    Sets the designated parameter to the given java.math.BigDecimal value.
    void
    RowSet.setBinaryStream(int parameterIndex, InputStream x)
    Sets the designated parameter in this RowSet object's command to the given input stream.
    void
    RowSet.setBinaryStream(int parameterIndex, InputStream x, int length)
    Sets the designated parameter in this RowSet object's command to the given java.io.InputStream value.
    void
    RowSet.setBinaryStream(String parameterName, InputStream x)
    Sets the designated parameter to the given input stream.
    void
    RowSet.setBinaryStream(String parameterName, InputStream x, int length)
    Sets the designated parameter to the given input stream, which will have the specified number of bytes.
    void
    RowSet.setBlob(int parameterIndex, InputStream inputStream)
    Sets the designated parameter to a InputStream object.
    void
    RowSet.setBlob(int parameterIndex, InputStream inputStream, long length)
    Sets the designated parameter to a InputStream object.
    void
    RowSet.setBlob(int i, Blob x)
    Sets the designated parameter in this RowSet object's command with the given Blob value.
    void
    RowSet.setBlob(String parameterName, InputStream inputStream)
    Sets the designated parameter to a InputStream object.
    void
    RowSet.setBlob(String parameterName, InputStream inputStream, long length)
    Sets the designated parameter to a InputStream object.
    void
    RowSet.setBlob(String parameterName, Blob x)
    Sets the designated parameter to the given java.sql.Blob object.
    void
    RowSet.setBoolean(int parameterIndex, boolean x)
    Sets the designated parameter in this RowSet object's command to the given Java boolean value.
    void
    RowSet.setBoolean(String parameterName, boolean x)
    Sets the designated parameter to the given Java boolean value.
    void
    RowSet.setByte(int parameterIndex, byte x)
    Sets the designated parameter in this RowSet object's command to the given Java byte value.
    void
    RowSet.setByte(String parameterName, byte x)
    Sets the designated parameter to the given Java byte value.
    void
    RowSet.setBytes(int parameterIndex, byte[] x)
    Sets the designated parameter in this RowSet object's command to the given Java array of byte values.
    void
    RowSet.setBytes(String parameterName, byte[] x)
    Sets the designated parameter to the given Java array of bytes.
    void
    RowSetMetaData.setCaseSensitive(int columnIndex, boolean property)
    Sets whether the designated column is case sensitive.
    void
    RowSetMetaData.setCatalogName(int columnIndex, String catalogName)
    Sets the designated column's table's catalog name, if any, to the given String.
    void
    RowSet.setCharacterStream(int parameterIndex, Reader reader)
    Sets the designated parameter in this RowSet object's command to the given Reader object.
    void
    RowSet.setCharacterStream(int parameterIndex, Reader reader, int length)
    Sets the designated parameter in this RowSet object's command to the given java.io.Reader value.
    void
    RowSet.setCharacterStream(String parameterName, Reader reader)
    Sets the designated parameter to the given Reader object.
    void
    RowSet.setCharacterStream(String parameterName, Reader reader, int length)
    Sets the designated parameter to the given Reader object, which is the given number of characters long.
    void
    RowSet.setClob(int parameterIndex, Reader reader)
    Sets the designated parameter to a Reader object.
    void
    RowSet.setClob(int parameterIndex, Reader reader, long length)
    Sets the designated parameter to a Reader object.
    void
    RowSet.setClob(int i, Clob x)
    Sets the designated parameter in this RowSet object's command with the given Clob value.
    void
    RowSet.setClob(String parameterName, Reader reader)
    Sets the designated parameter to a Reader object.
    void
    RowSet.setClob(String parameterName, Reader reader, long length)
    Sets the designated parameter to a Reader object.
    void
    RowSet.setClob(String parameterName, Clob x)
    Sets the designated parameter to the given java.sql.Clob object.
    void
    RowSetMetaData.setColumnCount(int columnCount)
    Sets the number of columns in the RowSet object to the given number.
    void
    RowSetMetaData.setColumnDisplaySize(int columnIndex, int size)
    Sets the designated column's normal maximum width in chars to the given int.
    void
    RowSetMetaData.setColumnLabel(int columnIndex, String label)
    Sets the suggested column title for use in printouts and displays, if any, to the given String.
    void
    RowSetMetaData.setColumnName(int columnIndex, String columnName)
    Sets the name of the designated column to the given String.
    void
    RowSetMetaData.setColumnType(int columnIndex, int SQLType)
    Sets the designated column's SQL type to the one given.
    void
    RowSetMetaData.setColumnTypeName(int columnIndex, String typeName)
    Sets the designated column's type name that is specific to the data source, if any, to the given String.
    void
    RowSet.setCommand(String cmd)
    Sets this RowSet object's command property to the given SQL query.
    void
    RowSet.setConcurrency(int concurrency)
    Sets the concurrency of this RowSet object to the given concurrency level.
    void
    RowSetMetaData.setCurrency(int columnIndex, boolean property)
    Sets whether the designated column is a cash value.
    void
    Sets the data source name property for this RowSet object to the given String.
    void
    RowSet.setDate(int parameterIndex, Date x)
    Sets the designated parameter in this RowSet object's command to the given java.sql.Date value.
    void
    RowSet.setDate(int parameterIndex, Date x, Calendar cal)
    Sets the designated parameter in this RowSet object's command with the given java.sql.Date value.
    void
    RowSet.setDate(String parameterName, Date x)
    Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.
    void
    RowSet.setDate(String parameterName, Date x, Calendar cal)
    Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
    void
    RowSet.setDouble(int parameterIndex, double x)
    Sets the designated parameter in this RowSet object's command to the given Java double value.
    void
    RowSet.setDouble(String parameterName, double x)
    Sets the designated parameter to the given Java double value.
    void
    RowSet.setEscapeProcessing(boolean enable)
    Sets escape processing for this RowSet object on or off.
    void
    RowSet.setFloat(int parameterIndex, float x)
    Sets the designated parameter in this RowSet object's command to the given Java float value.
    void
    RowSet.setFloat(String parameterName, float x)
    Sets the designated parameter to the given Java float value.
    void
    RowSet.setInt(int parameterIndex, int x)
    Sets the designated parameter in this RowSet object's command to the given Java int value.
    void
    RowSet.setInt(String parameterName, int x)
    Sets the designated parameter to the given Java int value.
    void
    CommonDataSource.setLoginTimeout(int seconds)
    Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.
    void
    ConnectionPoolDataSource.setLoginTimeout(int seconds)
    Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.
    void
    DataSource.setLoginTimeout(int seconds)
    Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.
    void
    XADataSource.setLoginTimeout(int seconds)
    Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.
    void
    CommonDataSource.setLogWriter(PrintWriter out)
    Sets the log writer for this DataSource object to the given java.io.PrintWriter object.
    void
    ConnectionPoolDataSource.setLogWriter(PrintWriter out)
    Sets the log writer for this DataSource object to the given java.io.PrintWriter object.
    void
    DataSource.setLogWriter(PrintWriter out)
    Sets the log writer for this DataSource object to the given java.io.PrintWriter object.
    void
    XADataSource.setLogWriter(PrintWriter out)
    Sets the log writer for this DataSource object to the given java.io.PrintWriter object.
    void
    RowSet.setLong(int parameterIndex, long x)
    Sets the designated parameter in this RowSet object's command to the given Java long value.
    void
    RowSet.setLong(String parameterName, long x)
    Sets the designated parameter to the given Java long value.
    void
    RowSet.setMaxFieldSize(int max)
    Sets the maximum number of bytes that can be returned for a column value to the given number of bytes.
    void
    RowSet.setMaxRows(int max)
    Sets the maximum number of rows that this RowSet object can contain to the specified number.
    void
    RowSetInternal.setMetaData(RowSetMetaData md)
    Sets the given RowSetMetaData object as the RowSetMetaData object for this RowSet object.
    void
    RowSet.setNCharacterStream(int parameterIndex, Reader value)
    Sets the designated parameter in this RowSet object's command to a Reader object.
    void
    RowSet.setNCharacterStream(int parameterIndex, Reader value, long length)
    Sets the designated parameter to a Reader object.
    void
    RowSet.setNCharacterStream(String parameterName, Reader value)
    Sets the designated parameter to a Reader object.
    void
    RowSet.setNCharacterStream(String parameterName, Reader value, long length)
    Sets the designated parameter to a Reader object.
    void
    RowSet.setNClob(int parameterIndex, Reader reader)
    Sets the designated parameter to a Reader object.
    void
    RowSet.setNClob(int parameterIndex, Reader reader, long length)
    Sets the designated parameter to a Reader object.
    void
    RowSet.setNClob(int parameterIndex, NClob value)
    Sets the designated parameter to a java.sql.NClob object.
    void
    RowSet.setNClob(String parameterName, Reader reader)
    Sets the designated parameter to a Reader object.
    void
    RowSet.setNClob(String parameterName, Reader reader, long length)
    Sets the designated parameter to a Reader object.
    void
    RowSet.setNClob(String parameterName, NClob value)
    Sets the designated parameter to a java.sql.NClob object.
    void
    RowSet.setNString(int parameterIndex, String value)
    Sets the designated parameter to the given String object.
    void
    RowSet.setNString(String parameterName, String value)
    Sets the designated parameter to the given String object.
    void
    RowSet.setNull(int parameterIndex, int sqlType)
    Sets the designated parameter in this RowSet object's SQL command to SQL NULL.
    void
    RowSet.setNull(int paramIndex, int sqlType, String typeName)
    Sets the designated parameter in this RowSet object's SQL command to SQL NULL.
    void
    RowSet.setNull(String parameterName, int sqlType)
    Sets the designated parameter to SQL NULL.
    void
    RowSet.setNull(String parameterName, int sqlType, String typeName)
    Sets the designated parameter to SQL NULL.
    void
    RowSetMetaData.setNullable(int columnIndex, int property)
    Sets whether the designated column's value can be set to NULL.
    void
    RowSet.setObject(int parameterIndex, Object x)
    Sets the designated parameter in this RowSet object's command with a Java Object.
    void
    RowSet.setObject(int parameterIndex, Object x, int targetSqlType)
    Sets the designated parameter in this RowSet object's command with a Java Object.
    void
    RowSet.setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength)
    Sets the designated parameter in this RowSet object's command with the given Java Object.
    void
    RowSet.setObject(String parameterName, Object x)
    Sets the value of the designated parameter with the given object.
    void
    RowSet.setObject(String parameterName, Object x, int targetSqlType)
    Sets the value of the designated parameter with the given object.
    void
    RowSet.setObject(String parameterName, Object x, int targetSqlType, int scale)
    Sets the value of the designated parameter with the given object.
    void
    RowSet.setPassword(String password)
    Sets the database password for this RowSet object to the given String.
    void
    RowSetMetaData.setPrecision(int columnIndex, int precision)
    Sets the designated column's number of decimal digits to the given int.
    void
    RowSet.setQueryTimeout(int seconds)
    Sets the maximum time the driver will wait for a statement to execute to the given number of seconds.
    void
    RowSet.setReadOnly(boolean value)
    Sets whether this RowSet object is read-only to the given boolean.
    void
    RowSet.setRef(int i, Ref x)
    Sets the designated parameter in this RowSet object's command with the given Ref value.
    void
    RowSet.setRowId(int parameterIndex, RowId x)
    Sets the designated parameter to the given java.sql.RowId object.
    void
    RowSet.setRowId(String parameterName, RowId x)
    Sets the designated parameter to the given java.sql.RowId object.
    void
    RowSetMetaData.setScale(int columnIndex, int scale)
    Sets the designated column's number of digits to the right of the decimal point to the given int.
    void
    RowSetMetaData.setSchemaName(int columnIndex, String schemaName)
    Sets the name of the designated column's table's schema, if any, to the given String.
    void
    RowSetMetaData.setSearchable(int columnIndex, boolean property)
    Sets whether the designated column can be used in a where clause.
    void
    RowSet.setShort(int parameterIndex, short x)
    Sets the designated parameter in this RowSet object's command to the given Java short value.
    void
    RowSet.setShort(String parameterName, short x)
    Sets the designated parameter to the given Java short value.
    void
    RowSetMetaData.setSigned(int columnIndex, boolean property)
    Sets whether the designated column is a signed number.
    void
    RowSet.setSQLXML(int parameterIndex, SQLXML xmlObject)
    Sets the designated parameter to the given java.sql.SQLXML object.
    void
    RowSet.setSQLXML(String parameterName, SQLXML xmlObject)
    Sets the designated parameter to the given java.sql.SQLXML object.
    void
    RowSet.setString(int parameterIndex, String x)
    Sets the designated parameter in this RowSet object's command to the given Java String value.
    void
    RowSet.setString(String parameterName, String x)
    Sets the designated parameter to the given Java String value.
    void
    RowSetMetaData.setTableName(int columnIndex, String tableName)
    Sets the designated column's table name, if any, to the given String.
    void
    RowSet.setTime(int parameterIndex, Time x)
    Sets the designated parameter in this RowSet object's command to the given java.sql.Time value.
    void
    RowSet.setTime(int parameterIndex, Time x, Calendar cal)
    Sets the designated parameter in this RowSet object's command with the given java.sql.Time value.
    void
    RowSet.setTime(String parameterName, Time x)
    Sets the designated parameter to the given java.sql.Time value.
    void
    RowSet.setTime(String parameterName, Time x, Calendar cal)
    Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.
    void
    RowSet.setTimestamp(int parameterIndex, Timestamp x)
    Sets the designated parameter in this RowSet object's command to the given java.sql.Timestamp value.
    void
    RowSet.setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
    Sets the designated parameter in this RowSet object's command with the given java.sql.Timestamp value.
    void
    RowSet.setTimestamp(String parameterName, Timestamp x)
    Sets the designated parameter to the given java.sql.Timestamp value.
    void
    RowSet.setTimestamp(String parameterName, Timestamp x, Calendar cal)
    Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.
    void
    RowSet.setTransactionIsolation(int level)
    Sets the transaction isolation level for this RowSet object.
    void
    RowSet.setType(int type)
    Sets the type of this RowSet object to the given type.
    void
    RowSet.setTypeMap(Map<String,Class<?>> map)
    Installs the given java.util.Map object as the default type map for this RowSet object.
    void
    RowSet.setUrl(String url)
    Sets the URL this RowSet object will use when it uses the DriverManager to create a connection.
    void
    RowSet.setURL(int parameterIndex, URL x)
    Sets the designated parameter to the given java.net.URL value.
    void
    RowSet.setUsername(String name)
    Sets the username property for this RowSet object to the given String.
    boolean
    RowSetWriter.writeData(RowSetInternal caller)
    Writes the changes in this RowSetWriter object's rowset back to the data source from which it got its data.
    Constructors in javax.sql with parameters of type SQLException
    Modifier
    Constructor
    Description
     
    Constructs a ConnectionEvent object initialized with the given PooledConnection object and SQLException object.
     
    Constructs a StatementEvent with the specified PooledConnection, PreparedStatement and SQLException
  • Uses of SQLException in javax.sql.rowset

    Modifier and Type
    Class
    Description
    class 
    An extension of SQLException that provides information about database warnings set on RowSet objects.
    Methods in javax.sql.rowset that throw SQLException
    Modifier and Type
    Method
    Description
    void
    JoinRowSet.addRowSet(RowSet[] rowset, int[] columnIdx)
    Adds one or more RowSet objects contained in the given array of RowSet objects to this JoinRowSet object and sets the match column for each of the RowSet objects to the match columns in the given array of column indexes.
    void
    JoinRowSet.addRowSet(RowSet[] rowset, String[] columnName)
    Adds one or more RowSet objects contained in the given array of RowSet objects to this JoinRowSet object and sets the match column for each of the RowSet objects to the match columns in the given array of column names.
    void
    JoinRowSet.addRowSet(Joinable rowset)
    Adds the given RowSet object to this JoinRowSet object.
    void
    JoinRowSet.addRowSet(RowSet rowset, int columnIdx)
    Adds the given RowSet object to this JoinRowSet object and sets the designated column as the match column for the RowSet object.
    void
    JoinRowSet.addRowSet(RowSet rowset, String columnName)
    Adds rowset to this JoinRowSet object and sets the designated column as the match column.
    void
    BaseRowSet.clearParameters()
    Clears all of the current parameter values in this RowSet object's internal representation of the parameters to be set in this RowSet object's command when it is executed.
    boolean
    CachedRowSet.columnUpdated(int idx)
    Indicates whether the designated column in the current row of this CachedRowSet object has been updated.
    boolean
    CachedRowSet.columnUpdated(String columnName)
    Indicates whether the designated column in the current row of this CachedRowSet object has been updated.
    void
    CachedRowSet.commit()
    Each CachedRowSet object's SyncProvider contains a Connection object from the ResultSet or JDBC properties passed to it's constructors.
    void
    JdbcRowSet.commit()
    Each JdbcRowSet contains a Connection object from the ResultSet or JDBC properties passed to it's constructors.
    RowSetFactory.createCachedRowSet()
    Creates a new instance of a CachedRowSet.
    CachedRowSet.createCopy()
    Creates a RowSet object that is a deep copy of the data in this CachedRowSet object.
    Creates a CachedRowSet object that is a deep copy of this CachedRowSet object's data but is independent of it.
    CachedRowSet.createCopySchema()
    Creates a CachedRowSet object that is an empty copy of this CachedRowSet object.
    RowSetFactory.createFilteredRowSet()
    Creates a new instance of a FilteredRowSet.
    RowSetFactory.createJdbcRowSet()
    Creates a new instance of a JdbcRowSet.
    RowSetFactory.createJoinRowSet()
    Creates a new instance of a JoinRowSet.
    CachedRowSet.createShared()
    Returns a new RowSet object backed by the same data as that of this CachedRowSet object.
    RowSetFactory.createWebRowSet()
    Creates a new instance of a WebRowSet.
    boolean
    Predicate.evaluate(Object value, int column)
    This method is called by a FilteredRowSet object to check whether the value lies between the filtering criterion (or criteria if multiple constraints exist) set using the setFilter() method.
    boolean
    Predicate.evaluate(Object value, String columnName)
    This method is called by the FilteredRowSet object to check whether the value lies between the filtering criteria set using the setFilter method.
    void
    CachedRowSet.execute(Connection conn)
    Populates this CachedRowSet object with data, using the given connection to produce the result set from which the data will be read.
    boolean
    JdbcRowSet.getAutoCommit()
    Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it.
    RowSetMetaDataImpl.getCatalogName(int columnIndex)
    Retrieves the catalog name of the table from which the value in the designated column was derived.
    RowSetMetaDataImpl.getColumnClassName(int columnIndex)
    Retrieves the fully-qualified name of the class in the Java programming language to which a value in the designated column will be mapped.
    int
    RowSetMetaDataImpl.getColumnCount()
    Retrieves the number of columns in the RowSet object for which this RowSetMetaDataImpl object was created.
    int
    RowSetMetaDataImpl.getColumnDisplaySize(int columnIndex)
    Retrieves the normal maximum width in chars of the designated column.
    RowSetMetaDataImpl.getColumnLabel(int columnIndex)
    Retrieves the suggested column title for the designated column for use in printouts and displays.
    RowSetMetaDataImpl.getColumnName(int columnIndex)
    Retrieves the name of the designated column.
    int
    RowSetMetaDataImpl.getColumnType(int columnIndex)
    Retrieves the type code (one of the java.sql.Types constants) for the SQL type of the value stored in the designated column.
    RowSetMetaDataImpl.getColumnTypeName(int columnIndex)
    Retrieves the DBMS-specific type name for values stored in the designated column.
    int
    BaseRowSet.getConcurrency()
    Returns the concurrency for this RowSet object.
    boolean
    BaseRowSet.getEscapeProcessing()
    Ascertains whether escape processing is enabled for this RowSet object.
    int
    BaseRowSet.getFetchDirection()
    Retrieves this RowSet object's current setting for the fetch direction.
    int
    BaseRowSet.getFetchSize()
    Returns the fetch size for this RowSet object.
    int
    JoinRowSet.getJoinType()
    Returns a int describing the set SQL JOIN type governing this JoinRowSet instance.
    int[]
    CachedRowSet.getKeyColumns()
    Returns an array containing one or more column numbers indicating the columns that form a key that uniquely identifies a row in this CachedRowSet object.
    int[]
    Retrieves the indexes of the match columns that were set for this RowSet object with the method setMatchColumn(int[] columnIdxes).
    Retrieves the names of the match columns that were set for this RowSet object with the method setMatchColumn(String [] columnNames).
    int
    BaseRowSet.getMaxFieldSize()
    Retrieves the maximum number of bytes that can be used for a column value in this RowSet object.
    int
    BaseRowSet.getMaxRows()
    Retrieves the maximum number of rows that this RowSet object may contain.
    CachedRowSet.getOriginal()
    Returns a ResultSet object containing the original value of this CachedRowSet object.
    CachedRowSet.getOriginalRow()
    Returns a ResultSet object containing the original value for the current row only of this CachedRowSet object.
    BaseRowSet.getParams()
    Retrieves an array containing the parameter values (both Objects and primitives) that have been set for this RowSet object's command and throws an SQLException object if all parameters have not been set.
    int
    RowSetMetaDataImpl.getPrecision(int columnIndex)
    Retrieves the total number of digits for values stored in the designated column.
    int
    BaseRowSet.getQueryTimeout()
    Retrieves the maximum number of seconds the driver will wait for a query to execute.
    JoinRowSet.getRowSetNames()
    Returns a String array containing the names of the RowSet objects added to this JoinRowSet object.
    JoinRowSet.getRowSets()
    Returns a Collection object containing the RowSet objects that have been added to this JoinRowSet object.
    CachedRowSet.getRowSetWarnings()
    Retrieves the first warning reported by calls on this RowSet object.
    JdbcRowSet.getRowSetWarnings()
    Retrieves the first warning reported by calls on this JdbcRowSet object.
    int
    RowSetMetaDataImpl.getScale(int columnIndex)
    Retrieves the number of digits to the right of the decimal point for values stored in the designated column.
    RowSetMetaDataImpl.getSchemaName(int columnIndex)
    Retrieves the schema name of the table from which the value in the designated column was derived.
    boolean
    BaseRowSet.getShowDeleted()
    Retrieves a boolean indicating whether rows marked for deletion appear in the set of current rows.
    boolean
    CachedRowSet.getShowDeleted()
    Retrieves a boolean indicating whether rows marked for deletion appear in the set of current rows.
    boolean
    JdbcRowSet.getShowDeleted()
    Retrieves a boolean indicating whether rows marked for deletion appear in the set of current rows.
    CachedRowSet.getSyncProvider()
    Retrieves the SyncProvider implementation for this CachedRowSet object.
    CachedRowSet.getTableName()
    Returns an identifier for the object (table) that was used to create this CachedRowSet object.
    RowSetMetaDataImpl.getTableName(int columnIndex)
    Retrieves the name of the table from which the value in the designated column was derived.
    int
    BaseRowSet.getType()
    Returns the type of this RowSet object.
    BaseRowSet.getUrl()
    Retrieves the JDBC URL that this RowSet object's javax.sql.Reader object uses to make a connection with a relational database using a JDBC technology-enabled driver.
    JoinRowSet.getWhereClause()
    Return a SQL-like description of the WHERE clause being used in a JoinRowSet object.
    boolean
    RowSetMetaDataImpl.isAutoIncrement(int columnIndex)
    Retrieves whether a value stored in the designated column is automatically numbered, and thus readonly.
    boolean
    RowSetMetaDataImpl.isCaseSensitive(int columnIndex)
    Indicates whether the case of the designated column's name matters.
    boolean
    RowSetMetaDataImpl.isCurrency(int columnIndex)
    Indicates whether a value stored in the designated column is a cash value.
    boolean
    RowSetMetaDataImpl.isDefinitelyWritable(int columnIndex)
    Indicates whether a write operation on the designated column will definitely succeed.
    int
    RowSetMetaDataImpl.isNullable(int columnIndex)
    Retrieves a constant indicating whether it is possible to store a NULL value in the designated column.
    boolean
    RowSetMetaDataImpl.isReadOnly(int columnIndex)
    Indicates whether the designated column is definitely not writable, thus readonly.
    boolean
    RowSetMetaDataImpl.isSearchable(int columnIndex)
    Indicates whether a value stored in the designated column can be used in a WHERE clause.
    boolean
    RowSetMetaDataImpl.isSigned(int columnIndex)
    Indicates whether a value stored in the designated column is a signed number.
    boolean
    RowSetMetaDataImpl.isWrapperFor(Class<?> interfaces)
    Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
    boolean
    RowSetMetaDataImpl.isWritable(int columnIndex)
    Indicates whether it is possible for a write operation on the designated column to succeed.
    RowSetProvider.newFactory()
    Creates a new instance of a RowSetFactory implementation.
    RowSetProvider.newFactory(String factoryClassName, ClassLoader cl)
    Creates a new instance of a RowSetFactory from the specified factory class name.
    boolean
    CachedRowSet.nextPage()
    Increments the current page of the CachedRowSet.
    protected void
    BaseRowSet.notifyCursorMoved()
    Notifies all of the listeners registered with this RowSet object that its cursor has moved.
    protected void
    BaseRowSet.notifyRowChanged()
    Notifies all of the listeners registered with this RowSet object that one of its rows has changed.
    protected void
    BaseRowSet.notifyRowSetChanged()
    Notifies all of the listeners registered with this RowSet object that its entire contents have changed.
    void
    CachedRowSet.populate(ResultSet data)
    Populates this CachedRowSet object with data from the given ResultSet object.
    void
    CachedRowSet.populate(ResultSet rs, int startRow)
    Populates this CachedRowSet object with data from the given ResultSet object.
    boolean
    CachedRowSet.previousPage()
    Decrements the current page of the CachedRowSet.
    void
    WebRowSet.readXml(InputStream iStream)
    Reads a stream based XML input to populate this WebRowSet object.
    void
    WebRowSet.readXml(Reader reader)
    Reads a WebRowSet object in its XML format from the given Reader object.
    void
    CachedRowSet.release()
    Releases the current contents of this CachedRowSet object and sends a rowSetChanged event to all registered listeners.
    void
    CachedRowSet.restoreOriginal()
    Restores this CachedRowSet object to its original value, that is, its value before the last set of changes.
    void
    CachedRowSet.rollback()
    Each CachedRowSet object's SyncProvider contains a Connection object from the original ResultSet or JDBC properties passed to it.
    void
    CachedRowSet.rollback(Savepoint s)
    Each CachedRowSet object's SyncProvider contains a Connection object from the original ResultSet or JDBC properties passed to it.
    void
    JdbcRowSet.rollback()
    Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it.
    void
    JdbcRowSet.rollback(Savepoint s)
    Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it.
    void
    CachedRowSet.rowSetPopulated(RowSetEvent event, int numRows)
    Notifies registered listeners that a RowSet object in the given RowSetEvent object has populated a number of additional rows.
    void
    BaseRowSet.setArray(int parameterIndex, Array array)
    Sets the designated parameter to an Array object in the Java programming language.
    void
    BaseRowSet.setAsciiStream(int parameterIndex, InputStream x)
    Sets the designated parameter in this RowSet object's command to the given input stream.
    void
    BaseRowSet.setAsciiStream(int parameterIndex, InputStream x, int length)
    Sets the designated parameter to the given java.io.InputStream object, which will have the specified number of bytes.
    void
    BaseRowSet.setAsciiStream(String parameterName, InputStream x)
    Sets the designated parameter to the given input stream.
    void
    BaseRowSet.setAsciiStream(String parameterName, InputStream x, int length)
    Sets the designated parameter to the given input stream, which will have the specified number of bytes.
    void
    JdbcRowSet.setAutoCommit(boolean autoCommit)
    Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it.
    void
    RowSetMetaDataImpl.setAutoIncrement(int columnIndex, boolean property)
    Sets whether the designated column is automatically numbered, thus read-only, to the given boolean value.
    void
    BaseRowSet.setBigDecimal(int parameterIndex, BigDecimal x)
    Sets the designated parameter to the given java.lang.BigDecimal value.
    void
    BaseRowSet.setBigDecimal(String parameterName, BigDecimal x)
    Sets the designated parameter to the given java.math.BigDecimal value.
    void
    BaseRowSet.setBinaryStream(int parameterIndex, InputStream x)
    Sets the designated parameter in this RowSet object's command to the given input stream.
    void
    BaseRowSet.setBinaryStream(int parameterIndex, InputStream x, int length)
    Sets the designated parameter to the given java.io.InputStream object, which will have the specified number of bytes.
    void
    BaseRowSet.setBinaryStream(String parameterName, InputStream x)
    Sets the designated parameter to the given input stream.
    void
    BaseRowSet.setBinaryStream(String parameterName, InputStream x, int length)
    Sets the designated parameter to the given input stream, which will have the specified number of bytes.
    void
    BaseRowSet.setBlob(int parameterIndex, InputStream inputStream)
    Sets the designated parameter to a InputStream object.
    void
    BaseRowSet.setBlob(int parameterIndex, InputStream inputStream, long length)
    Sets the designated parameter to a InputStream object.
    void
    BaseRowSet.setBlob(int parameterIndex, Blob x)
    Sets the designated parameter to the given Blob object in the Java programming language.
    void
    BaseRowSet.setBlob(String parameterName, InputStream inputStream)
    Sets the designated parameter to a InputStream object.
    void
    BaseRowSet.setBlob(String parameterName, InputStream inputStream, long length)
    Sets the designated parameter to a InputStream object.
    void
    BaseRowSet.setBlob(String parameterName, Blob x)
    Sets the designated parameter to the given java.sql.Blob object.
    void
    BaseRowSet.setBoolean(int parameterIndex, boolean x)
    Sets the designated parameter to the given boolean in the Java programming language.
    void
    BaseRowSet.setBoolean(String parameterName, boolean x)
    Sets the designated parameter to the given Java boolean value.
    void
    BaseRowSet.setByte(int parameterIndex, byte x)
    Sets the designated parameter to the given byte in the Java programming language.
    void
    BaseRowSet.setByte(String parameterName, byte x)
    Sets the designated parameter to the given Java byte value.
    void
    BaseRowSet.setBytes(int parameterIndex, byte[] x)
    Sets the designated parameter to the given array of bytes.
    void
    BaseRowSet.setBytes(String parameterName, byte[] x)
    Sets the designated parameter to the given Java array of bytes.
    void
    RowSetMetaDataImpl.setCaseSensitive(int columnIndex, boolean property)
    Sets whether the name of the designated column is case sensitive to the given boolean.
    void
    RowSetMetaDataImpl.setCatalogName(int columnIndex, String catalogName)
    Sets the catalog name of the table from which the designated column was derived to catalogName.
    void
    BaseRowSet.setCharacterStream(int parameterIndex, Reader reader)
    Sets the designated parameter in this RowSet object's command to the given Reader object.
    void
    BaseRowSet.setCharacterStream(int parameterIndex, Reader reader, int length)
    Sets the designated parameter to the given java.io.Reader object, which will have the specified number of characters.
    void
    BaseRowSet.setCharacterStream(String parameterName, Reader reader)
    Sets the designated parameter to the given Reader object.
    void
    BaseRowSet.setCharacterStream(String parameterName, Reader reader, int length)
    Sets the designated parameter to the given Reader object, which is the given number of characters long.
    void
    BaseRowSet.setClob(int parameterIndex, Reader reader)
    Sets the designated parameter to a Reader object.
    void
    BaseRowSet.setClob(int parameterIndex, Reader reader, long length)
    Sets the designated parameter to a Reader object.
    void
    BaseRowSet.setClob(int parameterIndex, Clob x)
    Sets the designated parameter to the given Clob object in the Java programming language.
    void
    BaseRowSet.setClob(String parameterName, Reader reader)
    Sets the designated parameter to a Reader object.
    void
    BaseRowSet.setClob(String parameterName, Reader reader, long length)
    Sets the designated parameter to a Reader object.
    void
    BaseRowSet.setClob(String parameterName, Clob x)
    Sets the designated parameter to the given java.sql.Clob object.
    void
    RowSetMetaDataImpl.setColumnCount(int columnCount)
    Sets to the given number the number of columns in the RowSet object for which this RowSetMetaDataImpl object was created.
    void
    RowSetMetaDataImpl.setColumnDisplaySize(int columnIndex, int size)
    Sets the normal maximum number of chars in the designated column to the given number.
    void
    RowSetMetaDataImpl.setColumnLabel(int columnIndex, String label)
    Sets the suggested column label for use in printouts and displays, if any, to label.
    void
    RowSetMetaDataImpl.setColumnName(int columnIndex, String columnName)
    Sets the column name of the designated column to the given name.
    void
    RowSetMetaDataImpl.setColumnType(int columnIndex, int SQLType)
    Sets the SQL type code for values stored in the designated column to the given type code from the class java.sql.Types.
    void
    RowSetMetaDataImpl.setColumnTypeName(int columnIndex, String typeName)
    Sets the type name used by the data source for values stored in the designated column to the given type name.
    void
    BaseRowSet.setCommand(String cmd)
    Sets this RowSet object's command property to the given String object and clears the parameters, if any, that were set for the previous command.
    void
    BaseRowSet.setConcurrency(int concurrency)
    Sets the concurrency for this RowSet object to the specified concurrency.
    void
    RowSetMetaDataImpl.setCurrency(int columnIndex, boolean property)
    Sets whether a value stored in the designated column is a cash value to the given boolean.
    void
    BaseRowSet.setDataSourceName(String name)
    Sets the DataSource name property for this RowSet object to the given logical name and sets this RowSet object's Url property to null.
    void
    BaseRowSet.setDate(int parameterIndex, Date x)
    Sets the designated parameter to the given java.sql.Date value.
    void
    BaseRowSet.setDate(int parameterIndex, Date x, Calendar cal)
    Sets the designated parameter to the given java.sql.Date object.
    void
    BaseRowSet.setDate(String parameterName, Date x)
    Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.
    void
    BaseRowSet.setDate(String parameterName, Date x, Calendar cal)
    Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
    void
    BaseRowSet.setDouble(int parameterIndex, double x)
    Sets the designated parameter to the given double in the Java programming language.
    void
    BaseRowSet.setDouble(String parameterName, double x)
    Sets the designated parameter to the given Java double value.
    void
    BaseRowSet.setEscapeProcessing(boolean enable)
    Sets to the given boolean whether or not the driver will scan for escape syntax and do escape substitution before sending SQL statements to the database.
    void
    BaseRowSet.setFetchDirection(int direction)
    Gives the driver a performance hint as to the direction in which the rows in this RowSet object will be processed.
    void
    BaseRowSet.setFetchSize(int rows)
    Sets the fetch size for this RowSet object to the given number of rows.
    void
    FilteredRowSet.setFilter(Predicate p)
    Applies the given Predicate object to this FilteredRowSet object.
    void
    BaseRowSet.setFloat(int parameterIndex, float x)
    Sets the designated parameter to the given float in the Java programming language.
    void
    BaseRowSet.setFloat(String parameterName, float x)
    Sets the designated parameter to the given Java float value.
    void
    BaseRowSet.setInt(int parameterIndex, int x)
    Sets the designated parameter to an int in the Java programming language.
    void
    BaseRowSet.setInt(String parameterName, int x)
    Sets the designated parameter to the given Java int value.
    void
    JoinRowSet.setJoinType(int joinType)
    Allow the application to adjust the type of JOIN imposed on tables contained within the JoinRowSet object instance.
    void
    CachedRowSet.setKeyColumns(int[] keys)
    Sets this CachedRowSet object's keyCols field with the given array of column numbers, which forms a key for uniquely identifying a row in this CachedRowSet object.
    void
    BaseRowSet.setLong(int parameterIndex, long x)
    Sets the designated parameter to the given long in the Java programming language.
    void
    BaseRowSet.setLong(String parameterName, long x)
    Sets the designated parameter to the given Java long value.
    void
    Joinable.setMatchColumn(int columnIdx)
    Sets the designated column as the match column for this RowSet object.
    void
    Joinable.setMatchColumn(int[] columnIdxes)
    Sets the designated columns as the match column for this RowSet object.
    void
    Joinable.setMatchColumn(String columnName)
    Sets the designated column as the match column for this RowSet object.
    void
    Joinable.setMatchColumn(String[] columnNames)
    Sets the designated columns as the match column for this RowSet object.
    void
    BaseRowSet.setMaxFieldSize(int max)
    Sets the maximum number of bytes that can be used for a column value in this RowSet object to the given number.
    void
    BaseRowSet.setMaxRows(int max)
    Sets the maximum number of rows that this RowSet object may contain to the given number.
    void
    CachedRowSet.setMetaData(RowSetMetaData md)
    Sets the metadata for this CachedRowSet object with the given RowSetMetaData object.
    void
    BaseRowSet.setNCharacterStream(int parameterIndex, Reader value)
    Sets the designated parameter in this RowSet object's command to a Reader object.
    void
    BaseRowSet.setNCharacterStream(int parameterIndex, Reader value, long length)
    Sets the designated parameter to a Reader object.
    void
    BaseRowSet.setNCharacterStream(String parameterName, Reader value)
    Sets the designated parameter to a Reader object.
    void
    BaseRowSet.setNCharacterStream(String parameterName, Reader value, long length)
    Sets the designated parameter to a Reader object.
    void
    BaseRowSet.setNClob(int parameterIndex, Reader reader)
    Sets the designated parameter to a Reader object.
    void
    BaseRowSet.setNClob(int parameterIndex, Reader reader, long length)
    Sets the designated parameter to a Reader object.
    void
    BaseRowSet.setNClob(int parameterIndex, NClob value)
    Sets the designated parameter to a java.sql.NClob object.
    void
    BaseRowSet.setNClob(String parameterName, Reader reader)
    Sets the designated parameter to a Reader object.
    void
    BaseRowSet.setNClob(String parameterName, Reader reader, long length)
    Sets the designated parameter to a Reader object.
    void
    BaseRowSet.setNClob(String parameterName, NClob value)
    Sets the designated parameter to a java.sql.NClob object.
    void
    BaseRowSet.setNString(int parameterIndex, String value)
    Sets the designated parameter to the given String object.
    void
    BaseRowSet.setNString(String parameterName, String value)
    Sets the designated parameter to the given String object.
    void
    BaseRowSet.setNull(int parameterIndex, int sqlType)
    Sets the designated parameter to SQL NULL.
    void
    BaseRowSet.setNull(int parameterIndex, int sqlType, String typeName)
    Sets the designated parameter to SQL NULL.
    void
    BaseRowSet.setNull(String parameterName, int sqlType)
    Sets the designated parameter to SQL NULL.
    void
    BaseRowSet.setNull(String parameterName, int sqlType, String typeName)
    Sets the designated parameter to SQL NULL.
    void
    RowSetMetaDataImpl.setNullable(int columnIndex, int property)
    Sets whether a value stored in the designated column can be set to NULL to the given constant from the interface ResultSetMetaData.
    void
    BaseRowSet.setObject(int parameterIndex, Object x)
    Sets the designated parameter to an Object in the Java programming language.
    void
    BaseRowSet.setObject(int parameterIndex, Object x, int targetSqlType)
    Sets the value of the designated parameter with the given Object value.
    void
    BaseRowSet.setObject(int parameterIndex, Object x, int targetSqlType, int scale)
    Sets the designated parameter to an Object in the Java programming language.
    void
    BaseRowSet.setObject(String parameterName, Object x)
    Sets the value of the designated parameter with the given object.
    void
    BaseRowSet.setObject(String parameterName, Object x, int targetSqlType)
    Sets the value of the designated parameter with the given object.
    void
    BaseRowSet.setObject(String parameterName, Object x, int targetSqlType, int scale)
    Sets the value of the designated parameter with the given object.
    void
    CachedRowSet.setOriginalRow()
    Sets the current row in this CachedRowSet object as the original row.
    void
    CachedRowSet.setPageSize(int size)
    Sets the CachedRowSet object's page-size.
    void
    RowSetMetaDataImpl.setPrecision(int columnIndex, int precision)
    Sets the total number of decimal digits in a value stored in the designated column to the given number.
    void
    BaseRowSet.setQueryTimeout(int seconds)
    Sets to the given number the maximum number of seconds the driver will wait for a query to execute.
    void
    BaseRowSet.setRef(int parameterIndex, Ref ref)
    Sets the designated parameter to the given Ref object in the Java programming language.
    void
    BaseRowSet.setRowId(int parameterIndex, RowId x)
    Sets the designated parameter to the given java.sql.RowId object.
    void
    BaseRowSet.setRowId(String parameterName, RowId x)
    Sets the designated parameter to the given java.sql.RowId object.
    void
    RowSetMetaDataImpl.setScale(int columnIndex, int scale)
    Sets the number of digits to the right of the decimal point in a value stored in the designated column to the given number.
    void
    RowSetMetaDataImpl.setSchemaName(int columnIndex, String schemaName)
    Sets the designated column's table's schema name, if any, to schemaName.
    void
    RowSetMetaDataImpl.setSearchable(int columnIndex, boolean property)
    Sets whether a value stored in the designated column can be used in a WHERE clause to the given boolean value.
    void
    BaseRowSet.setShort(int parameterIndex, short x)
    Sets the designated parameter to the given short in the Java programming language.
    void
    BaseRowSet.setShort(String parameterName, short x)
    Sets the designated parameter to the given Java short value.
    void
    BaseRowSet.setShowDeleted(boolean value)
    Sets the property showDeleted to the given boolean value, which determines whether rows marked for deletion appear in the set of current rows.
    void
    CachedRowSet.setShowDeleted(boolean b)
    Sets the property showDeleted to the given boolean value, which determines whether rows marked for deletion appear in the set of current rows.
    void
    JdbcRowSet.setShowDeleted(boolean b)
    Sets the property showDeleted to the given boolean value.
    void
    RowSetMetaDataImpl.setSigned(int columnIndex, boolean property)
    Sets whether a value stored in the designated column is a signed number to the given boolean.
    void
    BaseRowSet.setSQLXML(int parameterIndex, SQLXML xmlObject)
    Sets the designated parameter to the given java.sql.SQLXML object.
    void
    BaseRowSet.setSQLXML(String parameterName, SQLXML xmlObject)
    Sets the designated parameter to the given java.sql.SQLXML object.
    void
    BaseRowSet.setString(int parameterIndex, String x)
    Sets the designated parameter to the given String value.
    void
    BaseRowSet.setString(String parameterName, String x)
    Sets the designated parameter to the given Java String value.
    void
    CachedRowSet.setSyncProvider(String provider)
    Sets the SyncProvider object for this CachedRowSet object to the one specified.
    void
    CachedRowSet.setTableName(String tabName)
    Sets the identifier for the table from which this CachedRowSet object was derived to the given table name.
    void
    RowSetMetaDataImpl.setTableName(int columnIndex, String tableName)
    Sets the name of the table from which the designated column was derived to the given table name.
    void
    BaseRowSet.setTime(int parameterIndex, Time x)
    Sets the designated parameter to the given java.sql.Time value.
    void
    BaseRowSet.setTime(int parameterIndex, Time x, Calendar cal)
    Sets the designated parameter to the given java.sql.Time object.
    void
    BaseRowSet.setTime(String parameterName, Time x)
    Sets the designated parameter to the given java.sql.Time value.
    void
    BaseRowSet.setTime(String parameterName, Time x, Calendar cal)
    Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.
    void
    BaseRowSet.setTimestamp(int parameterIndex, Timestamp x)
    Sets the designated parameter to the given java.sql.Timestamp value.
    void
    BaseRowSet.setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
    Sets the designated parameter to the given java.sql.Timestamp object.
    void
    BaseRowSet.setTimestamp(String parameterName, Timestamp x)
    Sets the designated parameter to the given java.sql.Timestamp value.
    void
    BaseRowSet.setTimestamp(String parameterName, Timestamp x, Calendar cal)
    Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.
    void
    BaseRowSet.setTransactionIsolation(int level)
    Sets the transaction isolation property for this JDBC RowSet object to the given constant.
    void
    BaseRowSet.setType(int type)
    Sets the type for this RowSet object to the specified type.
    void
    BaseRowSet.setUnicodeStream(int parameterIndex, InputStream x, int length)
    Deprecated.
    getCharacterStream should be used in its place
    void
    BaseRowSet.setUrl(String url)
    Sets the Url property for this RowSet object to the given String object and sets the dataSource name property to null.
    void
    BaseRowSet.setURL(int parameterIndex, URL x)
    Sets the designated parameter to the given java.net.URL value.
    JoinRowSet.toCachedRowSet()
    Creates a new CachedRowSet object containing the data in this JoinRowSet object, which can be saved to a data source using the SyncProvider object for the CachedRowSet object.
    CachedRowSet.toCollection()
    Converts this CachedRowSet object to a Collection object that contains all of this CachedRowSet object's data.
    CachedRowSet.toCollection(int column)
    Converts the designated column in this CachedRowSet object to a Collection object.
    CachedRowSet.toCollection(String column)
    Converts the designated column in this CachedRowSet object to a Collection object.
    void
    CachedRowSet.undoDelete()
    Cancels the deletion of the current row and notifies listeners that a row has changed.
    void
    CachedRowSet.undoInsert()
    Immediately removes the current row from this CachedRowSet object if the row has been inserted, and also notifies listeners that a row has changed.
    void
    CachedRowSet.undoUpdate()
    Immediately reverses the last update operation if the row has been modified.
    void
    Joinable.unsetMatchColumn(int columnIdx)
    Unsets the designated column as the match column for this RowSet object.
    void
    Joinable.unsetMatchColumn(int[] columnIdxes)
    Unsets the designated columns as the match column for this RowSet object.
    void
    Joinable.unsetMatchColumn(String columnName)
    Unsets the designated column as the match column for this RowSet object.
    void
    Joinable.unsetMatchColumn(String[] columnName)
    Unsets the designated columns as the match columns for this RowSet object.
    <T> T
    RowSetMetaDataImpl.unwrap(Class<T> iface)
    Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
    void
    WebRowSet.writeXml(OutputStream oStream)
    Writes the data, properties, and metadata for this WebRowSet object to the given OutputStream object in XML format.
    void
    WebRowSet.writeXml(Writer writer)
    Writes the data, properties, and metadata for this WebRowSet object to the given Writer object in XML format.
    void
    WebRowSet.writeXml(ResultSet rs, OutputStream oStream)
    Populates this WebRowSet object with the contents of the given ResultSet object and writes its data, properties, and metadata to the given OutputStream object in XML format.
    void
    WebRowSet.writeXml(ResultSet rs, Writer writer)
    Populates this WebRowSet object with the contents of the given ResultSet object and writes its data, properties, and metadata to the given Writer object in XML format.
  • Uses of SQLException in javax.sql.rowset.serial

    Modifier and Type
    Class
    Description
    class 
    Indicates and an error with the serialization or de-serialization of SQL types such as BLOB, CLOB, STRUCT or ARRAY in addition to SQL types such as DATALINK and JAVAOBJECT
    Modifier and Type
    Method
    Description
    void
    SerialArray.free()
    This method frees the SerialArray object and releases the resources that it holds.
    void
    SerialBlob.free()
    This method frees the SerialBlob object and releases the resources that it holds.
    void
    SerialClob.free()
    This method frees the SerialClob object and releases the resources that it holds.
    SerialClob.getAsciiStream()
    Retrieves the CLOB value designated by this SerialClob object as an ascii stream.
    SerialBlob.getBinaryStream(long pos, long length)
    Returns an InputStream object that contains a partial Blob value, starting with the byte specified by pos, which is length bytes in length.
    SerialClob.getCharacterStream(long pos, long length)
    Returns a Reader object that contains a partial SerialClob value, starting with the character specified by pos, which is length characters in length.
    long
    SerialBlob.position(byte[] pattern, long start)
    Returns the position in this SerialBlob object where the given pattern of bytes begins, starting the search at the specified position.
    long
    SerialBlob.position(Blob pattern, long start)
    Returns the position in this SerialBlob object where the given Blob object begins, starting the search at the specified position.
    long
    SerialClob.position(String searchStr, long start)
    Returns the position in this SerialClob object where the given String object begins, starting the search at the specified position.
    long
    SerialClob.position(Clob searchStr, long start)
    Returns the position in this SerialClob object where the given Clob signature begins, starting the search at the specified position.
    SQLInputImpl.readArray()
    Reads an SQL ARRAY value from the stream and returns it as an Array object in the Java programming language.
    SQLInputImpl.readAsciiStream()
    Returns the next attribute in this SQLInputImpl object as a stream of ASCII characters.
    SQLInputImpl.readBigDecimal()
    Retrieves the next attribute in this SQLInputImpl object as a java.math.BigDecimal.
    SQLInputImpl.readBinaryStream()
    Returns the next attribute in this SQLInputImpl object as a stream of uninterpreted bytes.
    SQLInputImpl.readBlob()
    Retrieves the BLOB value at the head of this SQLInputImpl object as a Blob object in the Java programming language.
    boolean
    SQLInputImpl.readBoolean()
    Retrieves the next attribute in this SQLInputImpl object as a boolean in the Java programming language.
    byte
    SQLInputImpl.readByte()
    Retrieves the next attribute in this SQLInputImpl object as a byte in the Java programming language.
    byte[]
    SQLInputImpl.readBytes()
    Retrieves the next attribute in this SQLInputImpl object as an array of bytes.
    SQLInputImpl.readCharacterStream()
    Retrieves the next attribute in this SQLInputImpl object as a stream of Unicode characters.
    SQLInputImpl.readClob()
    Retrieves the CLOB value at the head of this SQLInputImpl object as a Clob object in the Java programming language.
    SQLInputImpl.readDate()
    Retrieves the next attribute in this SQLInputImpl as a java.sql.Date object.
    double
    SQLInputImpl.readDouble()
    Retrieves the next attribute in this SQLInputImpl object as a double in the Java programming language.
    float
    SQLInputImpl.readFloat()
    Retrieves the next attribute in this SQLInputImpl object as a float in the Java programming language.
    int
    SQLInputImpl.readInt()
    Retrieves the next attribute in this SQLInputImpl object as an int in the Java programming language.
    long
    SQLInputImpl.readLong()
    Retrieves the next attribute in this SQLInputImpl object as a long in the Java programming language.
    SQLInputImpl.readNClob()
    Reads an SQL NCLOB value from the stream and returns it as a Clob object in the Java programming language.
    SQLInputImpl.readNString()
    Reads the next attribute in the stream and returns it as a String in the Java programming language.
    SQLInputImpl.readObject()
    Retrieves the value at the head of this SQLInputImpl object as an Object in the Java programming language.
    SQLInputImpl.readRef()
    Retrieves the value at the head of this SQLInputImpl object as a Ref object in the Java programming language.
    SQLInputImpl.readRowId()
    Reads an SQL ROWID value from the stream and returns it as a RowId object in the Java programming language.
    short
    SQLInputImpl.readShort()
    Retrieves the next attribute in this SQLInputImpl object as a short in the Java programming language.
    SQLInputImpl.readSQLXML()
    Reads an SQL XML value from the stream and returns it as a SQLXML object in the Java programming language.
    SQLInputImpl.readString()
    Retrieves the next attribute in this SQLInputImpl object as a String in the Java programming language.
    SQLInputImpl.readTime()
    Retrieves the next attribute in this SQLInputImpl object as a java.sql.Time object.
    SQLInputImpl.readTimestamp()
    Retrieves the next attribute in this SQLInputImpl object as a java.sql.Timestamp object.
    SQLInputImpl.readURL()
    Reads an SQL DATALINK value from the stream and returns it as an URL object in the Java programming language.
    SerialClob.setAsciiStream(long pos)
    Retrieves a stream to be used to write Ascii characters to the CLOB value that this SerialClob object represents, starting at position pos.
    SerialBlob.setBinaryStream(long pos)
    Retrieves a stream that can be used to write to the BLOB value that this Blob object represents.
    int
    SerialBlob.setBytes(long pos, byte[] bytes)
    Writes the given array of bytes to the BLOB value that this Blob object represents, starting at position pos, and returns the number of bytes written.
    int
    SerialBlob.setBytes(long pos, byte[] bytes, int offset, int length)
    Writes all or part of the given byte array to the BLOB value that this Blob object represents and returns the number of bytes written.
    SerialClob.setCharacterStream(long pos)
    Retrieves a stream to be used to write a stream of Unicode characters to the CLOB value that this SerialClob object represents, at position pos.
    boolean
    SQLInputImpl.wasNull()
    Ascertains whether the last value read from this SQLInputImpl object was null.
    void
    SQLOutputImpl.writeArray(Array x)
    Writes an Array object in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeAsciiStream(InputStream x)
    Writes a stream of ASCII characters to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeBigDecimal(BigDecimal x)
    Writes a java.math.BigDecimal object in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeBinaryStream(InputStream x)
    Writes a stream of uninterpreted bytes to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeBlob(Blob x)
    Writes a Blob object in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeBoolean(boolean x)
    Writes a boolean in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeByte(byte x)
    Writes a byte in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeBytes(byte[] x)
    Writes an array of bytes in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeCharacterStream(Reader x)
    Writes a stream of Unicode characters to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeClob(Clob x)
    Writes a Clob object in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeDate(Date x)
    Writes a java.sql.Date object in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeDouble(double x)
    Writes a double in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeFloat(float x)
    Writes a float in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeInt(int x)
    Writes an int in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeLong(long x)
    Writes a long in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeNClob(NClob x)
    Writes an SQL NCLOB value to the stream.
    void
    SQLOutputImpl.writeNString(String x)
    Writes the next attribute to the stream as a String in the Java programming language.
    void
    SQLOutputImpl.writeObject(SQLData x)
    Writes to the stream the data contained in the given SQLData object.
    void
    SQLOutputImpl.writeRef(Ref x)
    Writes a Ref object in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeRowId(RowId x)
    Writes an SQL ROWID value to the stream.
    void
    SQLOutputImpl.writeShort(short x)
    Writes a short in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeSQLXML(SQLXML x)
    Writes an SQL XML value to the stream.
    void
    SQLOutputImpl.writeString(String x)
    Writes a String in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeStruct(Struct x)
    Writes a Struct object in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeTime(Time x)
    Writes a java.sql.Time object in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeTimestamp(Timestamp x)
    Writes a java.sql.Timestamp object in the Java programming language to this SQLOutputImpl object.
    void
    SQLOutputImpl.writeURL(URL url)
    Writes an java.sql.Type.DATALINK object in the Java programming language to this SQLOutputImpl object.
    Constructors in javax.sql.rowset.serial that throw SQLException
    Modifier
    Constructor
    Description
     
    Constructs a new SerialArray object from the given Array object.
     
    SerialArray(Array array, Map<String,Class<?>> map)
    Constructs a new SerialArray object from the given Array object, using the given type map for the custom mapping of each element when the elements are SQL UDTs.
     
    SerialBlob(byte[] b)
    Constructs a SerialBlob object that is a serialized version of the given byte array.
     
    Constructs a SerialBlob object that is a serialized version of the given Blob object.
     
    SerialClob(char[] ch)
    Constructs a SerialClob object that is a serialized version of the given char array.
     
    Constructs a SerialClob object that is a serialized version of the given Clob object.
     
    Constructs a SerialRef object from the given Ref object.
     
    SQLInputImpl(Object[] attributes, Map<String,Class<?>> map)
    Creates an SQLInputImpl object initialized with the given array of attributes and the given type map.
     
    SQLOutputImpl(Vector<?> attributes, Map<String,?> map)
    Creates a new SQLOutputImpl object initialized with the given vector of attributes and type map.
  • Uses of SQLException in javax.sql.rowset.spi

    Modifier and Type
    Class
    Description
    class 
    Indicates an error with SyncFactory mechanism.
    class 
    Indicates an error with the SyncProvider mechanism.
    Methods in javax.sql.rowset.spi that throw SQLException
    Modifier and Type
    Method
    Description
    void
    TransactionalWriter.commit()
    Makes permanent all changes that have been performed by the acceptChanges method since the last call to either the commit or rollback methods.
    SyncResolver.getConflictValue(int index)
    Retrieves the value in the designated column in the current row of this SyncResolver object, which is the value in the data source that caused a conflict.
    SyncResolver.getConflictValue(String columnName)
    Retrieves the value in the designated column in the current row of this SyncResolver object, which is the value in the data source that caused a conflict.
    boolean
    SyncResolver.nextConflict()
    Moves the cursor down from its current position to the next row that contains a conflict value.
    boolean
    SyncResolver.previousConflict()
    Moves the cursor up from its current position to the previous conflict row in this SyncResolver object.
    void
    XmlReader.readXML(WebRowSet caller, Reader reader)
    Reads and parses the given WebRowSet object from the given input stream in XML format.
    void
    TransactionalWriter.rollback()
    Undoes all changes made in the current transaction.
    void
    TransactionalWriter.rollback(Savepoint s)
    Undoes all changes made in the current transaction made prior to the given Savepoint object.
    void
    SyncResolver.setResolvedValue(int index, Object obj)
    Sets obj as the value in column index in the current row of the RowSet object that is being synchronized.
    void
    SyncResolver.setResolvedValue(String columnName, Object obj)
    Sets obj as the value in column columnName in the current row of the RowSet object that is being synchronized.
    void
    XmlWriter.writeXML(WebRowSet caller, Writer writer)
    Writes the given WebRowSet object to the specified java.io.Writer output stream as an XML document.