Uses of Class
java.sql.SQLException
Package
Description
Provides the API for accessing and processing data stored in a
data source (usually a relational database) using the
Java programming language.
Provides the API for server side data source access and processing from
the Java programming language.
Standard interfaces and base classes for JDBC
RowSet
implementations.Provides utility classes to allow serializable mappings between SQL types
and data types in the Java programming language.
The standard classes and interfaces that a third party vendor has to
use in its implementation of a synchronization provider.
-
Uses of SQLException in java.sql
Modifier and TypeClassDescriptionclass
The subclass ofSQLException
thrown when an error occurs during a batch update operation.class
An exception thrown as aDataTruncation
exception (on writes) or reported as aDataTruncation
warning (on reads) when a data values is unexpectedly truncated for reasons other than its having exceededMaxFieldSize
.class
The subclass ofSQLException
is thrown when one or more client info properties could not be set on aConnection
.class
The subclass ofSQLException
thrown when the SQLState class value is '22', or under vendor-specified conditions.class
The subclass ofSQLException
thrown when the SQLState class value is '0A' ( the value is 'zero' A).class
The subclass ofSQLException
thrown when the SQLState class value is '23', or under vendor-specified conditions.class
The subclass ofSQLException
thrown when the SQLState class value is '28', or under vendor-specified conditions.class
The subclass ofSQLException
thrown for the SQLState class value '08', or under vendor-specified conditions.class
The subclass ofSQLException
thrown when an instance where a retry of the same operation would fail unless the cause of theSQLException
is corrected.class
The subclass ofSQLException
thrown in situations where a previously failed operation might be able to succeed if the application performs some recovery steps and retries the entire transaction or in the case of a distributed transaction, the transaction branch.class
The subclass ofSQLException
thrown when the SQLState class value is '42', or under vendor-specified conditions.class
The subclass ofSQLException
thrown when the timeout specified byStatement.setQueryTimeout
,DriverManager.setLoginTimeout
,DataSource.setLoginTimeout
,XADataSource.setLoginTimeout
has expired.class
The subclass ofSQLException
thrown when the SQLState class value is '40', or under vendor-specified conditions.class
The subclass ofSQLException
for the SQLState class value '08', or under vendor-specified conditions.class
The subclass ofSQLException
is thrown in situations where a previously failed operation might be able to succeed when the operation is retried without any intervention by application-level functionality.class
An exception that provides information on database access warnings.Modifier and TypeMethodDescriptionSQLException.getNextException()
Retrieves the exception chained to thisSQLException
object by setNextException(SQLException ex).Modifier and TypeMethodDescriptionvoid
SQLException.setNextException(SQLException ex)
Adds anSQLException
object to the end of the chain.Modifier and TypeMethodDescriptionvoid
Terminates an open connection.boolean
ResultSet.absolute(int row)
Moves the cursor to the given row number in thisResultSet
object.boolean
Driver.acceptsURL(String url)
Retrieves whether the driver thinks that it can open a connection to the given URL.void
PreparedStatement.addBatch()
Adds a set of parameters to thisPreparedStatement
object's batch of commands.void
Adds the given SQL command to the current list of commands for thisStatement
object.void
ResultSet.afterLast()
Moves the cursor to the end of thisResultSet
object, just after the last row.boolean
DatabaseMetaData.allProceduresAreCallable()
Retrieves whether the current user can call all the procedures returned by the methodgetProcedures
.boolean
DatabaseMetaData.allTablesAreSelectable()
Retrieves whether the current user can use all the tables returned by the methodgetTables
in aSELECT
statement.boolean
DatabaseMetaData.autoCommitFailureClosesAllResultSets()
Retrieves whether aSQLException
while autoCommit istrue
indicates that all open ResultSets are closed, even ones that are holdable.void
ResultSet.beforeFirst()
Moves the cursor to the front of thisResultSet
object, just before the first row.default void
Connection.beginRequest()
Hints to the driver that a request, an independent unit of work, is beginning on this connection.ConnectionBuilder.build()
Returns an instance of the object defined by this builder.ShardingKeyBuilder.build()
Returns an instance of the object defined by this builder.void
Statement.cancel()
Cancels thisStatement
object if both the DBMS and driver support aborting an SQL statement.void
ResultSet.cancelRowUpdates()
Cancels the updates made to the current row in thisResultSet
object.void
Statement.clearBatch()
Empties thisStatement
object's current list of SQL commands.void
PreparedStatement.clearParameters()
Clears the current parameter values immediately.void
Connection.clearWarnings()
Clears all warnings reported for thisConnection
object.void
ResultSet.clearWarnings()
Clears all warnings reported on thisResultSet
object.void
Statement.clearWarnings()
Clears all the warnings reported on thisStatement
object.void
Connection.close()
Releases thisConnection
object's database and JDBC resources immediately instead of waiting for them to be automatically released.void
ResultSet.close()
Releases thisResultSet
object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.void
Statement.close()
Releases thisStatement
object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.void
Statement.closeOnCompletion()
Specifies that thisStatement
will be closed when all its dependent result sets are closed.void
Connection.commit()
Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by thisConnection
object.Driver.connect(String url, Properties info)
Attempts to make a database connection to the given URL.Connection.createArrayOf(String typeName, Object[] elements)
Factory method for creating Array objects.Connection.createBlob()
Constructs an object that implements theBlob
interface.Connection.createClob()
Constructs an object that implements theClob
interface.Connection.createNClob()
Constructs an object that implements theNClob
interface.Connection.createSQLXML()
Constructs an object that implements theSQLXML
interface.Connection.createStatement()
Creates aStatement
object for sending SQL statements to the database.Connection.createStatement(int resultSetType, int resultSetConcurrency)
Creates aStatement
object that will generateResultSet
objects with the given type and concurrency.Connection.createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)
Creates aStatement
object that will generateResultSet
objects with the given type, concurrency, and holdability.Connection.createStruct(String typeName, Object[] attributes)
Factory method for creating Struct objects.boolean
DatabaseMetaData.dataDefinitionCausesTransactionCommit()
Retrieves whether a data definition statement within a transaction forces the transaction to commit.boolean
DatabaseMetaData.dataDefinitionIgnoredInTransactions()
Retrieves whether this database ignores a data definition statement within a transaction.void
ResultSet.deleteRow()
Deletes the current row from thisResultSet
object and from the underlying database.boolean
DatabaseMetaData.deletesAreDetected(int type)
Retrieves whether or not a visible row delete can be detected by calling the methodResultSet.rowDeleted
.static void
DriverManager.deregisterDriver(Driver driver)
Removes the specified driver from theDriverManager
's list of registered drivers.boolean
DatabaseMetaData.doesMaxRowSizeIncludeBlobs()
Retrieves whether the return value for the methodgetMaxRowSize
includes the SQL data typesLONGVARCHAR
andLONGVARBINARY
.default void
Connection.endRequest()
Hints to the driver that a request, an independent unit of work, has completed.default String
Statement.enquoteIdentifier(String identifier, boolean alwaysQuote)
Returns a SQL identifier.default String
Statement.enquoteLiteral(String val)
Returns aString
enclosed in single quotes.default String
Statement.enquoteNCharLiteral(String val)
Returns aString
representing a National Character Set Literal enclosed in single quotes and prefixed with a upper case letter N.boolean
PreparedStatement.execute()
Executes the SQL statement in thisPreparedStatement
object, which may be any kind of SQL statement.boolean
Executes the given SQL statement, which may return multiple results.boolean
Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval.boolean
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.boolean
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.int[]
Statement.executeBatch()
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.default long[]
Statement.executeLargeBatch()
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.default long
PreparedStatement.executeLargeUpdate()
Executes the SQL statement in thisPreparedStatement
object, which must be an SQL Data Manipulation Language (DML) statement, such asINSERT
,UPDATE
orDELETE
; or an SQL statement that returns nothing, such as a DDL statement.default long
Statement.executeLargeUpdate(String sql)
Executes the given SQL statement, which may be anINSERT
,UPDATE
, orDELETE
statement or an SQL statement that returns nothing, such as an SQL DDL statement.default long
Statement.executeLargeUpdate(String sql, int autoGeneratedKeys)
Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by thisStatement
object should be made available for retrieval.default long
Statement.executeLargeUpdate(String sql, int[] columnIndexes)
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.default long
Statement.executeLargeUpdate(String sql, String[] columnNames)
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.PreparedStatement.executeQuery()
Executes the SQL query in thisPreparedStatement
object and returns theResultSet
object generated by the query.Statement.executeQuery(String sql)
Executes the given SQL statement, which returns a singleResultSet
object.int
PreparedStatement.executeUpdate()
Executes the SQL statement in thisPreparedStatement
object, which must be an SQL Data Manipulation Language (DML) statement, such asINSERT
,UPDATE
orDELETE
; or an SQL statement that returns nothing, such as a DDL statement.int
Statement.executeUpdate(String sql)
Executes the given SQL statement, which may be anINSERT
,UPDATE
, orDELETE
statement or an SQL statement that returns nothing, such as an SQL DDL statement.int
Statement.executeUpdate(String sql, int autoGeneratedKeys)
Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by thisStatement
object should be made available for retrieval.int
Statement.executeUpdate(String sql, int[] columnIndexes)
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.int
Statement.executeUpdate(String sql, String[] columnNames)
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.int
ResultSet.findColumn(String columnLabel)
Maps the givenResultSet
column label to itsResultSet
column index.boolean
ResultSet.first()
Moves the cursor to the first row in thisResultSet
object.void
Array.free()
This method frees theArray
object and releases the resources that it holds.void
Blob.free()
This method frees theBlob
object and releases the resources that it holds.void
Clob.free()
This method releases the resources that theClob
object holds.void
SQLXML.free()
This method closes this object and releases the resources that it held.boolean
DatabaseMetaData.generatedKeyAlwaysReturned()
Retrieves whether a generated key will always be returned if the column name(s) or index(es) specified for the auto generated key column(s) are valid and the statement succeeds.Array.getArray()
Retrieves the contents of the SQLARRAY
value designated by thisArray
object in the form of an array in the Java programming language.Array.getArray(long index, int count)
Retrieves a slice of the SQLARRAY
value designated by thisArray
object, beginning with the specifiedindex
and containing up tocount
successive elements of the SQL array.Retrieves a slice of the SQLARRAY
value designated by thisArray
object, beginning with the specifiedindex
and containing up tocount
successive elements of the SQL array.Retrieves the contents of the SQLARRAY
value designated by thisArray
object.CallableStatement.getArray(int parameterIndex)
Retrieves the value of the designated JDBCARRAY
parameter as anArray
object in the Java programming language.Retrieves the value of a JDBCARRAY
parameter as anArray
object in the Java programming language.ResultSet.getArray(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as anArray
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as anArray
object in the Java programming language.Clob.getAsciiStream()
Retrieves theCLOB
value designated by thisClob
object as an ascii stream.ResultSet.getAsciiStream(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as a stream of ASCII characters.ResultSet.getAsciiStream(String columnLabel)
Retrieves the value of the designated column in the current row of thisResultSet
object as a stream of ASCII characters.DatabaseMetaData.getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)
Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog.Object[]
Struct.getAttributes()
Produces the ordered values of the attributes of the SQL structured type that thisStruct
object represents.Object[]
Struct.getAttributes(Map<String,Class<?>> map)
Produces the ordered values of the attributes of the SQL structured type that thisStruct
object represents.boolean
Connection.getAutoCommit()
Retrieves the current auto-commit mode for thisConnection
object.int
Array.getBaseType()
Retrieves the JDBC type of the elements in the array designated by thisArray
object.Array.getBaseTypeName()
Retrieves the SQL type name of the elements in the array designated by thisArray
object.Ref.getBaseTypeName()
Retrieves the fully-qualified SQL name of the SQL structured type that thisRef
object references.DatabaseMetaData.getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)
Retrieves a description of a table's optimal set of columns that uniquely identifies a row.CallableStatement.getBigDecimal(int parameterIndex)
Retrieves the value of the designated JDBCNUMERIC
parameter as ajava.math.BigDecimal
object with as many digits to the right of the decimal point as the value contains.CallableStatement.getBigDecimal(int parameterIndex, int scale)
Deprecated.CallableStatement.getBigDecimal(String parameterName)
Retrieves the value of a JDBCNUMERIC
parameter as ajava.math.BigDecimal
object with as many digits to the right of the decimal point as the value contains.ResultSet.getBigDecimal(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.math.BigDecimal
with full precision.ResultSet.getBigDecimal(int columnIndex, int scale)
Deprecated.UsegetBigDecimal(int columnIndex)
orgetBigDecimal(String columnLabel)
ResultSet.getBigDecimal(String columnLabel)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.math.BigDecimal
with full precision.ResultSet.getBigDecimal(String columnLabel, int scale)
Deprecated.UsegetBigDecimal(int columnIndex)
orgetBigDecimal(String columnLabel)
Blob.getBinaryStream()
Retrieves theBLOB
value designated by thisBlob
instance as a stream.Blob.getBinaryStream(long pos, long length)
Returns anInputStream
object that contains a partialBlob
value, starting with the byte specified by pos, which is length bytes in length.ResultSet.getBinaryStream(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as a stream of uninterpreted bytes.ResultSet.getBinaryStream(String columnLabel)
Retrieves the value of the designated column in the current row of thisResultSet
object as a stream of uninterpretedbyte
s.SQLXML.getBinaryStream()
Retrieves the XML value designated by this SQLXML instance as a stream.CallableStatement.getBlob(int parameterIndex)
Retrieves the value of the designated JDBCBLOB
parameter as aBlob
object in the Java programming language.Retrieves the value of a JDBCBLOB
parameter as aBlob
object in the Java programming language.ResultSet.getBlob(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as aBlob
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as aBlob
object in the Java programming language.boolean
CallableStatement.getBoolean(int parameterIndex)
Retrieves the value of the designated JDBCBIT
orBOOLEAN
parameter as aboolean
in the Java programming language.boolean
CallableStatement.getBoolean(String parameterName)
Retrieves the value of a JDBCBIT
orBOOLEAN
parameter as aboolean
in the Java programming language.boolean
ResultSet.getBoolean(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as aboolean
in the Java programming language.boolean
ResultSet.getBoolean(String columnLabel)
Retrieves the value of the designated column in the current row of thisResultSet
object as aboolean
in the Java programming language.byte
CallableStatement.getByte(int parameterIndex)
Retrieves the value of the designated JDBCTINYINT
parameter as abyte
in the Java programming language.byte
Retrieves the value of a JDBCTINYINT
parameter as abyte
in the Java programming language.byte
ResultSet.getByte(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as abyte
in the Java programming language.byte
Retrieves the value of the designated column in the current row of thisResultSet
object as abyte
in the Java programming language.byte[]
Blob.getBytes(long pos, int length)
Retrieves all or part of theBLOB
value that thisBlob
object represents, as an array of bytes.byte[]
CallableStatement.getBytes(int parameterIndex)
Retrieves the value of the designated JDBCBINARY
orVARBINARY
parameter as an array ofbyte
values in the Java programming language.byte[]
Retrieves the value of a JDBCBINARY
orVARBINARY
parameter as an array ofbyte
values in the Java programming language.byte[]
ResultSet.getBytes(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as abyte
array in the Java programming language.byte[]
Retrieves the value of the designated column in the current row of thisResultSet
object as abyte
array in the Java programming language.Connection.getCatalog()
Retrieves thisConnection
object's current catalog name.ResultSetMetaData.getCatalogName(int column)
Gets the designated column's table's catalog name.DatabaseMetaData.getCatalogs()
Retrieves the catalog names available in this database.DatabaseMetaData.getCatalogSeparator()
Retrieves theString
that this database uses as the separator between a catalog and table name.DatabaseMetaData.getCatalogTerm()
Retrieves the database vendor's preferred term for "catalog".CallableStatement.getCharacterStream(int parameterIndex)
Retrieves the value of the designated parameter as ajava.io.Reader
object in the Java programming language.CallableStatement.getCharacterStream(String parameterName)
Retrieves the value of the designated parameter as ajava.io.Reader
object in the Java programming language.Clob.getCharacterStream()
Retrieves theCLOB
value designated by thisClob
object as ajava.io.Reader
object (or as a stream of characters).Clob.getCharacterStream(long pos, long length)
Returns aReader
object that contains a partialClob
value, starting with the character specified by pos, which is length characters in length.ResultSet.getCharacterStream(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.io.Reader
object.ResultSet.getCharacterStream(String columnLabel)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.io.Reader
object.SQLXML.getCharacterStream()
Retrieves the XML value designated by this SQLXML instance as a java.io.Reader object.Connection.getClientInfo()
Returns a list containing the name and current value of each client info property supported by the driver.Connection.getClientInfo(String name)
Returns the value of the client info property specified by name.DatabaseMetaData.getClientInfoProperties()
Retrieves a list of the client info properties that the driver supports.CallableStatement.getClob(int parameterIndex)
Retrieves the value of the designated JDBCCLOB
parameter as ajava.sql.Clob
object in the Java programming language.Retrieves the value of a JDBCCLOB
parameter as ajava.sql.Clob
object in the Java programming language.ResultSet.getClob(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as aClob
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as aClob
object in the Java programming language.ResultSetMetaData.getColumnClassName(int column)
Returns the fully-qualified name of the Java class whose instances are manufactured if the methodResultSet.getObject
is called to retrieve a value from the column.int
ResultSetMetaData.getColumnCount()
Returns the number of columns in thisResultSet
object.int
ResultSetMetaData.getColumnDisplaySize(int column)
Indicates the designated column's normal maximum width in characters.ResultSetMetaData.getColumnLabel(int column)
Gets the designated column's suggested title for use in printouts and displays.ResultSetMetaData.getColumnName(int column)
Get the designated column's name.DatabaseMetaData.getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)
Retrieves a description of the access rights for a table's columns.DatabaseMetaData.getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
Retrieves a description of table columns available in the specified catalog.int
ResultSetMetaData.getColumnType(int column)
Retrieves the designated column's SQL type.ResultSetMetaData.getColumnTypeName(int column)
Retrieves the designated column's database-specific type name.int
ResultSet.getConcurrency()
Retrieves the concurrency mode of thisResultSet
object.DatabaseMetaData.getConnection()
Retrieves the connection that produced this metadata object.static Connection
DriverManager.getConnection(String url)
Attempts to establish a connection to the given database URL.static Connection
DriverManager.getConnection(String url, String user, String password)
Attempts to establish a connection to the given database URL.static Connection
DriverManager.getConnection(String url, Properties info)
Attempts to establish a connection to the given database URL.Statement.getConnection()
Retrieves theConnection
object that produced thisStatement
object.DatabaseMetaData.getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable)
Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table).ResultSet.getCursorName()
Retrieves the name of the SQL cursor used by thisResultSet
object.int
DatabaseMetaData.getDatabaseMajorVersion()
Retrieves the major version number of the underlying database.int
DatabaseMetaData.getDatabaseMinorVersion()
Retrieves the minor version number of the underlying database.DatabaseMetaData.getDatabaseProductName()
Retrieves the name of this database product.DatabaseMetaData.getDatabaseProductVersion()
Retrieves the version number of this database product.CallableStatement.getDate(int parameterIndex)
Retrieves the value of the designated JDBCDATE
parameter as ajava.sql.Date
object.Retrieves the value of the designated JDBCDATE
parameter as ajava.sql.Date
object, using the givenCalendar
object to construct the date.Retrieves the value of a JDBCDATE
parameter as ajava.sql.Date
object.Retrieves the value of a JDBCDATE
parameter as ajava.sql.Date
object, using the givenCalendar
object to construct the date.ResultSet.getDate(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.Date
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.Date
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.Date
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.Date
object in the Java programming language.int
DatabaseMetaData.getDefaultTransactionIsolation()
Retrieves this database's default transaction isolation level.double
CallableStatement.getDouble(int parameterIndex)
Retrieves the value of the designated JDBCDOUBLE
parameter as adouble
in the Java programming language.double
Retrieves the value of a JDBCDOUBLE
parameter as adouble
in the Java programming language.double
ResultSet.getDouble(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as adouble
in the Java programming language.double
Retrieves the value of the designated column in the current row of thisResultSet
object as adouble
in the Java programming language.static Driver
Attempts to locate a driver that understands the given URL.DatabaseMetaData.getDriverName()
Retrieves the name of this JDBC driver.DatabaseMetaData.getDriverVersion()
Retrieves the version number of this JDBC driver as aString
.DatabaseMetaData.getExportedKeys(String catalog, String schema, String table)
Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).DatabaseMetaData.getExtraNameCharacters()
Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).int
ResultSet.getFetchDirection()
Retrieves the fetch direction for thisResultSet
object.int
Statement.getFetchDirection()
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from thisStatement
object.int
ResultSet.getFetchSize()
Retrieves the fetch size for thisResultSet
object.int
Statement.getFetchSize()
Retrieves the number of result set rows that is the default fetch size forResultSet
objects generated from thisStatement
object.float
CallableStatement.getFloat(int parameterIndex)
Retrieves the value of the designated JDBCFLOAT
parameter as afloat
in the Java programming language.float
Retrieves the value of a JDBCFLOAT
parameter as afloat
in the Java programming language.float
ResultSet.getFloat(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as afloat
in the Java programming language.float
Retrieves the value of the designated column in the current row of thisResultSet
object as afloat
in the Java programming language.DatabaseMetaData.getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern)
Retrieves a description of the given catalog's system or user function parameters and return type.DatabaseMetaData.getFunctions(String catalog, String schemaPattern, String functionNamePattern)
Retrieves a description of the system and user functions available in the given catalog.Statement.getGeneratedKeys()
Retrieves any auto-generated keys created as a result of executing thisStatement
object.int
Connection.getHoldability()
Retrieves the current holdability ofResultSet
objects created using thisConnection
object.int
ResultSet.getHoldability()
Retrieves the holdability of thisResultSet
objectDatabaseMetaData.getIdentifierQuoteString()
Retrieves the string used to quote SQL identifiers.DatabaseMetaData.getImportedKeys(String catalog, String schema, String table)
Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a table).DatabaseMetaData.getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)
Retrieves a description of the given table's indices and statistics.int
CallableStatement.getInt(int parameterIndex)
Retrieves the value of the designated JDBCINTEGER
parameter as anint
in the Java programming language.int
Retrieves the value of a JDBCINTEGER
parameter as anint
in the Java programming language.int
ResultSet.getInt(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as anint
in the Java programming language.int
Retrieves the value of the designated column in the current row of thisResultSet
object as anint
in the Java programming language.int
DatabaseMetaData.getJDBCMajorVersion()
Retrieves the major JDBC version number for this driver.int
DatabaseMetaData.getJDBCMinorVersion()
Retrieves the minor JDBC version number for this driver.default long
Statement.getLargeMaxRows()
Retrieves the maximum number of rows that aResultSet
object produced by thisStatement
object can contain.default long
Statement.getLargeUpdateCount()
Retrieves the current result as an update count; if the result is aResultSet
object or there are no more results, -1 is returned.long
CallableStatement.getLong(int parameterIndex)
Retrieves the value of the designated JDBCBIGINT
parameter as along
in the Java programming language.long
Retrieves the value of a JDBCBIGINT
parameter as along
in the Java programming language.long
ResultSet.getLong(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as along
in the Java programming language.long
Retrieves the value of the designated column in the current row of thisResultSet
object as along
in the Java programming language.int
DatabaseMetaData.getMaxBinaryLiteralLength()
Retrieves the maximum number of hex characters this database allows in an inline binary literal.int
DatabaseMetaData.getMaxCatalogNameLength()
Retrieves the maximum number of characters that this database allows in a catalog name.int
DatabaseMetaData.getMaxCharLiteralLength()
Retrieves the maximum number of characters this database allows for a character literal.int
DatabaseMetaData.getMaxColumnNameLength()
Retrieves the maximum number of characters this database allows for a column name.int
DatabaseMetaData.getMaxColumnsInGroupBy()
Retrieves the maximum number of columns this database allows in aGROUP BY
clause.int
DatabaseMetaData.getMaxColumnsInIndex()
Retrieves the maximum number of columns this database allows in an index.int
DatabaseMetaData.getMaxColumnsInOrderBy()
Retrieves the maximum number of columns this database allows in anORDER BY
clause.int
DatabaseMetaData.getMaxColumnsInSelect()
Retrieves the maximum number of columns this database allows in aSELECT
list.int
DatabaseMetaData.getMaxColumnsInTable()
Retrieves the maximum number of columns this database allows in a table.int
DatabaseMetaData.getMaxConnections()
Retrieves the maximum number of concurrent connections to this database that are possible.int
DatabaseMetaData.getMaxCursorNameLength()
Retrieves the maximum number of characters that this database allows in a cursor name.int
Statement.getMaxFieldSize()
Retrieves the maximum number of bytes that can be returned for character and binary column values in aResultSet
object produced by thisStatement
object.int
DatabaseMetaData.getMaxIndexLength()
Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.default long
DatabaseMetaData.getMaxLogicalLobSize()
Retrieves the maximum number of bytes this database allows for the logical size for aLOB
.int
DatabaseMetaData.getMaxProcedureNameLength()
Retrieves the maximum number of characters that this database allows in a procedure name.int
Statement.getMaxRows()
Retrieves the maximum number of rows that aResultSet
object produced by thisStatement
object can contain.int
DatabaseMetaData.getMaxRowSize()
Retrieves the maximum number of bytes this database allows in a single row.int
DatabaseMetaData.getMaxSchemaNameLength()
Retrieves the maximum number of characters that this database allows in a schema name.int
DatabaseMetaData.getMaxStatementLength()
Retrieves the maximum number of characters this database allows in an SQL statement.int
DatabaseMetaData.getMaxStatements()
Retrieves the maximum number of active statements to this database that can be open at the same time.int
DatabaseMetaData.getMaxTableNameLength()
Retrieves the maximum number of characters this database allows in a table name.int
DatabaseMetaData.getMaxTablesInSelect()
Retrieves the maximum number of tables this database allows in aSELECT
statement.int
DatabaseMetaData.getMaxUserNameLength()
Retrieves the maximum number of characters this database allows in a user name.Connection.getMetaData()
Retrieves aDatabaseMetaData
object that contains metadata about the database to which thisConnection
object represents a connection.PreparedStatement.getMetaData()
Retrieves aResultSetMetaData
object that contains information about the columns of theResultSet
object that will be returned when thisPreparedStatement
object is executed.ResultSet.getMetaData()
Retrieves the number, types and properties of thisResultSet
object's columns.boolean
Statement.getMoreResults()
Moves to thisStatement
object's next result, returnstrue
if it is aResultSet
object, and implicitly closes any currentResultSet
object(s) obtained with the methodgetResultSet
.boolean
Statement.getMoreResults(int current)
Moves to thisStatement
object's next result, deals with any currentResultSet
object(s) according to the instructions specified by the given flag, and returnstrue
if the next result is aResultSet
object.CallableStatement.getNCharacterStream(int parameterIndex)
Retrieves the value of the designated parameter as ajava.io.Reader
object in the Java programming language.CallableStatement.getNCharacterStream(String parameterName)
Retrieves the value of the designated parameter as ajava.io.Reader
object in the Java programming language.ResultSet.getNCharacterStream(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.io.Reader
object.ResultSet.getNCharacterStream(String columnLabel)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.io.Reader
object.CallableStatement.getNClob(int parameterIndex)
Retrieves the value of the designated JDBCNCLOB
parameter as ajava.sql.NClob
object in the Java programming language.Retrieves the value of a JDBCNCLOB
parameter as ajava.sql.NClob
object in the Java programming language.ResultSet.getNClob(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as aNClob
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as aNClob
object in the Java programming language.int
Connection.getNetworkTimeout()
Retrieves the number of milliseconds the driver will wait for a database request to complete.CallableStatement.getNString(int parameterIndex)
Retrieves the value of the designatedNCHAR
,NVARCHAR
orLONGNVARCHAR
parameter as aString
in the Java programming language.CallableStatement.getNString(String parameterName)
Retrieves the value of the designatedNCHAR
,NVARCHAR
orLONGNVARCHAR
parameter as aString
in the Java programming language.ResultSet.getNString(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as aString
in the Java programming language.ResultSet.getNString(String columnLabel)
Retrieves the value of the designated column in the current row of thisResultSet
object as aString
in the Java programming language.DatabaseMetaData.getNumericFunctions()
Retrieves a comma-separated list of math functions available with this database.CallableStatement.getObject(int parameterIndex)
Retrieves the value of the designated parameter as anObject
in the Java programming language.<T> T
Returns an object representing the value of OUT parameterparameterIndex
and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.Returns an object representing the value of OUT parameterparameterIndex
and usesmap
for the custom mapping of the parameter value.Retrieves the value of a parameter as anObject
in the Java programming language.<T> T
Returns an object representing the value of OUT parameterparameterName
and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.Returns an object representing the value of OUT parameterparameterName
and usesmap
for the custom mapping of the parameter value.Ref.getObject()
Retrieves the SQL structured type instance referenced by thisRef
object.Retrieves the referenced object and maps it to a Java type using the given type map.ResultSet.getObject(int columnIndex)
Gets the value of the designated column in the current row of thisResultSet
object as anObject
in the Java programming language.<T> T
Retrieves the value of the designated column in the current row of thisResultSet
object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.Retrieves the value of the designated column in the current row of thisResultSet
object as anObject
in the Java programming language.Gets the value of the designated column in the current row of thisResultSet
object as anObject
in the Java programming language.<T> T
Retrieves the value of the designated column in the current row of thisResultSet
object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.Retrieves the value of the designated column in the current row of thisResultSet
object as anObject
in the Java programming language.ParameterMetaData.getParameterClassName(int param)
Retrieves the fully-qualified name of the Java class whose instances should be passed to the methodPreparedStatement.setObject
.int
ParameterMetaData.getParameterCount()
Retrieves the number of parameters in thePreparedStatement
object for which thisParameterMetaData
object contains information.PreparedStatement.getParameterMetaData()
Retrieves the number, types and properties of thisPreparedStatement
object's parameters.int
ParameterMetaData.getParameterMode(int param)
Retrieves the designated parameter's mode.int
ParameterMetaData.getParameterType(int param)
Retrieves the designated parameter's SQL type.ParameterMetaData.getParameterTypeName(int param)
Retrieves the designated parameter's database-specific type name.int
ParameterMetaData.getPrecision(int param)
Retrieves the designated parameter's specified column size.int
ResultSetMetaData.getPrecision(int column)
Get the designated column's specified column size.DatabaseMetaData.getPrimaryKeys(String catalog, String schema, String table)
Retrieves a description of the given table's primary key columns.DatabaseMetaData.getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)
Retrieves a description of the given catalog's stored procedure parameter and result columns.DatabaseMetaData.getProcedures(String catalog, String schemaPattern, String procedureNamePattern)
Retrieves a description of the stored procedures available in the given catalog.DatabaseMetaData.getProcedureTerm()
Retrieves the database vendor's preferred term for "procedure".Driver.getPropertyInfo(String url, Properties info)
Gets information about the possible properties for this driver.DatabaseMetaData.getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
Retrieves a description of the pseudo or hidden columns available in a given table within the specified catalog and schema.int
Statement.getQueryTimeout()
Retrieves the number of seconds the driver will wait for aStatement
object to execute.CallableStatement.getRef(int parameterIndex)
Retrieves the value of the designated JDBCREF(<structured-type>)
parameter as aRef
object in the Java programming language.Retrieves the value of a JDBCREF(<structured-type>)
parameter as aRef
object in the Java programming language.ResultSet.getRef(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as aRef
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as aRef
object in the Java programming language.Array.getResultSet()
Retrieves a result set that contains the elements of the SQLARRAY
value designated by thisArray
object.Array.getResultSet(long index, int count)
Retrieves a result set holding the elements of the subarray that starts at indexindex
and contains up tocount
successive elements.Array.getResultSet(long index, int count, Map<String,Class<?>> map)
Retrieves a result set holding the elements of the subarray that starts at indexindex
and contains up tocount
successive elements.Array.getResultSet(Map<String,Class<?>> map)
Retrieves a result set that contains the elements of the SQLARRAY
value designated by thisArray
object.Statement.getResultSet()
Retrieves the current result as aResultSet
object.int
Statement.getResultSetConcurrency()
Retrieves the result set concurrency forResultSet
objects generated by thisStatement
object.int
DatabaseMetaData.getResultSetHoldability()
Retrieves this database's default holdability forResultSet
objects.int
Statement.getResultSetHoldability()
Retrieves the result set holdability forResultSet
objects generated by thisStatement
object.int
Statement.getResultSetType()
Retrieves the result set type forResultSet
objects generated by thisStatement
object.int
ResultSet.getRow()
Retrieves the current row number.CallableStatement.getRowId(int parameterIndex)
Retrieves the value of the designated JDBCROWID
parameter as ajava.sql.RowId
object.Retrieves the value of the designated JDBCROWID
parameter as ajava.sql.RowId
object.ResultSet.getRowId(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.RowId
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.RowId
object in the Java programming language.DatabaseMetaData.getRowIdLifetime()
Indicates whether this data source supports the SQLROWID
type, and the lifetime for which aRowId
object remains valid.int
Savepoint.getSavepointId()
Retrieves the generated ID for the savepoint that thisSavepoint
object represents.Savepoint.getSavepointName()
Retrieves the name of the savepoint that thisSavepoint
object represents.int
ParameterMetaData.getScale(int param)
Retrieves the designated parameter's number of digits to right of the decimal point. 0 is returned for data types where the scale is not applicable.int
ResultSetMetaData.getScale(int column)
Gets the designated column's number of digits to right of the decimal point. 0 is returned for data types where the scale is not applicable.Connection.getSchema()
Retrieves thisConnection
object's current schema name.ResultSetMetaData.getSchemaName(int column)
Get the designated column's table's schema.DatabaseMetaData.getSchemas()
Retrieves the schema names available in this database.DatabaseMetaData.getSchemas(String catalog, String schemaPattern)
Retrieves the schema names available in this database.DatabaseMetaData.getSchemaTerm()
Retrieves the database vendor's preferred term for "schema".DatabaseMetaData.getSearchStringEscape()
Retrieves the string that can be used to escape wildcard characters.short
CallableStatement.getShort(int parameterIndex)
Retrieves the value of the designated JDBCSMALLINT
parameter as ashort
in the Java programming language.short
Retrieves the value of a JDBCSMALLINT
parameter as ashort
in the Java programming language.short
ResultSet.getShort(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as ashort
in the Java programming language.short
Retrieves the value of the designated column in the current row of thisResultSet
object as ashort
in the Java programming language.<T extends Source>
TReturns a Source for reading the XML value designated by this SQLXML instance.DatabaseMetaData.getSQLKeywords()
Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.int
DatabaseMetaData.getSQLStateType()
Indicates whether the SQLSTATE returned bySQLException.getSQLState
is X/Open (now known as Open Group) SQL CLI or SQL:2003.SQLData.getSQLTypeName()
Returns the fully-qualified name of the SQL user-defined type that this object represents.Struct.getSQLTypeName()
Retrieves the SQL type name of the SQL structured type that thisStruct
object represents.CallableStatement.getSQLXML(int parameterIndex)
Retrieves the value of the designatedSQL XML
parameter as ajava.sql.SQLXML
object in the Java programming language.Retrieves the value of the designatedSQL XML
parameter as ajava.sql.SQLXML
object in the Java programming language.ResultSet.getSQLXML(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
as ajava.sql.SQLXML
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
as ajava.sql.SQLXML
object in the Java programming language.ResultSet.getStatement()
Retrieves theStatement
object that produced thisResultSet
object.CallableStatement.getString(int parameterIndex)
Retrieves the value of the designated JDBCCHAR
,VARCHAR
, orLONGVARCHAR
parameter as aString
in the Java programming language.Retrieves the value of a JDBCCHAR
,VARCHAR
, orLONGVARCHAR
parameter as aString
in the Java programming language.ResultSet.getString(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as aString
in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as aString
in the Java programming language.SQLXML.getString()
Returns a string representation of the XML value designated by this SQLXML instance.DatabaseMetaData.getStringFunctions()
Retrieves a comma-separated list of string functions available with this database.Clob.getSubString(long pos, int length)
Retrieves a copy of the specified substring in theCLOB
value designated by thisClob
object.DatabaseMetaData.getSuperTables(String catalog, String schemaPattern, String tableNamePattern)
Retrieves a description of the table hierarchies defined in a particular schema in this database.DatabaseMetaData.getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)
Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database.DatabaseMetaData.getSystemFunctions()
Retrieves a comma-separated list of system functions available with this database.ResultSetMetaData.getTableName(int column)
Gets the designated column's table name.DatabaseMetaData.getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
Retrieves a description of the access rights for each table available in a catalog.DatabaseMetaData.getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)
Retrieves a description of the tables available in the given catalog.DatabaseMetaData.getTableTypes()
Retrieves the table types available in this database.CallableStatement.getTime(int parameterIndex)
Retrieves the value of the designated JDBCTIME
parameter as ajava.sql.Time
object.Retrieves the value of the designated JDBCTIME
parameter as ajava.sql.Time
object, using the givenCalendar
object to construct the time.Retrieves the value of a JDBCTIME
parameter as ajava.sql.Time
object.Retrieves the value of a JDBCTIME
parameter as ajava.sql.Time
object, using the givenCalendar
object to construct the time.ResultSet.getTime(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.Time
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.Time
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.Time
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.Time
object in the Java programming language.DatabaseMetaData.getTimeDateFunctions()
Retrieves a comma-separated list of the time and date functions available with this database.CallableStatement.getTimestamp(int parameterIndex)
Retrieves the value of the designated JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object.CallableStatement.getTimestamp(int parameterIndex, Calendar cal)
Retrieves the value of the designated JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object, using the givenCalendar
object to construct theTimestamp
object.CallableStatement.getTimestamp(String parameterName)
Retrieves the value of a JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object.CallableStatement.getTimestamp(String parameterName, Calendar cal)
Retrieves the value of a JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object, using the givenCalendar
object to construct theTimestamp
object.ResultSet.getTimestamp(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.Timestamp
object in the Java programming language.ResultSet.getTimestamp(int columnIndex, Calendar cal)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.Timestamp
object in the Java programming language.ResultSet.getTimestamp(String columnLabel)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.Timestamp
object in the Java programming language.ResultSet.getTimestamp(String columnLabel, Calendar cal)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.Timestamp
object in the Java programming language.int
Connection.getTransactionIsolation()
Retrieves thisConnection
object's current transaction isolation level.int
ResultSet.getType()
Retrieves the type of thisResultSet
object.DatabaseMetaData.getTypeInfo()
Retrieves a description of all the data types supported by this database.Connection.getTypeMap()
Retrieves theMap
object associated with thisConnection
object.DatabaseMetaData.getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)
Retrieves a description of the user-defined types (UDTs) defined in a particular schema.ResultSet.getUnicodeStream(int columnIndex)
Deprecated.usegetCharacterStream
in place ofgetUnicodeStream
ResultSet.getUnicodeStream(String columnLabel)
Deprecated.usegetCharacterStream
insteadint
Statement.getUpdateCount()
Retrieves the current result as an update count; if the result is aResultSet
object or there are no more results, -1 is returned.CallableStatement.getURL(int parameterIndex)
Retrieves the value of the designated JDBCDATALINK
parameter as ajava.net.URL
object.Retrieves the value of a JDBCDATALINK
parameter as ajava.net.URL
object.DatabaseMetaData.getURL()
Retrieves the URL for this DBMS.ResultSet.getURL(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.net.URL
object in the Java programming language.Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.net.URL
object in the Java programming language.DatabaseMetaData.getUserName()
Retrieves the user name as known to this database.DatabaseMetaData.getVersionColumns(String catalog, String schema, String table)
Retrieves a description of a table's columns that are automatically updated when any value in a row is updated.Connection.getWarnings()
Retrieves the first warning reported by calls on thisConnection
object.ResultSet.getWarnings()
Retrieves the first warning reported by calls on thisResultSet
object.Statement.getWarnings()
Retrieves the first warning reported by calls on thisStatement
object.void
ResultSet.insertRow()
Inserts the contents of the insert row into thisResultSet
object and into the database.boolean
DatabaseMetaData.insertsAreDetected(int type)
Retrieves whether or not a visible row insert can be detected by calling the methodResultSet.rowInserted
.boolean
ResultSet.isAfterLast()
Retrieves whether the cursor is after the last row in thisResultSet
object.boolean
ResultSetMetaData.isAutoIncrement(int column)
Indicates whether the designated column is automatically numbered.boolean
ResultSet.isBeforeFirst()
Retrieves whether the cursor is before the first row in thisResultSet
object.boolean
ResultSetMetaData.isCaseSensitive(int column)
Indicates whether a column's case matters.boolean
DatabaseMetaData.isCatalogAtStart()
Retrieves whether a catalog appears at the start of a fully qualified table name.boolean
Connection.isClosed()
Retrieves whether thisConnection
object has been closed.boolean
ResultSet.isClosed()
Retrieves whether thisResultSet
object has been closed.boolean
Statement.isClosed()
Retrieves whether thisStatement
object has been closed.boolean
Statement.isCloseOnCompletion()
Returns a value indicating whether thisStatement
will be closed when all its dependent result sets are closed.boolean
ResultSetMetaData.isCurrency(int column)
Indicates whether the designated column is a cash value.boolean
ResultSetMetaData.isDefinitelyWritable(int column)
Indicates whether a write on the designated column will definitely succeed.boolean
ResultSet.isFirst()
Retrieves whether the cursor is on the first row of thisResultSet
object.boolean
ResultSet.isLast()
Retrieves whether the cursor is on the last row of thisResultSet
object.int
ParameterMetaData.isNullable(int param)
Retrieves whether null values are allowed in the designated parameter.int
ResultSetMetaData.isNullable(int column)
Indicates the nullability of values in the designated column.boolean
Statement.isPoolable()
Returns a value indicating whether theStatement
is poolable or not.boolean
Connection.isReadOnly()
Retrieves whether thisConnection
object is in read-only mode.boolean
DatabaseMetaData.isReadOnly()
Retrieves whether this database is in read-only mode.boolean
ResultSetMetaData.isReadOnly(int column)
Indicates whether the designated column is definitely not writable.boolean
ResultSetMetaData.isSearchable(int column)
Indicates whether the designated column can be used in a where clause.boolean
ParameterMetaData.isSigned(int param)
Retrieves whether values for the designated parameter can be signed numbers.boolean
ResultSetMetaData.isSigned(int column)
Indicates whether values in the designated column are signed numbers.default boolean
Statement.isSimpleIdentifier(String identifier)
Retrieves whetheridentifier
is a simple SQL identifier.boolean
Connection.isValid(int timeout)
Returns true if the connection has not been closed and is still valid.boolean
Wrapper.isWrapperFor(Class<?> iface)
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.boolean
ResultSetMetaData.isWritable(int column)
Indicates whether it is possible for a write on the designated column to succeed.boolean
ResultSet.last()
Moves the cursor to the last row in thisResultSet
object.long
Blob.length()
Returns the number of bytes in theBLOB
value designated by thisBlob
object.long
Clob.length()
Retrieves the number of characters in theCLOB
value designated by thisClob
object.boolean
DatabaseMetaData.locatorsUpdateCopy()
Indicates whether updates made to a LOB are made on a copy or directly to the LOB.void
ResultSet.moveToCurrentRow()
Moves the cursor to the remembered cursor position, usually the current row.void
ResultSet.moveToInsertRow()
Moves the cursor to the insert row.Converts the given SQL statement into the system's native SQL grammar.boolean
ResultSet.next()
Moves the cursor forward one row from its current position.boolean
DatabaseMetaData.nullPlusNonNullIsNull()
Retrieves whether this database supports concatenations betweenNULL
and non-NULL
values beingNULL
.boolean
DatabaseMetaData.nullsAreSortedAtEnd()
Retrieves whetherNULL
values are sorted at the end regardless of sort order.boolean
DatabaseMetaData.nullsAreSortedAtStart()
Retrieves whetherNULL
values are sorted at the start regardless of sort order.boolean
DatabaseMetaData.nullsAreSortedHigh()
Retrieves whetherNULL
values are sorted high.boolean
DatabaseMetaData.nullsAreSortedLow()
Retrieves whetherNULL
values are sorted low.boolean
DatabaseMetaData.othersDeletesAreVisible(int type)
Retrieves whether deletes made by others are visible.boolean
DatabaseMetaData.othersInsertsAreVisible(int type)
Retrieves whether inserts made by others are visible.boolean
DatabaseMetaData.othersUpdatesAreVisible(int type)
Retrieves whether updates made by others are visible.boolean
DatabaseMetaData.ownDeletesAreVisible(int type)
Retrieves whether a result set's own deletes are visible.boolean
DatabaseMetaData.ownInsertsAreVisible(int type)
Retrieves whether a result set's own inserts are visible.boolean
DatabaseMetaData.ownUpdatesAreVisible(int type)
Retrieves whether for the given type ofResultSet
object, the result set's own updates are visible.long
Blob.position(byte[] pattern, long start)
Retrieves the byte position at which the specified byte arraypattern
begins within theBLOB
value that thisBlob
object represents.long
Retrieves the byte position in theBLOB
value designated by thisBlob
object at whichpattern
begins.long
Retrieves the character position at which the specified substringsearchstr
appears in the SQLCLOB
value represented by thisClob
object.long
Retrieves the character position at which the specifiedClob
objectsearchstr
appears in thisClob
object.Connection.prepareCall(String sql)
Creates aCallableStatement
object for calling database stored procedures.Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency)
Creates aCallableStatement
object that will generateResultSet
objects with the given type and concurrency.Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
Creates aCallableStatement
object that will generateResultSet
objects with the given type and concurrency.Connection.prepareStatement(String sql)
Creates aPreparedStatement
object for sending parameterized SQL statements to the database.Connection.prepareStatement(String sql, int autoGeneratedKeys)
Creates a defaultPreparedStatement
object that has the capability to retrieve auto-generated keys.Connection.prepareStatement(String sql, int[] columnIndexes)
Creates a defaultPreparedStatement
object capable of returning the auto-generated keys designated by the given array.Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency)
Creates aPreparedStatement
object that will generateResultSet
objects with the given type and concurrency.Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
Creates aPreparedStatement
object that will generateResultSet
objects with the given type, concurrency, and holdability.Connection.prepareStatement(String sql, String[] columnNames)
Creates a defaultPreparedStatement
object capable of returning the auto-generated keys designated by the given array.boolean
ResultSet.previous()
Moves the cursor to the previous row in thisResultSet
object.SQLInput.readArray()
Reads an SQLARRAY
value from the stream and returns it as anArray
object in the Java programming language.SQLInput.readAsciiStream()
Reads the next attribute in the stream and returns it as a stream of ASCII characters.SQLInput.readBigDecimal()
Reads the next attribute in the stream and returns it as ajava.math.BigDecimal
object in the Java programming language.SQLInput.readBinaryStream()
Reads the next attribute in the stream and returns it as a stream of uninterpreted bytes.SQLInput.readBlob()
Reads an SQLBLOB
value from the stream and returns it as aBlob
object in the Java programming language.boolean
SQLInput.readBoolean()
Reads the next attribute in the stream and returns it as aboolean
in the Java programming language.byte
SQLInput.readByte()
Reads the next attribute in the stream and returns it as abyte
in the Java programming language.byte[]
SQLInput.readBytes()
Reads the next attribute in the stream and returns it as an array of bytes in the Java programming language.SQLInput.readCharacterStream()
Reads the next attribute in the stream and returns it as a stream of Unicode characters.SQLInput.readClob()
Reads an SQLCLOB
value from the stream and returns it as aClob
object in the Java programming language.SQLInput.readDate()
Reads the next attribute in the stream and returns it as ajava.sql.Date
object.double
SQLInput.readDouble()
Reads the next attribute in the stream and returns it as adouble
in the Java programming language.float
SQLInput.readFloat()
Reads the next attribute in the stream and returns it as afloat
in the Java programming language.int
SQLInput.readInt()
Reads the next attribute in the stream and returns it as anint
in the Java programming language.long
SQLInput.readLong()
Reads the next attribute in the stream and returns it as along
in the Java programming language.SQLInput.readNClob()
Reads an SQLNCLOB
value from the stream and returns it as aNClob
object in the Java programming language.SQLInput.readNString()
Reads the next attribute in the stream and returns it as aString
in the Java programming language.SQLInput.readObject()
Reads the datum at the head of the stream and returns it as anObject
in the Java programming language.default <T> T
SQLInput.readObject(Class<T> type)
Reads the next attribute in the stream and returns it as anObject
in the Java programming language.SQLInput.readRef()
Reads an SQLREF
value from the stream and returns it as aRef
object in the Java programming language.SQLInput.readRowId()
Reads an SQLROWID
value from the stream and returns it as aRowId
object in the Java programming language.short
SQLInput.readShort()
Reads the next attribute in the stream and returns it as ashort
in the Java programming language.void
Populates this object with data read from the database.SQLInput.readSQLXML()
Reads an SQLXML
value from the stream and returns it as aSQLXML
object in the Java programming language.SQLInput.readString()
Reads the next attribute in the stream and returns it as aString
in the Java programming language.SQLInput.readTime()
Reads the next attribute in the stream and returns it as ajava.sql.Time
object.SQLInput.readTimestamp()
Reads the next attribute in the stream and returns it as ajava.sql.Timestamp
object.SQLInput.readURL()
Reads an SQLDATALINK
value from the stream and returns it as ajava.net.URL
object in the Java programming language.void
ResultSet.refreshRow()
Refreshes the current row with its most recent value in the database.static void
DriverManager.registerDriver(Driver driver)
Registers the given driver with theDriverManager
.static void
DriverManager.registerDriver(Driver driver, DriverAction da)
Registers the given driver with theDriverManager
.void
CallableStatement.registerOutParameter(int parameterIndex, int sqlType)
Registers the OUT parameter in ordinal positionparameterIndex
to the JDBC typesqlType
.void
CallableStatement.registerOutParameter(int parameterIndex, int sqlType, int scale)
Registers the parameter in ordinal positionparameterIndex
to be of JDBC typesqlType
.void
CallableStatement.registerOutParameter(int parameterIndex, int sqlType, String typeName)
Registers the designated output parameter.default void
CallableStatement.registerOutParameter(int parameterIndex, SQLType sqlType)
Registers the OUT parameter in ordinal positionparameterIndex
to the JDBC typesqlType
.default void
CallableStatement.registerOutParameter(int parameterIndex, SQLType sqlType, int scale)
Registers the parameter in ordinal positionparameterIndex
to be of JDBC typesqlType
.default void
CallableStatement.registerOutParameter(int parameterIndex, SQLType sqlType, String typeName)
Registers the designated output parameter.void
CallableStatement.registerOutParameter(String parameterName, int sqlType)
Registers the OUT parameter namedparameterName
to the JDBC typesqlType
.void
CallableStatement.registerOutParameter(String parameterName, int sqlType, int scale)
Registers the parameter namedparameterName
to be of JDBC typesqlType
.void
CallableStatement.registerOutParameter(String parameterName, int sqlType, String typeName)
Registers the designated output parameter.default void
CallableStatement.registerOutParameter(String parameterName, SQLType sqlType)
Registers the OUT parameter namedparameterName
to the JDBC typesqlType
.default void
CallableStatement.registerOutParameter(String parameterName, SQLType sqlType, int scale)
Registers the parameter namedparameterName
to be of JDBC typesqlType
.default void
CallableStatement.registerOutParameter(String parameterName, SQLType sqlType, String typeName)
Registers the designated output parameter.boolean
ResultSet.relative(int rows)
Moves the cursor a relative number of rows, either positive or negative.void
Connection.releaseSavepoint(Savepoint savepoint)
Removes the specifiedSavepoint
and subsequentSavepoint
objects from the current transaction.void
Connection.rollback()
Undoes all changes made in the current transaction and releases any database locks currently held by thisConnection
object.void
Undoes all changes made after the givenSavepoint
object was set.boolean
ResultSet.rowDeleted()
Retrieves whether a row has been deleted.boolean
ResultSet.rowInserted()
Retrieves whether the current row has had an insertion.boolean
ResultSet.rowUpdated()
Retrieves whether the current row has been updated.void
Sets the designated parameter to the givenjava.sql.Array
object.void
CallableStatement.setAsciiStream(String parameterName, InputStream x)
Sets the designated parameter to the given input stream.void
CallableStatement.setAsciiStream(String parameterName, InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
CallableStatement.setAsciiStream(String parameterName, InputStream x, long length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.Clob.setAsciiStream(long pos)
Retrieves a stream to be used to write Ascii characters to theCLOB
value that thisClob
object represents, starting at positionpos
.void
PreparedStatement.setAsciiStream(int parameterIndex, InputStream x)
Sets the designated parameter to the given input stream.void
PreparedStatement.setAsciiStream(int parameterIndex, InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
PreparedStatement.setAsciiStream(int parameterIndex, InputStream x, long length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
Connection.setAutoCommit(boolean autoCommit)
Sets this connection's auto-commit mode to the given state.void
CallableStatement.setBigDecimal(String parameterName, BigDecimal x)
Sets the designated parameter to the givenjava.math.BigDecimal
value.void
PreparedStatement.setBigDecimal(int parameterIndex, BigDecimal x)
Sets the designated parameter to the givenjava.math.BigDecimal
value.Blob.setBinaryStream(long pos)
Retrieves a stream that can be used to write to theBLOB
value that thisBlob
object represents.void
CallableStatement.setBinaryStream(String parameterName, InputStream x)
Sets the designated parameter to the given input stream.void
CallableStatement.setBinaryStream(String parameterName, InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
CallableStatement.setBinaryStream(String parameterName, InputStream x, long length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
PreparedStatement.setBinaryStream(int parameterIndex, InputStream x)
Sets the designated parameter to the given input stream.void
PreparedStatement.setBinaryStream(int parameterIndex, InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
PreparedStatement.setBinaryStream(int parameterIndex, InputStream x, long length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.SQLXML.setBinaryStream()
Retrieves a stream that can be used to write the XML value that this SQLXML instance represents.void
CallableStatement.setBlob(String parameterName, InputStream inputStream)
Sets the designated parameter to anInputStream
object.void
CallableStatement.setBlob(String parameterName, InputStream inputStream, long length)
Sets the designated parameter to anInputStream
object.void
Sets the designated parameter to the givenjava.sql.Blob
object.void
PreparedStatement.setBlob(int parameterIndex, InputStream inputStream)
Sets the designated parameter to aInputStream
object.void
PreparedStatement.setBlob(int parameterIndex, InputStream inputStream, long length)
Sets the designated parameter to aInputStream
object.void
Sets the designated parameter to the givenjava.sql.Blob
object.void
CallableStatement.setBoolean(String parameterName, boolean x)
Sets the designated parameter to the given Javaboolean
value.void
PreparedStatement.setBoolean(int parameterIndex, boolean x)
Sets the designated parameter to the given Javaboolean
value.void
Sets the designated parameter to the given Javabyte
value.void
PreparedStatement.setByte(int parameterIndex, byte x)
Sets the designated parameter to the given Javabyte
value.int
Blob.setBytes(long pos, byte[] bytes)
Writes the given array of bytes to theBLOB
value that thisBlob
object represents, starting at positionpos
, and returns the number of bytes written.int
Blob.setBytes(long pos, byte[] bytes, int offset, int len)
Writes all or part of the givenbyte
array to theBLOB
value that thisBlob
object represents and returns the number of bytes written.void
Sets the designated parameter to the given Java array of bytes.void
PreparedStatement.setBytes(int parameterIndex, byte[] x)
Sets the designated parameter to the given Java array of bytes.void
Connection.setCatalog(String catalog)
Sets the given catalog name in order to select a subspace of thisConnection
object's database in which to work.void
CallableStatement.setCharacterStream(String parameterName, Reader reader)
Sets the designated parameter to the givenReader
object.void
CallableStatement.setCharacterStream(String parameterName, Reader reader, int length)
Sets the designated parameter to the givenReader
object, which is the given number of characters long.void
CallableStatement.setCharacterStream(String parameterName, Reader reader, long length)
Sets the designated parameter to the givenReader
object, which is the given number of characters long.Clob.setCharacterStream(long pos)
Retrieves a stream to be used to write a stream of Unicode characters to theCLOB
value that thisClob
object represents, at positionpos
.void
PreparedStatement.setCharacterStream(int parameterIndex, Reader reader)
Sets the designated parameter to the givenReader
object.void
PreparedStatement.setCharacterStream(int parameterIndex, Reader reader, int length)
Sets the designated parameter to the givenReader
object, which is the given number of characters long.void
PreparedStatement.setCharacterStream(int parameterIndex, Reader reader, long length)
Sets the designated parameter to the givenReader
object, which is the given number of characters long.SQLXML.setCharacterStream()
Retrieves a stream to be used to write the XML value that this SQLXML instance represents.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to the givenjava.sql.Clob
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to the givenjava.sql.Clob
object.void
Statement.setCursorName(String name)
Sets the SQL cursor name to the givenString
, which will be used by subsequentStatement
objectexecute
methods.void
Sets the designated parameter to the givenjava.sql.Date
value using the default time zone of the virtual machine that is running the application.void
Sets the designated parameter to the givenjava.sql.Date
value, using the givenCalendar
object.void
Sets the designated parameter to the givenjava.sql.Date
value using the default time zone of the virtual machine that is running the application.void
Sets the designated parameter to the givenjava.sql.Date
value, using the givenCalendar
object.void
Sets the designated parameter to the given Javadouble
value.void
PreparedStatement.setDouble(int parameterIndex, double x)
Sets the designated parameter to the given Javadouble
value.void
Statement.setEscapeProcessing(boolean enable)
Sets escape processing on or off.void
ResultSet.setFetchDirection(int direction)
Gives a hint as to the direction in which the rows in thisResultSet
object will be processed.void
Statement.setFetchDirection(int direction)
Gives the driver a hint as to the direction in which rows will be processed inResultSet
objects created using thisStatement
object.void
ResultSet.setFetchSize(int rows)
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for thisResultSet
object.void
Statement.setFetchSize(int rows)
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed forResultSet
objects generated by thisStatement
.void
Sets the designated parameter to the given Javafloat
value.void
PreparedStatement.setFloat(int parameterIndex, float x)
Sets the designated parameter to the given Javafloat
value.void
Connection.setHoldability(int holdability)
Changes the default holdability ofResultSet
objects created using thisConnection
object to the given holdability.void
Sets the designated parameter to the given Javaint
value.void
PreparedStatement.setInt(int parameterIndex, int x)
Sets the designated parameter to the given Javaint
value.default void
Statement.setLargeMaxRows(long max)
Sets the limit for the maximum number of rows that anyResultSet
object generated by thisStatement
object can contain to the given number.void
Sets the designated parameter to the given Javalong
value.void
PreparedStatement.setLong(int parameterIndex, long x)
Sets the designated parameter to the given Javalong
value.void
Statement.setMaxFieldSize(int max)
Sets the limit for the maximum number of bytes that can be returned for character and binary column values in aResultSet
object produced by thisStatement
object.void
Statement.setMaxRows(int max)
Sets the limit for the maximum number of rows that anyResultSet
object generated by thisStatement
object can contain to the given number.void
CallableStatement.setNCharacterStream(String parameterName, Reader value)
Sets the designated parameter to aReader
object.void
CallableStatement.setNCharacterStream(String parameterName, Reader value, long length)
Sets the designated parameter to aReader
object.void
PreparedStatement.setNCharacterStream(int parameterIndex, Reader value)
Sets the designated parameter to aReader
object.void
PreparedStatement.setNCharacterStream(int parameterIndex, Reader value, long length)
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to ajava.sql.NClob
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to ajava.sql.NClob
object.void
Connection.setNetworkTimeout(Executor executor, int milliseconds)
Sets the maximum period aConnection
or objects created from theConnection
will wait for the database to reply to any one request.void
CallableStatement.setNString(String parameterName, String value)
Sets the designated parameter to the givenString
object.void
PreparedStatement.setNString(int parameterIndex, String value)
Sets the designated parameter to the givenString
object.void
Sets the designated parameter to SQLNULL
.void
Sets the designated parameter to SQLNULL
.void
PreparedStatement.setNull(int parameterIndex, int sqlType)
Sets the designated parameter to SQLNULL
.void
Sets the designated parameter to SQLNULL
.void
Sets the value of the designated parameter with the given object.void
Sets the value of the designated parameter with the given object.void
Sets the value of the designated parameter with the given object.default void
Sets the value of the designated parameter with the given object.default void
CallableStatement.setObject(String parameterName, Object x, SQLType targetSqlType, int scaleOrLength)
Sets the value of the designated parameter with the given object.void
Sets the value of the designated parameter using the given object.void
Sets the value of the designated parameter with the given object.void
Sets the value of the designated parameter with the given object.default void
Sets the value of the designated parameter with the given object.default void
PreparedStatement.setObject(int parameterIndex, Object x, SQLType targetSqlType, int scaleOrLength)
Sets the value of the designated parameter with the given object.void
Sets the structured type value that thisRef
object references to the given instance ofObject
.void
Statement.setPoolable(boolean poolable)
Requests that aStatement
be pooled or not pooled.void
Statement.setQueryTimeout(int seconds)
Sets the number of seconds the driver will wait for aStatement
object to execute to the given number of seconds.void
Connection.setReadOnly(boolean readOnly)
Puts this connection in read-only mode as a hint to the driver to enable database optimizations.void
Sets the designated parameter to the givenREF(<structured-type>)
value.<T extends Result>
TReturns a Result for setting the XML value designated by this SQLXML instance.void
Sets the designated parameter to the givenjava.sql.RowId
object.void
Sets the designated parameter to the givenjava.sql.RowId
object.Connection.setSavepoint()
Creates an unnamed savepoint in the current transaction and returns the newSavepoint
object that represents it.Connection.setSavepoint(String name)
Creates a savepoint with the given name in the current transaction and returns the newSavepoint
object that represents it.void
Sets the given schema name to access.default void
Connection.setShardingKey(ShardingKey shardingKey)
Specifies a shardingKey to use with this Connectiondefault void
Connection.setShardingKey(ShardingKey shardingKey, ShardingKey superShardingKey)
Specifies a shardingKey and superShardingKey to use with this Connectiondefault boolean
Connection.setShardingKeyIfValid(ShardingKey shardingKey, int timeout)
Sets and validates the sharding key for this connection.default boolean
Connection.setShardingKeyIfValid(ShardingKey shardingKey, ShardingKey superShardingKey, int timeout)
Sets and validates the sharding keys for this connection.void
Sets the designated parameter to the given Javashort
value.void
PreparedStatement.setShort(int parameterIndex, short x)
Sets the designated parameter to the given Javashort
value.void
Sets the designated parameter to the givenjava.sql.SQLXML
object.void
Sets the designated parameter to the givenjava.sql.SQLXML
object.void
Sets the designated parameter to the given JavaString
value.int
Writes the given JavaString
to theCLOB
value that thisClob
object designates at the positionpos
.int
Writeslen
characters ofstr
, starting at characteroffset
, to theCLOB
value that thisClob
represents.void
Sets the designated parameter to the given JavaString
value.void
Sets the XML value designated by this SQLXML instance to the given String representation.void
Sets the designated parameter to the givenjava.sql.Time
value.void
Sets the designated parameter to the givenjava.sql.Time
value, using the givenCalendar
object.void
Sets the designated parameter to the givenjava.sql.Time
value.void
Sets the designated parameter to the givenjava.sql.Time
value, using the givenCalendar
object.void
CallableStatement.setTimestamp(String parameterName, Timestamp x)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
CallableStatement.setTimestamp(String parameterName, Timestamp x, Calendar cal)
Sets the designated parameter to the givenjava.sql.Timestamp
value, using the givenCalendar
object.void
PreparedStatement.setTimestamp(int parameterIndex, Timestamp x)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
PreparedStatement.setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
Sets the designated parameter to the givenjava.sql.Timestamp
value, using the givenCalendar
object.void
Connection.setTransactionIsolation(int level)
Attempts to change the transaction isolation level for thisConnection
object to the one given.void
Connection.setTypeMap(Map<String,Class<?>> map)
Installs the givenTypeMap
object as the type map for thisConnection
object.void
PreparedStatement.setUnicodeStream(int parameterIndex, InputStream x, int length)
Deprecated.UsesetCharacterStream
void
Sets the designated parameter to the givenjava.net.URL
object.void
Sets the designated parameter to the givenjava.net.URL
value.boolean
DatabaseMetaData.storesLowerCaseIdentifiers()
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.boolean
DatabaseMetaData.storesLowerCaseQuotedIdentifiers()
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.boolean
DatabaseMetaData.storesMixedCaseIdentifiers()
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.boolean
DatabaseMetaData.storesMixedCaseQuotedIdentifiers()
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.boolean
DatabaseMetaData.storesUpperCaseIdentifiers()
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.boolean
DatabaseMetaData.storesUpperCaseQuotedIdentifiers()
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.boolean
DatabaseMetaData.supportsAlterTableWithAddColumn()
Retrieves whether this database supportsALTER TABLE
with add column.boolean
DatabaseMetaData.supportsAlterTableWithDropColumn()
Retrieves whether this database supportsALTER TABLE
with drop column.boolean
DatabaseMetaData.supportsANSI92EntryLevelSQL()
Retrieves whether this database supports the ANSI92 entry level SQL grammar.boolean
DatabaseMetaData.supportsANSI92FullSQL()
Retrieves whether this database supports the ANSI92 full SQL grammar supported.boolean
DatabaseMetaData.supportsANSI92IntermediateSQL()
Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.boolean
DatabaseMetaData.supportsBatchUpdates()
Retrieves whether this database supports batch updates.boolean
DatabaseMetaData.supportsCatalogsInDataManipulation()
Retrieves whether a catalog name can be used in a data manipulation statement.boolean
DatabaseMetaData.supportsCatalogsInIndexDefinitions()
Retrieves whether a catalog name can be used in an index definition statement.boolean
DatabaseMetaData.supportsCatalogsInPrivilegeDefinitions()
Retrieves whether a catalog name can be used in a privilege definition statement.boolean
DatabaseMetaData.supportsCatalogsInProcedureCalls()
Retrieves whether a catalog name can be used in a procedure call statement.boolean
DatabaseMetaData.supportsCatalogsInTableDefinitions()
Retrieves whether a catalog name can be used in a table definition statement.boolean
DatabaseMetaData.supportsColumnAliasing()
Retrieves whether this database supports column aliasing.boolean
DatabaseMetaData.supportsConvert()
Retrieves whether this database supports the JDBC scalar functionCONVERT
for the conversion of one JDBC type to another.boolean
DatabaseMetaData.supportsConvert(int fromType, int toType)
Retrieves whether this database supports the JDBC scalar functionCONVERT
for conversions between the JDBC types fromType and toType.boolean
DatabaseMetaData.supportsCoreSQLGrammar()
Retrieves whether this database supports the ODBC Core SQL grammar.boolean
DatabaseMetaData.supportsCorrelatedSubqueries()
Retrieves whether this database supports correlated subqueries.boolean
DatabaseMetaData.supportsDataDefinitionAndDataManipulationTransactions()
Retrieves whether this database supports both data definition and data manipulation statements within a transaction.boolean
DatabaseMetaData.supportsDataManipulationTransactionsOnly()
Retrieves whether this database supports only data manipulation statements within a transaction.boolean
DatabaseMetaData.supportsDifferentTableCorrelationNames()
Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.boolean
DatabaseMetaData.supportsExpressionsInOrderBy()
Retrieves whether this database supports expressions inORDER BY
lists.boolean
DatabaseMetaData.supportsExtendedSQLGrammar()
Retrieves whether this database supports the ODBC Extended SQL grammar.boolean
DatabaseMetaData.supportsFullOuterJoins()
Retrieves whether this database supports full nested outer joins.boolean
DatabaseMetaData.supportsGetGeneratedKeys()
Retrieves whether auto-generated keys can be retrieved after a statement has been executedboolean
DatabaseMetaData.supportsGroupBy()
Retrieves whether this database supports some form ofGROUP BY
clause.boolean
DatabaseMetaData.supportsGroupByBeyondSelect()
Retrieves whether this database supports using columns not included in theSELECT
statement in aGROUP BY
clause provided that all of the columns in theSELECT
statement are included in theGROUP BY
clause.boolean
DatabaseMetaData.supportsGroupByUnrelated()
Retrieves whether this database supports using a column that is not in theSELECT
statement in aGROUP BY
clause.boolean
DatabaseMetaData.supportsIntegrityEnhancementFacility()
Retrieves whether this database supports the SQL Integrity Enhancement Facility.boolean
DatabaseMetaData.supportsLikeEscapeClause()
Retrieves whether this database supports specifying aLIKE
escape clause.boolean
DatabaseMetaData.supportsLimitedOuterJoins()
Retrieves whether this database provides limited support for outer joins.boolean
DatabaseMetaData.supportsMinimumSQLGrammar()
Retrieves whether this database supports the ODBC Minimum SQL grammar.boolean
DatabaseMetaData.supportsMixedCaseIdentifiers()
Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.boolean
DatabaseMetaData.supportsMixedCaseQuotedIdentifiers()
Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.boolean
DatabaseMetaData.supportsMultipleOpenResults()
Retrieves whether it is possible to have multipleResultSet
objects returned from aCallableStatement
object simultaneously.boolean
DatabaseMetaData.supportsMultipleResultSets()
Retrieves whether this database supports getting multipleResultSet
objects from a single call to the methodexecute
.boolean
DatabaseMetaData.supportsMultipleTransactions()
Retrieves whether this database allows having multiple transactions open at once (on different connections).boolean
DatabaseMetaData.supportsNamedParameters()
Retrieves whether this database supports named parameters to callable statements.boolean
DatabaseMetaData.supportsNonNullableColumns()
Retrieves whether columns in this database may be defined as non-nullable.boolean
DatabaseMetaData.supportsOpenCursorsAcrossCommit()
Retrieves whether this database supports keeping cursors open across commits.boolean
DatabaseMetaData.supportsOpenCursorsAcrossRollback()
Retrieves whether this database supports keeping cursors open across rollbacks.boolean
DatabaseMetaData.supportsOpenStatementsAcrossCommit()
Retrieves whether this database supports keeping statements open across commits.boolean
DatabaseMetaData.supportsOpenStatementsAcrossRollback()
Retrieves whether this database supports keeping statements open across rollbacks.boolean
DatabaseMetaData.supportsOrderByUnrelated()
Retrieves whether this database supports using a column that is not in theSELECT
statement in anORDER BY
clause.boolean
DatabaseMetaData.supportsOuterJoins()
Retrieves whether this database supports some form of outer join.boolean
DatabaseMetaData.supportsPositionedDelete()
Retrieves whether this database supports positionedDELETE
statements.boolean
DatabaseMetaData.supportsPositionedUpdate()
Retrieves whether this database supports positionedUPDATE
statements.default boolean
DatabaseMetaData.supportsRefCursors()
Retrieves whether this database supports REF CURSOR.boolean
DatabaseMetaData.supportsResultSetConcurrency(int type, int concurrency)
Retrieves whether this database supports the given concurrency type in combination with the given result set type.boolean
DatabaseMetaData.supportsResultSetHoldability(int holdability)
Retrieves whether this database supports the given result set holdability.boolean
DatabaseMetaData.supportsResultSetType(int type)
Retrieves whether this database supports the given result set type.boolean
DatabaseMetaData.supportsSavepoints()
Retrieves whether this database supports savepoints.boolean
DatabaseMetaData.supportsSchemasInDataManipulation()
Retrieves whether a schema name can be used in a data manipulation statement.boolean
DatabaseMetaData.supportsSchemasInIndexDefinitions()
Retrieves whether a schema name can be used in an index definition statement.boolean
DatabaseMetaData.supportsSchemasInPrivilegeDefinitions()
Retrieves whether a schema name can be used in a privilege definition statement.boolean
DatabaseMetaData.supportsSchemasInProcedureCalls()
Retrieves whether a schema name can be used in a procedure call statement.boolean
DatabaseMetaData.supportsSchemasInTableDefinitions()
Retrieves whether a schema name can be used in a table definition statement.boolean
DatabaseMetaData.supportsSelectForUpdate()
Retrieves whether this database supportsSELECT FOR UPDATE
statements.default boolean
DatabaseMetaData.supportsSharding()
Retrieves whether this database supports sharding.boolean
DatabaseMetaData.supportsStatementPooling()
Retrieves whether this database supports statement pooling.boolean
DatabaseMetaData.supportsStoredFunctionsUsingCallSyntax()
Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.boolean
DatabaseMetaData.supportsStoredProcedures()
Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.boolean
DatabaseMetaData.supportsSubqueriesInComparisons()
Retrieves whether this database supports subqueries in comparison expressions.boolean
DatabaseMetaData.supportsSubqueriesInExists()
Retrieves whether this database supports subqueries inEXISTS
expressions.boolean
DatabaseMetaData.supportsSubqueriesInIns()
Retrieves whether this database supports subqueries inIN
expressions.boolean
DatabaseMetaData.supportsSubqueriesInQuantifieds()
Retrieves whether this database supports subqueries in quantified expressions.boolean
DatabaseMetaData.supportsTableCorrelationNames()
Retrieves whether this database supports table correlation names.boolean
DatabaseMetaData.supportsTransactionIsolationLevel(int level)
Retrieves whether this database supports the given transaction isolation level.boolean
DatabaseMetaData.supportsTransactions()
Retrieves whether this database supports transactions.boolean
DatabaseMetaData.supportsUnion()
Retrieves whether this database supports SQLUNION
.boolean
DatabaseMetaData.supportsUnionAll()
Retrieves whether this database supports SQLUNION ALL
.void
Blob.truncate(long len)
Truncates theBLOB
value that thisBlob
object represents to belen
bytes in length.void
Clob.truncate(long len)
Truncates theCLOB
value that thisClob
designates to have a length oflen
characters.<T> T
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.void
ResultSet.updateArray(int columnIndex, Array x)
Updates the designated column with ajava.sql.Array
value.void
ResultSet.updateArray(String columnLabel, Array x)
Updates the designated column with ajava.sql.Array
value.void
ResultSet.updateAsciiStream(int columnIndex, InputStream x)
Updates the designated column with an ascii stream value.void
ResultSet.updateAsciiStream(int columnIndex, InputStream x, int length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.void
ResultSet.updateAsciiStream(int columnIndex, InputStream x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.void
ResultSet.updateAsciiStream(String columnLabel, InputStream x)
Updates the designated column with an ascii stream value.void
ResultSet.updateAsciiStream(String columnLabel, InputStream x, int length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.void
ResultSet.updateAsciiStream(String columnLabel, InputStream x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.void
ResultSet.updateBigDecimal(int columnIndex, BigDecimal x)
Updates the designated column with ajava.math.BigDecimal
value.void
ResultSet.updateBigDecimal(String columnLabel, BigDecimal x)
Updates the designated column with ajava.sql.BigDecimal
value.void
ResultSet.updateBinaryStream(int columnIndex, InputStream x)
Updates the designated column with a binary stream value.void
ResultSet.updateBinaryStream(int columnIndex, InputStream x, int length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.void
ResultSet.updateBinaryStream(int columnIndex, InputStream x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.void
ResultSet.updateBinaryStream(String columnLabel, InputStream x)
Updates the designated column with a binary stream value.void
ResultSet.updateBinaryStream(String columnLabel, InputStream x, int length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.void
ResultSet.updateBinaryStream(String columnLabel, InputStream x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.void
ResultSet.updateBlob(int columnIndex, InputStream inputStream)
Updates the designated column using the given input stream.void
ResultSet.updateBlob(int columnIndex, InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes.void
ResultSet.updateBlob(int columnIndex, Blob x)
Updates the designated column with ajava.sql.Blob
value.void
ResultSet.updateBlob(String columnLabel, InputStream inputStream)
Updates the designated column using the given input stream.void
ResultSet.updateBlob(String columnLabel, InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes.void
ResultSet.updateBlob(String columnLabel, Blob x)
Updates the designated column with ajava.sql.Blob
value.void
ResultSet.updateBoolean(int columnIndex, boolean x)
Updates the designated column with aboolean
value.void
ResultSet.updateBoolean(String columnLabel, boolean x)
Updates the designated column with aboolean
value.void
ResultSet.updateByte(int columnIndex, byte x)
Updates the designated column with abyte
value.void
ResultSet.updateByte(String columnLabel, byte x)
Updates the designated column with abyte
value.void
ResultSet.updateBytes(int columnIndex, byte[] x)
Updates the designated column with abyte
array value.void
ResultSet.updateBytes(String columnLabel, byte[] x)
Updates the designated column with a byte array value.void
ResultSet.updateCharacterStream(int columnIndex, Reader x)
Updates the designated column with a character stream value.void
ResultSet.updateCharacterStream(int columnIndex, Reader x, int length)
Updates the designated column with a character stream value, which will have the specified number of bytes.void
ResultSet.updateCharacterStream(int columnIndex, Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.void
ResultSet.updateCharacterStream(String columnLabel, Reader reader)
Updates the designated column with a character stream value.void
ResultSet.updateCharacterStream(String columnLabel, Reader reader, int length)
Updates the designated column with a character stream value, which will have the specified number of bytes.void
ResultSet.updateCharacterStream(String columnLabel, Reader reader, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.void
ResultSet.updateClob(int columnIndex, Reader reader)
Updates the designated column using the givenReader
object.void
ResultSet.updateClob(int columnIndex, Reader reader, long length)
Updates the designated column using the givenReader
object, which is the given number of characters long.void
ResultSet.updateClob(int columnIndex, Clob x)
Updates the designated column with ajava.sql.Clob
value.void
ResultSet.updateClob(String columnLabel, Reader reader)
Updates the designated column using the givenReader
object.void
ResultSet.updateClob(String columnLabel, Reader reader, long length)
Updates the designated column using the givenReader
object, which is the given number of characters long.void
ResultSet.updateClob(String columnLabel, Clob x)
Updates the designated column with ajava.sql.Clob
value.void
ResultSet.updateDate(int columnIndex, Date x)
Updates the designated column with ajava.sql.Date
value.void
ResultSet.updateDate(String columnLabel, Date x)
Updates the designated column with ajava.sql.Date
value.void
ResultSet.updateDouble(int columnIndex, double x)
Updates the designated column with adouble
value.void
ResultSet.updateDouble(String columnLabel, double x)
Updates the designated column with adouble
value.void
ResultSet.updateFloat(int columnIndex, float x)
Updates the designated column with afloat
value.void
ResultSet.updateFloat(String columnLabel, float x)
Updates the designated column with afloat
value.void
ResultSet.updateInt(int columnIndex, int x)
Updates the designated column with anint
value.void
Updates the designated column with anint
value.void
ResultSet.updateLong(int columnIndex, long x)
Updates the designated column with along
value.void
ResultSet.updateLong(String columnLabel, long x)
Updates the designated column with along
value.void
ResultSet.updateNCharacterStream(int columnIndex, Reader x)
Updates the designated column with a character stream value.void
ResultSet.updateNCharacterStream(int columnIndex, Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.void
ResultSet.updateNCharacterStream(String columnLabel, Reader reader)
Updates the designated column with a character stream value.void
ResultSet.updateNCharacterStream(String columnLabel, Reader reader, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.void
ResultSet.updateNClob(int columnIndex, Reader reader)
Updates the designated column using the givenReader
The data will be read from the stream as needed until end-of-stream is reached.void
ResultSet.updateNClob(int columnIndex, Reader reader, long length)
Updates the designated column using the givenReader
object, which is the given number of characters long.void
ResultSet.updateNClob(int columnIndex, NClob nClob)
Updates the designated column with ajava.sql.NClob
value.void
ResultSet.updateNClob(String columnLabel, Reader reader)
Updates the designated column using the givenReader
object.void
ResultSet.updateNClob(String columnLabel, Reader reader, long length)
Updates the designated column using the givenReader
object, which is the given number of characters long.void
ResultSet.updateNClob(String columnLabel, NClob nClob)
Updates the designated column with ajava.sql.NClob
value.void
ResultSet.updateNString(int columnIndex, String nString)
Updates the designated column with aString
value.void
ResultSet.updateNString(String columnLabel, String nString)
Updates the designated column with aString
value.void
ResultSet.updateNull(int columnIndex)
Updates the designated column with anull
value.void
ResultSet.updateNull(String columnLabel)
Updates the designated column with anull
value.void
ResultSet.updateObject(int columnIndex, Object x)
Updates the designated column with anObject
value.void
ResultSet.updateObject(int columnIndex, Object x, int scaleOrLength)
Updates the designated column with anObject
value.default void
ResultSet.updateObject(int columnIndex, Object x, SQLType targetSqlType)
Updates the designated column with anObject
value.default void
ResultSet.updateObject(int columnIndex, Object x, SQLType targetSqlType, int scaleOrLength)
Updates the designated column with anObject
value.void
ResultSet.updateObject(String columnLabel, Object x)
Updates the designated column with anObject
value.void
ResultSet.updateObject(String columnLabel, Object x, int scaleOrLength)
Updates the designated column with anObject
value.default void
ResultSet.updateObject(String columnLabel, Object x, SQLType targetSqlType)
Updates the designated column with anObject
value.default void
ResultSet.updateObject(String columnLabel, Object x, SQLType targetSqlType, int scaleOrLength)
Updates the designated column with anObject
value.void
Updates the designated column with ajava.sql.Ref
value.void
Updates the designated column with ajava.sql.Ref
value.void
ResultSet.updateRow()
Updates the underlying database with the new contents of the current row of thisResultSet
object.void
ResultSet.updateRowId(int columnIndex, RowId x)
Updates the designated column with aRowId
value.void
ResultSet.updateRowId(String columnLabel, RowId x)
Updates the designated column with aRowId
value.boolean
DatabaseMetaData.updatesAreDetected(int type)
Retrieves whether or not a visible row update can be detected by calling the methodResultSet.rowUpdated
.void
ResultSet.updateShort(int columnIndex, short x)
Updates the designated column with ashort
value.void
ResultSet.updateShort(String columnLabel, short x)
Updates the designated column with ashort
value.void
ResultSet.updateSQLXML(int columnIndex, SQLXML xmlObject)
Updates the designated column with ajava.sql.SQLXML
value.void
ResultSet.updateSQLXML(String columnLabel, SQLXML xmlObject)
Updates the designated column with ajava.sql.SQLXML
value.void
ResultSet.updateString(int columnIndex, String x)
Updates the designated column with aString
value.void
ResultSet.updateString(String columnLabel, String x)
Updates the designated column with aString
value.void
ResultSet.updateTime(int columnIndex, Time x)
Updates the designated column with ajava.sql.Time
value.void
ResultSet.updateTime(String columnLabel, Time x)
Updates the designated column with ajava.sql.Time
value.void
ResultSet.updateTimestamp(int columnIndex, Timestamp x)
Updates the designated column with ajava.sql.Timestamp
value.void
ResultSet.updateTimestamp(String columnLabel, Timestamp x)
Updates the designated column with ajava.sql.Timestamp
value.boolean
DatabaseMetaData.usesLocalFilePerTable()
Retrieves whether this database uses a file for each table.boolean
DatabaseMetaData.usesLocalFiles()
Retrieves whether this database stores tables in a local file.boolean
CallableStatement.wasNull()
Retrieves whether the last OUT parameter read had the value of SQLNULL
.boolean
ResultSet.wasNull()
Reports whether the last column read had a value of SQLNULL
.boolean
SQLInput.wasNull()
Retrieves whether the last value read was SQLNULL
.void
SQLOutput.writeArray(Array x)
Writes an SQLARRAY
value to the stream.void
SQLOutput.writeAsciiStream(InputStream x)
Writes the next attribute to the stream as a stream of ASCII characters.void
SQLOutput.writeBigDecimal(BigDecimal x)
Writes the next attribute to the stream as a java.math.BigDecimal object.void
SQLOutput.writeBinaryStream(InputStream x)
Writes the next attribute to the stream as a stream of uninterpreted bytes.void
Writes an SQLBLOB
value to the stream.void
SQLOutput.writeBoolean(boolean x)
Writes the next attribute to the stream as a Java boolean.void
SQLOutput.writeByte(byte x)
Writes the next attribute to the stream as a Java byte.void
SQLOutput.writeBytes(byte[] x)
Writes the next attribute to the stream as an array of bytes.void
SQLOutput.writeCharacterStream(Reader x)
Writes the next attribute to the stream as a stream of Unicode characters.void
Writes an SQLCLOB
value to the stream.void
Writes the next attribute to the stream as a java.sql.Date object.void
SQLOutput.writeDouble(double x)
Writes the next attribute to the stream as a Java double.void
SQLOutput.writeFloat(float x)
Writes the next attribute to the stream as a Java float.void
SQLOutput.writeInt(int x)
Writes the next attribute to the stream as a Java int.void
SQLOutput.writeLong(long x)
Writes the next attribute to the stream as a Java long.void
SQLOutput.writeNClob(NClob x)
Writes an SQLNCLOB
value to the stream.void
SQLOutput.writeNString(String x)
Writes the next attribute to the stream as aString
in the Java programming language.default void
SQLOutput.writeObject(Object x, SQLType targetSqlType)
Writes to the stream the data contained in the given object.void
SQLOutput.writeObject(SQLData x)
Writes to the stream the data contained in the givenSQLData
object.void
Writes an SQLREF
value to the stream.void
SQLOutput.writeRowId(RowId x)
Writes an SQLROWID
value to the stream.void
SQLOutput.writeShort(short x)
Writes the next attribute to the stream as a Java short.void
Writes this object to the given SQL data stream, converting it back to its SQL value in the data source.void
SQLOutput.writeSQLXML(SQLXML x)
Writes an SQLXML
value to the stream.void
SQLOutput.writeString(String x)
Writes the next attribute to the stream as aString
in the Java programming language.void
SQLOutput.writeStruct(Struct x)
Writes an SQL structured type value to the stream.void
Writes the next attribute to the stream as a java.sql.Time object.void
SQLOutput.writeTimestamp(Timestamp x)
Writes the next attribute to the stream as a java.sql.Timestamp object.void
Writes a SQLDATALINK
value to the stream. -
Uses of SQLException in javax.sql
Modifier and TypeMethodDescriptionConnectionEvent.getSQLException()
Retrieves theSQLException
for thisConnectionEvent
object.StatementEvent.getSQLException()
Returns theSQLException
the driver is about to throwModifier and TypeMethodDescriptionPooledConnectionBuilder.build()
Returns an instance of the object defined by this builder.XAConnectionBuilder.build()
Returns an instance of the object defined by this builder.void
RowSet.clearParameters()
Clears the parameters set for thisRowSet
object's command.void
PooledConnection.close()
Closes the physical connection that thisPooledConnection
object represents.default ConnectionBuilder
DataSource.createConnectionBuilder()
Create a newConnectionBuilder
instancedefault PooledConnectionBuilder
ConnectionPoolDataSource.createPooledConnectionBuilder()
Creates a newPooledConnectionBuilder
instancedefault ShardingKeyBuilder
CommonDataSource.createShardingKeyBuilder()
Creates a newShardingKeyBuilder
instancedefault XAConnectionBuilder
XADataSource.createXAConnectionBuilder()
Creates a newXAConnectionBuilder
instancevoid
RowSet.execute()
Fills thisRowSet
object with data.DataSource.getConnection()
Attempts to establish a connection with the data source that thisDataSource
object represents.DataSource.getConnection(String username, String password)
Attempts to establish a connection with the data source that thisDataSource
object represents.PooledConnection.getConnection()
Creates and returns aConnection
object that is a handle for the physical connection that thisPooledConnection
object represents.RowSetInternal.getConnection()
Retrieves theConnection
object that was passed to thisRowSet
object.boolean
RowSet.getEscapeProcessing()
Retrieves whether escape processing is enabled for thisRowSet
object.int
CommonDataSource.getLoginTimeout()
Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.int
ConnectionPoolDataSource.getLoginTimeout()
Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.int
DataSource.getLoginTimeout()
Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.int
XADataSource.getLoginTimeout()
Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.CommonDataSource.getLogWriter()
Retrieves the log writer for thisDataSource
object.ConnectionPoolDataSource.getLogWriter()
Retrieves the log writer for thisDataSource
object.DataSource.getLogWriter()
Retrieves the log writer for thisDataSource
object.XADataSource.getLogWriter()
Retrieves the log writer for thisDataSource
object.int
RowSet.getMaxFieldSize()
Retrieves the maximum number of bytes that may be returned for certain column values.int
RowSet.getMaxRows()
Retrieves the maximum number of rows that thisRowSet
object can contain.RowSetInternal.getOriginal()
Retrieves aResultSet
object containing the original value of thisRowSet
object.RowSetInternal.getOriginalRow()
Retrieves aResultSet
object containing the original value of the current row only.Object[]
RowSetInternal.getParams()
Retrieves the parameters that have been set for thisRowSet
object's command.ConnectionPoolDataSource.getPooledConnection()
Attempts to establish a physical database connection that can be used as a pooled connection.ConnectionPoolDataSource.getPooledConnection(String user, String password)
Attempts to establish a physical database connection that can be used as a pooled connection.int
RowSet.getQueryTimeout()
Retrieves the maximum number of seconds the driver will wait for a statement to execute.RowSet.getTypeMap()
Retrieves theMap
object associated with thisRowSet
object, which specifies the custom mapping of SQL user-defined types, if any.RowSet.getUrl()
Retrieves the url property thisRowSet
object will use to create a connection if it uses theDriverManager
instead of aDataSource
object to establish the connection.XADataSource.getXAConnection()
Attempts to establish a physical database connection that can be used in a distributed transaction.XADataSource.getXAConnection(String user, String password)
Attempts to establish a physical database connection, using the given user name and password.XAConnection.getXAResource()
Retrieves anXAResource
object that the transaction manager will use to manage thisXAConnection
object's participation in a distributed transaction.void
RowSetReader.readData(RowSetInternal caller)
Reads the new contents of the callingRowSet
object.void
Sets the designated parameter in thisRowSet
object's command with the givenArray
value.void
RowSet.setAsciiStream(int parameterIndex, InputStream x)
Sets the designated parameter in thisRowSet
object's command to the given input stream.void
RowSet.setAsciiStream(int parameterIndex, InputStream x, int length)
Sets the designated parameter in thisRowSet
object's command to the givenjava.io.InputStream
value.void
RowSet.setAsciiStream(String parameterName, InputStream x)
Sets the designated parameter to the given input stream.void
RowSet.setAsciiStream(String parameterName, InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
RowSetMetaData.setAutoIncrement(int columnIndex, boolean property)
Sets whether the designated column is automatically numbered, The default is for aRowSet
object's columns not to be automatically numbered.void
RowSet.setBigDecimal(int parameterIndex, BigDecimal x)
Sets the designated parameter in thisRowSet
object's command to the givenjava.math.BigDecimal
value.void
RowSet.setBigDecimal(String parameterName, BigDecimal x)
Sets the designated parameter to the givenjava.math.BigDecimal
value.void
RowSet.setBinaryStream(int parameterIndex, InputStream x)
Sets the designated parameter in thisRowSet
object's command to the given input stream.void
RowSet.setBinaryStream(int parameterIndex, InputStream x, int length)
Sets the designated parameter in thisRowSet
object's command to the givenjava.io.InputStream
value.void
RowSet.setBinaryStream(String parameterName, InputStream x)
Sets the designated parameter to the given input stream.void
RowSet.setBinaryStream(String parameterName, InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
RowSet.setBlob(int parameterIndex, InputStream inputStream)
Sets the designated parameter to aInputStream
object.void
RowSet.setBlob(int parameterIndex, InputStream inputStream, long length)
Sets the designated parameter to aInputStream
object.void
Sets the designated parameter in thisRowSet
object's command with the givenBlob
value.void
RowSet.setBlob(String parameterName, InputStream inputStream)
Sets the designated parameter to aInputStream
object.void
RowSet.setBlob(String parameterName, InputStream inputStream, long length)
Sets the designated parameter to aInputStream
object.void
Sets the designated parameter to the givenjava.sql.Blob
object.void
RowSet.setBoolean(int parameterIndex, boolean x)
Sets the designated parameter in thisRowSet
object's command to the given Javaboolean
value.void
RowSet.setBoolean(String parameterName, boolean x)
Sets the designated parameter to the given Javaboolean
value.void
RowSet.setByte(int parameterIndex, byte x)
Sets the designated parameter in thisRowSet
object's command to the given Javabyte
value.void
Sets the designated parameter to the given Javabyte
value.void
RowSet.setBytes(int parameterIndex, byte[] x)
Sets the designated parameter in thisRowSet
object's command to the given Java array ofbyte
values.void
Sets the designated parameter to the given Java array of bytes.void
RowSetMetaData.setCaseSensitive(int columnIndex, boolean property)
Sets whether the designated column is case sensitive.void
RowSetMetaData.setCatalogName(int columnIndex, String catalogName)
Sets the designated column's table's catalog name, if any, to the givenString
.void
RowSet.setCharacterStream(int parameterIndex, Reader reader)
Sets the designated parameter in thisRowSet
object's command to the givenReader
object.void
RowSet.setCharacterStream(int parameterIndex, Reader reader, int length)
Sets the designated parameter in thisRowSet
object's command to the givenjava.io.Reader
value.void
RowSet.setCharacterStream(String parameterName, Reader reader)
Sets the designated parameter to the givenReader
object.void
RowSet.setCharacterStream(String parameterName, Reader reader, int length)
Sets the designated parameter to the givenReader
object, which is the given number of characters long.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter in thisRowSet
object's command with the givenClob
value.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to the givenjava.sql.Clob
object.void
RowSetMetaData.setColumnCount(int columnCount)
Sets the number of columns in theRowSet
object to the given number.void
RowSetMetaData.setColumnDisplaySize(int columnIndex, int size)
Sets the designated column's normal maximum width in chars to the givenint
.void
RowSetMetaData.setColumnLabel(int columnIndex, String label)
Sets the suggested column title for use in printouts and displays, if any, to the givenString
.void
RowSetMetaData.setColumnName(int columnIndex, String columnName)
Sets the name of the designated column to the givenString
.void
RowSetMetaData.setColumnType(int columnIndex, int SQLType)
Sets the designated column's SQL type to the one given.void
RowSetMetaData.setColumnTypeName(int columnIndex, String typeName)
Sets the designated column's type name that is specific to the data source, if any, to the givenString
.void
RowSet.setCommand(String cmd)
Sets thisRowSet
object's command property to the given SQL query.void
RowSet.setConcurrency(int concurrency)
Sets the concurrency of thisRowSet
object to the given concurrency level.void
RowSetMetaData.setCurrency(int columnIndex, boolean property)
Sets whether the designated column is a cash value.void
RowSet.setDataSourceName(String name)
Sets the data source name property for thisRowSet
object to the givenString
.void
Sets the designated parameter in thisRowSet
object's command to the givenjava.sql.Date
value.void
Sets the designated parameter in thisRowSet
object's command with the givenjava.sql.Date
value.void
Sets the designated parameter to the givenjava.sql.Date
value using the default time zone of the virtual machine that is running the application.void
Sets the designated parameter to the givenjava.sql.Date
value, using the givenCalendar
object.void
RowSet.setDouble(int parameterIndex, double x)
Sets the designated parameter in thisRowSet
object's command to the given Javadouble
value.void
Sets the designated parameter to the given Javadouble
value.void
RowSet.setEscapeProcessing(boolean enable)
Sets escape processing for thisRowSet
object on or off.void
RowSet.setFloat(int parameterIndex, float x)
Sets the designated parameter in thisRowSet
object's command to the given Javafloat
value.void
Sets the designated parameter to the given Javafloat
value.void
RowSet.setInt(int parameterIndex, int x)
Sets the designated parameter in thisRowSet
object's command to the given Javaint
value.void
Sets the designated parameter to the given Javaint
value.void
CommonDataSource.setLoginTimeout(int seconds)
Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.void
ConnectionPoolDataSource.setLoginTimeout(int seconds)
Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.void
DataSource.setLoginTimeout(int seconds)
Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.void
XADataSource.setLoginTimeout(int seconds)
Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.void
CommonDataSource.setLogWriter(PrintWriter out)
Sets the log writer for thisDataSource
object to the givenjava.io.PrintWriter
object.void
ConnectionPoolDataSource.setLogWriter(PrintWriter out)
Sets the log writer for thisDataSource
object to the givenjava.io.PrintWriter
object.void
DataSource.setLogWriter(PrintWriter out)
Sets the log writer for thisDataSource
object to the givenjava.io.PrintWriter
object.void
XADataSource.setLogWriter(PrintWriter out)
Sets the log writer for thisDataSource
object to the givenjava.io.PrintWriter
object.void
RowSet.setLong(int parameterIndex, long x)
Sets the designated parameter in thisRowSet
object's command to the given Javalong
value.void
Sets the designated parameter to the given Javalong
value.void
RowSet.setMaxFieldSize(int max)
Sets the maximum number of bytes that can be returned for a column value to the given number of bytes.void
RowSet.setMaxRows(int max)
Sets the maximum number of rows that thisRowSet
object can contain to the specified number.void
RowSetInternal.setMetaData(RowSetMetaData md)
Sets the givenRowSetMetaData
object as theRowSetMetaData
object for thisRowSet
object.void
RowSet.setNCharacterStream(int parameterIndex, Reader value)
Sets the designated parameter in thisRowSet
object's command to aReader
object.void
RowSet.setNCharacterStream(int parameterIndex, Reader value, long length)
Sets the designated parameter to aReader
object.void
RowSet.setNCharacterStream(String parameterName, Reader value)
Sets the designated parameter to aReader
object.void
RowSet.setNCharacterStream(String parameterName, Reader value, long length)
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to ajava.sql.NClob
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to ajava.sql.NClob
object.void
RowSet.setNString(int parameterIndex, String value)
Sets the designated parameter to the givenString
object.void
RowSet.setNString(String parameterName, String value)
Sets the designated parameter to the givenString
object.void
RowSet.setNull(int parameterIndex, int sqlType)
Sets the designated parameter in thisRowSet
object's SQL command to SQLNULL
.void
Sets the designated parameter in thisRowSet
object's SQL command to SQLNULL
.void
Sets the designated parameter to SQLNULL
.void
Sets the designated parameter to SQLNULL
.void
RowSetMetaData.setNullable(int columnIndex, int property)
Sets whether the designated column's value can be set toNULL
.void
Sets the designated parameter in thisRowSet
object's command with a JavaObject
.void
Sets the designated parameter in thisRowSet
object's command with a JavaObject
.void
Sets the designated parameter in thisRowSet
object's command with the given JavaObject
.void
Sets the value of the designated parameter with the given object.void
Sets the value of the designated parameter with the given object.void
Sets the value of the designated parameter with the given object.void
RowSet.setPassword(String password)
Sets the database password for thisRowSet
object to the givenString
.void
RowSetMetaData.setPrecision(int columnIndex, int precision)
Sets the designated column's number of decimal digits to the givenint
.void
RowSet.setQueryTimeout(int seconds)
Sets the maximum time the driver will wait for a statement to execute to the given number of seconds.void
RowSet.setReadOnly(boolean value)
Sets whether thisRowSet
object is read-only to the givenboolean
.void
Sets the designated parameter in thisRowSet
object's command with the givenRef
value.void
Sets the designated parameter to the givenjava.sql.RowId
object.void
Sets the designated parameter to the givenjava.sql.RowId
object.void
RowSetMetaData.setScale(int columnIndex, int scale)
Sets the designated column's number of digits to the right of the decimal point to the givenint
.void
RowSetMetaData.setSchemaName(int columnIndex, String schemaName)
Sets the name of the designated column's table's schema, if any, to the givenString
.void
RowSetMetaData.setSearchable(int columnIndex, boolean property)
Sets whether the designated column can be used in a where clause.void
RowSet.setShort(int parameterIndex, short x)
Sets the designated parameter in thisRowSet
object's command to the given Javashort
value.void
Sets the designated parameter to the given Javashort
value.void
RowSetMetaData.setSigned(int columnIndex, boolean property)
Sets whether the designated column is a signed number.void
Sets the designated parameter to the givenjava.sql.SQLXML
object.void
Sets the designated parameter to the givenjava.sql.SQLXML
object.void
Sets the designated parameter in thisRowSet
object's command to the given JavaString
value.void
Sets the designated parameter to the given JavaString
value.void
RowSetMetaData.setTableName(int columnIndex, String tableName)
Sets the designated column's table name, if any, to the givenString
.void
Sets the designated parameter in thisRowSet
object's command to the givenjava.sql.Time
value.void
Sets the designated parameter in thisRowSet
object's command with the givenjava.sql.Time
value.void
Sets the designated parameter to the givenjava.sql.Time
value.void
Sets the designated parameter to the givenjava.sql.Time
value, using the givenCalendar
object.void
RowSet.setTimestamp(int parameterIndex, Timestamp x)
Sets the designated parameter in thisRowSet
object's command to the givenjava.sql.Timestamp
value.void
RowSet.setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
Sets the designated parameter in thisRowSet
object's command with the givenjava.sql.Timestamp
value.void
RowSet.setTimestamp(String parameterName, Timestamp x)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
RowSet.setTimestamp(String parameterName, Timestamp x, Calendar cal)
Sets the designated parameter to the givenjava.sql.Timestamp
value, using the givenCalendar
object.void
RowSet.setTransactionIsolation(int level)
Sets the transaction isolation level for thisRowSet
object.void
RowSet.setType(int type)
Sets the type of thisRowSet
object to the given type.void
RowSet.setTypeMap(Map<String,Class<?>> map)
Installs the givenjava.util.Map
object as the default type map for thisRowSet
object.void
Sets the URL thisRowSet
object will use when it uses theDriverManager
to create a connection.void
Sets the designated parameter to the givenjava.net.URL
value.void
RowSet.setUsername(String name)
Sets the username property for thisRowSet
object to the givenString
.boolean
RowSetWriter.writeData(RowSetInternal caller)
Writes the changes in thisRowSetWriter
object's rowset back to the data source from which it got its data.ModifierConstructorDescriptionConnectionEvent(PooledConnection con, SQLException ex)
Constructs aConnectionEvent
object initialized with the givenPooledConnection
object andSQLException
object.StatementEvent(PooledConnection con, PreparedStatement statement, SQLException exception)
Constructs aStatementEvent
with the specifiedPooledConnection
,PreparedStatement
andSQLException
-
Uses of SQLException in javax.sql.rowset
Modifier and TypeClassDescriptionclass
An extension ofSQLException
that provides information about database warnings set onRowSet
objects.Modifier and TypeMethodDescriptionvoid
Adds one or moreRowSet
objects contained in the given array ofRowSet
objects to thisJoinRowSet
object and sets the match column for each of theRowSet
objects to the match columns in the given array of column indexes.void
Adds one or moreRowSet
objects contained in the given array ofRowSet
objects to thisJoinRowSet
object and sets the match column for each of theRowSet
objects to the match columns in the given array of column names.void
Adds the givenRowSet
object to thisJoinRowSet
object.void
Adds the givenRowSet
object to thisJoinRowSet
object and sets the designated column as the match column for theRowSet
object.void
Adds rowset to thisJoinRowSet
object and sets the designated column as the match column.void
BaseRowSet.clearParameters()
Clears all of the current parameter values in thisRowSet
object's internal representation of the parameters to be set in thisRowSet
object's command when it is executed.boolean
CachedRowSet.columnUpdated(int idx)
Indicates whether the designated column in the current row of thisCachedRowSet
object has been updated.boolean
CachedRowSet.columnUpdated(String columnName)
Indicates whether the designated column in the current row of thisCachedRowSet
object has been updated.void
CachedRowSet.commit()
EachCachedRowSet
object'sSyncProvider
contains aConnection
object from theResultSet
or JDBC properties passed to it's constructors.void
JdbcRowSet.commit()
EachJdbcRowSet
contains aConnection
object from theResultSet
or JDBC properties passed to it's constructors.RowSetFactory.createCachedRowSet()
Creates a new instance of a CachedRowSet.CachedRowSet.createCopy()
Creates aRowSet
object that is a deep copy of the data in thisCachedRowSet
object.CachedRowSet.createCopyNoConstraints()
Creates aCachedRowSet
object that is a deep copy of thisCachedRowSet
object's data but is independent of it.CachedRowSet.createCopySchema()
Creates aCachedRowSet
object that is an empty copy of thisCachedRowSet
object.RowSetFactory.createFilteredRowSet()
Creates a new instance of a FilteredRowSet.RowSetFactory.createJdbcRowSet()
Creates a new instance of a JdbcRowSet.RowSetFactory.createJoinRowSet()
Creates a new instance of a JoinRowSet.CachedRowSet.createShared()
Returns a newRowSet
object backed by the same data as that of thisCachedRowSet
object.RowSetFactory.createWebRowSet()
Creates a new instance of a WebRowSet.boolean
This method is called by aFilteredRowSet
object to check whether the value lies between the filtering criterion (or criteria if multiple constraints exist) set using thesetFilter()
method.boolean
This method is called by theFilteredRowSet
object to check whether the value lies between the filtering criteria set using the setFilter method.void
CachedRowSet.execute(Connection conn)
Populates thisCachedRowSet
object with data, using the given connection to produce the result set from which the data will be read.boolean
JdbcRowSet.getAutoCommit()
EachJdbcRowSet
contains aConnection
object from the originalResultSet
or JDBC properties passed to it.RowSetMetaDataImpl.getCatalogName(int columnIndex)
Retrieves the catalog name of the table from which the value in the designated column was derived.RowSetMetaDataImpl.getColumnClassName(int columnIndex)
Retrieves the fully-qualified name of the class in the Java programming language to which a value in the designated column will be mapped.int
RowSetMetaDataImpl.getColumnCount()
Retrieves the number of columns in theRowSet
object for which thisRowSetMetaDataImpl
object was created.int
RowSetMetaDataImpl.getColumnDisplaySize(int columnIndex)
Retrieves the normal maximum width in chars of the designated column.RowSetMetaDataImpl.getColumnLabel(int columnIndex)
Retrieves the suggested column title for the designated column for use in printouts and displays.RowSetMetaDataImpl.getColumnName(int columnIndex)
Retrieves the name of the designated column.int
RowSetMetaDataImpl.getColumnType(int columnIndex)
Retrieves the type code (one of thejava.sql.Types
constants) for the SQL type of the value stored in the designated column.RowSetMetaDataImpl.getColumnTypeName(int columnIndex)
Retrieves the DBMS-specific type name for values stored in the designated column.int
BaseRowSet.getConcurrency()
Returns the concurrency for thisRowSet
object.boolean
BaseRowSet.getEscapeProcessing()
Ascertains whether escape processing is enabled for thisRowSet
object.int
BaseRowSet.getFetchDirection()
Retrieves thisRowSet
object's current setting for the fetch direction.int
BaseRowSet.getFetchSize()
Returns the fetch size for thisRowSet
object.int
JoinRowSet.getJoinType()
Returns aint
describing the set SQLJOIN
type governing this JoinRowSet instance.int[]
CachedRowSet.getKeyColumns()
Returns an array containing one or more column numbers indicating the columns that form a key that uniquely identifies a row in thisCachedRowSet
object.int[]
Joinable.getMatchColumnIndexes()
Retrieves the indexes of the match columns that were set for thisRowSet
object with the methodsetMatchColumn(int[] columnIdxes)
.String[]
Joinable.getMatchColumnNames()
Retrieves the names of the match columns that were set for thisRowSet
object with the methodsetMatchColumn(String [] columnNames)
.int
BaseRowSet.getMaxFieldSize()
Retrieves the maximum number of bytes that can be used for a column value in thisRowSet
object.int
BaseRowSet.getMaxRows()
Retrieves the maximum number of rows that thisRowSet
object may contain.CachedRowSet.getOriginal()
Returns aResultSet
object containing the original value of thisCachedRowSet
object.CachedRowSet.getOriginalRow()
Returns aResultSet
object containing the original value for the current row only of thisCachedRowSet
object.Object[]
BaseRowSet.getParams()
Retrieves an array containing the parameter values (both Objects and primitives) that have been set for thisRowSet
object's command and throws anSQLException
object if all parameters have not been set.int
RowSetMetaDataImpl.getPrecision(int columnIndex)
Retrieves the total number of digits for values stored in the designated column.int
BaseRowSet.getQueryTimeout()
Retrieves the maximum number of seconds the driver will wait for a query to execute.String[]
JoinRowSet.getRowSetNames()
Returns aString
array containing the names of theRowSet
objects added to thisJoinRowSet
object.Collection<?>
JoinRowSet.getRowSets()
Returns aCollection
object containing theRowSet
objects that have been added to thisJoinRowSet
object.CachedRowSet.getRowSetWarnings()
Retrieves the first warning reported by calls on thisRowSet
object.JdbcRowSet.getRowSetWarnings()
Retrieves the first warning reported by calls on thisJdbcRowSet
object.int
RowSetMetaDataImpl.getScale(int columnIndex)
Retrieves the number of digits to the right of the decimal point for values stored in the designated column.RowSetMetaDataImpl.getSchemaName(int columnIndex)
Retrieves the schema name of the table from which the value in the designated column was derived.boolean
BaseRowSet.getShowDeleted()
Retrieves aboolean
indicating whether rows marked for deletion appear in the set of current rows.boolean
CachedRowSet.getShowDeleted()
Retrieves aboolean
indicating whether rows marked for deletion appear in the set of current rows.boolean
JdbcRowSet.getShowDeleted()
Retrieves aboolean
indicating whether rows marked for deletion appear in the set of current rows.CachedRowSet.getSyncProvider()
Retrieves theSyncProvider
implementation for thisCachedRowSet
object.CachedRowSet.getTableName()
Returns an identifier for the object (table) that was used to create thisCachedRowSet
object.RowSetMetaDataImpl.getTableName(int columnIndex)
Retrieves the name of the table from which the value in the designated column was derived.int
BaseRowSet.getType()
Returns the type of thisRowSet
object.BaseRowSet.getUrl()
Retrieves the JDBC URL that thisRowSet
object'sjavax.sql.Reader
object uses to make a connection with a relational database using a JDBC technology-enabled driver.JoinRowSet.getWhereClause()
Return a SQL-like description of the WHERE clause being used in a JoinRowSet object.boolean
RowSetMetaDataImpl.isAutoIncrement(int columnIndex)
Retrieves whether a value stored in the designated column is automatically numbered, and thus readonly.boolean
RowSetMetaDataImpl.isCaseSensitive(int columnIndex)
Indicates whether the case of the designated column's name matters.boolean
RowSetMetaDataImpl.isCurrency(int columnIndex)
Indicates whether a value stored in the designated column is a cash value.boolean
RowSetMetaDataImpl.isDefinitelyWritable(int columnIndex)
Indicates whether a write operation on the designated column will definitely succeed.int
RowSetMetaDataImpl.isNullable(int columnIndex)
Retrieves a constant indicating whether it is possible to store aNULL
value in the designated column.boolean
RowSetMetaDataImpl.isReadOnly(int columnIndex)
Indicates whether the designated column is definitely not writable, thus readonly.boolean
RowSetMetaDataImpl.isSearchable(int columnIndex)
Indicates whether a value stored in the designated column can be used in aWHERE
clause.boolean
RowSetMetaDataImpl.isSigned(int columnIndex)
Indicates whether a value stored in the designated column is a signed number.boolean
RowSetMetaDataImpl.isWrapperFor(Class<?> interfaces)
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.boolean
RowSetMetaDataImpl.isWritable(int columnIndex)
Indicates whether it is possible for a write operation on the designated column to succeed.static RowSetFactory
RowSetProvider.newFactory()
Creates a new instance of aRowSetFactory
implementation.static RowSetFactory
RowSetProvider.newFactory(String factoryClassName, ClassLoader cl)
Creates a new instance of aRowSetFactory
from the specified factory class name.boolean
CachedRowSet.nextPage()
Increments the current page of theCachedRowSet
.protected void
BaseRowSet.notifyCursorMoved()
Notifies all of the listeners registered with thisRowSet
object that its cursor has moved.protected void
BaseRowSet.notifyRowChanged()
Notifies all of the listeners registered with thisRowSet
object that one of its rows has changed.protected void
BaseRowSet.notifyRowSetChanged()
Notifies all of the listeners registered with thisRowSet
object that its entire contents have changed.void
Populates thisCachedRowSet
object with data from the givenResultSet
object.void
Populates thisCachedRowSet
object with data from the givenResultSet
object.boolean
CachedRowSet.previousPage()
Decrements the current page of theCachedRowSet
.void
WebRowSet.readXml(InputStream iStream)
Reads a stream based XML input to populate thisWebRowSet
object.void
Reads aWebRowSet
object in its XML format from the givenReader
object.void
CachedRowSet.release()
Releases the current contents of thisCachedRowSet
object and sends arowSetChanged
event to all registered listeners.void
CachedRowSet.restoreOriginal()
Restores thisCachedRowSet
object to its original value, that is, its value before the last set of changes.void
CachedRowSet.rollback()
EachCachedRowSet
object'sSyncProvider
contains aConnection
object from the originalResultSet
or JDBC properties passed to it.void
EachCachedRowSet
object'sSyncProvider
contains aConnection
object from the originalResultSet
or JDBC properties passed to it.void
JdbcRowSet.rollback()
EachJdbcRowSet
contains aConnection
object from the originalResultSet
or JDBC properties passed to it.void
EachJdbcRowSet
contains aConnection
object from the originalResultSet
or JDBC properties passed to it.void
CachedRowSet.rowSetPopulated(RowSetEvent event, int numRows)
Notifies registered listeners that a RowSet object in the given RowSetEvent object has populated a number of additional rows.void
Sets the designated parameter to anArray
object in the Java programming language.void
BaseRowSet.setAsciiStream(int parameterIndex, InputStream x)
Sets the designated parameter in thisRowSet
object's command to the given input stream.void
BaseRowSet.setAsciiStream(int parameterIndex, InputStream x, int length)
Sets the designated parameter to the givenjava.io.InputStream
object, which will have the specified number of bytes.void
BaseRowSet.setAsciiStream(String parameterName, InputStream x)
Sets the designated parameter to the given input stream.void
BaseRowSet.setAsciiStream(String parameterName, InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
JdbcRowSet.setAutoCommit(boolean autoCommit)
EachJdbcRowSet
contains aConnection
object from the originalResultSet
or JDBC properties passed to it.void
RowSetMetaDataImpl.setAutoIncrement(int columnIndex, boolean property)
Sets whether the designated column is automatically numbered, thus read-only, to the givenboolean
value.void
BaseRowSet.setBigDecimal(int parameterIndex, BigDecimal x)
Sets the designated parameter to the givenjava.lang.BigDecimal
value.void
BaseRowSet.setBigDecimal(String parameterName, BigDecimal x)
Sets the designated parameter to the givenjava.math.BigDecimal
value.void
BaseRowSet.setBinaryStream(int parameterIndex, InputStream x)
Sets the designated parameter in thisRowSet
object's command to the given input stream.void
BaseRowSet.setBinaryStream(int parameterIndex, InputStream x, int length)
Sets the designated parameter to the givenjava.io.InputStream
object, which will have the specified number of bytes.void
BaseRowSet.setBinaryStream(String parameterName, InputStream x)
Sets the designated parameter to the given input stream.void
BaseRowSet.setBinaryStream(String parameterName, InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
BaseRowSet.setBlob(int parameterIndex, InputStream inputStream)
Sets the designated parameter to aInputStream
object.void
BaseRowSet.setBlob(int parameterIndex, InputStream inputStream, long length)
Sets the designated parameter to aInputStream
object.void
Sets the designated parameter to the givenBlob
object in the Java programming language.void
BaseRowSet.setBlob(String parameterName, InputStream inputStream)
Sets the designated parameter to aInputStream
object.void
BaseRowSet.setBlob(String parameterName, InputStream inputStream, long length)
Sets the designated parameter to aInputStream
object.void
Sets the designated parameter to the givenjava.sql.Blob
object.void
BaseRowSet.setBoolean(int parameterIndex, boolean x)
Sets the designated parameter to the givenboolean
in the Java programming language.void
BaseRowSet.setBoolean(String parameterName, boolean x)
Sets the designated parameter to the given Javaboolean
value.void
BaseRowSet.setByte(int parameterIndex, byte x)
Sets the designated parameter to the givenbyte
in the Java programming language.void
Sets the designated parameter to the given Javabyte
value.void
BaseRowSet.setBytes(int parameterIndex, byte[] x)
Sets the designated parameter to the given array of bytes.void
Sets the designated parameter to the given Java array of bytes.void
RowSetMetaDataImpl.setCaseSensitive(int columnIndex, boolean property)
Sets whether the name of the designated column is case sensitive to the givenboolean
.void
RowSetMetaDataImpl.setCatalogName(int columnIndex, String catalogName)
Sets the catalog name of the table from which the designated column was derived to catalogName.void
BaseRowSet.setCharacterStream(int parameterIndex, Reader reader)
Sets the designated parameter in thisRowSet
object's command to the givenReader
object.void
BaseRowSet.setCharacterStream(int parameterIndex, Reader reader, int length)
Sets the designated parameter to the givenjava.io.Reader
object, which will have the specified number of characters.void
BaseRowSet.setCharacterStream(String parameterName, Reader reader)
Sets the designated parameter to the givenReader
object.void
BaseRowSet.setCharacterStream(String parameterName, Reader reader, int length)
Sets the designated parameter to the givenReader
object, which is the given number of characters long.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to the givenClob
object in the Java programming language.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to the givenjava.sql.Clob
object.void
RowSetMetaDataImpl.setColumnCount(int columnCount)
Sets to the given number the number of columns in theRowSet
object for which thisRowSetMetaDataImpl
object was created.void
RowSetMetaDataImpl.setColumnDisplaySize(int columnIndex, int size)
Sets the normal maximum number of chars in the designated column to the given number.void
RowSetMetaDataImpl.setColumnLabel(int columnIndex, String label)
Sets the suggested column label for use in printouts and displays, if any, to label.void
RowSetMetaDataImpl.setColumnName(int columnIndex, String columnName)
Sets the column name of the designated column to the given name.void
RowSetMetaDataImpl.setColumnType(int columnIndex, int SQLType)
Sets the SQL type code for values stored in the designated column to the given type code from the classjava.sql.Types
.void
RowSetMetaDataImpl.setColumnTypeName(int columnIndex, String typeName)
Sets the type name used by the data source for values stored in the designated column to the given type name.void
BaseRowSet.setCommand(String cmd)
Sets thisRowSet
object'scommand
property to the givenString
object and clears the parameters, if any, that were set for the previous command.void
BaseRowSet.setConcurrency(int concurrency)
Sets the concurrency for thisRowSet
object to the specified concurrency.void
RowSetMetaDataImpl.setCurrency(int columnIndex, boolean property)
Sets whether a value stored in the designated column is a cash value to the givenboolean
.void
BaseRowSet.setDataSourceName(String name)
Sets theDataSource
name property for thisRowSet
object to the given logical name and sets thisRowSet
object's Url property tonull
.void
Sets the designated parameter to the givenjava.sql.Date
value.void
Sets the designated parameter to the givenjava.sql.Date
object.void
Sets the designated parameter to the givenjava.sql.Date
value using the default time zone of the virtual machine that is running the application.void
Sets the designated parameter to the givenjava.sql.Date
value, using the givenCalendar
object.void
BaseRowSet.setDouble(int parameterIndex, double x)
Sets the designated parameter to the givendouble
in the Java programming language.void
Sets the designated parameter to the given Javadouble
value.void
BaseRowSet.setEscapeProcessing(boolean enable)
Sets to the givenboolean
whether or not the driver will scan for escape syntax and do escape substitution before sending SQL statements to the database.void
BaseRowSet.setFetchDirection(int direction)
Gives the driver a performance hint as to the direction in which the rows in thisRowSet
object will be processed.void
BaseRowSet.setFetchSize(int rows)
Sets the fetch size for thisRowSet
object to the given number of rows.void
Applies the givenPredicate
object to thisFilteredRowSet
object.void
BaseRowSet.setFloat(int parameterIndex, float x)
Sets the designated parameter to the givenfloat
in the Java programming language.void
Sets the designated parameter to the given Javafloat
value.void
BaseRowSet.setInt(int parameterIndex, int x)
Sets the designated parameter to anint
in the Java programming language.void
Sets the designated parameter to the given Javaint
value.void
JoinRowSet.setJoinType(int joinType)
Allow the application to adjust the type ofJOIN
imposed on tables contained within the JoinRowSet object instance.void
CachedRowSet.setKeyColumns(int[] keys)
Sets thisCachedRowSet
object'skeyCols
field with the given array of column numbers, which forms a key for uniquely identifying a row in thisCachedRowSet
object.void
BaseRowSet.setLong(int parameterIndex, long x)
Sets the designated parameter to the givenlong
in the Java programming language.void
Sets the designated parameter to the given Javalong
value.void
Joinable.setMatchColumn(int columnIdx)
Sets the designated column as the match column for thisRowSet
object.void
Joinable.setMatchColumn(int[] columnIdxes)
Sets the designated columns as the match column for thisRowSet
object.void
Joinable.setMatchColumn(String columnName)
Sets the designated column as the match column for thisRowSet
object.void
Joinable.setMatchColumn(String[] columnNames)
Sets the designated columns as the match column for thisRowSet
object.void
BaseRowSet.setMaxFieldSize(int max)
Sets the maximum number of bytes that can be used for a column value in thisRowSet
object to the given number.void
BaseRowSet.setMaxRows(int max)
Sets the maximum number of rows that thisRowSet
object may contain to the given number.void
CachedRowSet.setMetaData(RowSetMetaData md)
Sets the metadata for thisCachedRowSet
object with the givenRowSetMetaData
object.void
BaseRowSet.setNCharacterStream(int parameterIndex, Reader value)
Sets the designated parameter in thisRowSet
object's command to aReader
object.void
BaseRowSet.setNCharacterStream(int parameterIndex, Reader value, long length)
Sets the designated parameter to aReader
object.void
BaseRowSet.setNCharacterStream(String parameterName, Reader value)
Sets the designated parameter to aReader
object.void
BaseRowSet.setNCharacterStream(String parameterName, Reader value, long length)
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to ajava.sql.NClob
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to aReader
object.void
Sets the designated parameter to ajava.sql.NClob
object.void
BaseRowSet.setNString(int parameterIndex, String value)
Sets the designated parameter to the givenString
object.void
BaseRowSet.setNString(String parameterName, String value)
Sets the designated parameter to the givenString
object.void
BaseRowSet.setNull(int parameterIndex, int sqlType)
Sets the designated parameter to SQLNULL
.void
Sets the designated parameter to SQLNULL
.void
Sets the designated parameter to SQLNULL
.void
Sets the designated parameter to SQLNULL
.void
RowSetMetaDataImpl.setNullable(int columnIndex, int property)
Sets whether a value stored in the designated column can be set toNULL
to the given constant from the interfaceResultSetMetaData
.void
Sets the designated parameter to anObject
in the Java programming language.void
Sets the value of the designated parameter with the givenObject
value.void
Sets the designated parameter to anObject
in the Java programming language.void
Sets the value of the designated parameter with the given object.void
Sets the value of the designated parameter with the given object.void
Sets the value of the designated parameter with the given object.void
CachedRowSet.setOriginalRow()
Sets the current row in thisCachedRowSet
object as the original row.void
CachedRowSet.setPageSize(int size)
Sets theCachedRowSet
object's page-size.void
RowSetMetaDataImpl.setPrecision(int columnIndex, int precision)
Sets the total number of decimal digits in a value stored in the designated column to the given number.void
BaseRowSet.setQueryTimeout(int seconds)
Sets to the given number the maximum number of seconds the driver will wait for a query to execute.void
Sets the designated parameter to the givenRef
object in the Java programming language.void
Sets the designated parameter to the givenjava.sql.RowId
object.void
Sets the designated parameter to the givenjava.sql.RowId
object.void
RowSetMetaDataImpl.setScale(int columnIndex, int scale)
Sets the number of digits to the right of the decimal point in a value stored in the designated column to the given number.void
RowSetMetaDataImpl.setSchemaName(int columnIndex, String schemaName)
Sets the designated column's table's schema name, if any, to schemaName.void
RowSetMetaDataImpl.setSearchable(int columnIndex, boolean property)
Sets whether a value stored in the designated column can be used in aWHERE
clause to the givenboolean
value.void
BaseRowSet.setShort(int parameterIndex, short x)
Sets the designated parameter to the givenshort
in the Java programming language.void
Sets the designated parameter to the given Javashort
value.void
BaseRowSet.setShowDeleted(boolean value)
Sets the propertyshowDeleted
to the givenboolean
value, which determines whether rows marked for deletion appear in the set of current rows.void
CachedRowSet.setShowDeleted(boolean b)
Sets the propertyshowDeleted
to the givenboolean
value, which determines whether rows marked for deletion appear in the set of current rows.void
JdbcRowSet.setShowDeleted(boolean b)
Sets the propertyshowDeleted
to the givenboolean
value.void
RowSetMetaDataImpl.setSigned(int columnIndex, boolean property)
Sets whether a value stored in the designated column is a signed number to the givenboolean
.void
Sets the designated parameter to the givenjava.sql.SQLXML
object.void
Sets the designated parameter to the givenjava.sql.SQLXML
object.void
Sets the designated parameter to the givenString
value.void
Sets the designated parameter to the given JavaString
value.void
CachedRowSet.setSyncProvider(String provider)
Sets theSyncProvider
object for thisCachedRowSet
object to the one specified.void
CachedRowSet.setTableName(String tabName)
Sets the identifier for the table from which thisCachedRowSet
object was derived to the given table name.void
RowSetMetaDataImpl.setTableName(int columnIndex, String tableName)
Sets the name of the table from which the designated column was derived to the given table name.void
Sets the designated parameter to the givenjava.sql.Time
value.void
Sets the designated parameter to the givenjava.sql.Time
object.void
Sets the designated parameter to the givenjava.sql.Time
value.void
Sets the designated parameter to the givenjava.sql.Time
value, using the givenCalendar
object.void
BaseRowSet.setTimestamp(int parameterIndex, Timestamp x)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
BaseRowSet.setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
Sets the designated parameter to the givenjava.sql.Timestamp
object.void
BaseRowSet.setTimestamp(String parameterName, Timestamp x)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
BaseRowSet.setTimestamp(String parameterName, Timestamp x, Calendar cal)
Sets the designated parameter to the givenjava.sql.Timestamp
value, using the givenCalendar
object.void
BaseRowSet.setTransactionIsolation(int level)
Sets the transaction isolation property for this JDBCRowSet
object to the given constant.void
BaseRowSet.setType(int type)
Sets the type for thisRowSet
object to the specified type.void
BaseRowSet.setUnicodeStream(int parameterIndex, InputStream x, int length)
Deprecated.getCharacterStream should be used in its placevoid
Sets the Url property for thisRowSet
object to the givenString
object and sets the dataSource name property tonull
.void
Sets the designated parameter to the givenjava.net.URL
value.JoinRowSet.toCachedRowSet()
Creates a newCachedRowSet
object containing the data in thisJoinRowSet
object, which can be saved to a data source using theSyncProvider
object for theCachedRowSet
object.Collection<?>
CachedRowSet.toCollection()
Converts thisCachedRowSet
object to aCollection
object that contains all of thisCachedRowSet
object's data.Collection<?>
CachedRowSet.toCollection(int column)
Converts the designated column in thisCachedRowSet
object to aCollection
object.Collection<?>
CachedRowSet.toCollection(String column)
Converts the designated column in thisCachedRowSet
object to aCollection
object.void
CachedRowSet.undoDelete()
Cancels the deletion of the current row and notifies listeners that a row has changed.void
CachedRowSet.undoInsert()
Immediately removes the current row from thisCachedRowSet
object if the row has been inserted, and also notifies listeners that a row has changed.void
CachedRowSet.undoUpdate()
Immediately reverses the last update operation if the row has been modified.void
Joinable.unsetMatchColumn(int columnIdx)
Unsets the designated column as the match column for thisRowSet
object.void
Joinable.unsetMatchColumn(int[] columnIdxes)
Unsets the designated columns as the match column for thisRowSet
object.void
Joinable.unsetMatchColumn(String columnName)
Unsets the designated column as the match column for thisRowSet
object.void
Joinable.unsetMatchColumn(String[] columnName)
Unsets the designated columns as the match columns for thisRowSet
object.<T> T
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.void
WebRowSet.writeXml(OutputStream oStream)
Writes the data, properties, and metadata for thisWebRowSet
object to the givenOutputStream
object in XML format.void
Writes the data, properties, and metadata for thisWebRowSet
object to the givenWriter
object in XML format.void
WebRowSet.writeXml(ResultSet rs, OutputStream oStream)
Populates thisWebRowSet
object with the contents of the givenResultSet
object and writes its data, properties, and metadata to the givenOutputStream
object in XML format.void
Populates thisWebRowSet
object with the contents of the givenResultSet
object and writes its data, properties, and metadata to the givenWriter
object in XML format. -
Uses of SQLException in javax.sql.rowset.serial
Modifier and TypeClassDescriptionclass
Indicates and an error with the serialization or de-serialization of SQL types such asBLOB, CLOB, STRUCT or ARRAY
in addition to SQL types such asDATALINK and JAVAOBJECT
Modifier and TypeMethodDescriptionvoid
SerialArray.free()
This method frees theSerialArray
object and releases the resources that it holds.void
SerialBlob.free()
This method frees theSerialBlob
object and releases the resources that it holds.void
SerialClob.free()
This method frees theSerialClob
object and releases the resources that it holds.SerialClob.getAsciiStream()
Retrieves theCLOB
value designated by thisSerialClob
object as an ascii stream.SerialBlob.getBinaryStream(long pos, long length)
Returns anInputStream
object that contains a partialBlob
value, starting with the byte specified by pos, which is length bytes in length.SerialClob.getCharacterStream(long pos, long length)
Returns aReader
object that contains a partialSerialClob
value, starting with the character specified by pos, which is length characters in length.long
SerialBlob.position(byte[] pattern, long start)
Returns the position in thisSerialBlob
object where the given pattern of bytes begins, starting the search at the specified position.long
Returns the position in thisSerialBlob
object where the givenBlob
object begins, starting the search at the specified position.long
Returns the position in thisSerialClob
object where the givenString
object begins, starting the search at the specified position.long
Returns the position in thisSerialClob
object where the givenClob
signature begins, starting the search at the specified position.SQLInputImpl.readArray()
Reads an SQLARRAY
value from the stream and returns it as anArray
object in the Java programming language.SQLInputImpl.readAsciiStream()
Returns the next attribute in thisSQLInputImpl
object as a stream of ASCII characters.SQLInputImpl.readBigDecimal()
Retrieves the next attribute in thisSQLInputImpl
object as ajava.math.BigDecimal
.SQLInputImpl.readBinaryStream()
Returns the next attribute in thisSQLInputImpl
object as a stream of uninterpreted bytes.SQLInputImpl.readBlob()
Retrieves theBLOB
value at the head of thisSQLInputImpl
object as aBlob
object in the Java programming language.boolean
SQLInputImpl.readBoolean()
Retrieves the next attribute in thisSQLInputImpl
object as aboolean
in the Java programming language.byte
SQLInputImpl.readByte()
Retrieves the next attribute in thisSQLInputImpl
object as abyte
in the Java programming language.byte[]
SQLInputImpl.readBytes()
Retrieves the next attribute in thisSQLInputImpl
object as an array of bytes.SQLInputImpl.readCharacterStream()
Retrieves the next attribute in thisSQLInputImpl
object as a stream of Unicode characters.SQLInputImpl.readClob()
Retrieves theCLOB
value at the head of thisSQLInputImpl
object as aClob
object in the Java programming language.SQLInputImpl.readDate()
Retrieves the next attribute in thisSQLInputImpl
as ajava.sql.Date
object.double
SQLInputImpl.readDouble()
Retrieves the next attribute in thisSQLInputImpl
object as adouble
in the Java programming language.float
SQLInputImpl.readFloat()
Retrieves the next attribute in thisSQLInputImpl
object as afloat
in the Java programming language.int
SQLInputImpl.readInt()
Retrieves the next attribute in thisSQLInputImpl
object as anint
in the Java programming language.long
SQLInputImpl.readLong()
Retrieves the next attribute in thisSQLInputImpl
object as along
in the Java programming language.SQLInputImpl.readNClob()
Reads an SQLNCLOB
value from the stream and returns it as aClob
object in the Java programming language.SQLInputImpl.readNString()
Reads the next attribute in the stream and returns it as aString
in the Java programming language.SQLInputImpl.readObject()
Retrieves the value at the head of thisSQLInputImpl
object as anObject
in the Java programming language.SQLInputImpl.readRef()
Retrieves the value at the head of thisSQLInputImpl
object as aRef
object in the Java programming language.SQLInputImpl.readRowId()
Reads an SQLROWID
value from the stream and returns it as aRowId
object in the Java programming language.short
SQLInputImpl.readShort()
Retrieves the next attribute in thisSQLInputImpl
object as ashort
in the Java programming language.SQLInputImpl.readSQLXML()
Reads an SQLXML
value from the stream and returns it as aSQLXML
object in the Java programming language.SQLInputImpl.readString()
Retrieves the next attribute in thisSQLInputImpl
object as aString
in the Java programming language.SQLInputImpl.readTime()
Retrieves the next attribute in thisSQLInputImpl
object as ajava.sql.Time
object.SQLInputImpl.readTimestamp()
Retrieves the next attribute in thisSQLInputImpl
object as ajava.sql.Timestamp
object.SQLInputImpl.readURL()
Reads an SQLDATALINK
value from the stream and returns it as anURL
object in the Java programming language.SerialClob.setAsciiStream(long pos)
Retrieves a stream to be used to write Ascii characters to theCLOB
value that thisSerialClob
object represents, starting at positionpos
.SerialBlob.setBinaryStream(long pos)
Retrieves a stream that can be used to write to theBLOB
value that thisBlob
object represents.int
SerialBlob.setBytes(long pos, byte[] bytes)
Writes the given array of bytes to theBLOB
value that thisBlob
object represents, starting at positionpos
, and returns the number of bytes written.int
SerialBlob.setBytes(long pos, byte[] bytes, int offset, int length)
Writes all or part of the givenbyte
array to theBLOB
value that thisBlob
object represents and returns the number of bytes written.SerialClob.setCharacterStream(long pos)
Retrieves a stream to be used to write a stream of Unicode characters to theCLOB
value that thisSerialClob
object represents, at positionpos
.boolean
SQLInputImpl.wasNull()
Ascertains whether the last value read from thisSQLInputImpl
object wasnull
.void
SQLOutputImpl.writeArray(Array x)
Writes anArray
object in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeAsciiStream(InputStream x)
Writes a stream of ASCII characters to thisSQLOutputImpl
object.void
SQLOutputImpl.writeBigDecimal(BigDecimal x)
Writes ajava.math.BigDecimal
object in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeBinaryStream(InputStream x)
Writes a stream of uninterpreted bytes to thisSQLOutputImpl
object.void
Writes aBlob
object in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeBoolean(boolean x)
Writes aboolean
in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeByte(byte x)
Writes abyte
in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeBytes(byte[] x)
Writes an array ofbytes
in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeCharacterStream(Reader x)
Writes a stream of Unicode characters to thisSQLOutputImpl
object.void
Writes aClob
object in the Java programming language to thisSQLOutputImpl
object.void
Writes ajava.sql.Date
object in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeDouble(double x)
Writes adouble
in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeFloat(float x)
Writes afloat
in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeInt(int x)
Writes anint
in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeLong(long x)
Writes along
in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeNClob(NClob x)
Writes an SQLNCLOB
value to the stream.void
SQLOutputImpl.writeNString(String x)
Writes the next attribute to the stream as aString
in the Java programming language.void
SQLOutputImpl.writeObject(SQLData x)
Writes to the stream the data contained in the givenSQLData
object.void
Writes aRef
object in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeRowId(RowId x)
Writes an SQLROWID
value to the stream.void
SQLOutputImpl.writeShort(short x)
Writes ashort
in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeSQLXML(SQLXML x)
Writes an SQLXML
value to the stream.void
SQLOutputImpl.writeString(String x)
Writes aString
in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeStruct(Struct x)
Writes aStruct
object in the Java programming language to thisSQLOutputImpl
object.void
Writes ajava.sql.Time
object in the Java programming language to thisSQLOutputImpl
object.void
SQLOutputImpl.writeTimestamp(Timestamp x)
Writes ajava.sql.Timestamp
object in the Java programming language to thisSQLOutputImpl
object.void
Writes anjava.sql.Type.DATALINK
object in the Java programming language to thisSQLOutputImpl
object.ModifierConstructorDescriptionSerialArray(Array array)
Constructs a newSerialArray
object from the givenArray
object.SerialArray(Array array, Map<String,Class<?>> map)
Constructs a newSerialArray
object from the givenArray
object, using the given type map for the custom mapping of each element when the elements are SQL UDTs.SerialBlob(byte[] b)
Constructs aSerialBlob
object that is a serialized version of the givenbyte
array.SerialBlob(Blob blob)
Constructs aSerialBlob
object that is a serialized version of the givenBlob
object.SerialClob(char[] ch)
Constructs aSerialClob
object that is a serialized version of the givenchar
array.SerialClob(Clob clob)
Constructs aSerialClob
object that is a serialized version of the givenClob
object.Constructs aSerialRef
object from the givenRef
object.SQLInputImpl(Object[] attributes, Map<String,Class<?>> map)
Creates anSQLInputImpl
object initialized with the given array of attributes and the given type map.SQLOutputImpl(Vector<?> attributes, Map<String,?> map)
Creates a newSQLOutputImpl
object initialized with the given vector of attributes and type map. -
Uses of SQLException in javax.sql.rowset.spi
Modifier and TypeClassDescriptionclass
Indicates an error withSyncFactory
mechanism.class
Indicates an error with theSyncProvider
mechanism.Modifier and TypeMethodDescriptionvoid
TransactionalWriter.commit()
Makes permanent all changes that have been performed by theacceptChanges
method since the last call to either thecommit
orrollback
methods.SyncResolver.getConflictValue(int index)
Retrieves the value in the designated column in the current row of thisSyncResolver
object, which is the value in the data source that caused a conflict.SyncResolver.getConflictValue(String columnName)
Retrieves the value in the designated column in the current row of thisSyncResolver
object, which is the value in the data source that caused a conflict.boolean
SyncResolver.nextConflict()
Moves the cursor down from its current position to the next row that contains a conflict value.boolean
SyncResolver.previousConflict()
Moves the cursor up from its current position to the previous conflict row in thisSyncResolver
object.void
Reads and parses the givenWebRowSet
object from the given input stream in XML format.void
TransactionalWriter.rollback()
Undoes all changes made in the current transaction.void
Undoes all changes made in the current transaction made prior to the givenSavepoint
object.void
SyncResolver.setResolvedValue(int index, Object obj)
Sets obj as the value in column index in the current row of theRowSet
object that is being synchronized.void
SyncResolver.setResolvedValue(String columnName, Object obj)
Sets obj as the value in column columnName in the current row of theRowSet
object that is being synchronized.void
Writes the givenWebRowSet
object to the specifiedjava.io.Writer
output stream as an XML document.
getBigDecimal(int parameterIndex)
orgetBigDecimal(String parameterName)