Uses of Class
java.sql.SQLException
| Package | Description |
|---|---|
| java.sql |
Provides the API for accessing and processing data stored in a
data source (usually a relational database) using the
Java™ programming language.
|
| javax.sql |
Provides the API for server side data source access and processing from
the Java™ programming language.
|
| javax.sql.rowset |
Standard interfaces and base classes for JDBC
RowSet
implementations. |
| javax.sql.rowset.serial |
Provides utility classes to allow serializable mappings between SQL types
and data types in the Java programming language.
|
| javax.sql.rowset.spi |
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 classBatchUpdateExceptionThe subclass ofSQLExceptionthrown when an error occurs during a batch update operation.classDataTruncationAn exception thrown as aDataTruncationexception (on writes) or reported as aDataTruncationwarning (on reads) when a data values is unexpectedly truncated for reasons other than its having exceededMaxFieldSize.classSQLClientInfoExceptionThe subclass ofSQLExceptionis thrown when one or more client info properties could not be set on aConnection.classSQLDataExceptionThe subclass ofSQLExceptionthrown when the SQLState class value is '22', or under vendor-specified conditions.classSQLFeatureNotSupportedExceptionThe subclass ofSQLExceptionthrown when the SQLState class value is '0A' ( the value is 'zero' A).classSQLIntegrityConstraintViolationExceptionThe subclass ofSQLExceptionthrown when the SQLState class value is '23', or under vendor-specified conditions.classSQLInvalidAuthorizationSpecExceptionThe subclass ofSQLExceptionthrown when the SQLState class value is '28', or under vendor-specified conditions.classSQLNonTransientConnectionExceptionThe subclass ofSQLExceptionthrown for the SQLState class value '08', or under vendor-specified conditions.classSQLNonTransientExceptionThe subclass ofSQLExceptionthrown when an instance where a retry of the same operation would fail unless the cause of theSQLExceptionis corrected.classSQLRecoverableExceptionThe subclass ofSQLExceptionthrown 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.classSQLSyntaxErrorExceptionThe subclass ofSQLExceptionthrown when the SQLState class value is '42', or under vendor-specified conditions.classSQLTimeoutExceptionThe subclass ofSQLExceptionthrown when the timeout specified byStatement.setQueryTimeout,DriverManager.setLoginTimeout,DataSource.setLoginTimeout,XADataSource.setLoginTimeouthas expired.classSQLTransactionRollbackExceptionThe subclass ofSQLExceptionthrown when the SQLState class value is '40', or under vendor-specified conditions.classSQLTransientConnectionExceptionThe subclass ofSQLExceptionfor the SQLState class value '08', or under vendor-specified conditions.classSQLTransientExceptionThe subclass ofSQLExceptionis 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.classSQLWarningAn exception that provides information on database access warnings.Methods in java.sql that return SQLException Modifier and Type Method Description SQLExceptionSQLException. getNextException()Retrieves the exception chained to thisSQLExceptionobject by setNextException(SQLException ex).Methods in java.sql with parameters of type SQLException Modifier and Type Method Description voidSQLException. setNextException(SQLException ex)Adds anSQLExceptionobject to the end of the chain.Methods in java.sql that throw SQLException Modifier and Type Method Description voidConnection. abort(Executor executor)Terminates an open connection.booleanResultSet. absolute(int row)Moves the cursor to the given row number in thisResultSetobject.booleanDriver. acceptsURL(String url)Retrieves whether the driver thinks that it can open a connection to the given URL.voidPreparedStatement. addBatch()Adds a set of parameters to thisPreparedStatementobject's batch of commands.voidStatement. addBatch(String sql)Adds the given SQL command to the current list of commands for thisStatementobject.voidResultSet. afterLast()Moves the cursor to the end of thisResultSetobject, just after the last row.booleanDatabaseMetaData. allProceduresAreCallable()Retrieves whether the current user can call all the procedures returned by the methodgetProcedures.booleanDatabaseMetaData. allTablesAreSelectable()Retrieves whether the current user can use all the tables returned by the methodgetTablesin aSELECTstatement.booleanDatabaseMetaData. autoCommitFailureClosesAllResultSets()Retrieves whether aSQLExceptionwhile autoCommit istrueindicates that all open ResultSets are closed, even ones that are holdable.voidResultSet. beforeFirst()Moves the cursor to the front of thisResultSetobject, just before the first row.default voidConnection. beginRequest()Hints to the driver that a request, an independent unit of work, is beginning on this connection.ConnectionConnectionBuilder. build()Returns an instance of the object defined by this builder.ShardingKeyShardingKeyBuilder. build()Returns an instance of the object defined by this builder.voidStatement. cancel()Cancels thisStatementobject if both the DBMS and driver support aborting an SQL statement.voidResultSet. cancelRowUpdates()Cancels the updates made to the current row in thisResultSetobject.voidStatement. clearBatch()Empties thisStatementobject's current list of SQL commands.voidPreparedStatement. clearParameters()Clears the current parameter values immediately.voidConnection. clearWarnings()Clears all warnings reported for thisConnectionobject.voidResultSet. clearWarnings()Clears all warnings reported on thisResultSetobject.voidStatement. clearWarnings()Clears all the warnings reported on thisStatementobject.voidConnection. close()Releases thisConnectionobject's database and JDBC resources immediately instead of waiting for them to be automatically released.voidResultSet. close()Releases thisResultSetobject's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.voidStatement. close()Releases thisStatementobject's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.voidStatement. closeOnCompletion()Specifies that thisStatementwill be closed when all its dependent result sets are closed.voidConnection. commit()Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by thisConnectionobject.ConnectionDriver. connect(String url, Properties info)Attempts to make a database connection to the given URL.ArrayConnection. createArrayOf(String typeName, Object[] elements)Factory method for creating Array objects.BlobConnection. createBlob()Constructs an object that implements theBlobinterface.ClobConnection. createClob()Constructs an object that implements theClobinterface.NClobConnection. createNClob()Constructs an object that implements theNClobinterface.SQLXMLConnection. createSQLXML()Constructs an object that implements theSQLXMLinterface.StatementConnection. createStatement()Creates aStatementobject for sending SQL statements to the database.StatementConnection. createStatement(int resultSetType, int resultSetConcurrency)Creates aStatementobject that will generateResultSetobjects with the given type and concurrency.StatementConnection. createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)Creates aStatementobject that will generateResultSetobjects with the given type, concurrency, and holdability.StructConnection. createStruct(String typeName, Object[] attributes)Factory method for creating Struct objects.booleanDatabaseMetaData. dataDefinitionCausesTransactionCommit()Retrieves whether a data definition statement within a transaction forces the transaction to commit.booleanDatabaseMetaData. dataDefinitionIgnoredInTransactions()Retrieves whether this database ignores a data definition statement within a transaction.voidResultSet. deleteRow()Deletes the current row from thisResultSetobject and from the underlying database.booleanDatabaseMetaData. deletesAreDetected(int type)Retrieves whether or not a visible row delete can be detected by calling the methodResultSet.rowDeleted.static voidDriverManager. deregisterDriver(Driver driver)Removes the specified driver from theDriverManager's list of registered drivers.booleanDatabaseMetaData. doesMaxRowSizeIncludeBlobs()Retrieves whether the return value for the methodgetMaxRowSizeincludes the SQL data typesLONGVARCHARandLONGVARBINARY.default voidConnection. endRequest()Hints to the driver that a request, an independent unit of work, has completed.default StringStatement. enquoteIdentifier(String identifier, boolean alwaysQuote)Returns a SQL identifier.default StringStatement. enquoteLiteral(String val)Returns aStringenclosed in single quotes.default StringStatement. enquoteNCharLiteral(String val)Returns aStringrepresenting a National Character Set Literal enclosed in single quotes and prefixed with a upper case letter N.booleanPreparedStatement. execute()Executes the SQL statement in thisPreparedStatementobject, which may be any kind of SQL statement.booleanStatement. execute(String sql)Executes the given SQL statement, which may return multiple results.booleanStatement. 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.booleanStatement. 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.booleanStatement. 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 longPreparedStatement. executeLargeUpdate()Executes the SQL statement in thisPreparedStatementobject, which must be an SQL Data Manipulation Language (DML) statement, such asINSERT,UPDATEorDELETE; or an SQL statement that returns nothing, such as a DDL statement.default longStatement. executeLargeUpdate(String sql)Executes the given SQL statement, which may be anINSERT,UPDATE, orDELETEstatement or an SQL statement that returns nothing, such as an SQL DDL statement.default longStatement. 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 thisStatementobject should be made available for retrieval.default longStatement. 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 longStatement. 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.ResultSetPreparedStatement. executeQuery()Executes the SQL query in thisPreparedStatementobject and returns theResultSetobject generated by the query.ResultSetStatement. executeQuery(String sql)Executes the given SQL statement, which returns a singleResultSetobject.intPreparedStatement. executeUpdate()Executes the SQL statement in thisPreparedStatementobject, which must be an SQL Data Manipulation Language (DML) statement, such asINSERT,UPDATEorDELETE; or an SQL statement that returns nothing, such as a DDL statement.intStatement. executeUpdate(String sql)Executes the given SQL statement, which may be anINSERT,UPDATE, orDELETEstatement or an SQL statement that returns nothing, such as an SQL DDL statement.intStatement. 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 thisStatementobject should be made available for retrieval.intStatement. 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.intStatement. 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.intResultSet. findColumn(String columnLabel)Maps the givenResultSetcolumn label to itsResultSetcolumn index.booleanResultSet. first()Moves the cursor to the first row in thisResultSetobject.voidArray. free()This method frees theArrayobject and releases the resources that it holds.voidBlob. free()This method frees theBlobobject and releases the resources that it holds.voidClob. free()This method releases the resources that theClobobject holds.voidSQLXML. free()This method closes this object and releases the resources that it held.booleanDatabaseMetaData. 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.ObjectArray. getArray()Retrieves the contents of the SQLARRAYvalue designated by thisArrayobject in the form of an array in the Java programming language.ObjectArray. getArray(long index, int count)Retrieves a slice of the SQLARRAYvalue designated by thisArrayobject, beginning with the specifiedindexand containing up tocountsuccessive elements of the SQL array.ObjectArray. getArray(long index, int count, Map<String,Class<?>> map)Retrieves a slice of the SQLARRAYvalue designated by thisArrayobject, beginning with the specifiedindexand containing up tocountsuccessive elements of the SQL array.ObjectArray. getArray(Map<String,Class<?>> map)Retrieves the contents of the SQLARRAYvalue designated by thisArrayobject.ArrayCallableStatement. getArray(int parameterIndex)Retrieves the value of the designated JDBCARRAYparameter as anArrayobject in the Java programming language.ArrayCallableStatement. getArray(String parameterName)Retrieves the value of a JDBCARRAYparameter as anArrayobject in the Java programming language.ArrayResultSet. getArray(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as anArrayobject in the Java programming language.ArrayResultSet. getArray(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as anArrayobject in the Java programming language.InputStreamClob. getAsciiStream()Retrieves theCLOBvalue designated by thisClobobject as an ascii stream.InputStreamResultSet. getAsciiStream(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as a stream of ASCII characters.InputStreamResultSet. getAsciiStream(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as a stream of ASCII characters.ResultSetDatabaseMetaData. 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.Object[]Struct. getAttributes()Produces the ordered values of the attributes of the SQL structured type that thisStructobject represents.Object[]Struct. getAttributes(Map<String,Class<?>> map)Produces the ordered values of the attributes of the SQL structured type that thisStructobject represents.booleanConnection. getAutoCommit()Retrieves the current auto-commit mode for thisConnectionobject.intArray. getBaseType()Retrieves the JDBC type of the elements in the array designated by thisArrayobject.StringArray. getBaseTypeName()Retrieves the SQL type name of the elements in the array designated by thisArrayobject.StringRef. getBaseTypeName()Retrieves the fully-qualified SQL name of the SQL structured type that thisRefobject references.ResultSetDatabaseMetaData. 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.BigDecimalCallableStatement. getBigDecimal(int parameterIndex)Retrieves the value of the designated JDBCNUMERICparameter as ajava.math.BigDecimalobject with as many digits to the right of the decimal point as the value contains.BigDecimalCallableStatement. getBigDecimal(int parameterIndex, int scale)Deprecated.usegetBigDecimal(int parameterIndex)orgetBigDecimal(String parameterName)BigDecimalCallableStatement. getBigDecimal(String parameterName)Retrieves the value of a JDBCNUMERICparameter as ajava.math.BigDecimalobject with as many digits to the right of the decimal point as the value contains.BigDecimalResultSet. getBigDecimal(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.math.BigDecimalwith full precision.BigDecimalResultSet. getBigDecimal(int columnIndex, int scale)Deprecated.UsegetBigDecimal(int columnIndex)orgetBigDecimal(String columnLabel)BigDecimalResultSet. getBigDecimal(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.math.BigDecimalwith full precision.BigDecimalResultSet. getBigDecimal(String columnLabel, int scale)Deprecated.UsegetBigDecimal(int columnIndex)orgetBigDecimal(String columnLabel)InputStreamBlob. getBinaryStream()Retrieves theBLOBvalue designated by thisBlobinstance as a stream.InputStreamBlob. getBinaryStream(long pos, long length)Returns anInputStreamobject that contains a partialBlobvalue, starting with the byte specified by pos, which is length bytes in length.InputStreamResultSet. getBinaryStream(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as a stream of uninterpreted bytes.InputStreamResultSet. getBinaryStream(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as a stream of uninterpretedbytes.InputStreamSQLXML. getBinaryStream()Retrieves the XML value designated by this SQLXML instance as a stream.BlobCallableStatement. getBlob(int parameterIndex)Retrieves the value of the designated JDBCBLOBparameter as aBlobobject in the Java programming language.BlobCallableStatement. getBlob(String parameterName)Retrieves the value of a JDBCBLOBparameter as aBlobobject in the Java programming language.BlobResultSet. getBlob(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as aBlobobject in the Java programming language.BlobResultSet. getBlob(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as aBlobobject in the Java programming language.booleanCallableStatement. getBoolean(int parameterIndex)Retrieves the value of the designated JDBCBITorBOOLEANparameter as abooleanin the Java programming language.booleanCallableStatement. getBoolean(String parameterName)Retrieves the value of a JDBCBITorBOOLEANparameter as abooleanin the Java programming language.booleanResultSet. getBoolean(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as abooleanin the Java programming language.booleanResultSet. getBoolean(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as abooleanin the Java programming language.byteCallableStatement. getByte(int parameterIndex)Retrieves the value of the designated JDBCTINYINTparameter as abytein the Java programming language.byteCallableStatement. getByte(String parameterName)Retrieves the value of a JDBCTINYINTparameter as abytein the Java programming language.byteResultSet. getByte(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as abytein the Java programming language.byteResultSet. getByte(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as abytein the Java programming language.byte[]Blob. getBytes(long pos, int length)Retrieves all or part of theBLOBvalue that thisBlobobject represents, as an array of bytes.byte[]CallableStatement. getBytes(int parameterIndex)Retrieves the value of the designated JDBCBINARYorVARBINARYparameter as an array ofbytevalues in the Java programming language.byte[]CallableStatement. getBytes(String parameterName)Retrieves the value of a JDBCBINARYorVARBINARYparameter as an array ofbytevalues in the Java programming language.byte[]ResultSet. getBytes(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as abytearray in the Java programming language.byte[]ResultSet. getBytes(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as abytearray in the Java programming language.StringConnection. getCatalog()Retrieves thisConnectionobject's current catalog name.StringResultSetMetaData. getCatalogName(int column)Gets the designated column's table's catalog name.ResultSetDatabaseMetaData. getCatalogs()Retrieves the catalog names available in this database.StringDatabaseMetaData. getCatalogSeparator()Retrieves theStringthat this database uses as the separator between a catalog and table name.StringDatabaseMetaData. getCatalogTerm()Retrieves the database vendor's preferred term for "catalog".ReaderCallableStatement. getCharacterStream(int parameterIndex)Retrieves the value of the designated parameter as ajava.io.Readerobject in the Java programming language.ReaderCallableStatement. getCharacterStream(String parameterName)Retrieves the value of the designated parameter as ajava.io.Readerobject in the Java programming language.ReaderClob. getCharacterStream()Retrieves theCLOBvalue designated by thisClobobject as ajava.io.Readerobject (or as a stream of characters).ReaderClob. getCharacterStream(long pos, long length)Returns aReaderobject that contains a partialClobvalue, starting with the character specified by pos, which is length characters in length.ReaderResultSet. getCharacterStream(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.io.Readerobject.ReaderResultSet. getCharacterStream(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.io.Readerobject.ReaderSQLXML. getCharacterStream()Retrieves the XML value designated by this SQLXML instance as a java.io.Reader object.PropertiesConnection. getClientInfo()Returns a list containing the name and current value of each client info property supported by the driver.StringConnection. getClientInfo(String name)Returns the value of the client info property specified by name.ResultSetDatabaseMetaData. getClientInfoProperties()Retrieves a list of the client info properties that the driver supports.ClobCallableStatement. getClob(int parameterIndex)Retrieves the value of the designated JDBCCLOBparameter as ajava.sql.Clobobject in the Java programming language.ClobCallableStatement. getClob(String parameterName)Retrieves the value of a JDBCCLOBparameter as ajava.sql.Clobobject in the Java programming language.ClobResultSet. getClob(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as aClobobject in the Java programming language.ClobResultSet. getClob(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as aClobobject in the Java programming language.StringResultSetMetaData. getColumnClassName(int column)Returns the fully-qualified name of the Java class whose instances are manufactured if the methodResultSet.getObjectis called to retrieve a value from the column.intResultSetMetaData. getColumnCount()Returns the number of columns in thisResultSetobject.intResultSetMetaData. getColumnDisplaySize(int column)Indicates the designated column's normal maximum width in characters.StringResultSetMetaData. getColumnLabel(int column)Gets the designated column's suggested title for use in printouts and displays.StringResultSetMetaData. getColumnName(int column)Get the designated column's name.ResultSetDatabaseMetaData. getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)Retrieves a description of the access rights for a table's columns.ResultSetDatabaseMetaData. getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)Retrieves a description of table columns available in the specified catalog.intResultSetMetaData. getColumnType(int column)Retrieves the designated column's SQL type.StringResultSetMetaData. getColumnTypeName(int column)Retrieves the designated column's database-specific type name.intResultSet. getConcurrency()Retrieves the concurrency mode of thisResultSetobject.ConnectionDatabaseMetaData. getConnection()Retrieves the connection that produced this metadata object.static ConnectionDriverManager. getConnection(String url)Attempts to establish a connection to the given database URL.static ConnectionDriverManager. getConnection(String url, String user, String password)Attempts to establish a connection to the given database URL.static ConnectionDriverManager. getConnection(String url, Properties info)Attempts to establish a connection to the given database URL.ConnectionStatement. getConnection()Retrieves theConnectionobject that produced thisStatementobject.ResultSetDatabaseMetaData. 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).StringResultSet. getCursorName()Retrieves the name of the SQL cursor used by thisResultSetobject.intDatabaseMetaData. getDatabaseMajorVersion()Retrieves the major version number of the underlying database.intDatabaseMetaData. getDatabaseMinorVersion()Retrieves the minor version number of the underlying database.StringDatabaseMetaData. getDatabaseProductName()Retrieves the name of this database product.StringDatabaseMetaData. getDatabaseProductVersion()Retrieves the version number of this database product.DateCallableStatement. getDate(int parameterIndex)Retrieves the value of the designated JDBCDATEparameter as ajava.sql.Dateobject.DateCallableStatement. getDate(int parameterIndex, Calendar cal)Retrieves the value of the designated JDBCDATEparameter as ajava.sql.Dateobject, using the givenCalendarobject to construct the date.DateCallableStatement. getDate(String parameterName)Retrieves the value of a JDBCDATEparameter as ajava.sql.Dateobject.DateCallableStatement. getDate(String parameterName, Calendar cal)Retrieves the value of a JDBCDATEparameter as ajava.sql.Dateobject, using the givenCalendarobject to construct the date.DateResultSet. getDate(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.Dateobject in the Java programming language.DateResultSet. getDate(int columnIndex, Calendar cal)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.Dateobject in the Java programming language.DateResultSet. getDate(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.Dateobject in the Java programming language.DateResultSet. getDate(String columnLabel, Calendar cal)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.Dateobject in the Java programming language.intDatabaseMetaData. getDefaultTransactionIsolation()Retrieves this database's default transaction isolation level.doubleCallableStatement. getDouble(int parameterIndex)Retrieves the value of the designated JDBCDOUBLEparameter as adoublein the Java programming language.doubleCallableStatement. getDouble(String parameterName)Retrieves the value of a JDBCDOUBLEparameter as adoublein the Java programming language.doubleResultSet. getDouble(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as adoublein the Java programming language.doubleResultSet. getDouble(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as adoublein the Java programming language.static DriverDriverManager. getDriver(String url)Attempts to locate a driver that understands the given URL.StringDatabaseMetaData. getDriverName()Retrieves the name of this JDBC driver.StringDatabaseMetaData. getDriverVersion()Retrieves the version number of this JDBC driver as aString.ResultSetDatabaseMetaData. 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).StringDatabaseMetaData. getExtraNameCharacters()Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).intResultSet. getFetchDirection()Retrieves the fetch direction for thisResultSetobject.intStatement. getFetchDirection()Retrieves the direction for fetching rows from database tables that is the default for result sets generated from thisStatementobject.intResultSet. getFetchSize()Retrieves the fetch size for thisResultSetobject.intStatement. getFetchSize()Retrieves the number of result set rows that is the default fetch size forResultSetobjects generated from thisStatementobject.floatCallableStatement. getFloat(int parameterIndex)Retrieves the value of the designated JDBCFLOATparameter as afloatin the Java programming language.floatCallableStatement. getFloat(String parameterName)Retrieves the value of a JDBCFLOATparameter as afloatin the Java programming language.floatResultSet. getFloat(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as afloatin the Java programming language.floatResultSet. getFloat(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as afloatin the Java programming language.ResultSetDatabaseMetaData. 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.ResultSetDatabaseMetaData. getFunctions(String catalog, String schemaPattern, String functionNamePattern)Retrieves a description of the system and user functions available in the given catalog.ResultSetStatement. getGeneratedKeys()Retrieves any auto-generated keys created as a result of executing thisStatementobject.intConnection. getHoldability()Retrieves the current holdability ofResultSetobjects created using thisConnectionobject.intResultSet. getHoldability()Retrieves the holdability of thisResultSetobjectStringDatabaseMetaData. getIdentifierQuoteString()Retrieves the string used to quote SQL identifiers.ResultSetDatabaseMetaData. 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).ResultSetDatabaseMetaData. getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)Retrieves a description of the given table's indices and statistics.intCallableStatement. getInt(int parameterIndex)Retrieves the value of the designated JDBCINTEGERparameter as anintin the Java programming language.intCallableStatement. getInt(String parameterName)Retrieves the value of a JDBCINTEGERparameter as anintin the Java programming language.intResultSet. getInt(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as anintin the Java programming language.intResultSet. getInt(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as anintin the Java programming language.intDatabaseMetaData. getJDBCMajorVersion()Retrieves the major JDBC version number for this driver.intDatabaseMetaData. getJDBCMinorVersion()Retrieves the minor JDBC version number for this driver.default longStatement. getLargeMaxRows()Retrieves the maximum number of rows that aResultSetobject produced by thisStatementobject can contain.default longStatement. getLargeUpdateCount()Retrieves the current result as an update count; if the result is aResultSetobject or there are no more results, -1 is returned.longCallableStatement. getLong(int parameterIndex)Retrieves the value of the designated JDBCBIGINTparameter as alongin the Java programming language.longCallableStatement. getLong(String parameterName)Retrieves the value of a JDBCBIGINTparameter as alongin the Java programming language.longResultSet. getLong(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as alongin the Java programming language.longResultSet. getLong(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as alongin the Java programming language.intDatabaseMetaData. getMaxBinaryLiteralLength()Retrieves the maximum number of hex characters this database allows in an inline binary literal.intDatabaseMetaData. getMaxCatalogNameLength()Retrieves the maximum number of characters that this database allows in a catalog name.intDatabaseMetaData. getMaxCharLiteralLength()Retrieves the maximum number of characters this database allows for a character literal.intDatabaseMetaData. getMaxColumnNameLength()Retrieves the maximum number of characters this database allows for a column name.intDatabaseMetaData. getMaxColumnsInGroupBy()Retrieves the maximum number of columns this database allows in aGROUP BYclause.intDatabaseMetaData. getMaxColumnsInIndex()Retrieves the maximum number of columns this database allows in an index.intDatabaseMetaData. getMaxColumnsInOrderBy()Retrieves the maximum number of columns this database allows in anORDER BYclause.intDatabaseMetaData. getMaxColumnsInSelect()Retrieves the maximum number of columns this database allows in aSELECTlist.intDatabaseMetaData. getMaxColumnsInTable()Retrieves the maximum number of columns this database allows in a table.intDatabaseMetaData. getMaxConnections()Retrieves the maximum number of concurrent connections to this database that are possible.intDatabaseMetaData. getMaxCursorNameLength()Retrieves the maximum number of characters that this database allows in a cursor name.intStatement. getMaxFieldSize()Retrieves the maximum number of bytes that can be returned for character and binary column values in aResultSetobject produced by thisStatementobject.intDatabaseMetaData. getMaxIndexLength()Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.default longDatabaseMetaData. getMaxLogicalLobSize()Retrieves the maximum number of bytes this database allows for the logical size for aLOB.intDatabaseMetaData. getMaxProcedureNameLength()Retrieves the maximum number of characters that this database allows in a procedure name.intStatement. getMaxRows()Retrieves the maximum number of rows that aResultSetobject produced by thisStatementobject can contain.intDatabaseMetaData. getMaxRowSize()Retrieves the maximum number of bytes this database allows in a single row.intDatabaseMetaData. getMaxSchemaNameLength()Retrieves the maximum number of characters that this database allows in a schema name.intDatabaseMetaData. getMaxStatementLength()Retrieves the maximum number of characters this database allows in an SQL statement.intDatabaseMetaData. getMaxStatements()Retrieves the maximum number of active statements to this database that can be open at the same time.intDatabaseMetaData. getMaxTableNameLength()Retrieves the maximum number of characters this database allows in a table name.intDatabaseMetaData. getMaxTablesInSelect()Retrieves the maximum number of tables this database allows in aSELECTstatement.intDatabaseMetaData. getMaxUserNameLength()Retrieves the maximum number of characters this database allows in a user name.DatabaseMetaDataConnection. getMetaData()Retrieves aDatabaseMetaDataobject that contains metadata about the database to which thisConnectionobject represents a connection.ResultSetMetaDataPreparedStatement. getMetaData()Retrieves aResultSetMetaDataobject that contains information about the columns of theResultSetobject that will be returned when thisPreparedStatementobject is executed.ResultSetMetaDataResultSet. getMetaData()Retrieves the number, types and properties of thisResultSetobject's columns.booleanStatement. getMoreResults()Moves to thisStatementobject's next result, returnstrueif it is aResultSetobject, and implicitly closes any currentResultSetobject(s) obtained with the methodgetResultSet.booleanStatement. getMoreResults(int current)Moves to thisStatementobject's next result, deals with any currentResultSetobject(s) according to the instructions specified by the given flag, and returnstrueif the next result is aResultSetobject.ReaderCallableStatement. getNCharacterStream(int parameterIndex)Retrieves the value of the designated parameter as ajava.io.Readerobject in the Java programming language.ReaderCallableStatement. getNCharacterStream(String parameterName)Retrieves the value of the designated parameter as ajava.io.Readerobject in the Java programming language.ReaderResultSet. getNCharacterStream(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.io.Readerobject.ReaderResultSet. getNCharacterStream(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.io.Readerobject.NClobCallableStatement. getNClob(int parameterIndex)Retrieves the value of the designated JDBCNCLOBparameter as ajava.sql.NClobobject in the Java programming language.NClobCallableStatement. getNClob(String parameterName)Retrieves the value of a JDBCNCLOBparameter as ajava.sql.NClobobject in the Java programming language.NClobResultSet. getNClob(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as aNClobobject in the Java programming language.NClobResultSet. getNClob(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as aNClobobject in the Java programming language.intConnection. getNetworkTimeout()Retrieves the number of milliseconds the driver will wait for a database request to complete.StringCallableStatement. getNString(int parameterIndex)Retrieves the value of the designatedNCHAR,NVARCHARorLONGNVARCHARparameter as aStringin the Java programming language.StringCallableStatement. getNString(String parameterName)Retrieves the value of the designatedNCHAR,NVARCHARorLONGNVARCHARparameter as aStringin the Java programming language.StringResultSet. getNString(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as aStringin the Java programming language.StringResultSet. getNString(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as aStringin the Java programming language.StringDatabaseMetaData. getNumericFunctions()Retrieves a comma-separated list of math functions available with this database.ObjectCallableStatement. getObject(int parameterIndex)Retrieves the value of the designated parameter as anObjectin the Java programming language.<T> TCallableStatement. getObject(int parameterIndex, Class<T> type)Returns an object representing the value of OUT parameterparameterIndexand will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.ObjectCallableStatement. getObject(int parameterIndex, Map<String,Class<?>> map)Returns an object representing the value of OUT parameterparameterIndexand usesmapfor the custom mapping of the parameter value.ObjectCallableStatement. getObject(String parameterName)Retrieves the value of a parameter as anObjectin the Java programming language.<T> TCallableStatement. getObject(String parameterName, Class<T> type)Returns an object representing the value of OUT parameterparameterNameand will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.ObjectCallableStatement. getObject(String parameterName, Map<String,Class<?>> map)Returns an object representing the value of OUT parameterparameterNameand usesmapfor the custom mapping of the parameter value.ObjectRef. getObject()Retrieves the SQL structured type instance referenced by thisRefobject.ObjectRef. getObject(Map<String,Class<?>> map)Retrieves the referenced object and maps it to a Java type using the given type map.ObjectResultSet. getObject(int columnIndex)Gets the value of the designated column in the current row of thisResultSetobject as anObjectin the Java programming language.<T> TResultSet. getObject(int columnIndex, Class<T> type)Retrieves the value of the designated column in the current row of thisResultSetobject and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.ObjectResultSet. getObject(int columnIndex, Map<String,Class<?>> map)Retrieves the value of the designated column in the current row of thisResultSetobject as anObjectin the Java programming language.ObjectResultSet. getObject(String columnLabel)Gets the value of the designated column in the current row of thisResultSetobject as anObjectin the Java programming language.<T> TResultSet. getObject(String columnLabel, Class<T> type)Retrieves the value of the designated column in the current row of thisResultSetobject and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.ObjectResultSet. getObject(String columnLabel, Map<String,Class<?>> map)Retrieves the value of the designated column in the current row of thisResultSetobject as anObjectin the Java programming language.StringParameterMetaData. getParameterClassName(int param)Retrieves the fully-qualified name of the Java class whose instances should be passed to the methodPreparedStatement.setObject.intParameterMetaData. getParameterCount()Retrieves the number of parameters in thePreparedStatementobject for which thisParameterMetaDataobject contains information.ParameterMetaDataPreparedStatement. getParameterMetaData()Retrieves the number, types and properties of thisPreparedStatementobject's parameters.intParameterMetaData. getParameterMode(int param)Retrieves the designated parameter's mode.intParameterMetaData. getParameterType(int param)Retrieves the designated parameter's SQL type.StringParameterMetaData. getParameterTypeName(int param)Retrieves the designated parameter's database-specific type name.intParameterMetaData. getPrecision(int param)Retrieves the designated parameter's specified column size.intResultSetMetaData. getPrecision(int column)Get the designated column's specified column size.ResultSetDatabaseMetaData. getPrimaryKeys(String catalog, String schema, String table)Retrieves a description of the given table's primary key columns.ResultSetDatabaseMetaData. getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)Retrieves a description of the given catalog's stored procedure parameter and result columns.ResultSetDatabaseMetaData. getProcedures(String catalog, String schemaPattern, String procedureNamePattern)Retrieves a description of the stored procedures available in the given catalog.StringDatabaseMetaData. getProcedureTerm()Retrieves the database vendor's preferred term for "procedure".DriverPropertyInfo[]Driver. getPropertyInfo(String url, Properties info)Gets information about the possible properties for this driver.ResultSetDatabaseMetaData. 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.intStatement. getQueryTimeout()Retrieves the number of seconds the driver will wait for aStatementobject to execute.RefCallableStatement. getRef(int parameterIndex)Retrieves the value of the designated JDBCREF(<structured-type>)parameter as aRefobject in the Java programming language.RefCallableStatement. getRef(String parameterName)Retrieves the value of a JDBCREF(<structured-type>)parameter as aRefobject in the Java programming language.RefResultSet. getRef(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as aRefobject in the Java programming language.RefResultSet. getRef(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as aRefobject in the Java programming language.ResultSetArray. getResultSet()Retrieves a result set that contains the elements of the SQLARRAYvalue designated by thisArrayobject.ResultSetArray. getResultSet(long index, int count)Retrieves a result set holding the elements of the subarray that starts at indexindexand contains up tocountsuccessive elements.ResultSetArray. getResultSet(long index, int count, Map<String,Class<?>> map)Retrieves a result set holding the elements of the subarray that starts at indexindexand contains up tocountsuccessive elements.ResultSetArray. getResultSet(Map<String,Class<?>> map)Retrieves a result set that contains the elements of the SQLARRAYvalue designated by thisArrayobject.ResultSetStatement. getResultSet()Retrieves the current result as aResultSetobject.intStatement. getResultSetConcurrency()Retrieves the result set concurrency forResultSetobjects generated by thisStatementobject.intDatabaseMetaData. getResultSetHoldability()Retrieves this database's default holdability forResultSetobjects.intStatement. getResultSetHoldability()Retrieves the result set holdability forResultSetobjects generated by thisStatementobject.intStatement. getResultSetType()Retrieves the result set type forResultSetobjects generated by thisStatementobject.intResultSet. getRow()Retrieves the current row number.RowIdCallableStatement. getRowId(int parameterIndex)Retrieves the value of the designated JDBCROWIDparameter as ajava.sql.RowIdobject.RowIdCallableStatement. getRowId(String parameterName)Retrieves the value of the designated JDBCROWIDparameter as ajava.sql.RowIdobject.RowIdResultSet. getRowId(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.RowIdobject in the Java programming language.RowIdResultSet. getRowId(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.RowIdobject in the Java programming language.RowIdLifetimeDatabaseMetaData. getRowIdLifetime()Indicates whether this data source supports the SQLROWIDtype, and the lifetime for which aRowIdobject remains valid.intSavepoint. getSavepointId()Retrieves the generated ID for the savepoint that thisSavepointobject represents.StringSavepoint. getSavepointName()Retrieves the name of the savepoint that thisSavepointobject represents.intParameterMetaData. 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.intResultSetMetaData. 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.StringConnection. getSchema()Retrieves thisConnectionobject's current schema name.StringResultSetMetaData. getSchemaName(int column)Get the designated column's table's schema.ResultSetDatabaseMetaData. getSchemas()Retrieves the schema names available in this database.ResultSetDatabaseMetaData. getSchemas(String catalog, String schemaPattern)Retrieves the schema names available in this database.StringDatabaseMetaData. getSchemaTerm()Retrieves the database vendor's preferred term for "schema".StringDatabaseMetaData. getSearchStringEscape()Retrieves the string that can be used to escape wildcard characters.shortCallableStatement. getShort(int parameterIndex)Retrieves the value of the designated JDBCSMALLINTparameter as ashortin the Java programming language.shortCallableStatement. getShort(String parameterName)Retrieves the value of a JDBCSMALLINTparameter as ashortin the Java programming language.shortResultSet. getShort(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as ashortin the Java programming language.shortResultSet. getShort(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as ashortin the Java programming language.<T extends Source>
TSQLXML. getSource(Class<T> sourceClass)Returns a Source for reading the XML value designated by this SQLXML instance.StringDatabaseMetaData. getSQLKeywords()Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.intDatabaseMetaData. getSQLStateType()Indicates whether the SQLSTATE returned bySQLException.getSQLStateis X/Open (now known as Open Group) SQL CLI or SQL:2003.StringSQLData. getSQLTypeName()Returns the fully-qualified name of the SQL user-defined type that this object represents.StringStruct. getSQLTypeName()Retrieves the SQL type name of the SQL structured type that thisStructobject represents.SQLXMLCallableStatement. getSQLXML(int parameterIndex)Retrieves the value of the designatedSQL XMLparameter as ajava.sql.SQLXMLobject in the Java programming language.SQLXMLCallableStatement. getSQLXML(String parameterName)Retrieves the value of the designatedSQL XMLparameter as ajava.sql.SQLXMLobject in the Java programming language.SQLXMLResultSet. getSQLXML(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetas ajava.sql.SQLXMLobject in the Java programming language.SQLXMLResultSet. getSQLXML(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetas ajava.sql.SQLXMLobject in the Java programming language.StatementResultSet. getStatement()Retrieves theStatementobject that produced thisResultSetobject.StringCallableStatement. getString(int parameterIndex)Retrieves the value of the designated JDBCCHAR,VARCHAR, orLONGVARCHARparameter as aStringin the Java programming language.StringCallableStatement. getString(String parameterName)Retrieves the value of a JDBCCHAR,VARCHAR, orLONGVARCHARparameter as aStringin the Java programming language.StringResultSet. getString(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as aStringin the Java programming language.StringResultSet. getString(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as aStringin the Java programming language.StringSQLXML. getString()Returns a string representation of the XML value designated by this SQLXML instance.StringDatabaseMetaData. getStringFunctions()Retrieves a comma-separated list of string functions available with this database.StringClob. getSubString(long pos, int length)Retrieves a copy of the specified substring in theCLOBvalue designated by thisClobobject.ResultSetDatabaseMetaData. getSuperTables(String catalog, String schemaPattern, String tableNamePattern)Retrieves a description of the table hierarchies defined in a particular schema in this database.ResultSetDatabaseMetaData. 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.StringDatabaseMetaData. getSystemFunctions()Retrieves a comma-separated list of system functions available with this database.StringResultSetMetaData. getTableName(int column)Gets the designated column's table name.ResultSetDatabaseMetaData. getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)Retrieves a description of the access rights for each table available in a catalog.ResultSetDatabaseMetaData. getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)Retrieves a description of the tables available in the given catalog.ResultSetDatabaseMetaData. getTableTypes()Retrieves the table types available in this database.TimeCallableStatement. getTime(int parameterIndex)Retrieves the value of the designated JDBCTIMEparameter as ajava.sql.Timeobject.TimeCallableStatement. getTime(int parameterIndex, Calendar cal)Retrieves the value of the designated JDBCTIMEparameter as ajava.sql.Timeobject, using the givenCalendarobject to construct the time.TimeCallableStatement. getTime(String parameterName)Retrieves the value of a JDBCTIMEparameter as ajava.sql.Timeobject.TimeCallableStatement. getTime(String parameterName, Calendar cal)Retrieves the value of a JDBCTIMEparameter as ajava.sql.Timeobject, using the givenCalendarobject to construct the time.TimeResultSet. getTime(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.Timeobject in the Java programming language.TimeResultSet. getTime(int columnIndex, Calendar cal)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.Timeobject in the Java programming language.TimeResultSet. getTime(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.Timeobject in the Java programming language.TimeResultSet. getTime(String columnLabel, Calendar cal)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.Timeobject in the Java programming language.StringDatabaseMetaData. getTimeDateFunctions()Retrieves a comma-separated list of the time and date functions available with this database.TimestampCallableStatement. getTimestamp(int parameterIndex)Retrieves the value of the designated JDBCTIMESTAMPparameter as ajava.sql.Timestampobject.TimestampCallableStatement. getTimestamp(int parameterIndex, Calendar cal)Retrieves the value of the designated JDBCTIMESTAMPparameter as ajava.sql.Timestampobject, using the givenCalendarobject to construct theTimestampobject.TimestampCallableStatement. getTimestamp(String parameterName)Retrieves the value of a JDBCTIMESTAMPparameter as ajava.sql.Timestampobject.TimestampCallableStatement. getTimestamp(String parameterName, Calendar cal)Retrieves the value of a JDBCTIMESTAMPparameter as ajava.sql.Timestampobject, using the givenCalendarobject to construct theTimestampobject.TimestampResultSet. getTimestamp(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.Timestampobject in the Java programming language.TimestampResultSet. getTimestamp(int columnIndex, Calendar cal)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.Timestampobject in the Java programming language.TimestampResultSet. getTimestamp(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.Timestampobject in the Java programming language.TimestampResultSet. getTimestamp(String columnLabel, Calendar cal)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.sql.Timestampobject in the Java programming language.intConnection. getTransactionIsolation()Retrieves thisConnectionobject's current transaction isolation level.intResultSet. getType()Retrieves the type of thisResultSetobject.ResultSetDatabaseMetaData. getTypeInfo()Retrieves a description of all the data types supported by this database.Map<String,Class<?>>Connection. getTypeMap()Retrieves theMapobject associated with thisConnectionobject.ResultSetDatabaseMetaData. getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)Retrieves a description of the user-defined types (UDTs) defined in a particular schema.InputStreamResultSet. getUnicodeStream(int columnIndex)Deprecated.usegetCharacterStreamin place ofgetUnicodeStreamInputStreamResultSet. getUnicodeStream(String columnLabel)Deprecated.usegetCharacterStreaminsteadintStatement. getUpdateCount()Retrieves the current result as an update count; if the result is aResultSetobject or there are no more results, -1 is returned.URLCallableStatement. getURL(int parameterIndex)Retrieves the value of the designated JDBCDATALINKparameter as ajava.net.URLobject.URLCallableStatement. getURL(String parameterName)Retrieves the value of a JDBCDATALINKparameter as ajava.net.URLobject.StringDatabaseMetaData. getURL()Retrieves the URL for this DBMS.URLResultSet. getURL(int columnIndex)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.net.URLobject in the Java programming language.URLResultSet. getURL(String columnLabel)Retrieves the value of the designated column in the current row of thisResultSetobject as ajava.net.URLobject in the Java programming language.StringDatabaseMetaData. getUserName()Retrieves the user name as known to this database.ResultSetDatabaseMetaData. 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.SQLWarningConnection. getWarnings()Retrieves the first warning reported by calls on thisConnectionobject.SQLWarningResultSet. getWarnings()Retrieves the first warning reported by calls on thisResultSetobject.SQLWarningStatement. getWarnings()Retrieves the first warning reported by calls on thisStatementobject.voidResultSet. insertRow()Inserts the contents of the insert row into thisResultSetobject and into the database.booleanDatabaseMetaData. insertsAreDetected(int type)Retrieves whether or not a visible row insert can be detected by calling the methodResultSet.rowInserted.booleanResultSet. isAfterLast()Retrieves whether the cursor is after the last row in thisResultSetobject.booleanResultSetMetaData. isAutoIncrement(int column)Indicates whether the designated column is automatically numbered.booleanResultSet. isBeforeFirst()Retrieves whether the cursor is before the first row in thisResultSetobject.booleanResultSetMetaData. isCaseSensitive(int column)Indicates whether a column's case matters.booleanDatabaseMetaData. isCatalogAtStart()Retrieves whether a catalog appears at the start of a fully qualified table name.booleanConnection. isClosed()Retrieves whether thisConnectionobject has been closed.booleanResultSet. isClosed()Retrieves whether thisResultSetobject has been closed.booleanStatement. isClosed()Retrieves whether thisStatementobject has been closed.booleanStatement. isCloseOnCompletion()Returns a value indicating whether thisStatementwill be closed when all its dependent result sets are closed.booleanResultSetMetaData. isCurrency(int column)Indicates whether the designated column is a cash value.booleanResultSetMetaData. isDefinitelyWritable(int column)Indicates whether a write on the designated column will definitely succeed.booleanResultSet. isFirst()Retrieves whether the cursor is on the first row of thisResultSetobject.booleanResultSet. isLast()Retrieves whether the cursor is on the last row of thisResultSetobject.intParameterMetaData. isNullable(int param)Retrieves whether null values are allowed in the designated parameter.intResultSetMetaData. isNullable(int column)Indicates the nullability of values in the designated column.booleanStatement. isPoolable()Returns a value indicating whether theStatementis poolable or not.booleanConnection. isReadOnly()Retrieves whether thisConnectionobject is in read-only mode.booleanDatabaseMetaData. isReadOnly()Retrieves whether this database is in read-only mode.booleanResultSetMetaData. isReadOnly(int column)Indicates whether the designated column is definitely not writable.booleanResultSetMetaData. isSearchable(int column)Indicates whether the designated column can be used in a where clause.booleanParameterMetaData. isSigned(int param)Retrieves whether values for the designated parameter can be signed numbers.booleanResultSetMetaData. isSigned(int column)Indicates whether values in the designated column are signed numbers.default booleanStatement. isSimpleIdentifier(String identifier)Retrieves whetheridentifieris a simple SQL identifier.booleanConnection. isValid(int timeout)Returns true if the connection has not been closed and is still valid.booleanWrapper. isWrapperFor(Class<?> iface)Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.booleanResultSetMetaData. isWritable(int column)Indicates whether it is possible for a write on the designated column to succeed.booleanResultSet. last()Moves the cursor to the last row in thisResultSetobject.longBlob. length()Returns the number of bytes in theBLOBvalue designated by thisBlobobject.longClob. length()Retrieves the number of characters in theCLOBvalue designated by thisClobobject.booleanDatabaseMetaData. locatorsUpdateCopy()Indicates whether updates made to a LOB are made on a copy or directly to the LOB.voidResultSet. moveToCurrentRow()Moves the cursor to the remembered cursor position, usually the current row.voidResultSet. moveToInsertRow()Moves the cursor to the insert row.StringConnection. nativeSQL(String sql)Converts the given SQL statement into the system's native SQL grammar.booleanResultSet. next()Moves the cursor forward one row from its current position.booleanDatabaseMetaData. nullPlusNonNullIsNull()Retrieves whether this database supports concatenations betweenNULLand non-NULLvalues beingNULL.booleanDatabaseMetaData. nullsAreSortedAtEnd()Retrieves whetherNULLvalues are sorted at the end regardless of sort order.booleanDatabaseMetaData. nullsAreSortedAtStart()Retrieves whetherNULLvalues are sorted at the start regardless of sort order.booleanDatabaseMetaData. nullsAreSortedHigh()Retrieves whetherNULLvalues are sorted high.booleanDatabaseMetaData. nullsAreSortedLow()Retrieves whetherNULLvalues are sorted low.booleanDatabaseMetaData. othersDeletesAreVisible(int type)Retrieves whether deletes made by others are visible.booleanDatabaseMetaData. othersInsertsAreVisible(int type)Retrieves whether inserts made by others are visible.booleanDatabaseMetaData. othersUpdatesAreVisible(int type)Retrieves whether updates made by others are visible.booleanDatabaseMetaData. ownDeletesAreVisible(int type)Retrieves whether a result set's own deletes are visible.booleanDatabaseMetaData. ownInsertsAreVisible(int type)Retrieves whether a result set's own inserts are visible.booleanDatabaseMetaData. ownUpdatesAreVisible(int type)Retrieves whether for the given type ofResultSetobject, the result set's own updates are visible.longBlob. position(byte[] pattern, long start)Retrieves the byte position at which the specified byte arraypatternbegins within theBLOBvalue that thisBlobobject represents.longBlob. position(Blob pattern, long start)Retrieves the byte position in theBLOBvalue designated by thisBlobobject at whichpatternbegins.longClob. position(String searchstr, long start)Retrieves the character position at which the specified substringsearchstrappears in the SQLCLOBvalue represented by thisClobobject.longClob. position(Clob searchstr, long start)Retrieves the character position at which the specifiedClobobjectsearchstrappears in thisClobobject.CallableStatementConnection. prepareCall(String sql)Creates aCallableStatementobject for calling database stored procedures.CallableStatementConnection. prepareCall(String sql, int resultSetType, int resultSetConcurrency)Creates aCallableStatementobject that will generateResultSetobjects with the given type and concurrency.CallableStatementConnection. prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)Creates aCallableStatementobject that will generateResultSetobjects with the given type and concurrency.PreparedStatementConnection. prepareStatement(String sql)Creates aPreparedStatementobject for sending parameterized SQL statements to the database.PreparedStatementConnection. prepareStatement(String sql, int autoGeneratedKeys)Creates a defaultPreparedStatementobject that has the capability to retrieve auto-generated keys.PreparedStatementConnection. prepareStatement(String sql, int[] columnIndexes)Creates a defaultPreparedStatementobject capable of returning the auto-generated keys designated by the given array.PreparedStatementConnection. prepareStatement(String sql, int resultSetType, int resultSetConcurrency)Creates aPreparedStatementobject that will generateResultSetobjects with the given type and concurrency.PreparedStatementConnection. prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)Creates aPreparedStatementobject that will generateResultSetobjects with the given type, concurrency, and holdability.PreparedStatementConnection. prepareStatement(String sql, String[] columnNames)Creates a defaultPreparedStatementobject capable of returning the auto-generated keys designated by the given array.booleanResultSet. previous()Moves the cursor to the previous row in thisResultSetobject.ArraySQLInput. readArray()Reads an SQLARRAYvalue from the stream and returns it as anArrayobject in the Java programming language.InputStreamSQLInput. readAsciiStream()Reads the next attribute in the stream and returns it as a stream of ASCII characters.BigDecimalSQLInput. readBigDecimal()Reads the next attribute in the stream and returns it as ajava.math.BigDecimalobject in the Java programming language.InputStreamSQLInput. readBinaryStream()Reads the next attribute in the stream and returns it as a stream of uninterpreted bytes.BlobSQLInput. readBlob()Reads an SQLBLOBvalue from the stream and returns it as aBlobobject in the Java programming language.booleanSQLInput. readBoolean()Reads the next attribute in the stream and returns it as abooleanin the Java programming language.byteSQLInput. readByte()Reads the next attribute in the stream and returns it as abytein 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.ReaderSQLInput. readCharacterStream()Reads the next attribute in the stream and returns it as a stream of Unicode characters.ClobSQLInput. readClob()Reads an SQLCLOBvalue from the stream and returns it as aClobobject in the Java programming language.DateSQLInput. readDate()Reads the next attribute in the stream and returns it as ajava.sql.Dateobject.doubleSQLInput. readDouble()Reads the next attribute in the stream and returns it as adoublein the Java programming language.floatSQLInput. readFloat()Reads the next attribute in the stream and returns it as afloatin the Java programming language.intSQLInput. readInt()Reads the next attribute in the stream and returns it as anintin the Java programming language.longSQLInput. readLong()Reads the next attribute in the stream and returns it as alongin the Java programming language.NClobSQLInput. readNClob()Reads an SQLNCLOBvalue from the stream and returns it as aNClobobject in the Java programming language.StringSQLInput. readNString()Reads the next attribute in the stream and returns it as aStringin the Java programming language.ObjectSQLInput. readObject()Reads the datum at the head of the stream and returns it as anObjectin the Java programming language.default <T> TSQLInput. readObject(Class<T> type)Reads the next attribute in the stream and returns it as anObjectin the Java programming language.RefSQLInput. readRef()Reads an SQLREFvalue from the stream and returns it as aRefobject in the Java programming language.RowIdSQLInput. readRowId()Reads an SQLROWIDvalue from the stream and returns it as aRowIdobject in the Java programming language.shortSQLInput. readShort()Reads the next attribute in the stream and returns it as ashortin the Java programming language.voidSQLData. readSQL(SQLInput stream, String typeName)Populates this object with data read from the database.SQLXMLSQLInput. readSQLXML()Reads an SQLXMLvalue from the stream and returns it as aSQLXMLobject in the Java programming language.StringSQLInput. readString()Reads the next attribute in the stream and returns it as aStringin the Java programming language.TimeSQLInput. readTime()Reads the next attribute in the stream and returns it as ajava.sql.Timeobject.TimestampSQLInput. readTimestamp()Reads the next attribute in the stream and returns it as ajava.sql.Timestampobject.URLSQLInput. readURL()Reads an SQLDATALINKvalue from the stream and returns it as ajava.net.URLobject in the Java programming language.voidResultSet. refreshRow()Refreshes the current row with its most recent value in the database.static voidDriverManager. registerDriver(Driver driver)Registers the given driver with theDriverManager.static voidDriverManager. registerDriver(Driver driver, DriverAction da)Registers the given driver with theDriverManager.voidCallableStatement. registerOutParameter(int parameterIndex, int sqlType)Registers the OUT parameter in ordinal positionparameterIndexto the JDBC typesqlType.voidCallableStatement. registerOutParameter(int parameterIndex, int sqlType, int scale)Registers the parameter in ordinal positionparameterIndexto be of JDBC typesqlType.voidCallableStatement. registerOutParameter(int parameterIndex, int sqlType, String typeName)Registers the designated output parameter.default voidCallableStatement. registerOutParameter(int parameterIndex, SQLType sqlType)Registers the OUT parameter in ordinal positionparameterIndexto the JDBC typesqlType.default voidCallableStatement. registerOutParameter(int parameterIndex, SQLType sqlType, int scale)Registers the parameter in ordinal positionparameterIndexto be of JDBC typesqlType.default voidCallableStatement. registerOutParameter(int parameterIndex, SQLType sqlType, String typeName)Registers the designated output parameter.voidCallableStatement. registerOutParameter(String parameterName, int sqlType)Registers the OUT parameter namedparameterNameto the JDBC typesqlType.voidCallableStatement. registerOutParameter(String parameterName, int sqlType, int scale)Registers the parameter namedparameterNameto be of JDBC typesqlType.voidCallableStatement. registerOutParameter(String parameterName, int sqlType, String typeName)Registers the designated output parameter.default voidCallableStatement. registerOutParameter(String parameterName, SQLType sqlType)Registers the OUT parameter namedparameterNameto the JDBC typesqlType.default voidCallableStatement. registerOutParameter(String parameterName, SQLType sqlType, int scale)Registers the parameter namedparameterNameto be of JDBC typesqlType.default voidCallableStatement. registerOutParameter(String parameterName, SQLType sqlType, String typeName)Registers the designated output parameter.booleanResultSet. relative(int rows)Moves the cursor a relative number of rows, either positive or negative.voidConnection. releaseSavepoint(Savepoint savepoint)Removes the specifiedSavepointand subsequentSavepointobjects from the current transaction.voidConnection. rollback()Undoes all changes made in the current transaction and releases any database locks currently held by thisConnectionobject.voidConnection. rollback(Savepoint savepoint)Undoes all changes made after the givenSavepointobject was set.booleanResultSet. rowDeleted()Retrieves whether a row has been deleted.booleanResultSet. rowInserted()Retrieves whether the current row has had an insertion.booleanResultSet. rowUpdated()Retrieves whether the current row has been updated.voidPreparedStatement. setArray(int parameterIndex, Array x)Sets the designated parameter to the givenjava.sql.Arrayobject.voidCallableStatement. setAsciiStream(String parameterName, InputStream x)Sets the designated parameter to the given input stream.voidCallableStatement. setAsciiStream(String parameterName, InputStream x, int length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidCallableStatement. setAsciiStream(String parameterName, InputStream x, long length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.OutputStreamClob. setAsciiStream(long pos)Retrieves a stream to be used to write Ascii characters to theCLOBvalue that thisClobobject represents, starting at positionpos.voidPreparedStatement. setAsciiStream(int parameterIndex, InputStream x)Sets the designated parameter to the given input stream.voidPreparedStatement. setAsciiStream(int parameterIndex, InputStream x, int length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidPreparedStatement. setAsciiStream(int parameterIndex, InputStream x, long length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidConnection. setAutoCommit(boolean autoCommit)Sets this connection's auto-commit mode to the given state.voidCallableStatement. setBigDecimal(String parameterName, BigDecimal x)Sets the designated parameter to the givenjava.math.BigDecimalvalue.voidPreparedStatement. setBigDecimal(int parameterIndex, BigDecimal x)Sets the designated parameter to the givenjava.math.BigDecimalvalue.OutputStreamBlob. setBinaryStream(long pos)Retrieves a stream that can be used to write to theBLOBvalue that thisBlobobject represents.voidCallableStatement. setBinaryStream(String parameterName, InputStream x)Sets the designated parameter to the given input stream.voidCallableStatement. setBinaryStream(String parameterName, InputStream x, int length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidCallableStatement. setBinaryStream(String parameterName, InputStream x, long length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidPreparedStatement. setBinaryStream(int parameterIndex, InputStream x)Sets the designated parameter to the given input stream.voidPreparedStatement. setBinaryStream(int parameterIndex, InputStream x, int length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidPreparedStatement. setBinaryStream(int parameterIndex, InputStream x, long length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.OutputStreamSQLXML. setBinaryStream()Retrieves a stream that can be used to write the XML value that this SQLXML instance represents.voidCallableStatement. setBlob(String parameterName, InputStream inputStream)Sets the designated parameter to anInputStreamobject.voidCallableStatement. setBlob(String parameterName, InputStream inputStream, long length)Sets the designated parameter to anInputStreamobject.voidCallableStatement. setBlob(String parameterName, Blob x)Sets the designated parameter to the givenjava.sql.Blobobject.voidPreparedStatement. setBlob(int parameterIndex, InputStream inputStream)Sets the designated parameter to aInputStreamobject.voidPreparedStatement. setBlob(int parameterIndex, InputStream inputStream, long length)Sets the designated parameter to aInputStreamobject.voidPreparedStatement. setBlob(int parameterIndex, Blob x)Sets the designated parameter to the givenjava.sql.Blobobject.voidCallableStatement. setBoolean(String parameterName, boolean x)Sets the designated parameter to the given Javabooleanvalue.voidPreparedStatement. setBoolean(int parameterIndex, boolean x)Sets the designated parameter to the given Javabooleanvalue.voidCallableStatement. setByte(String parameterName, byte x)Sets the designated parameter to the given Javabytevalue.voidPreparedStatement. setByte(int parameterIndex, byte x)Sets the designated parameter to the given Javabytevalue.intBlob. setBytes(long pos, byte[] bytes)Writes the given array of bytes to theBLOBvalue that thisBlobobject represents, starting at positionpos, and returns the number of bytes written.intBlob. setBytes(long pos, byte[] bytes, int offset, int len)Writes all or part of the givenbytearray to theBLOBvalue that thisBlobobject represents and returns the number of bytes written.voidCallableStatement. setBytes(String parameterName, byte[] x)Sets the designated parameter to the given Java array of bytes.voidPreparedStatement. setBytes(int parameterIndex, byte[] x)Sets the designated parameter to the given Java array of bytes.voidConnection. setCatalog(String catalog)Sets the given catalog name in order to select a subspace of thisConnectionobject's database in which to work.voidCallableStatement. setCharacterStream(String parameterName, Reader reader)Sets the designated parameter to the givenReaderobject.voidCallableStatement. setCharacterStream(String parameterName, Reader reader, int length)Sets the designated parameter to the givenReaderobject, which is the given number of characters long.voidCallableStatement. setCharacterStream(String parameterName, Reader reader, long length)Sets the designated parameter to the givenReaderobject, which is the given number of characters long.WriterClob. setCharacterStream(long pos)Retrieves a stream to be used to write a stream of Unicode characters to theCLOBvalue that thisClobobject represents, at positionpos.voidPreparedStatement. setCharacterStream(int parameterIndex, Reader reader)Sets the designated parameter to the givenReaderobject.voidPreparedStatement. setCharacterStream(int parameterIndex, Reader reader, int length)Sets the designated parameter to the givenReaderobject, which is the given number of characters long.voidPreparedStatement. setCharacterStream(int parameterIndex, Reader reader, long length)Sets the designated parameter to the givenReaderobject, which is the given number of characters long.WriterSQLXML. setCharacterStream()Retrieves a stream to be used to write the XML value that this SQLXML instance represents.voidCallableStatement. setClob(String parameterName, Reader reader)Sets the designated parameter to aReaderobject.voidCallableStatement. setClob(String parameterName, Reader reader, long length)Sets the designated parameter to aReaderobject.voidCallableStatement. setClob(String parameterName, Clob x)Sets the designated parameter to the givenjava.sql.Clobobject.voidPreparedStatement. setClob(int parameterIndex, Reader reader)Sets the designated parameter to aReaderobject.voidPreparedStatement. setClob(int parameterIndex, Reader reader, long length)Sets the designated parameter to aReaderobject.voidPreparedStatement. setClob(int parameterIndex, Clob x)Sets the designated parameter to the givenjava.sql.Clobobject.voidStatement. setCursorName(String name)Sets the SQL cursor name to the givenString, which will be used by subsequentStatementobjectexecutemethods.voidCallableStatement. setDate(String parameterName, Date x)Sets the designated parameter to the givenjava.sql.Datevalue using the default time zone of the virtual machine that is running the application.voidCallableStatement. setDate(String parameterName, Date x, Calendar cal)Sets the designated parameter to the givenjava.sql.Datevalue, using the givenCalendarobject.voidPreparedStatement. setDate(int parameterIndex, Date x)Sets the designated parameter to the givenjava.sql.Datevalue using the default time zone of the virtual machine that is running the application.voidPreparedStatement. setDate(int parameterIndex, Date x, Calendar cal)Sets the designated parameter to the givenjava.sql.Datevalue, using the givenCalendarobject.voidCallableStatement. setDouble(String parameterName, double x)Sets the designated parameter to the given Javadoublevalue.voidPreparedStatement. setDouble(int parameterIndex, double x)Sets the designated parameter to the given Javadoublevalue.voidStatement. setEscapeProcessing(boolean enable)Sets escape processing on or off.voidResultSet. setFetchDirection(int direction)Gives a hint as to the direction in which the rows in thisResultSetobject will be processed.voidStatement. setFetchDirection(int direction)Gives the driver a hint as to the direction in which rows will be processed inResultSetobjects created using thisStatementobject.voidResultSet. 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 thisResultSetobject.voidStatement. 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 forResultSetobjects generated by thisStatement.voidCallableStatement. setFloat(String parameterName, float x)Sets the designated parameter to the given Javafloatvalue.voidPreparedStatement. setFloat(int parameterIndex, float x)Sets the designated parameter to the given Javafloatvalue.voidConnection. setHoldability(int holdability)Changes the default holdability ofResultSetobjects created using thisConnectionobject to the given holdability.voidCallableStatement. setInt(String parameterName, int x)Sets the designated parameter to the given Javaintvalue.voidPreparedStatement. setInt(int parameterIndex, int x)Sets the designated parameter to the given Javaintvalue.default voidStatement. setLargeMaxRows(long max)Sets the limit for the maximum number of rows that anyResultSetobject generated by thisStatementobject can contain to the given number.voidCallableStatement. setLong(String parameterName, long x)Sets the designated parameter to the given Javalongvalue.voidPreparedStatement. setLong(int parameterIndex, long x)Sets the designated parameter to the given Javalongvalue.voidStatement. setMaxFieldSize(int max)Sets the limit for the maximum number of bytes that can be returned for character and binary column values in aResultSetobject produced by thisStatementobject.voidStatement. setMaxRows(int max)Sets the limit for the maximum number of rows that anyResultSetobject generated by thisStatementobject can contain to the given number.voidCallableStatement. setNCharacterStream(String parameterName, Reader value)Sets the designated parameter to aReaderobject.voidCallableStatement. setNCharacterStream(String parameterName, Reader value, long length)Sets the designated parameter to aReaderobject.voidPreparedStatement. setNCharacterStream(int parameterIndex, Reader value)Sets the designated parameter to aReaderobject.voidPreparedStatement. setNCharacterStream(int parameterIndex, Reader value, long length)Sets the designated parameter to aReaderobject.voidCallableStatement. setNClob(String parameterName, Reader reader)Sets the designated parameter to aReaderobject.voidCallableStatement. setNClob(String parameterName, Reader reader, long length)Sets the designated parameter to aReaderobject.voidCallableStatement. setNClob(String parameterName, NClob value)Sets the designated parameter to ajava.sql.NClobobject.voidPreparedStatement. setNClob(int parameterIndex, Reader reader)Sets the designated parameter to aReaderobject.voidPreparedStatement. setNClob(int parameterIndex, Reader reader, long length)Sets the designated parameter to aReaderobject.voidPreparedStatement. setNClob(int parameterIndex, NClob value)Sets the designated parameter to ajava.sql.NClobobject.voidConnection. setNetworkTimeout(Executor executor, int milliseconds)Sets the maximum period aConnectionor objects created from theConnectionwill wait for the database to reply to any one request.voidCallableStatement. setNString(String parameterName, String value)Sets the designated parameter to the givenStringobject.voidPreparedStatement. setNString(int parameterIndex, String value)Sets the designated parameter to the givenStringobject.voidCallableStatement. setNull(String parameterName, int sqlType)Sets the designated parameter to SQLNULL.voidCallableStatement. setNull(String parameterName, int sqlType, String typeName)Sets the designated parameter to SQLNULL.voidPreparedStatement. setNull(int parameterIndex, int sqlType)Sets the designated parameter to SQLNULL.voidPreparedStatement. setNull(int parameterIndex, int sqlType, String typeName)Sets the designated parameter to SQLNULL.voidCallableStatement. setObject(String parameterName, Object x)Sets the value of the designated parameter with the given object.voidCallableStatement. setObject(String parameterName, Object x, int targetSqlType)Sets the value of the designated parameter with the given object.voidCallableStatement. setObject(String parameterName, Object x, int targetSqlType, int scale)Sets the value of the designated parameter with the given object.default voidCallableStatement. setObject(String parameterName, Object x, SQLType targetSqlType)Sets the value of the designated parameter with the given object.default voidCallableStatement. setObject(String parameterName, Object x, SQLType targetSqlType, int scaleOrLength)Sets the value of the designated parameter with the given object.voidPreparedStatement. setObject(int parameterIndex, Object x)Sets the value of the designated parameter using the given object.voidPreparedStatement. setObject(int parameterIndex, Object x, int targetSqlType)Sets the value of the designated parameter with the given object.voidPreparedStatement. setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength)Sets the value of the designated parameter with the given object.default voidPreparedStatement. setObject(int parameterIndex, Object x, SQLType targetSqlType)Sets the value of the designated parameter with the given object.default voidPreparedStatement. setObject(int parameterIndex, Object x, SQLType targetSqlType, int scaleOrLength)Sets the value of the designated parameter with the given object.voidRef. setObject(Object value)Sets the structured type value that thisRefobject references to the given instance ofObject.voidStatement. setPoolable(boolean poolable)Requests that aStatementbe pooled or not pooled.voidStatement. setQueryTimeout(int seconds)Sets the number of seconds the driver will wait for aStatementobject to execute to the given number of seconds.voidConnection. setReadOnly(boolean readOnly)Puts this connection in read-only mode as a hint to the driver to enable database optimizations.voidPreparedStatement. setRef(int parameterIndex, Ref x)Sets the designated parameter to the givenREF(<structured-type>)value.<T extends Result>
TSQLXML. setResult(Class<T> resultClass)Returns a Result for setting the XML value designated by this SQLXML instance.voidCallableStatement. setRowId(String parameterName, RowId x)Sets the designated parameter to the givenjava.sql.RowIdobject.voidPreparedStatement. setRowId(int parameterIndex, RowId x)Sets the designated parameter to the givenjava.sql.RowIdobject.SavepointConnection. setSavepoint()Creates an unnamed savepoint in the current transaction and returns the newSavepointobject that represents it.SavepointConnection. setSavepoint(String name)Creates a savepoint with the given name in the current transaction and returns the newSavepointobject that represents it.voidConnection. setSchema(String schema)Sets the given schema name to access.default voidConnection. setShardingKey(ShardingKey shardingKey)Specifies a shardingKey to use with this Connectiondefault voidConnection. setShardingKey(ShardingKey shardingKey, ShardingKey superShardingKey)Specifies a shardingKey and superShardingKey to use with this Connectiondefault booleanConnection. setShardingKeyIfValid(ShardingKey shardingKey, int timeout)Sets and validates the sharding key for this connection.default booleanConnection. setShardingKeyIfValid(ShardingKey shardingKey, ShardingKey superShardingKey, int timeout)Sets and validates the sharding keys for this connection.voidCallableStatement. setShort(String parameterName, short x)Sets the designated parameter to the given Javashortvalue.voidPreparedStatement. setShort(int parameterIndex, short x)Sets the designated parameter to the given Javashortvalue.voidCallableStatement. setSQLXML(String parameterName, SQLXML xmlObject)Sets the designated parameter to the givenjava.sql.SQLXMLobject.voidPreparedStatement. setSQLXML(int parameterIndex, SQLXML xmlObject)Sets the designated parameter to the givenjava.sql.SQLXMLobject.voidCallableStatement. setString(String parameterName, String x)Sets the designated parameter to the given JavaStringvalue.intClob. setString(long pos, String str)Writes the given JavaStringto theCLOBvalue that thisClobobject designates at the positionpos.intClob. setString(long pos, String str, int offset, int len)Writeslencharacters ofstr, starting at characteroffset, to theCLOBvalue that thisClobrepresents.voidPreparedStatement. setString(int parameterIndex, String x)Sets the designated parameter to the given JavaStringvalue.voidSQLXML. setString(String value)Sets the XML value designated by this SQLXML instance to the given String representation.voidCallableStatement. setTime(String parameterName, Time x)Sets the designated parameter to the givenjava.sql.Timevalue.voidCallableStatement. setTime(String parameterName, Time x, Calendar cal)Sets the designated parameter to the givenjava.sql.Timevalue, using the givenCalendarobject.voidPreparedStatement. setTime(int parameterIndex, Time x)Sets the designated parameter to the givenjava.sql.Timevalue.voidPreparedStatement. setTime(int parameterIndex, Time x, Calendar cal)Sets the designated parameter to the givenjava.sql.Timevalue, using the givenCalendarobject.voidCallableStatement. setTimestamp(String parameterName, Timestamp x)Sets the designated parameter to the givenjava.sql.Timestampvalue.voidCallableStatement. setTimestamp(String parameterName, Timestamp x, Calendar cal)Sets the designated parameter to the givenjava.sql.Timestampvalue, using the givenCalendarobject.voidPreparedStatement. setTimestamp(int parameterIndex, Timestamp x)Sets the designated parameter to the givenjava.sql.Timestampvalue.voidPreparedStatement. setTimestamp(int parameterIndex, Timestamp x, Calendar cal)Sets the designated parameter to the givenjava.sql.Timestampvalue, using the givenCalendarobject.voidConnection. setTransactionIsolation(int level)Attempts to change the transaction isolation level for thisConnectionobject to the one given.voidConnection. setTypeMap(Map<String,Class<?>> map)Installs the givenTypeMapobject as the type map for thisConnectionobject.voidPreparedStatement. setUnicodeStream(int parameterIndex, InputStream x, int length)Deprecated.UsesetCharacterStreamvoidCallableStatement. setURL(String parameterName, URL val)Sets the designated parameter to the givenjava.net.URLobject.voidPreparedStatement. setURL(int parameterIndex, URL x)Sets the designated parameter to the givenjava.net.URLvalue.booleanDatabaseMetaData. storesLowerCaseIdentifiers()Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.booleanDatabaseMetaData. storesLowerCaseQuotedIdentifiers()Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.booleanDatabaseMetaData. storesMixedCaseIdentifiers()Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.booleanDatabaseMetaData. storesMixedCaseQuotedIdentifiers()Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.booleanDatabaseMetaData. storesUpperCaseIdentifiers()Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.booleanDatabaseMetaData. storesUpperCaseQuotedIdentifiers()Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.booleanDatabaseMetaData. supportsAlterTableWithAddColumn()Retrieves whether this database supportsALTER TABLEwith add column.booleanDatabaseMetaData. supportsAlterTableWithDropColumn()Retrieves whether this database supportsALTER TABLEwith drop column.booleanDatabaseMetaData. supportsANSI92EntryLevelSQL()Retrieves whether this database supports the ANSI92 entry level SQL grammar.booleanDatabaseMetaData. supportsANSI92FullSQL()Retrieves whether this database supports the ANSI92 full SQL grammar supported.booleanDatabaseMetaData. supportsANSI92IntermediateSQL()Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.booleanDatabaseMetaData. supportsBatchUpdates()Retrieves whether this database supports batch updates.booleanDatabaseMetaData. supportsCatalogsInDataManipulation()Retrieves whether a catalog name can be used in a data manipulation statement.booleanDatabaseMetaData. supportsCatalogsInIndexDefinitions()Retrieves whether a catalog name can be used in an index definition statement.booleanDatabaseMetaData. supportsCatalogsInPrivilegeDefinitions()Retrieves whether a catalog name can be used in a privilege definition statement.booleanDatabaseMetaData. supportsCatalogsInProcedureCalls()Retrieves whether a catalog name can be used in a procedure call statement.booleanDatabaseMetaData. supportsCatalogsInTableDefinitions()Retrieves whether a catalog name can be used in a table definition statement.booleanDatabaseMetaData. supportsColumnAliasing()Retrieves whether this database supports column aliasing.booleanDatabaseMetaData. supportsConvert()Retrieves whether this database supports the JDBC scalar functionCONVERTfor the conversion of one JDBC type to another.booleanDatabaseMetaData. supportsConvert(int fromType, int toType)Retrieves whether this database supports the JDBC scalar functionCONVERTfor conversions between the JDBC types fromType and toType.booleanDatabaseMetaData. supportsCoreSQLGrammar()Retrieves whether this database supports the ODBC Core SQL grammar.booleanDatabaseMetaData. supportsCorrelatedSubqueries()Retrieves whether this database supports correlated subqueries.booleanDatabaseMetaData. supportsDataDefinitionAndDataManipulationTransactions()Retrieves whether this database supports both data definition and data manipulation statements within a transaction.booleanDatabaseMetaData. supportsDataManipulationTransactionsOnly()Retrieves whether this database supports only data manipulation statements within a transaction.booleanDatabaseMetaData. supportsDifferentTableCorrelationNames()Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.booleanDatabaseMetaData. supportsExpressionsInOrderBy()Retrieves whether this database supports expressions inORDER BYlists.booleanDatabaseMetaData. supportsExtendedSQLGrammar()Retrieves whether this database supports the ODBC Extended SQL grammar.booleanDatabaseMetaData. supportsFullOuterJoins()Retrieves whether this database supports full nested outer joins.booleanDatabaseMetaData. supportsGetGeneratedKeys()Retrieves whether auto-generated keys can be retrieved after a statement has been executedbooleanDatabaseMetaData. supportsGroupBy()Retrieves whether this database supports some form ofGROUP BYclause.booleanDatabaseMetaData. supportsGroupByBeyondSelect()Retrieves whether this database supports using columns not included in theSELECTstatement in aGROUP BYclause provided that all of the columns in theSELECTstatement are included in theGROUP BYclause.booleanDatabaseMetaData. supportsGroupByUnrelated()Retrieves whether this database supports using a column that is not in theSELECTstatement in aGROUP BYclause.booleanDatabaseMetaData. supportsIntegrityEnhancementFacility()Retrieves whether this database supports the SQL Integrity Enhancement Facility.booleanDatabaseMetaData. supportsLikeEscapeClause()Retrieves whether this database supports specifying aLIKEescape clause.booleanDatabaseMetaData. supportsLimitedOuterJoins()Retrieves whether this database provides limited support for outer joins.booleanDatabaseMetaData. supportsMinimumSQLGrammar()Retrieves whether this database supports the ODBC Minimum SQL grammar.booleanDatabaseMetaData. supportsMixedCaseIdentifiers()Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.booleanDatabaseMetaData. supportsMixedCaseQuotedIdentifiers()Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.booleanDatabaseMetaData. supportsMultipleOpenResults()Retrieves whether it is possible to have multipleResultSetobjects returned from aCallableStatementobject simultaneously.booleanDatabaseMetaData. supportsMultipleResultSets()Retrieves whether this database supports getting multipleResultSetobjects from a single call to the methodexecute.booleanDatabaseMetaData. supportsMultipleTransactions()Retrieves whether this database allows having multiple transactions open at once (on different connections).booleanDatabaseMetaData. supportsNamedParameters()Retrieves whether this database supports named parameters to callable statements.booleanDatabaseMetaData. supportsNonNullableColumns()Retrieves whether columns in this database may be defined as non-nullable.booleanDatabaseMetaData. supportsOpenCursorsAcrossCommit()Retrieves whether this database supports keeping cursors open across commits.booleanDatabaseMetaData. supportsOpenCursorsAcrossRollback()Retrieves whether this database supports keeping cursors open across rollbacks.booleanDatabaseMetaData. supportsOpenStatementsAcrossCommit()Retrieves whether this database supports keeping statements open across commits.booleanDatabaseMetaData. supportsOpenStatementsAcrossRollback()Retrieves whether this database supports keeping statements open across rollbacks.booleanDatabaseMetaData. supportsOrderByUnrelated()Retrieves whether this database supports using a column that is not in theSELECTstatement in anORDER BYclause.booleanDatabaseMetaData. supportsOuterJoins()Retrieves whether this database supports some form of outer join.booleanDatabaseMetaData. supportsPositionedDelete()Retrieves whether this database supports positionedDELETEstatements.booleanDatabaseMetaData. supportsPositionedUpdate()Retrieves whether this database supports positionedUPDATEstatements.default booleanDatabaseMetaData. supportsRefCursors()Retrieves whether this database supports REF CURSOR.booleanDatabaseMetaData. supportsResultSetConcurrency(int type, int concurrency)Retrieves whether this database supports the given concurrency type in combination with the given result set type.booleanDatabaseMetaData. supportsResultSetHoldability(int holdability)Retrieves whether this database supports the given result set holdability.booleanDatabaseMetaData. supportsResultSetType(int type)Retrieves whether this database supports the given result set type.booleanDatabaseMetaData. supportsSavepoints()Retrieves whether this database supports savepoints.booleanDatabaseMetaData. supportsSchemasInDataManipulation()Retrieves whether a schema name can be used in a data manipulation statement.booleanDatabaseMetaData. supportsSchemasInIndexDefinitions()Retrieves whether a schema name can be used in an index definition statement.booleanDatabaseMetaData. supportsSchemasInPrivilegeDefinitions()Retrieves whether a schema name can be used in a privilege definition statement.booleanDatabaseMetaData. supportsSchemasInProcedureCalls()Retrieves whether a schema name can be used in a procedure call statement.booleanDatabaseMetaData. supportsSchemasInTableDefinitions()Retrieves whether a schema name can be used in a table definition statement.booleanDatabaseMetaData. supportsSelectForUpdate()Retrieves whether this database supportsSELECT FOR UPDATEstatements.default booleanDatabaseMetaData. supportsSharding()Retrieves whether this database supports sharding.booleanDatabaseMetaData. supportsStatementPooling()Retrieves whether this database supports statement pooling.booleanDatabaseMetaData. supportsStoredFunctionsUsingCallSyntax()Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.booleanDatabaseMetaData. supportsStoredProcedures()Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.booleanDatabaseMetaData. supportsSubqueriesInComparisons()Retrieves whether this database supports subqueries in comparison expressions.booleanDatabaseMetaData. supportsSubqueriesInExists()Retrieves whether this database supports subqueries inEXISTSexpressions.booleanDatabaseMetaData. supportsSubqueriesInIns()Retrieves whether this database supports subqueries inINexpressions.booleanDatabaseMetaData. supportsSubqueriesInQuantifieds()Retrieves whether this database supports subqueries in quantified expressions.booleanDatabaseMetaData. supportsTableCorrelationNames()Retrieves whether this database supports table correlation names.booleanDatabaseMetaData. supportsTransactionIsolationLevel(int level)Retrieves whether this database supports the given transaction isolation level.booleanDatabaseMetaData. supportsTransactions()Retrieves whether this database supports transactions.booleanDatabaseMetaData. supportsUnion()Retrieves whether this database supports SQLUNION.booleanDatabaseMetaData. supportsUnionAll()Retrieves whether this database supports SQLUNION ALL.voidBlob. truncate(long len)Truncates theBLOBvalue that thisBlobobject represents to belenbytes in length.voidClob. truncate(long len)Truncates theCLOBvalue that thisClobdesignates to have a length oflencharacters.<T> TWrapper. 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.voidResultSet. updateArray(int columnIndex, Array x)Updates the designated column with ajava.sql.Arrayvalue.voidResultSet. updateArray(String columnLabel, Array x)Updates the designated column with ajava.sql.Arrayvalue.voidResultSet. updateAsciiStream(int columnIndex, InputStream x)Updates the designated column with an ascii stream value.voidResultSet. updateAsciiStream(int columnIndex, InputStream x, int length)Updates the designated column with an ascii stream value, which will have the specified number of bytes.voidResultSet. updateAsciiStream(int columnIndex, InputStream x, long length)Updates the designated column with an ascii stream value, which will have the specified number of bytes.voidResultSet. updateAsciiStream(String columnLabel, InputStream x)Updates the designated column with an ascii stream value.voidResultSet. updateAsciiStream(String columnLabel, InputStream x, int length)Updates the designated column with an ascii stream value, which will have the specified number of bytes.voidResultSet. updateAsciiStream(String columnLabel, InputStream x, long length)Updates the designated column with an ascii stream value, which will have the specified number of bytes.voidResultSet. updateBigDecimal(int columnIndex, BigDecimal x)Updates the designated column with ajava.math.BigDecimalvalue.voidResultSet. updateBigDecimal(String columnLabel, BigDecimal x)Updates the designated column with ajava.sql.BigDecimalvalue.voidResultSet. updateBinaryStream(int columnIndex, InputStream x)Updates the designated column with a binary stream value.voidResultSet. updateBinaryStream(int columnIndex, InputStream x, int length)Updates the designated column with a binary stream value, which will have the specified number of bytes.voidResultSet. updateBinaryStream(int columnIndex, InputStream x, long length)Updates the designated column with a binary stream value, which will have the specified number of bytes.voidResultSet. updateBinaryStream(String columnLabel, InputStream x)Updates the designated column with a binary stream value.voidResultSet. updateBinaryStream(String columnLabel, InputStream x, int length)Updates the designated column with a binary stream value, which will have the specified number of bytes.voidResultSet. updateBinaryStream(String columnLabel, InputStream x, long length)Updates the designated column with a binary stream value, which will have the specified number of bytes.voidResultSet. updateBlob(int columnIndex, InputStream inputStream)Updates the designated column using the given input stream.voidResultSet. updateBlob(int columnIndex, InputStream inputStream, long length)Updates the designated column using the given input stream, which will have the specified number of bytes.voidResultSet. updateBlob(int columnIndex, Blob x)Updates the designated column with ajava.sql.Blobvalue.voidResultSet. updateBlob(String columnLabel, InputStream inputStream)Updates the designated column using the given input stream.voidResultSet. updateBlob(String columnLabel, InputStream inputStream, long length)Updates the designated column using the given input stream, which will have the specified number of bytes.voidResultSet. updateBlob(String columnLabel, Blob x)Updates the designated column with ajava.sql.Blobvalue.voidResultSet. updateBoolean(int columnIndex, boolean x)Updates the designated column with abooleanvalue.voidResultSet. updateBoolean(String columnLabel, boolean x)Updates the designated column with abooleanvalue.voidResultSet. updateByte(int columnIndex, byte x)Updates the designated column with abytevalue.voidResultSet. updateByte(String columnLabel, byte x)Updates the designated column with abytevalue.voidResultSet. updateBytes(int columnIndex, byte[] x)Updates the designated column with abytearray value.voidResultSet. updateBytes(String columnLabel, byte[] x)Updates the designated column with a byte array value.voidResultSet. updateCharacterStream(int columnIndex, Reader x)Updates the designated column with a character stream value.voidResultSet. updateCharacterStream(int columnIndex, Reader x, int length)Updates the designated column with a character stream value, which will have the specified number of bytes.voidResultSet. updateCharacterStream(int columnIndex, Reader x, long length)Updates the designated column with a character stream value, which will have the specified number of bytes.voidResultSet. updateCharacterStream(String columnLabel, Reader reader)Updates the designated column with a character stream value.voidResultSet. updateCharacterStream(String columnLabel, Reader reader, int length)Updates the designated column with a character stream value, which will have the specified number of bytes.voidResultSet. updateCharacterStream(String columnLabel, Reader reader, long length)Updates the designated column with a character stream value, which will have the specified number of bytes.voidResultSet. updateClob(int columnIndex, Reader reader)Updates the designated column using the givenReaderobject.voidResultSet. updateClob(int columnIndex, Reader reader, long length)Updates the designated column using the givenReaderobject, which is the given number of characters long.voidResultSet. updateClob(int columnIndex, Clob x)Updates the designated column with ajava.sql.Clobvalue.voidResultSet. updateClob(String columnLabel, Reader reader)Updates the designated column using the givenReaderobject.voidResultSet. updateClob(String columnLabel, Reader reader, long length)Updates the designated column using the givenReaderobject, which is the given number of characters long.voidResultSet. updateClob(String columnLabel, Clob x)Updates the designated column with ajava.sql.Clobvalue.voidResultSet. updateDate(int columnIndex, Date x)Updates the designated column with ajava.sql.Datevalue.voidResultSet. updateDate(String columnLabel, Date x)Updates the designated column with ajava.sql.Datevalue.voidResultSet. updateDouble(int columnIndex, double x)Updates the designated column with adoublevalue.voidResultSet. updateDouble(String columnLabel, double x)Updates the designated column with adoublevalue.voidResultSet. updateFloat(int columnIndex, float x)Updates the designated column with afloatvalue.voidResultSet. updateFloat(String columnLabel, float x)Updates the designated column with afloatvalue.voidResultSet. updateInt(int columnIndex, int x)Updates the designated column with anintvalue.voidResultSet. updateInt(String columnLabel, int x)Updates the designated column with anintvalue.voidResultSet. updateLong(int columnIndex, long x)Updates the designated column with alongvalue.voidResultSet. updateLong(String columnLabel, long x)Updates the designated column with alongvalue.voidResultSet. updateNCharacterStream(int columnIndex, Reader x)Updates the designated column with a character stream value.voidResultSet. updateNCharacterStream(int columnIndex, Reader x, long length)Updates the designated column with a character stream value, which will have the specified number of bytes.voidResultSet. updateNCharacterStream(String columnLabel, Reader reader)Updates the designated column with a character stream value.voidResultSet. updateNCharacterStream(String columnLabel, Reader reader, long length)Updates the designated column with a character stream value, which will have the specified number of bytes.voidResultSet. updateNClob(int columnIndex, Reader reader)Updates the designated column using the givenReaderThe data will be read from the stream as needed until end-of-stream is reached.voidResultSet. updateNClob(int columnIndex, Reader reader, long length)Updates the designated column using the givenReaderobject, which is the given number of characters long.voidResultSet. updateNClob(int columnIndex, NClob nClob)Updates the designated column with ajava.sql.NClobvalue.voidResultSet. updateNClob(String columnLabel, Reader reader)Updates the designated column using the givenReaderobject.voidResultSet. updateNClob(String columnLabel, Reader reader, long length)Updates the designated column using the givenReaderobject, which is the given number of characters long.voidResultSet. updateNClob(String columnLabel, NClob nClob)Updates the designated column with ajava.sql.NClobvalue.voidResultSet. updateNString(int columnIndex, String nString)Updates the designated column with aStringvalue.voidResultSet. updateNString(String columnLabel, String nString)Updates the designated column with aStringvalue.voidResultSet. updateNull(int columnIndex)Updates the designated column with anullvalue.voidResultSet. updateNull(String columnLabel)Updates the designated column with anullvalue.voidResultSet. updateObject(int columnIndex, Object x)Updates the designated column with anObjectvalue.voidResultSet. updateObject(int columnIndex, Object x, int scaleOrLength)Updates the designated column with anObjectvalue.default voidResultSet. updateObject(int columnIndex, Object x, SQLType targetSqlType)Updates the designated column with anObjectvalue.default voidResultSet. updateObject(int columnIndex, Object x, SQLType targetSqlType, int scaleOrLength)Updates the designated column with anObjectvalue.voidResultSet. updateObject(String columnLabel, Object x)Updates the designated column with anObjectvalue.voidResultSet. updateObject(String columnLabel, Object x, int scaleOrLength)Updates the designated column with anObjectvalue.default voidResultSet. updateObject(String columnLabel, Object x, SQLType targetSqlType)Updates the designated column with anObjectvalue.default voidResultSet. updateObject(String columnLabel, Object x, SQLType targetSqlType, int scaleOrLength)Updates the designated column with anObjectvalue.voidResultSet. updateRef(int columnIndex, Ref x)Updates the designated column with ajava.sql.Refvalue.voidResultSet. updateRef(String columnLabel, Ref x)Updates the designated column with ajava.sql.Refvalue.voidResultSet. updateRow()Updates the underlying database with the new contents of the current row of thisResultSetobject.voidResultSet. updateRowId(int columnIndex, RowId x)Updates the designated column with aRowIdvalue.voidResultSet. updateRowId(String columnLabel, RowId x)Updates the designated column with aRowIdvalue.booleanDatabaseMetaData. updatesAreDetected(int type)Retrieves whether or not a visible row update can be detected by calling the methodResultSet.rowUpdated.voidResultSet. updateShort(int columnIndex, short x)Updates the designated column with ashortvalue.voidResultSet. updateShort(String columnLabel, short x)Updates the designated column with ashortvalue.voidResultSet. updateSQLXML(int columnIndex, SQLXML xmlObject)Updates the designated column with ajava.sql.SQLXMLvalue.voidResultSet. updateSQLXML(String columnLabel, SQLXML xmlObject)Updates the designated column with ajava.sql.SQLXMLvalue.voidResultSet. updateString(int columnIndex, String x)Updates the designated column with aStringvalue.voidResultSet. updateString(String columnLabel, String x)Updates the designated column with aStringvalue.voidResultSet. updateTime(int columnIndex, Time x)Updates the designated column with ajava.sql.Timevalue.voidResultSet. updateTime(String columnLabel, Time x)Updates the designated column with ajava.sql.Timevalue.voidResultSet. updateTimestamp(int columnIndex, Timestamp x)Updates the designated column with ajava.sql.Timestampvalue.voidResultSet. updateTimestamp(String columnLabel, Timestamp x)Updates the designated column with ajava.sql.Timestampvalue.booleanDatabaseMetaData. usesLocalFilePerTable()Retrieves whether this database uses a file for each table.booleanDatabaseMetaData. usesLocalFiles()Retrieves whether this database stores tables in a local file.booleanCallableStatement. wasNull()Retrieves whether the last OUT parameter read had the value of SQLNULL.booleanResultSet. wasNull()Reports whether the last column read had a value of SQLNULL.booleanSQLInput. wasNull()Retrieves whether the last value read was SQLNULL.voidSQLOutput. writeArray(Array x)Writes an SQLARRAYvalue to the stream.voidSQLOutput. writeAsciiStream(InputStream x)Writes the next attribute to the stream as a stream of ASCII characters.voidSQLOutput. writeBigDecimal(BigDecimal x)Writes the next attribute to the stream as a java.math.BigDecimal object.voidSQLOutput. writeBinaryStream(InputStream x)Writes the next attribute to the stream as a stream of uninterpreted bytes.voidSQLOutput. writeBlob(Blob x)Writes an SQLBLOBvalue to the stream.voidSQLOutput. writeBoolean(boolean x)Writes the next attribute to the stream as a Java boolean.voidSQLOutput. writeByte(byte x)Writes the next attribute to the stream as a Java byte.voidSQLOutput. writeBytes(byte[] x)Writes the next attribute to the stream as an array of bytes.voidSQLOutput. writeCharacterStream(Reader x)Writes the next attribute to the stream as a stream of Unicode characters.voidSQLOutput. writeClob(Clob x)Writes an SQLCLOBvalue to the stream.voidSQLOutput. writeDate(Date x)Writes the next attribute to the stream as a java.sql.Date object.voidSQLOutput. writeDouble(double x)Writes the next attribute to the stream as a Java double.voidSQLOutput. writeFloat(float x)Writes the next attribute to the stream as a Java float.voidSQLOutput. writeInt(int x)Writes the next attribute to the stream as a Java int.voidSQLOutput. writeLong(long x)Writes the next attribute to the stream as a Java long.voidSQLOutput. writeNClob(NClob x)Writes an SQLNCLOBvalue to the stream.voidSQLOutput. writeNString(String x)Writes the next attribute to the stream as aStringin the Java programming language.default voidSQLOutput. writeObject(Object x, SQLType targetSqlType)Writes to the stream the data contained in the given object.voidSQLOutput. writeObject(SQLData x)Writes to the stream the data contained in the givenSQLDataobject.voidSQLOutput. writeRef(Ref x)Writes an SQLREFvalue to the stream.voidSQLOutput. writeRowId(RowId x)Writes an SQLROWIDvalue to the stream.voidSQLOutput. writeShort(short x)Writes the next attribute to the stream as a Java short.voidSQLData. writeSQL(SQLOutput stream)Writes this object to the given SQL data stream, converting it back to its SQL value in the data source.voidSQLOutput. writeSQLXML(SQLXML x)Writes an SQLXMLvalue to the stream.voidSQLOutput. writeString(String x)Writes the next attribute to the stream as aStringin the Java programming language.voidSQLOutput. writeStruct(Struct x)Writes an SQL structured type value to the stream.voidSQLOutput. writeTime(Time x)Writes the next attribute to the stream as a java.sql.Time object.voidSQLOutput. writeTimestamp(Timestamp x)Writes the next attribute to the stream as a java.sql.Timestamp object.voidSQLOutput. writeURL(URL x)Writes a SQLDATALINKvalue to the stream. -
Uses of SQLException in javax.sql
Methods in javax.sql that return SQLException Modifier and Type Method Description SQLExceptionConnectionEvent. getSQLException()Retrieves theSQLExceptionfor thisConnectionEventobject.SQLExceptionStatementEvent. getSQLException()Returns theSQLExceptionthe driver is about to throwMethods in javax.sql that throw SQLException Modifier and Type Method Description PooledConnectionPooledConnectionBuilder. build()Returns an instance of the object defined by this builder.XAConnectionXAConnectionBuilder. build()Returns an instance of the object defined by this builder.voidRowSet. clearParameters()Clears the parameters set for thisRowSetobject's command.voidPooledConnection. close()Closes the physical connection that thisPooledConnectionobject represents.default ConnectionBuilderDataSource. createConnectionBuilder()Create a newConnectionBuilderinstancedefault PooledConnectionBuilderConnectionPoolDataSource. createPooledConnectionBuilder()Creates a newPooledConnectionBuilderinstancedefault ShardingKeyBuilderCommonDataSource. createShardingKeyBuilder()Creates a newShardingKeyBuilderinstancedefault XAConnectionBuilderXADataSource. createXAConnectionBuilder()Creates a newXAConnectionBuilderinstancevoidRowSet. execute()Fills thisRowSetobject with data.ConnectionDataSource. getConnection()Attempts to establish a connection with the data source that thisDataSourceobject represents.ConnectionDataSource. getConnection(String username, String password)Attempts to establish a connection with the data source that thisDataSourceobject represents.ConnectionPooledConnection. getConnection()Creates and returns aConnectionobject that is a handle for the physical connection that thisPooledConnectionobject represents.ConnectionRowSetInternal. getConnection()Retrieves theConnectionobject that was passed to thisRowSetobject.booleanRowSet. getEscapeProcessing()Retrieves whether escape processing is enabled for thisRowSetobject.intCommonDataSource. getLoginTimeout()Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.intConnectionPoolDataSource. getLoginTimeout()Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.intDataSource. getLoginTimeout()Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.intXADataSource. getLoginTimeout()Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.PrintWriterCommonDataSource. getLogWriter()Retrieves the log writer for thisDataSourceobject.PrintWriterConnectionPoolDataSource. getLogWriter()Retrieves the log writer for thisDataSourceobject.PrintWriterDataSource. getLogWriter()Retrieves the log writer for thisDataSourceobject.PrintWriterXADataSource. getLogWriter()Retrieves the log writer for thisDataSourceobject.intRowSet. getMaxFieldSize()Retrieves the maximum number of bytes that may be returned for certain column values.intRowSet. getMaxRows()Retrieves the maximum number of rows that thisRowSetobject can contain.ResultSetRowSetInternal. getOriginal()Retrieves aResultSetobject containing the original value of thisRowSetobject.ResultSetRowSetInternal. getOriginalRow()Retrieves aResultSetobject containing the original value of the current row only.Object[]RowSetInternal. getParams()Retrieves the parameters that have been set for thisRowSetobject's command.PooledConnectionConnectionPoolDataSource. getPooledConnection()Attempts to establish a physical database connection that can be used as a pooled connection.PooledConnectionConnectionPoolDataSource. getPooledConnection(String user, String password)Attempts to establish a physical database connection that can be used as a pooled connection.intRowSet. getQueryTimeout()Retrieves the maximum number of seconds the driver will wait for a statement to execute.Map<String,Class<?>>RowSet. getTypeMap()Retrieves theMapobject associated with thisRowSetobject, which specifies the custom mapping of SQL user-defined types, if any.StringRowSet. getUrl()Retrieves the url property thisRowSetobject will use to create a connection if it uses theDriverManagerinstead of aDataSourceobject to establish the connection.XAConnectionXADataSource. getXAConnection()Attempts to establish a physical database connection that can be used in a distributed transaction.XAConnectionXADataSource. getXAConnection(String user, String password)Attempts to establish a physical database connection, using the given user name and password.XAResourceXAConnection. getXAResource()Retrieves anXAResourceobject that the transaction manager will use to manage thisXAConnectionobject's participation in a distributed transaction.voidRowSetReader. readData(RowSetInternal caller)Reads the new contents of the callingRowSetobject.voidRowSet. setArray(int i, Array x)Sets the designated parameter in thisRowSetobject's command with the givenArrayvalue.voidRowSet. setAsciiStream(int parameterIndex, InputStream x)Sets the designated parameter in thisRowSetobject's command to the given input stream.voidRowSet. setAsciiStream(int parameterIndex, InputStream x, int length)Sets the designated parameter in thisRowSetobject's command to the givenjava.io.InputStreamvalue.voidRowSet. setAsciiStream(String parameterName, InputStream x)Sets the designated parameter to the given input stream.voidRowSet. setAsciiStream(String parameterName, InputStream x, int length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidRowSetMetaData. setAutoIncrement(int columnIndex, boolean property)Sets whether the designated column is automatically numbered, The default is for aRowSetobject's columns not to be automatically numbered.voidRowSet. setBigDecimal(int parameterIndex, BigDecimal x)Sets the designated parameter in thisRowSetobject's command to the givenjava.math.BigDecimalvalue.voidRowSet. setBigDecimal(String parameterName, BigDecimal x)Sets the designated parameter to the givenjava.math.BigDecimalvalue.voidRowSet. setBinaryStream(int parameterIndex, InputStream x)Sets the designated parameter in thisRowSetobject's command to the given input stream.voidRowSet. setBinaryStream(int parameterIndex, InputStream x, int length)Sets the designated parameter in thisRowSetobject's command to the givenjava.io.InputStreamvalue.voidRowSet. setBinaryStream(String parameterName, InputStream x)Sets the designated parameter to the given input stream.voidRowSet. setBinaryStream(String parameterName, InputStream x, int length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidRowSet. setBlob(int parameterIndex, InputStream inputStream)Sets the designated parameter to aInputStreamobject.voidRowSet. setBlob(int parameterIndex, InputStream inputStream, long length)Sets the designated parameter to aInputStreamobject.voidRowSet. setBlob(int i, Blob x)Sets the designated parameter in thisRowSetobject's command with the givenBlobvalue.voidRowSet. setBlob(String parameterName, InputStream inputStream)Sets the designated parameter to aInputStreamobject.voidRowSet. setBlob(String parameterName, InputStream inputStream, long length)Sets the designated parameter to aInputStreamobject.voidRowSet. setBlob(String parameterName, Blob x)Sets the designated parameter to the givenjava.sql.Blobobject.voidRowSet. setBoolean(int parameterIndex, boolean x)Sets the designated parameter in thisRowSetobject's command to the given Javabooleanvalue.voidRowSet. setBoolean(String parameterName, boolean x)Sets the designated parameter to the given Javabooleanvalue.voidRowSet. setByte(int parameterIndex, byte x)Sets the designated parameter in thisRowSetobject's command to the given Javabytevalue.voidRowSet. setByte(String parameterName, byte x)Sets the designated parameter to the given Javabytevalue.voidRowSet. setBytes(int parameterIndex, byte[] x)Sets the designated parameter in thisRowSetobject's command to the given Java array ofbytevalues.voidRowSet. setBytes(String parameterName, byte[] x)Sets the designated parameter to the given Java array of bytes.voidRowSetMetaData. setCaseSensitive(int columnIndex, boolean property)Sets whether the designated column is case sensitive.voidRowSetMetaData. setCatalogName(int columnIndex, String catalogName)Sets the designated column's table's catalog name, if any, to the givenString.voidRowSet. setCharacterStream(int parameterIndex, Reader reader)Sets the designated parameter in thisRowSetobject's command to the givenReaderobject.voidRowSet. setCharacterStream(int parameterIndex, Reader reader, int length)Sets the designated parameter in thisRowSetobject's command to the givenjava.io.Readervalue.voidRowSet. setCharacterStream(String parameterName, Reader reader)Sets the designated parameter to the givenReaderobject.voidRowSet. setCharacterStream(String parameterName, Reader reader, int length)Sets the designated parameter to the givenReaderobject, which is the given number of characters long.voidRowSet. setClob(int parameterIndex, Reader reader)Sets the designated parameter to aReaderobject.voidRowSet. setClob(int parameterIndex, Reader reader, long length)Sets the designated parameter to aReaderobject.voidRowSet. setClob(int i, Clob x)Sets the designated parameter in thisRowSetobject's command with the givenClobvalue.voidRowSet. setClob(String parameterName, Reader reader)Sets the designated parameter to aReaderobject.voidRowSet. setClob(String parameterName, Reader reader, long length)Sets the designated parameter to aReaderobject.voidRowSet. setClob(String parameterName, Clob x)Sets the designated parameter to the givenjava.sql.Clobobject.voidRowSetMetaData. setColumnCount(int columnCount)Sets the number of columns in theRowSetobject to the given number.voidRowSetMetaData. setColumnDisplaySize(int columnIndex, int size)Sets the designated column's normal maximum width in chars to the givenint.voidRowSetMetaData. setColumnLabel(int columnIndex, String label)Sets the suggested column title for use in printouts and displays, if any, to the givenString.voidRowSetMetaData. setColumnName(int columnIndex, String columnName)Sets the name of the designated column to the givenString.voidRowSetMetaData. setColumnType(int columnIndex, int SQLType)Sets the designated column's SQL type to the one given.voidRowSetMetaData. setColumnTypeName(int columnIndex, String typeName)Sets the designated column's type name that is specific to the data source, if any, to the givenString.voidRowSet. setCommand(String cmd)Sets thisRowSetobject's command property to the given SQL query.voidRowSet. setConcurrency(int concurrency)Sets the concurrency of thisRowSetobject to the given concurrency level.voidRowSetMetaData. setCurrency(int columnIndex, boolean property)Sets whether the designated column is a cash value.voidRowSet. setDataSourceName(String name)Sets the data source name property for thisRowSetobject to the givenString.voidRowSet. setDate(int parameterIndex, Date x)Sets the designated parameter in thisRowSetobject's command to the givenjava.sql.Datevalue.voidRowSet. setDate(int parameterIndex, Date x, Calendar cal)Sets the designated parameter in thisRowSetobject's command with the givenjava.sql.Datevalue.voidRowSet. setDate(String parameterName, Date x)Sets the designated parameter to the givenjava.sql.Datevalue using the default time zone of the virtual machine that is running the application.voidRowSet. setDate(String parameterName, Date x, Calendar cal)Sets the designated parameter to the givenjava.sql.Datevalue, using the givenCalendarobject.voidRowSet. setDouble(int parameterIndex, double x)Sets the designated parameter in thisRowSetobject's command to the given Javadoublevalue.voidRowSet. setDouble(String parameterName, double x)Sets the designated parameter to the given Javadoublevalue.voidRowSet. setEscapeProcessing(boolean enable)Sets escape processing for thisRowSetobject on or off.voidRowSet. setFloat(int parameterIndex, float x)Sets the designated parameter in thisRowSetobject's command to the given Javafloatvalue.voidRowSet. setFloat(String parameterName, float x)Sets the designated parameter to the given Javafloatvalue.voidRowSet. setInt(int parameterIndex, int x)Sets the designated parameter in thisRowSetobject's command to the given Javaintvalue.voidRowSet. setInt(String parameterName, int x)Sets the designated parameter to the given Javaintvalue.voidCommonDataSource. setLoginTimeout(int seconds)Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.voidConnectionPoolDataSource. setLoginTimeout(int seconds)Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.voidDataSource. setLoginTimeout(int seconds)Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.voidXADataSource. setLoginTimeout(int seconds)Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.voidCommonDataSource. setLogWriter(PrintWriter out)Sets the log writer for thisDataSourceobject to the givenjava.io.PrintWriterobject.voidConnectionPoolDataSource. setLogWriter(PrintWriter out)Sets the log writer for thisDataSourceobject to the givenjava.io.PrintWriterobject.voidDataSource. setLogWriter(PrintWriter out)Sets the log writer for thisDataSourceobject to the givenjava.io.PrintWriterobject.voidXADataSource. setLogWriter(PrintWriter out)Sets the log writer for thisDataSourceobject to the givenjava.io.PrintWriterobject.voidRowSet. setLong(int parameterIndex, long x)Sets the designated parameter in thisRowSetobject's command to the given Javalongvalue.voidRowSet. setLong(String parameterName, long x)Sets the designated parameter to the given Javalongvalue.voidRowSet. setMaxFieldSize(int max)Sets the maximum number of bytes that can be returned for a column value to the given number of bytes.voidRowSet. setMaxRows(int max)Sets the maximum number of rows that thisRowSetobject can contain to the specified number.voidRowSetInternal. setMetaData(RowSetMetaData md)Sets the givenRowSetMetaDataobject as theRowSetMetaDataobject for thisRowSetobject.voidRowSet. setNCharacterStream(int parameterIndex, Reader value)Sets the designated parameter in thisRowSetobject's command to aReaderobject.voidRowSet. setNCharacterStream(int parameterIndex, Reader value, long length)Sets the designated parameter to aReaderobject.voidRowSet. setNCharacterStream(String parameterName, Reader value)Sets the designated parameter to aReaderobject.voidRowSet. setNCharacterStream(String parameterName, Reader value, long length)Sets the designated parameter to aReaderobject.voidRowSet. setNClob(int parameterIndex, Reader reader)Sets the designated parameter to aReaderobject.voidRowSet. setNClob(int parameterIndex, Reader reader, long length)Sets the designated parameter to aReaderobject.voidRowSet. setNClob(int parameterIndex, NClob value)Sets the designated parameter to ajava.sql.NClobobject.voidRowSet. setNClob(String parameterName, Reader reader)Sets the designated parameter to aReaderobject.voidRowSet. setNClob(String parameterName, Reader reader, long length)Sets the designated parameter to aReaderobject.voidRowSet. setNClob(String parameterName, NClob value)Sets the designated parameter to ajava.sql.NClobobject.voidRowSet. setNString(int parameterIndex, String value)Sets the designated parameter to the givenStringobject.voidRowSet. setNString(String parameterName, String value)Sets the designated parameter to the givenStringobject.voidRowSet. setNull(int parameterIndex, int sqlType)Sets the designated parameter in thisRowSetobject's SQL command to SQLNULL.voidRowSet. setNull(int paramIndex, int sqlType, String typeName)Sets the designated parameter in thisRowSetobject's SQL command to SQLNULL.voidRowSet. setNull(String parameterName, int sqlType)Sets the designated parameter to SQLNULL.voidRowSet. setNull(String parameterName, int sqlType, String typeName)Sets the designated parameter to SQLNULL.voidRowSetMetaData. setNullable(int columnIndex, int property)Sets whether the designated column's value can be set toNULL.voidRowSet. setObject(int parameterIndex, Object x)Sets the designated parameter in thisRowSetobject's command with a JavaObject.voidRowSet. setObject(int parameterIndex, Object x, int targetSqlType)Sets the designated parameter in thisRowSetobject's command with a JavaObject.voidRowSet. setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength)Sets the designated parameter in thisRowSetobject's command with the given JavaObject.voidRowSet. setObject(String parameterName, Object x)Sets the value of the designated parameter with the given object.voidRowSet. setObject(String parameterName, Object x, int targetSqlType)Sets the value of the designated parameter with the given object.voidRowSet. setObject(String parameterName, Object x, int targetSqlType, int scale)Sets the value of the designated parameter with the given object.voidRowSet. setPassword(String password)Sets the database password for thisRowSetobject to the givenString.voidRowSetMetaData. setPrecision(int columnIndex, int precision)Sets the designated column's number of decimal digits to the givenint.voidRowSet. setQueryTimeout(int seconds)Sets the maximum time the driver will wait for a statement to execute to the given number of seconds.voidRowSet. setReadOnly(boolean value)Sets whether thisRowSetobject is read-only to the givenboolean.voidRowSet. setRef(int i, Ref x)Sets the designated parameter in thisRowSetobject's command with the givenRefvalue.voidRowSet. setRowId(int parameterIndex, RowId x)Sets the designated parameter to the givenjava.sql.RowIdobject.voidRowSet. setRowId(String parameterName, RowId x)Sets the designated parameter to the givenjava.sql.RowIdobject.voidRowSetMetaData. setScale(int columnIndex, int scale)Sets the designated column's number of digits to the right of the decimal point to the givenint.voidRowSetMetaData. setSchemaName(int columnIndex, String schemaName)Sets the name of the designated column's table's schema, if any, to the givenString.voidRowSetMetaData. setSearchable(int columnIndex, boolean property)Sets whether the designated column can be used in a where clause.voidRowSet. setShort(int parameterIndex, short x)Sets the designated parameter in thisRowSetobject's command to the given Javashortvalue.voidRowSet. setShort(String parameterName, short x)Sets the designated parameter to the given Javashortvalue.voidRowSetMetaData. setSigned(int columnIndex, boolean property)Sets whether the designated column is a signed number.voidRowSet. setSQLXML(int parameterIndex, SQLXML xmlObject)Sets the designated parameter to the givenjava.sql.SQLXMLobject.voidRowSet. setSQLXML(String parameterName, SQLXML xmlObject)Sets the designated parameter to the givenjava.sql.SQLXMLobject.voidRowSet. setString(int parameterIndex, String x)Sets the designated parameter in thisRowSetobject's command to the given JavaStringvalue.voidRowSet. setString(String parameterName, String x)Sets the designated parameter to the given JavaStringvalue.voidRowSetMetaData. setTableName(int columnIndex, String tableName)Sets the designated column's table name, if any, to the givenString.voidRowSet. setTime(int parameterIndex, Time x)Sets the designated parameter in thisRowSetobject's command to the givenjava.sql.Timevalue.voidRowSet. setTime(int parameterIndex, Time x, Calendar cal)Sets the designated parameter in thisRowSetobject's command with the givenjava.sql.Timevalue.voidRowSet. setTime(String parameterName, Time x)Sets the designated parameter to the givenjava.sql.Timevalue.voidRowSet. setTime(String parameterName, Time x, Calendar cal)Sets the designated parameter to the givenjava.sql.Timevalue, using the givenCalendarobject.voidRowSet. setTimestamp(int parameterIndex, Timestamp x)Sets the designated parameter in thisRowSetobject's command to the givenjava.sql.Timestampvalue.voidRowSet. setTimestamp(int parameterIndex, Timestamp x, Calendar cal)Sets the designated parameter in thisRowSetobject's command with the givenjava.sql.Timestampvalue.voidRowSet. setTimestamp(String parameterName, Timestamp x)Sets the designated parameter to the givenjava.sql.Timestampvalue.voidRowSet. setTimestamp(String parameterName, Timestamp x, Calendar cal)Sets the designated parameter to the givenjava.sql.Timestampvalue, using the givenCalendarobject.voidRowSet. setTransactionIsolation(int level)Sets the transaction isolation level for thisRowSetobject.voidRowSet. setType(int type)Sets the type of thisRowSetobject to the given type.voidRowSet. setTypeMap(Map<String,Class<?>> map)Installs the givenjava.util.Mapobject as the default type map for thisRowSetobject.voidRowSet. setUrl(String url)Sets the URL thisRowSetobject will use when it uses theDriverManagerto create a connection.voidRowSet. setURL(int parameterIndex, URL x)Sets the designated parameter to the givenjava.net.URLvalue.voidRowSet. setUsername(String name)Sets the username property for thisRowSetobject to the givenString.booleanRowSetWriter. writeData(RowSetInternal caller)Writes the changes in thisRowSetWriterobject's rowset back to the data source from which it got its data.Constructors in javax.sql with parameters of type SQLException Constructor Description ConnectionEvent(PooledConnection con, SQLException ex)Constructs aConnectionEventobject initialized with the givenPooledConnectionobject andSQLExceptionobject.StatementEvent(PooledConnection con, PreparedStatement statement, SQLException exception)Constructs aStatementEventwith the specifiedPooledConnection,PreparedStatementandSQLException -
Uses of SQLException in javax.sql.rowset
Subclasses of SQLException in javax.sql.rowset Modifier and Type Class Description classRowSetWarningAn extension ofSQLExceptionthat provides information about database warnings set onRowSetobjects.Methods in javax.sql.rowset that throw SQLException Modifier and Type Method Description voidJoinRowSet. addRowSet(RowSet[] rowset, int[] columnIdx)Adds one or moreRowSetobjects contained in the given array ofRowSetobjects to thisJoinRowSetobject and sets the match column for each of theRowSetobjects to the match columns in the given array of column indexes.voidJoinRowSet. addRowSet(RowSet[] rowset, String[] columnName)Adds one or moreRowSetobjects contained in the given array ofRowSetobjects to thisJoinRowSetobject and sets the match column for each of theRowSetobjects to the match columns in the given array of column names.voidJoinRowSet. addRowSet(Joinable rowset)Adds the givenRowSetobject to thisJoinRowSetobject.voidJoinRowSet. addRowSet(RowSet rowset, int columnIdx)Adds the givenRowSetobject to thisJoinRowSetobject and sets the designated column as the match column for theRowSetobject.voidJoinRowSet. addRowSet(RowSet rowset, String columnName)Adds rowset to thisJoinRowSetobject and sets the designated column as the match column.voidBaseRowSet. clearParameters()Clears all of the current parameter values in thisRowSetobject's internal representation of the parameters to be set in thisRowSetobject's command when it is executed.booleanCachedRowSet. columnUpdated(int idx)Indicates whether the designated column in the current row of thisCachedRowSetobject has been updated.booleanCachedRowSet. columnUpdated(String columnName)Indicates whether the designated column in the current row of thisCachedRowSetobject has been updated.voidCachedRowSet. commit()EachCachedRowSetobject'sSyncProvidercontains aConnectionobject from theResultSetor JDBC properties passed to it's constructors.voidJdbcRowSet. commit()EachJdbcRowSetcontains aConnectionobject from theResultSetor JDBC properties passed to it's constructors.CachedRowSetRowSetFactory. createCachedRowSet()Creates a new instance of a CachedRowSet.CachedRowSetCachedRowSet. createCopy()Creates aRowSetobject that is a deep copy of the data in thisCachedRowSetobject.CachedRowSetCachedRowSet. createCopyNoConstraints()Creates aCachedRowSetobject that is a deep copy of thisCachedRowSetobject's data but is independent of it.CachedRowSetCachedRowSet. createCopySchema()Creates aCachedRowSetobject that is an empty copy of thisCachedRowSetobject.FilteredRowSetRowSetFactory. createFilteredRowSet()Creates a new instance of a FilteredRowSet.JdbcRowSetRowSetFactory. createJdbcRowSet()Creates a new instance of a JdbcRowSet.JoinRowSetRowSetFactory. createJoinRowSet()Creates a new instance of a JoinRowSet.RowSetCachedRowSet. createShared()Returns a newRowSetobject backed by the same data as that of thisCachedRowSetobject.WebRowSetRowSetFactory. createWebRowSet()Creates a new instance of a WebRowSet.booleanPredicate. evaluate(Object value, int column)This method is called by aFilteredRowSetobject to check whether the value lies between the filtering criterion (or criteria if multiple constraints exist) set using thesetFilter()method.booleanPredicate. evaluate(Object value, String columnName)This method is called by theFilteredRowSetobject to check whether the value lies between the filtering criteria set using the setFilter method.voidCachedRowSet. execute(Connection conn)Populates thisCachedRowSetobject with data, using the given connection to produce the result set from which the data will be read.booleanJdbcRowSet. getAutoCommit()EachJdbcRowSetcontains aConnectionobject from the originalResultSetor JDBC properties passed to it.StringRowSetMetaDataImpl. getCatalogName(int columnIndex)Retrieves the catalog name of the table from which the value in the designated column was derived.StringRowSetMetaDataImpl. 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.intRowSetMetaDataImpl. getColumnCount()Retrieves the number of columns in theRowSetobject for which thisRowSetMetaDataImplobject was created.intRowSetMetaDataImpl. getColumnDisplaySize(int columnIndex)Retrieves the normal maximum width in chars of the designated column.StringRowSetMetaDataImpl. getColumnLabel(int columnIndex)Retrieves the suggested column title for the designated column for use in printouts and displays.StringRowSetMetaDataImpl. getColumnName(int columnIndex)Retrieves the name of the designated column.intRowSetMetaDataImpl. getColumnType(int columnIndex)Retrieves the type code (one of thejava.sql.Typesconstants) for the SQL type of the value stored in the designated column.StringRowSetMetaDataImpl. getColumnTypeName(int columnIndex)Retrieves the DBMS-specific type name for values stored in the designated column.intBaseRowSet. getConcurrency()Returns the concurrency for thisRowSetobject.booleanBaseRowSet. getEscapeProcessing()Ascertains whether escape processing is enabled for thisRowSetobject.intBaseRowSet. getFetchDirection()Retrieves thisRowSetobject's current setting for the fetch direction.intBaseRowSet. getFetchSize()Returns the fetch size for thisRowSetobject.intJoinRowSet. getJoinType()Returns aintdescribing the set SQLJOINtype 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 thisCachedRowSetobject.int[]Joinable. getMatchColumnIndexes()Retrieves the indexes of the match columns that were set for thisRowSetobject with the methodsetMatchColumn(int[] columnIdxes).String[]Joinable. getMatchColumnNames()Retrieves the names of the match columns that were set for thisRowSetobject with the methodsetMatchColumn(String [] columnNames).intBaseRowSet. getMaxFieldSize()Retrieves the maximum number of bytes that can be used for a column value in thisRowSetobject.intBaseRowSet. getMaxRows()Retrieves the maximum number of rows that thisRowSetobject may contain.ResultSetCachedRowSet. getOriginal()Returns aResultSetobject containing the original value of thisCachedRowSetobject.ResultSetCachedRowSet. getOriginalRow()Returns aResultSetobject containing the original value for the current row only of thisCachedRowSetobject.Object[]BaseRowSet. getParams()Retrieves an array containing the parameter values (both Objects and primitives) that have been set for thisRowSetobject's command and throws anSQLExceptionobject if all parameters have not been set.intRowSetMetaDataImpl. getPrecision(int columnIndex)Retrieves the total number of digits for values stored in the designated column.intBaseRowSet. getQueryTimeout()Retrieves the maximum number of seconds the driver will wait for a query to execute.String[]JoinRowSet. getRowSetNames()Returns aStringarray containing the names of theRowSetobjects added to thisJoinRowSetobject.Collection<?>JoinRowSet. getRowSets()Returns aCollectionobject containing theRowSetobjects that have been added to thisJoinRowSetobject.RowSetWarningCachedRowSet. getRowSetWarnings()Retrieves the first warning reported by calls on thisRowSetobject.RowSetWarningJdbcRowSet. getRowSetWarnings()Retrieves the first warning reported by calls on thisJdbcRowSetobject.intRowSetMetaDataImpl. getScale(int columnIndex)Retrieves the number of digits to the right of the decimal point for values stored in the designated column.StringRowSetMetaDataImpl. getSchemaName(int columnIndex)Retrieves the schema name of the table from which the value in the designated column was derived.booleanBaseRowSet. getShowDeleted()Retrieves abooleanindicating whether rows marked for deletion appear in the set of current rows.booleanCachedRowSet. getShowDeleted()Retrieves abooleanindicating whether rows marked for deletion appear in the set of current rows.booleanJdbcRowSet. getShowDeleted()Retrieves abooleanindicating whether rows marked for deletion appear in the set of current rows.SyncProviderCachedRowSet. getSyncProvider()Retrieves theSyncProviderimplementation for thisCachedRowSetobject.StringCachedRowSet. getTableName()Returns an identifier for the object (table) that was used to create thisCachedRowSetobject.StringRowSetMetaDataImpl. getTableName(int columnIndex)Retrieves the name of the table from which the value in the designated column was derived.intBaseRowSet. getType()Returns the type of thisRowSetobject.StringBaseRowSet. getUrl()Retrieves the JDBC URL that thisRowSetobject'sjavax.sql.Readerobject uses to make a connection with a relational database using a JDBC technology-enabled driver.StringJoinRowSet. getWhereClause()Return a SQL-like description of the WHERE clause being used in a JoinRowSet object.booleanRowSetMetaDataImpl. isAutoIncrement(int columnIndex)Retrieves whether a value stored in the designated column is automatically numbered, and thus readonly.booleanRowSetMetaDataImpl. isCaseSensitive(int columnIndex)Indicates whether the case of the designated column's name matters.booleanRowSetMetaDataImpl. isCurrency(int columnIndex)Indicates whether a value stored in the designated column is a cash value.booleanRowSetMetaDataImpl. isDefinitelyWritable(int columnIndex)Indicates whether a write operation on the designated column will definitely succeed.intRowSetMetaDataImpl. isNullable(int columnIndex)Retrieves a constant indicating whether it is possible to store aNULLvalue in the designated column.booleanRowSetMetaDataImpl. isReadOnly(int columnIndex)Indicates whether the designated column is definitely not writable, thus readonly.booleanRowSetMetaDataImpl. isSearchable(int columnIndex)Indicates whether a value stored in the designated column can be used in aWHEREclause.booleanRowSetMetaDataImpl. isSigned(int columnIndex)Indicates whether a value stored in the designated column is a signed number.booleanRowSetMetaDataImpl. isWrapperFor(Class<?> interfaces)Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.booleanRowSetMetaDataImpl. isWritable(int columnIndex)Indicates whether it is possible for a write operation on the designated column to succeed.static RowSetFactoryRowSetProvider. newFactory()Creates a new instance of aRowSetFactoryimplementation.static RowSetFactoryRowSetProvider. newFactory(String factoryClassName, ClassLoader cl)Creates a new instance of aRowSetFactoryfrom the specified factory class name.booleanCachedRowSet. nextPage()Increments the current page of theCachedRowSet.protected voidBaseRowSet. notifyCursorMoved()Notifies all of the listeners registered with thisRowSetobject that its cursor has moved.protected voidBaseRowSet. notifyRowChanged()Notifies all of the listeners registered with thisRowSetobject that one of its rows has changed.protected voidBaseRowSet. notifyRowSetChanged()Notifies all of the listeners registered with thisRowSetobject that its entire contents have changed.voidCachedRowSet. populate(ResultSet data)Populates thisCachedRowSetobject with data from the givenResultSetobject.voidCachedRowSet. populate(ResultSet rs, int startRow)Populates thisCachedRowSetobject with data from the givenResultSetobject.booleanCachedRowSet. previousPage()Decrements the current page of theCachedRowSet.voidWebRowSet. readXml(InputStream iStream)Reads a stream based XML input to populate thisWebRowSetobject.voidWebRowSet. readXml(Reader reader)Reads aWebRowSetobject in its XML format from the givenReaderobject.voidCachedRowSet. release()Releases the current contents of thisCachedRowSetobject and sends arowSetChangedevent to all registered listeners.voidCachedRowSet. restoreOriginal()Restores thisCachedRowSetobject to its original value, that is, its value before the last set of changes.voidCachedRowSet. rollback()EachCachedRowSetobject'sSyncProvidercontains aConnectionobject from the originalResultSetor JDBC properties passed to it.voidCachedRowSet. rollback(Savepoint s)EachCachedRowSetobject'sSyncProvidercontains aConnectionobject from the originalResultSetor JDBC properties passed to it.voidJdbcRowSet. rollback()EachJdbcRowSetcontains aConnectionobject from the originalResultSetor JDBC properties passed to it.voidJdbcRowSet. rollback(Savepoint s)EachJdbcRowSetcontains aConnectionobject from the originalResultSetor JDBC properties passed to it.voidCachedRowSet. rowSetPopulated(RowSetEvent event, int numRows)Notifies registered listeners that a RowSet object in the given RowSetEvent object has populated a number of additional rows.voidBaseRowSet. setArray(int parameterIndex, Array array)Sets the designated parameter to anArrayobject in the Java programming language.voidBaseRowSet. setAsciiStream(int parameterIndex, InputStream x)Sets the designated parameter in thisRowSetobject's command to the given input stream.voidBaseRowSet. setAsciiStream(int parameterIndex, InputStream x, int length)Sets the designated parameter to the givenjava.io.InputStreamobject, which will have the specified number of bytes.voidBaseRowSet. setAsciiStream(String parameterName, InputStream x)Sets the designated parameter to the given input stream.voidBaseRowSet. setAsciiStream(String parameterName, InputStream x, int length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidJdbcRowSet. setAutoCommit(boolean autoCommit)EachJdbcRowSetcontains aConnectionobject from the originalResultSetor JDBC properties passed to it.voidRowSetMetaDataImpl. setAutoIncrement(int columnIndex, boolean property)Sets whether the designated column is automatically numbered, thus read-only, to the givenbooleanvalue.voidBaseRowSet. setBigDecimal(int parameterIndex, BigDecimal x)Sets the designated parameter to the givenjava.lang.BigDecimalvalue.voidBaseRowSet. setBigDecimal(String parameterName, BigDecimal x)Sets the designated parameter to the givenjava.math.BigDecimalvalue.voidBaseRowSet. setBinaryStream(int parameterIndex, InputStream x)Sets the designated parameter in thisRowSetobject's command to the given input stream.voidBaseRowSet. setBinaryStream(int parameterIndex, InputStream x, int length)Sets the designated parameter to the givenjava.io.InputStreamobject, which will have the specified number of bytes.voidBaseRowSet. setBinaryStream(String parameterName, InputStream x)Sets the designated parameter to the given input stream.voidBaseRowSet. setBinaryStream(String parameterName, InputStream x, int length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidBaseRowSet. setBlob(int parameterIndex, InputStream inputStream)Sets the designated parameter to aInputStreamobject.voidBaseRowSet. setBlob(int parameterIndex, InputStream inputStream, long length)Sets the designated parameter to aInputStreamobject.voidBaseRowSet. setBlob(int parameterIndex, Blob x)Sets the designated parameter to the givenBlobobject in the Java programming language.voidBaseRowSet. setBlob(String parameterName, InputStream inputStream)Sets the designated parameter to aInputStreamobject.voidBaseRowSet. setBlob(String parameterName, InputStream inputStream, long length)Sets the designated parameter to aInputStreamobject.voidBaseRowSet. setBlob(String parameterName, Blob x)Sets the designated parameter to the givenjava.sql.Blobobject.voidBaseRowSet. setBoolean(int parameterIndex, boolean x)Sets the designated parameter to the givenbooleanin the Java programming language.voidBaseRowSet. setBoolean(String parameterName, boolean x)Sets the designated parameter to the given Javabooleanvalue.voidBaseRowSet. setByte(int parameterIndex, byte x)Sets the designated parameter to the givenbytein the Java programming language.voidBaseRowSet. setByte(String parameterName, byte x)Sets the designated parameter to the given Javabytevalue.voidBaseRowSet. setBytes(int parameterIndex, byte[] x)Sets the designated parameter to the given array of bytes.voidBaseRowSet. setBytes(String parameterName, byte[] x)Sets the designated parameter to the given Java array of bytes.voidRowSetMetaDataImpl. setCaseSensitive(int columnIndex, boolean property)Sets whether the name of the designated column is case sensitive to the givenboolean.voidRowSetMetaDataImpl. setCatalogName(int columnIndex, String catalogName)Sets the catalog name of the table from which the designated column was derived to catalogName.voidBaseRowSet. setCharacterStream(int parameterIndex, Reader reader)Sets the designated parameter in thisRowSetobject's command to the givenReaderobject.voidBaseRowSet. setCharacterStream(int parameterIndex, Reader reader, int length)Sets the designated parameter to the givenjava.io.Readerobject, which will have the specified number of characters.voidBaseRowSet. setCharacterStream(String parameterName, Reader reader)Sets the designated parameter to the givenReaderobject.voidBaseRowSet. setCharacterStream(String parameterName, Reader reader, int length)Sets the designated parameter to the givenReaderobject, which is the given number of characters long.voidBaseRowSet. setClob(int parameterIndex, Reader reader)Sets the designated parameter to aReaderobject.voidBaseRowSet. setClob(int parameterIndex, Reader reader, long length)Sets the designated parameter to aReaderobject.voidBaseRowSet. setClob(int parameterIndex, Clob x)Sets the designated parameter to the givenClobobject in the Java programming language.voidBaseRowSet. setClob(String parameterName, Reader reader)Sets the designated parameter to aReaderobject.voidBaseRowSet. setClob(String parameterName, Reader reader, long length)Sets the designated parameter to aReaderobject.voidBaseRowSet. setClob(String parameterName, Clob x)Sets the designated parameter to the givenjava.sql.Clobobject.voidRowSetMetaDataImpl. setColumnCount(int columnCount)Sets to the given number the number of columns in theRowSetobject for which thisRowSetMetaDataImplobject was created.voidRowSetMetaDataImpl. setColumnDisplaySize(int columnIndex, int size)Sets the normal maximum number of chars in the designated column to the given number.voidRowSetMetaDataImpl. setColumnLabel(int columnIndex, String label)Sets the suggested column label for use in printouts and displays, if any, to label.voidRowSetMetaDataImpl. setColumnName(int columnIndex, String columnName)Sets the column name of the designated column to the given name.voidRowSetMetaDataImpl. setColumnType(int columnIndex, int SQLType)Sets the SQL type code for values stored in the designated column to the given type code from the classjava.sql.Types.voidRowSetMetaDataImpl. 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.voidBaseRowSet. setCommand(String cmd)Sets thisRowSetobject'scommandproperty to the givenStringobject and clears the parameters, if any, that were set for the previous command.voidBaseRowSet. setConcurrency(int concurrency)Sets the concurrency for thisRowSetobject to the specified concurrency.voidRowSetMetaDataImpl. setCurrency(int columnIndex, boolean property)Sets whether a value stored in the designated column is a cash value to the givenboolean.voidBaseRowSet. setDataSourceName(String name)Sets theDataSourcename property for thisRowSetobject to the given logical name and sets thisRowSetobject's Url property tonull.voidBaseRowSet. setDate(int parameterIndex, Date x)Sets the designated parameter to the givenjava.sql.Datevalue.voidBaseRowSet. setDate(int parameterIndex, Date x, Calendar cal)Sets the designated parameter to the givenjava.sql.Dateobject.voidBaseRowSet. setDate(String parameterName, Date x)Sets the designated parameter to the givenjava.sql.Datevalue using the default time zone of the virtual machine that is running the application.voidBaseRowSet. setDate(String parameterName, Date x, Calendar cal)Sets the designated parameter to the givenjava.sql.Datevalue, using the givenCalendarobject.voidBaseRowSet. setDouble(int parameterIndex, double x)Sets the designated parameter to the givendoublein the Java programming language.voidBaseRowSet. setDouble(String parameterName, double x)Sets the designated parameter to the given Javadoublevalue.voidBaseRowSet. setEscapeProcessing(boolean enable)Sets to the givenbooleanwhether or not the driver will scan for escape syntax and do escape substitution before sending SQL statements to the database.voidBaseRowSet. setFetchDirection(int direction)Gives the driver a performance hint as to the direction in which the rows in thisRowSetobject will be processed.voidBaseRowSet. setFetchSize(int rows)Sets the fetch size for thisRowSetobject to the given number of rows.voidFilteredRowSet. setFilter(Predicate p)Applies the givenPredicateobject to thisFilteredRowSetobject.voidBaseRowSet. setFloat(int parameterIndex, float x)Sets the designated parameter to the givenfloatin the Java programming language.voidBaseRowSet. setFloat(String parameterName, float x)Sets the designated parameter to the given Javafloatvalue.voidBaseRowSet. setInt(int parameterIndex, int x)Sets the designated parameter to anintin the Java programming language.voidBaseRowSet. setInt(String parameterName, int x)Sets the designated parameter to the given Javaintvalue.voidJoinRowSet. setJoinType(int joinType)Allow the application to adjust the type ofJOINimposed on tables contained within the JoinRowSet object instance.voidCachedRowSet. setKeyColumns(int[] keys)Sets thisCachedRowSetobject'skeyColsfield with the given array of column numbers, which forms a key for uniquely identifying a row in thisCachedRowSetobject.voidBaseRowSet. setLong(int parameterIndex, long x)Sets the designated parameter to the givenlongin the Java programming language.voidBaseRowSet. setLong(String parameterName, long x)Sets the designated parameter to the given Javalongvalue.voidJoinable. setMatchColumn(int columnIdx)Sets the designated column as the match column for thisRowSetobject.voidJoinable. setMatchColumn(int[] columnIdxes)Sets the designated columns as the match column for thisRowSetobject.voidJoinable. setMatchColumn(String columnName)Sets the designated column as the match column for thisRowSetobject.voidJoinable. setMatchColumn(String[] columnNames)Sets the designated columns as the match column for thisRowSetobject.voidBaseRowSet. setMaxFieldSize(int max)Sets the maximum number of bytes that can be used for a column value in thisRowSetobject to the given number.voidBaseRowSet. setMaxRows(int max)Sets the maximum number of rows that thisRowSetobject may contain to the given number.voidCachedRowSet. setMetaData(RowSetMetaData md)Sets the metadata for thisCachedRowSetobject with the givenRowSetMetaDataobject.voidBaseRowSet. setNCharacterStream(int parameterIndex, Reader value)Sets the designated parameter in thisRowSetobject's command to aReaderobject.voidBaseRowSet. setNCharacterStream(int parameterIndex, Reader value, long length)Sets the designated parameter to aReaderobject.voidBaseRowSet. setNCharacterStream(String parameterName, Reader value)Sets the designated parameter to aReaderobject.voidBaseRowSet. setNCharacterStream(String parameterName, Reader value, long length)Sets the designated parameter to aReaderobject.voidBaseRowSet. setNClob(int parameterIndex, Reader reader)Sets the designated parameter to aReaderobject.voidBaseRowSet. setNClob(int parameterIndex, Reader reader, long length)Sets the designated parameter to aReaderobject.voidBaseRowSet. setNClob(int parameterIndex, NClob value)Sets the designated parameter to ajava.sql.NClobobject.voidBaseRowSet. setNClob(String parameterName, Reader reader)Sets the designated parameter to aReaderobject.voidBaseRowSet. setNClob(String parameterName, Reader reader, long length)Sets the designated parameter to aReaderobject.voidBaseRowSet. setNClob(String parameterName, NClob value)Sets the designated parameter to ajava.sql.NClobobject.voidBaseRowSet. setNString(int parameterIndex, String value)Sets the designated parameter to the givenStringobject.voidBaseRowSet. setNString(String parameterName, String value)Sets the designated parameter to the givenStringobject.voidBaseRowSet. setNull(int parameterIndex, int sqlType)Sets the designated parameter to SQLNULL.voidBaseRowSet. setNull(int parameterIndex, int sqlType, String typeName)Sets the designated parameter to SQLNULL.voidBaseRowSet. setNull(String parameterName, int sqlType)Sets the designated parameter to SQLNULL.voidBaseRowSet. setNull(String parameterName, int sqlType, String typeName)Sets the designated parameter to SQLNULL.voidRowSetMetaDataImpl. setNullable(int columnIndex, int property)Sets whether a value stored in the designated column can be set toNULLto the given constant from the interfaceResultSetMetaData.voidBaseRowSet. setObject(int parameterIndex, Object x)Sets the designated parameter to anObjectin the Java programming language.voidBaseRowSet. setObject(int parameterIndex, Object x, int targetSqlType)Sets the value of the designated parameter with the givenObjectvalue.voidBaseRowSet. setObject(int parameterIndex, Object x, int targetSqlType, int scale)Sets the designated parameter to anObjectin the Java programming language.voidBaseRowSet. setObject(String parameterName, Object x)Sets the value of the designated parameter with the given object.voidBaseRowSet. setObject(String parameterName, Object x, int targetSqlType)Sets the value of the designated parameter with the given object.voidBaseRowSet. setObject(String parameterName, Object x, int targetSqlType, int scale)Sets the value of the designated parameter with the given object.voidCachedRowSet. setOriginalRow()Sets the current row in thisCachedRowSetobject as the original row.voidCachedRowSet. setPageSize(int size)Sets theCachedRowSetobject's page-size.voidRowSetMetaDataImpl. setPrecision(int columnIndex, int precision)Sets the total number of decimal digits in a value stored in the designated column to the given number.voidBaseRowSet. setQueryTimeout(int seconds)Sets to the given number the maximum number of seconds the driver will wait for a query to execute.voidBaseRowSet. setRef(int parameterIndex, Ref ref)Sets the designated parameter to the givenRefobject in the Java programming language.voidBaseRowSet. setRowId(int parameterIndex, RowId x)Sets the designated parameter to the givenjava.sql.RowIdobject.voidBaseRowSet. setRowId(String parameterName, RowId x)Sets the designated parameter to the givenjava.sql.RowIdobject.voidRowSetMetaDataImpl. 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.voidRowSetMetaDataImpl. setSchemaName(int columnIndex, String schemaName)Sets the designated column's table's schema name, if any, to schemaName.voidRowSetMetaDataImpl. setSearchable(int columnIndex, boolean property)Sets whether a value stored in the designated column can be used in aWHEREclause to the givenbooleanvalue.voidBaseRowSet. setShort(int parameterIndex, short x)Sets the designated parameter to the givenshortin the Java programming language.voidBaseRowSet. setShort(String parameterName, short x)Sets the designated parameter to the given Javashortvalue.voidBaseRowSet. setShowDeleted(boolean value)Sets the propertyshowDeletedto the givenbooleanvalue, which determines whether rows marked for deletion appear in the set of current rows.voidCachedRowSet. setShowDeleted(boolean b)Sets the propertyshowDeletedto the givenbooleanvalue, which determines whether rows marked for deletion appear in the set of current rows.voidJdbcRowSet. setShowDeleted(boolean b)Sets the propertyshowDeletedto the givenbooleanvalue.voidRowSetMetaDataImpl. setSigned(int columnIndex, boolean property)Sets whether a value stored in the designated column is a signed number to the givenboolean.voidBaseRowSet. setSQLXML(int parameterIndex, SQLXML xmlObject)Sets the designated parameter to the givenjava.sql.SQLXMLobject.voidBaseRowSet. setSQLXML(String parameterName, SQLXML xmlObject)Sets the designated parameter to the givenjava.sql.SQLXMLobject.voidBaseRowSet. setString(int parameterIndex, String x)Sets the designated parameter to the givenStringvalue.voidBaseRowSet. setString(String parameterName, String x)Sets the designated parameter to the given JavaStringvalue.voidCachedRowSet. setSyncProvider(String provider)Sets theSyncProviderobject for thisCachedRowSetobject to the one specified.voidCachedRowSet. setTableName(String tabName)Sets the identifier for the table from which thisCachedRowSetobject was derived to the given table name.voidRowSetMetaDataImpl. setTableName(int columnIndex, String tableName)Sets the name of the table from which the designated column was derived to the given table name.voidBaseRowSet. setTime(int parameterIndex, Time x)Sets the designated parameter to the givenjava.sql.Timevalue.voidBaseRowSet. setTime(int parameterIndex, Time x, Calendar cal)Sets the designated parameter to the givenjava.sql.Timeobject.voidBaseRowSet. setTime(String parameterName, Time x)Sets the designated parameter to the givenjava.sql.Timevalue.voidBaseRowSet. setTime(String parameterName, Time x, Calendar cal)Sets the designated parameter to the givenjava.sql.Timevalue, using the givenCalendarobject.voidBaseRowSet. setTimestamp(int parameterIndex, Timestamp x)Sets the designated parameter to the givenjava.sql.Timestampvalue.voidBaseRowSet. setTimestamp(int parameterIndex, Timestamp x, Calendar cal)Sets the designated parameter to the givenjava.sql.Timestampobject.voidBaseRowSet. setTimestamp(String parameterName, Timestamp x)Sets the designated parameter to the givenjava.sql.Timestampvalue.voidBaseRowSet. setTimestamp(String parameterName, Timestamp x, Calendar cal)Sets the designated parameter to the givenjava.sql.Timestampvalue, using the givenCalendarobject.voidBaseRowSet. setTransactionIsolation(int level)Sets the transaction isolation property for this JDBCRowSetobject to the given constant.voidBaseRowSet. setType(int type)Sets the type for thisRowSetobject to the specified type.voidBaseRowSet. setUnicodeStream(int parameterIndex, InputStream x, int length)Deprecated.getCharacterStream should be used in its placevoidBaseRowSet. setUrl(String url)Sets the Url property for thisRowSetobject to the givenStringobject and sets the dataSource name property tonull.voidBaseRowSet. setURL(int parameterIndex, URL x)Sets the designated parameter to the givenjava.net.URLvalue.CachedRowSetJoinRowSet. toCachedRowSet()Creates a newCachedRowSetobject containing the data in thisJoinRowSetobject, which can be saved to a data source using theSyncProviderobject for theCachedRowSetobject.Collection<?>CachedRowSet. toCollection()Converts thisCachedRowSetobject to aCollectionobject that contains all of thisCachedRowSetobject's data.Collection<?>CachedRowSet. toCollection(int column)Converts the designated column in thisCachedRowSetobject to aCollectionobject.Collection<?>CachedRowSet. toCollection(String column)Converts the designated column in thisCachedRowSetobject to aCollectionobject.voidCachedRowSet. undoDelete()Cancels the deletion of the current row and notifies listeners that a row has changed.voidCachedRowSet. undoInsert()Immediately removes the current row from thisCachedRowSetobject if the row has been inserted, and also notifies listeners that a row has changed.voidCachedRowSet. undoUpdate()Immediately reverses the last update operation if the row has been modified.voidJoinable. unsetMatchColumn(int columnIdx)Unsets the designated column as the match column for thisRowSetobject.voidJoinable. unsetMatchColumn(int[] columnIdxes)Unsets the designated columns as the match column for thisRowSetobject.voidJoinable. unsetMatchColumn(String columnName)Unsets the designated column as the match column for thisRowSetobject.voidJoinable. unsetMatchColumn(String[] columnName)Unsets the designated columns as the match columns for thisRowSetobject.<T> TRowSetMetaDataImpl. 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.voidWebRowSet. writeXml(OutputStream oStream)Writes the data, properties, and metadata for thisWebRowSetobject to the givenOutputStreamobject in XML format.voidWebRowSet. writeXml(Writer writer)Writes the data, properties, and metadata for thisWebRowSetobject to the givenWriterobject in XML format.voidWebRowSet. writeXml(ResultSet rs, OutputStream oStream)Populates thisWebRowSetobject with the contents of the givenResultSetobject and writes its data, properties, and metadata to the givenOutputStreamobject in XML format.voidWebRowSet. writeXml(ResultSet rs, Writer writer)Populates thisWebRowSetobject with the contents of the givenResultSetobject and writes its data, properties, and metadata to the givenWriterobject in XML format. -
Uses of SQLException in javax.sql.rowset.serial
Subclasses of SQLException in javax.sql.rowset.serial Modifier and Type Class Description classSerialExceptionIndicates and an error with the serialization or de-serialization of SQL types such asBLOB, CLOB, STRUCT or ARRAYin addition to SQL types such asDATALINK and JAVAOBJECTMethods in javax.sql.rowset.serial that throw SQLException Modifier and Type Method Description voidSerialArray. free()This method frees theSerialArrayobject and releases the resources that it holds.voidSerialBlob. free()This method frees theSerialBlobobject and releases the resources that it holds.voidSerialClob. free()This method frees theSerialClobobject and releases the resources that it holds.InputStreamSerialClob. getAsciiStream()Retrieves theCLOBvalue designated by thisSerialClobobject as an ascii stream.InputStreamSerialBlob. getBinaryStream(long pos, long length)Returns anInputStreamobject that contains a partialBlobvalue, starting with the byte specified by pos, which is length bytes in length.ReaderSerialClob. getCharacterStream(long pos, long length)Returns aReaderobject that contains a partialSerialClobvalue, starting with the character specified by pos, which is length characters in length.longSerialBlob. position(byte[] pattern, long start)Returns the position in thisSerialBlobobject where the given pattern of bytes begins, starting the search at the specified position.longSerialBlob. position(Blob pattern, long start)Returns the position in thisSerialBlobobject where the givenBlobobject begins, starting the search at the specified position.longSerialClob. position(String searchStr, long start)Returns the position in thisSerialClobobject where the givenStringobject begins, starting the search at the specified position.longSerialClob. position(Clob searchStr, long start)Returns the position in thisSerialClobobject where the givenClobsignature begins, starting the search at the specified position.ArraySQLInputImpl. readArray()Reads an SQLARRAYvalue from the stream and returns it as anArrayobject in the Java programming language.InputStreamSQLInputImpl. readAsciiStream()Returns the next attribute in thisSQLInputImplobject as a stream of ASCII characters.BigDecimalSQLInputImpl. readBigDecimal()Retrieves the next attribute in thisSQLInputImplobject as ajava.math.BigDecimal.InputStreamSQLInputImpl. readBinaryStream()Returns the next attribute in thisSQLInputImplobject as a stream of uninterpreted bytes.BlobSQLInputImpl. readBlob()Retrieves theBLOBvalue at the head of thisSQLInputImplobject as aBlobobject in the Java programming language.booleanSQLInputImpl. readBoolean()Retrieves the next attribute in thisSQLInputImplobject as abooleanin the Java programming language.byteSQLInputImpl. readByte()Retrieves the next attribute in thisSQLInputImplobject as abytein the Java programming language.byte[]SQLInputImpl. readBytes()Retrieves the next attribute in thisSQLInputImplobject as an array of bytes.ReaderSQLInputImpl. readCharacterStream()Retrieves the next attribute in thisSQLInputImplobject as a stream of Unicode characters.ClobSQLInputImpl. readClob()Retrieves theCLOBvalue at the head of thisSQLInputImplobject as aClobobject in the Java programming language.DateSQLInputImpl. readDate()Retrieves the next attribute in thisSQLInputImplas ajava.sql.Dateobject.doubleSQLInputImpl. readDouble()Retrieves the next attribute in thisSQLInputImplobject as adoublein the Java programming language.floatSQLInputImpl. readFloat()Retrieves the next attribute in thisSQLInputImplobject as afloatin the Java programming language.intSQLInputImpl. readInt()Retrieves the next attribute in thisSQLInputImplobject as anintin the Java programming language.longSQLInputImpl. readLong()Retrieves the next attribute in thisSQLInputImplobject as alongin the Java programming language.NClobSQLInputImpl. readNClob()Reads an SQLNCLOBvalue from the stream and returns it as aClobobject in the Java programming language.StringSQLInputImpl. readNString()Reads the next attribute in the stream and returns it as aStringin the Java programming language.ObjectSQLInputImpl. readObject()Retrieves the value at the head of thisSQLInputImplobject as anObjectin the Java programming language.RefSQLInputImpl. readRef()Retrieves the value at the head of thisSQLInputImplobject as aRefobject in the Java programming language.RowIdSQLInputImpl. readRowId()Reads an SQLROWIDvalue from the stream and returns it as aRowIdobject in the Java programming language.shortSQLInputImpl. readShort()Retrieves the next attribute in thisSQLInputImplobject as ashortin the Java programming language.SQLXMLSQLInputImpl. readSQLXML()Reads an SQLXMLvalue from the stream and returns it as aSQLXMLobject in the Java programming language.StringSQLInputImpl. readString()Retrieves the next attribute in thisSQLInputImplobject as aStringin the Java programming language.TimeSQLInputImpl. readTime()Retrieves the next attribute in thisSQLInputImplobject as ajava.sql.Timeobject.TimestampSQLInputImpl. readTimestamp()Retrieves the next attribute in thisSQLInputImplobject as ajava.sql.Timestampobject.URLSQLInputImpl. readURL()Reads an SQLDATALINKvalue from the stream and returns it as anURLobject in the Java programming language.OutputStreamSerialClob. setAsciiStream(long pos)Retrieves a stream to be used to write Ascii characters to theCLOBvalue that thisSerialClobobject represents, starting at positionpos.OutputStreamSerialBlob. setBinaryStream(long pos)Retrieves a stream that can be used to write to theBLOBvalue that thisBlobobject represents.intSerialBlob. setBytes(long pos, byte[] bytes)Writes the given array of bytes to theBLOBvalue that thisBlobobject represents, starting at positionpos, and returns the number of bytes written.intSerialBlob. setBytes(long pos, byte[] bytes, int offset, int length)Writes all or part of the givenbytearray to theBLOBvalue that thisBlobobject represents and returns the number of bytes written.WriterSerialClob. setCharacterStream(long pos)Retrieves a stream to be used to write a stream of Unicode characters to theCLOBvalue that thisSerialClobobject represents, at positionpos.booleanSQLInputImpl. wasNull()Ascertains whether the last value read from thisSQLInputImplobject wasnull.voidSQLOutputImpl. writeArray(Array x)Writes anArrayobject in the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeAsciiStream(InputStream x)Writes a stream of ASCII characters to thisSQLOutputImplobject.voidSQLOutputImpl. writeBigDecimal(BigDecimal x)Writes ajava.math.BigDecimalobject in the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeBinaryStream(InputStream x)Writes a stream of uninterpreted bytes to thisSQLOutputImplobject.voidSQLOutputImpl. writeBlob(Blob x)Writes aBlobobject in the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeBoolean(boolean x)Writes abooleanin the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeByte(byte x)Writes abytein the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeBytes(byte[] x)Writes an array ofbytesin the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeCharacterStream(Reader x)Writes a stream of Unicode characters to thisSQLOutputImplobject.voidSQLOutputImpl. writeClob(Clob x)Writes aClobobject in the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeDate(Date x)Writes ajava.sql.Dateobject in the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeDouble(double x)Writes adoublein the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeFloat(float x)Writes afloatin the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeInt(int x)Writes anintin the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeLong(long x)Writes alongin the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeNClob(NClob x)Writes an SQLNCLOBvalue to the stream.voidSQLOutputImpl. writeNString(String x)Writes the next attribute to the stream as aStringin the Java programming language.voidSQLOutputImpl. writeObject(SQLData x)Writes to the stream the data contained in the givenSQLDataobject.voidSQLOutputImpl. writeRef(Ref x)Writes aRefobject in the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeRowId(RowId x)Writes an SQLROWIDvalue to the stream.voidSQLOutputImpl. writeShort(short x)Writes ashortin the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeSQLXML(SQLXML x)Writes an SQLXMLvalue to the stream.voidSQLOutputImpl. writeString(String x)Writes aStringin the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeStruct(Struct x)Writes aStructobject in the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeTime(Time x)Writes ajava.sql.Timeobject in the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeTimestamp(Timestamp x)Writes ajava.sql.Timestampobject in the Java programming language to thisSQLOutputImplobject.voidSQLOutputImpl. writeURL(URL url)Writes anjava.sql.Type.DATALINKobject in the Java programming language to thisSQLOutputImplobject.Constructors in javax.sql.rowset.serial that throw SQLException Constructor Description SerialArray(Array array)Constructs a newSerialArrayobject from the givenArrayobject.SerialArray(Array array, Map<String,Class<?>> map)Constructs a newSerialArrayobject from the givenArrayobject, using the given type map for the custom mapping of each element when the elements are SQL UDTs.SerialBlob(byte[] b)Constructs aSerialBlobobject that is a serialized version of the givenbytearray.SerialBlob(Blob blob)Constructs aSerialBlobobject that is a serialized version of the givenBlobobject.SerialClob(char[] ch)Constructs aSerialClobobject that is a serialized version of the givenchararray.SerialClob(Clob clob)Constructs aSerialClobobject that is a serialized version of the givenClobobject.SerialRef(Ref ref)Constructs aSerialRefobject from the givenRefobject.SQLInputImpl(Object[] attributes, Map<String,Class<?>> map)Creates anSQLInputImplobject initialized with the given array of attributes and the given type map.SQLOutputImpl(Vector<?> attributes, Map<String,?> map)Creates a newSQLOutputImplobject initialized with the given vector of attributes and type map. -
Uses of SQLException in javax.sql.rowset.spi
Subclasses of SQLException in javax.sql.rowset.spi Modifier and Type Class Description classSyncFactoryExceptionIndicates an error withSyncFactorymechanism.classSyncProviderExceptionIndicates an error with theSyncProvidermechanism.Methods in javax.sql.rowset.spi that throw SQLException Modifier and Type Method Description voidTransactionalWriter. commit()Makes permanent all changes that have been performed by theacceptChangesmethod since the last call to either thecommitorrollbackmethods.ObjectSyncResolver. getConflictValue(int index)Retrieves the value in the designated column in the current row of thisSyncResolverobject, which is the value in the data source that caused a conflict.ObjectSyncResolver. getConflictValue(String columnName)Retrieves the value in the designated column in the current row of thisSyncResolverobject, which is the value in the data source that caused a conflict.booleanSyncResolver. nextConflict()Moves the cursor down from its current position to the next row that contains a conflict value.booleanSyncResolver. previousConflict()Moves the cursor up from its current position to the previous conflict row in thisSyncResolverobject.voidXmlReader. readXML(WebRowSet caller, Reader reader)Reads and parses the givenWebRowSetobject from the given input stream in XML format.voidTransactionalWriter. rollback()Undoes all changes made in the current transaction.voidTransactionalWriter. rollback(Savepoint s)Undoes all changes made in the current transaction made prior to the givenSavepointobject.voidSyncResolver. setResolvedValue(int index, Object obj)Sets obj as the value in column index in the current row of theRowSetobject that is being synchronized.voidSyncResolver. setResolvedValue(String columnName, Object obj)Sets obj as the value in column columnName in the current row of theRowSetobject that is being synchronized.voidXmlWriter. writeXML(WebRowSet caller, Writer writer)Writes the givenWebRowSetobject to the specifiedjava.io.Writeroutput stream as an XML document.