|
Java™ Platform Standard Ed. 7 DRAFT ea-b34 |
|||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||
| Packages that use SQLException | |
|---|---|
| java.sql | Provides the API for accessing and processing data stored in a data source (usually a relational database) using the JavaTM programming language. |
| javax.sql | Provides the API for server side data source access and processing from the JavaTM programming language. |
| javax.sql.rowset | Standard interfaces and base classes for JDBC RowSet
implementations. |
| javax.sql.rowset.serial | Provides utility classes to allow serializable mappings between SQL types and data types in the Java programming language. |
| javax.sql.rowset.spi | The standard classes and interfaces that a third party vendor has to use in its implementation of a synchronization provider. |
| Uses of SQLException in java.sql |
|---|
| Subclasses of SQLException in java.sql | |
|---|---|
class |
BatchUpdateException
The subclass of SQLException thrown when an error
occurs during a batch update operation. |
class |
DataTruncation
An exception thrown as a DataTruncation exception
(on writes) or reported as a
DataTruncation warning (on reads)
when a data values is unexpectedly truncated for reasons other than its having
execeeded MaxFieldSize. |
class |
SQLClientInfoException
The subclass of SQLException is thrown when one or more client info properties
could not be set on a Connection. |
class |
SQLDataException
The subclass of SQLException thrown when the SQLState class value is '22'. |
class |
SQLFeatureNotSupportedException
The subclass of SQLException thrown when the SQLState class value is '0A'
( the value is 'zero' A). |
class |
SQLIntegrityConstraintViolationException
The subclass of SQLException thrown when the SQLState class value is '23'. |
class |
SQLInvalidAuthorizationSpecException
The subclass of SQLException thrown when the SQLState class value is '28'. |
class |
SQLNonTransientConnectionException
The subclass of SQLException thrown for the SQLState
class value '08', representing
that the connection operation that failed will not succeed when
the operation is retried without the cause of the failure being corrected. |
class |
SQLNonTransientException
The subclass of SQLException thrown when an instance where a retry
of the same operation would fail unless the cause of the SQLException
is corrected. |
class |
SQLRecoverableException
The subclass of SQLException thrown in situations where a
previously failed operation might be able to succeed if the application performs
some recovery steps and retries the entire transaction or in the case of a
distributed transaction, the transaction branch. |
class |
SQLSyntaxErrorException
The subclass of SQLException thrown when the SQLState class value is '42'. |
class |
SQLTimeoutException
The subclass of SQLException thrown when the timeout specified by Statement
has expired. |
class |
SQLTransactionRollbackException
The subclass of SQLException thrown when the SQLState class value is '40'. |
class |
SQLTransientConnectionException
The subclass of SQLException for the SQLState class
value '08', representing
that the connection operation that failed might be able to succeed when
the operation is retried without any application-level changes. |
class |
SQLTransientException
The subclass of SQLException is thrown in situations where a
previoulsy failed operation might be able to succeed when the operation is
retried without any intervention by application-level functionality. |
class |
SQLWarning
An exception that provides information on database access warnings. |
| Methods in java.sql that return SQLException | |
|---|---|
SQLException |
SQLException.getNextException()
Retrieves the exception chained to this SQLException object by setNextException(SQLException ex). |
| Methods in java.sql with parameters of type SQLException | |
|---|---|
void |
SQLException.setNextException(SQLException ex)
Adds an SQLException object to the end of the chain. |
| Methods in java.sql that throw SQLException | |
|---|---|
boolean |
ResultSet.absolute(int row)
Moves the cursor to the given row number in this ResultSet object. |
boolean |
Driver.acceptsURL(String url)
Retrieves whether the driver thinks that it can open a connection to the given URL. |
void |
PreparedStatement.addBatch()
Adds a set of parameters to this PreparedStatement
object's batch of commands. |
void |
Statement.addBatch(String sql)
Adds the given SQL command to the current list of commmands for this Statement object. |
void |
ResultSet.afterLast()
Moves the cursor to the end of this ResultSet object, just after the
last row. |
boolean |
DatabaseMetaData.allProceduresAreCallable()
Retrieves whether the current user can call all the procedures returned by the method getProcedures. |
boolean |
DatabaseMetaData.allTablesAreSelectable()
Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT
statement. |
boolean |
DatabaseMetaData.autoCommitFailureClosesAllResultSets()
Retrieves whether a SQLException while autoCommit is true inidcates
that all open ResultSets are closed, even ones that are holdable. |
void |
ResultSet.beforeFirst()
Moves the cursor to the front of this ResultSet object, just before the
first row. |
void |
Statement.cancel()
Cancels this Statement object if both the DBMS and
driver support aborting an SQL statement. |
void |
ResultSet.cancelRowUpdates()
Cancels the updates made to the current row in this ResultSet object. |
void |
Statement.clearBatch()
Empties this Statement object's current list of
SQL commands. |
void |
PreparedStatement.clearParameters()
Clears the current parameter values immediately. |
void |
Statement.clearWarnings()
Clears all the warnings reported on this Statement
object. |
void |
ResultSet.clearWarnings()
Clears all warnings reported on this ResultSet object. |
void |
Connection.clearWarnings()
Clears all warnings reported for this Connection object. |
void |
Statement.close()
Releases this Statement object's database
and JDBC resources immediately instead of waiting for
this to happen when it is automatically closed. |
void |
ResultSet.close()
Releases this ResultSet object's database and
JDBC resources immediately instead of waiting for
this to happen when it is automatically closed. |
void |
Connection.close()
Releases this Connection object's database and JDBC resources
immediately instead of waiting for them to be automatically released. |
void |
Connection.commit()
Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by this Connection object. |
Connection |
Driver.connect(String url,
Properties info)
Attempts to make a database connection to the given URL. |
Array |
Connection.createArrayOf(String typeName,
Object[] elements)
Factory method for creating Array objects. |
Blob |
Connection.createBlob()
Constructs an object that implements the Blob interface. |
Clob |
Connection.createClob()
Constructs an object that implements the Clob interface. |
NClob |
Connection.createNClob()
Constructs an object that implements the NClob interface. |
SQLXML |
Connection.createSQLXML()
Constructs an object that implements the SQLXML interface. |
Statement |
Connection.createStatement()
Creates a Statement object for sending
SQL statements to the database. |
Statement |
Connection.createStatement(int resultSetType,
int resultSetConcurrency)
Creates a Statement object that will generate
ResultSet objects with the given type and concurrency. |
Statement |
Connection.createStatement(int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
Creates a Statement object that will generate
ResultSet objects with the given type, concurrency,
and holdability. |
Struct |
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 this ResultSet object
and from the underlying database. |
boolean |
DatabaseMetaData.deletesAreDetected(int type)
Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted. |
static void |
DriverManager.deregisterDriver(Driver driver)
Drops a driver from the DriverManager's list. |
boolean |
DatabaseMetaData.doesMaxRowSizeIncludeBlobs()
Retrieves whether the return value for the method getMaxRowSize includes the SQL data types
LONGVARCHAR and LONGVARBINARY. |
boolean |
PreparedStatement.execute()
Executes the SQL statement in this PreparedStatement object,
which may be any kind of SQL statement. |
boolean |
Statement.execute(String sql)
Executes the given SQL statement, which may return multiple results. |
boolean |
Statement.execute(String sql,
int autoGeneratedKeys)
Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval. |
boolean |
Statement.execute(String sql,
int[] columnIndexes)
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. |
boolean |
Statement.execute(String sql,
String[] columnNames)
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. |
int[] |
Statement.executeBatch()
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. |
ResultSet |
PreparedStatement.executeQuery()
Executes the SQL query in this PreparedStatement object
and returns the ResultSet object generated by the query. |
ResultSet |
Statement.executeQuery(String sql)
Executes the given SQL statement, which returns a single ResultSet object. |
int |
PreparedStatement.executeUpdate()
Executes the SQL statement in this PreparedStatement object,
which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement. |
int |
Statement.executeUpdate(String sql)
Executes the given SQL statement, which may be an INSERT,
UPDATE, or DELETE statement or an
SQL statement that returns nothing, such as an SQL DDL statement. |
int |
Statement.executeUpdate(String sql,
int autoGeneratedKeys)
Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object
should be made available for retrieval. |
int |
Statement.executeUpdate(String sql,
int[] columnIndexes)
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. |
int |
Statement.executeUpdate(String sql,
String[] columnNames)
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. |
int |
ResultSet.findColumn(String columnLabel)
Maps the given ResultSet column label to its
ResultSet column index. |
boolean |
ResultSet.first()
Moves the cursor to the first row in this ResultSet object. |
void |
SQLXML.free()
This method closes this object and releases the resources that it held. |
void |
Clob.free()
This method frees the Clob object and releases the resources the resources
that it holds. |
void |
Blob.free()
This method frees the Blob object and releases the resources that
it holds. |
void |
Array.free()
This method frees the Array object and releases the resources that
it holds. |
Object |
Array.getArray()
Retrieves the contents of the SQL ARRAY value designated
by this
Array object in the form of an array in the Java
programming language. |
Array |
ResultSet.getArray(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as an Array object
in the Java programming language. |
Array |
CallableStatement.getArray(int parameterIndex)
Retrieves the value of the designated JDBC ARRAY parameter as an
Array object in the Java programming language. |
Object |
Array.getArray(long index,
int count)
Retrieves a slice of the SQL ARRAY
value designated by this Array object, beginning with the
specified index and containing up to count
successive elements of the SQL array. |
Object |
Array.getArray(long index,
int count,
Map<String,Class<?>> map)
Retreives a slice of the SQL ARRAY value
designated by this Array object, beginning with the specified
index and containing up to count
successive elements of the SQL array. |
Object |
Array.getArray(Map<String,Class<?>> map)
Retrieves the contents of the SQL ARRAY value designated by this
Array object. |
Array |
ResultSet.getArray(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as an Array object
in the Java programming language. |
Array |
CallableStatement.getArray(String parameterName)
Retrieves the value of a JDBC ARRAY parameter as an
Array object in the Java programming language. |
InputStream |
Clob.getAsciiStream()
Retrieves the CLOB value designated by this Clob
object as an ascii stream. |
InputStream |
ResultSet.getAsciiStream(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a stream of ASCII characters. |
InputStream |
ResultSet.getAsciiStream(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of
ASCII characters. |
Object[] |
Struct.getAttributes()
Produces the ordered values of the attributes of the SQL structured type that this Struct object represents. |
Object[] |
Struct.getAttributes(Map<String,Class<?>> map)
Produces the ordered values of the attributes of the SQL structured type that this Struct object represents. |
ResultSet |
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. |
boolean |
Connection.getAutoCommit()
Retrieves the current auto-commit mode for this Connection
object. |
int |
Array.getBaseType()
Retrieves the JDBC type of the elements in the array designated by this Array object. |
String |
Ref.getBaseTypeName()
Retrieves the fully-qualified SQL name of the SQL structured type that this Ref object references. |
String |
Array.getBaseTypeName()
Retrieves the SQL type name of the elements in the array designated by this Array object. |
ResultSet |
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. |
BigDecimal |
ResultSet.getBigDecimal(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a
java.math.BigDecimal with full precision. |
BigDecimal |
CallableStatement.getBigDecimal(int parameterIndex)
Retrieves the value of the designated JDBC NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains. |
BigDecimal |
ResultSet.getBigDecimal(int columnIndex,
int scale)
Deprecated. |
BigDecimal |
CallableStatement.getBigDecimal(int parameterIndex,
int scale)
Deprecated. use getBigDecimal(int parameterIndex)
or getBigDecimal(String parameterName) |
BigDecimal |
ResultSet.getBigDecimal(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a
java.math.BigDecimal with full precision. |
BigDecimal |
CallableStatement.getBigDecimal(String parameterName)
Retrieves the value of a JDBC NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains. |
BigDecimal |
ResultSet.getBigDecimal(String columnLabel,
int scale)
Deprecated. |
InputStream |
SQLXML.getBinaryStream()
Retrieves the XML value designated by this SQLXML instance as a stream. |
InputStream |
Blob.getBinaryStream()
Retrieves the BLOB value designated by this
Blob instance as a stream. |
InputStream |
ResultSet.getBinaryStream(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of
uninterpreted bytes. |
InputStream |
Blob.getBinaryStream(long pos,
long length)
Returns an InputStream object that contains a partial Blob value,
starting with the byte specified by pos, which is length bytes in length. |
InputStream |
ResultSet.getBinaryStream(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted
bytes. |
Blob |
ResultSet.getBlob(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object
in the Java programming language. |
Blob |
CallableStatement.getBlob(int parameterIndex)
Retrieves the value of the designated JDBC BLOB parameter as a
Blob object in the Java programming language. |
Blob |
ResultSet.getBlob(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object
in the Java programming language. |
Blob |
CallableStatement.getBlob(String parameterName)
Retrieves the value of a JDBC BLOB parameter as a
Blob object in the Java programming language. |
boolean |
ResultSet.getBoolean(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a boolean in the Java programming language. |
boolean |
CallableStatement.getBoolean(int parameterIndex)
Retrieves the value of the designated JDBC BIT
or BOOLEAN parameter as a
boolean in the Java programming language. |
boolean |
ResultSet.getBoolean(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as
a boolean in the Java programming language. |
boolean |
CallableStatement.getBoolean(String parameterName)
Retrieves the value of a JDBC BIT or BOOLEAN
parameter as a
boolean in the Java programming language. |
byte |
ResultSet.getByte(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a byte in the Java programming language. |
byte |
CallableStatement.getByte(int parameterIndex)
Retrieves the value of the designated JDBC TINYINT parameter
as a byte in the Java programming language. |
byte |
ResultSet.getByte(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as
a byte in the Java programming language. |
byte |
CallableStatement.getByte(String parameterName)
Retrieves the value of a JDBC TINYINT parameter as a byte
in the Java programming language. |
byte[] |
ResultSet.getBytes(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a byte array in the Java programming language. |
byte[] |
CallableStatement.getBytes(int parameterIndex)
Retrieves the value of the designated JDBC BINARY or
VARBINARY parameter as an array of byte
values in the Java programming language. |
byte[] |
Blob.getBytes(long pos,
int length)
Retrieves all or part of the BLOB
value that this Blob object represents, as an array of
bytes. |
byte[] |
ResultSet.getBytes(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as
a byte array in the Java programming language. |
byte[] |
CallableStatement.getBytes(String parameterName)
Retrieves the value of a JDBC BINARY or VARBINARY
parameter as an array of byte values in the Java
programming language. |
String |
Connection.getCatalog()
Retrieves this Connection object's current catalog name. |
String |
ResultSetMetaData.getCatalogName(int column)
Gets the designated column's table's catalog name. |
ResultSet |
DatabaseMetaData.getCatalogs()
Retrieves the catalog names available in this database. |
String |
DatabaseMetaData.getCatalogSeparator()
Retrieves the String that this database uses as the
separator between a catalog and table name. |
String |
DatabaseMetaData.getCatalogTerm()
Retrieves the database vendor's preferred term for "catalog". |
Reader |
SQLXML.getCharacterStream()
Retrieves the XML value designated by this SQLXML instance as a java.io.Reader object. |
Reader |
Clob.getCharacterStream()
Retrieves the CLOB value designated by this Clob
object as a java.io.Reader object (or as a stream of
characters). |
Reader |
ResultSet.getCharacterStream(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a
java.io.Reader object. |
Reader |
CallableStatement.getCharacterStream(int parameterIndex)
Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language. |
Reader |
Clob.getCharacterStream(long pos,
long length)
Returns a Reader object that contains a partial Clob value, starting
with the character specified by pos, which is length characters in length. |
Reader |
ResultSet.getCharacterStream(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a
java.io.Reader object. |
Reader |
CallableStatement.getCharacterStream(String parameterName)
Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language. |
Properties |
Connection.getClientInfo()
Returns a list containing the name and current value of each client info property supported by the driver. |
String |
Connection.getClientInfo(String name)
Returns the value of the client info property specified by name. |
ResultSet |
DatabaseMetaData.getClientInfoProperties()
Retrieves a list of the client info properties that the driver supports. |
Clob |
ResultSet.getClob(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object
in the Java programming language. |
Clob |
CallableStatement.getClob(int parameterIndex)
Retrieves the value of the designated JDBC CLOB parameter as a
java.sql.Clob object in the Java programming language. |
Clob |
ResultSet.getClob(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object
in the Java programming language. |
Clob |
CallableStatement.getClob(String parameterName)
Retrieves the value of a JDBC CLOB parameter as a
java.sql.Clob object in the Java programming language. |
String |
ResultSetMetaData.getColumnClassName(int column)
Returns the fully-qualified name of the Java class whose instances are manufactured if the method ResultSet.getObject
is called to retrieve a value
from the column. |
int |
ResultSetMetaData.getColumnCount()
Returns the number of columns in this ResultSet object. |
int |
ResultSetMetaData.getColumnDisplaySize(int column)
Indicates the designated column's normal maximum width in characters. |
String |
ResultSetMetaData.getColumnLabel(int column)
Gets the designated column's suggested title for use in printouts and displays. |
String |
ResultSetMetaData.getColumnName(int column)
Get the designated column's name. |
ResultSet |
DatabaseMetaData.getColumnPrivileges(String catalog,
String schema,
String table,
String columnNamePattern)
Retrieves a description of the access rights for a table's columns. |
ResultSet |
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. |
String |
ResultSetMetaData.getColumnTypeName(int column)
Retrieves the designated column's database-specific type name. |
int |
ResultSet.getConcurrency()
Retrieves the concurrency mode of this ResultSet object. |
Connection |
Statement.getConnection()
Retrieves the Connection object
that produced this Statement object. |
Connection |
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,
Properties info)
Attempts to establish a connection to the given database URL. |
static Connection |
DriverManager.getConnection(String url,
String user,
String password)
Attempts to establish a connection to the given database URL. |
ResultSet |
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). |
String |
ResultSet.getCursorName()
Retrieves the name of the SQL cursor used by this ResultSet
object. |
int |
DatabaseMetaData.getDatabaseMajorVersion()
Retrieves the major version number of the underlying database. |
int |
DatabaseMetaData.getDatabaseMinorVersion()
Retrieves the minor version number of the underlying database. |
String |
DatabaseMetaData.getDatabaseProductName()
Retrieves the name of this database product. |
String |
DatabaseMetaData.getDatabaseProductVersion()
Retrieves the version number of this database product. |
Date |
ResultSet.getDate(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Date object in the Java programming language. |
Date |
CallableStatement.getDate(int parameterIndex)
Retrieves the value of the designated JDBC DATE parameter as a
java.sql.Date object. |
Date |
ResultSet.getDate(int columnIndex,
Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object
in the Java programming language. |
Date |
CallableStatement.getDate(int parameterIndex,
Calendar cal)
Retrieves the value of the designated JDBC DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date. |
Date |
ResultSet.getDate(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Date object in the Java programming language. |
Date |
CallableStatement.getDate(String parameterName)
Retrieves the value of a JDBC DATE parameter as a
java.sql.Date object. |
Date |
ResultSet.getDate(String columnLabel,
Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object
in the Java programming language. |
Date |
CallableStatement.getDate(String parameterName,
Calendar cal)
Retrieves the value of a JDBC DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date. |
int |
DatabaseMetaData.getDefaultTransactionIsolation()
Retrieves this database's default transaction isolation level. |
double |
ResultSet.getDouble(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a double in the Java programming language. |
double |
CallableStatement.getDouble(int parameterIndex)
Retrieves the value of the designated JDBC DOUBLE parameter as a double
in the Java programming language. |
double |
ResultSet.getDouble(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as
a double in the Java programming language. |
double |
CallableStatement.getDouble(String parameterName)
Retrieves the value of a JDBC DOUBLE parameter as a double
in the Java programming language. |
static Driver |
DriverManager.getDriver(String url)
Attempts to locate a driver that understands the given URL. |
String |
DatabaseMetaData.getDriverName()
Retrieves the name of this JDBC driver. |
String |
DatabaseMetaData.getDriverVersion()
Retrieves the version number of this JDBC driver as a String. |
ResultSet |
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). |
String |
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 |
Statement.getFetchDirection()
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object. |
int |
ResultSet.getFetchDirection()
Retrieves the fetch direction for this ResultSet object. |
int |
Statement.getFetchSize()
Retrieves the number of result set rows that is the default fetch size for ResultSet objects
generated from this Statement object. |
int |
ResultSet.getFetchSize()
Retrieves the fetch size for this ResultSet object. |
float |
ResultSet.getFloat(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a float in the Java programming language. |
float |
CallableStatement.getFloat(int parameterIndex)
Retrieves the value of the designated JDBC FLOAT parameter
as a float in the Java programming language. |
float |
ResultSet.getFloat(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as
a float in the Java programming language. |
float |
CallableStatement.getFloat(String parameterName)
Retrieves the value of a JDBC FLOAT parameter as a float
in the Java programming language. |
ResultSet |
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. |
ResultSet |
DatabaseMetaData.getFunctions(String catalog,
String schemaPattern,
String functionNamePattern)
Retrieves a description of the system and user functions available in the given catalog. |
ResultSet |
Statement.getGeneratedKeys()
Retrieves any auto-generated keys created as a result of executing this Statement object. |
int |
ResultSet.getHoldability()
Retrieves the holdability of this ResultSet object |
int |
Connection.getHoldability()
Retrieves the current holdability of ResultSet objects
created using this Connection object. |
String |
DatabaseMetaData.getIdentifierQuoteString()
Retrieves the string used to quote SQL identifiers. |
ResultSet |
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). |
ResultSet |
DatabaseMetaData.getIndexInfo(String catalog,
String schema,
String table,
boolean unique,
boolean approximate)
Retrieves a description of the given table's indices and statistics. |
int |
ResultSet.getInt(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
an int in the Java programming language. |
int |
CallableStatement.getInt(int parameterIndex)
Retrieves the value of the designated JDBC INTEGER parameter
as an int in the Java programming language. |
int |
ResultSet.getInt(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as
an int in the Java programming language. |
int |
CallableStatement.getInt(String parameterName)
Retrieves the value of a JDBC INTEGER parameter as an int
in the Java programming language. |
int |
DatabaseMetaData.getJDBCMajorVersion()
Retrieves the major JDBC version number for this driver. |
int |
DatabaseMetaData.getJDBCMinorVersion()
Retrieves the minor JDBC version number for this driver. |
long |
ResultSet.getLong(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a long in the Java programming language. |
long |
CallableStatement.getLong(int parameterIndex)
Retrieves the value of the designated JDBC BIGINT parameter
as a long in the Java programming language. |
long |
ResultSet.getLong(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as
a long in the Java programming language. |
long |
CallableStatement.getLong(String parameterName)
Retrieves the value of a JDBC BIGINT parameter as a long
in the Java programming language. |
int |
DatabaseMetaData.getMaxBinaryLiteralLength()
Retrieves the maximum number of hex characters this database allows in an inline binary literal. |
int |
DatabaseMetaData.getMaxCatalogNameLength()
Retrieves the maximum number of characters that this database allows in a catalog name. |
int |
DatabaseMetaData.getMaxCharLiteralLength()
Retrieves the maximum number of characters this database allows for a character literal. |
int |
DatabaseMetaData.getMaxColumnNameLength()
Retrieves the maximum number of characters this database allows for a column name. |
int |
DatabaseMetaData.getMaxColumnsInGroupBy()
Retrieves the maximum number of columns this database allows in a GROUP BY clause. |
int |
DatabaseMetaData.getMaxColumnsInIndex()
Retrieves the maximum number of columns this database allows in an index. |
int |
DatabaseMetaData.getMaxColumnsInOrderBy()
Retrieves the maximum number of columns this database allows in an ORDER BY clause. |
int |
DatabaseMetaData.getMaxColumnsInSelect()
Retrieves the maximum number of columns this database allows in a SELECT list. |
int |
DatabaseMetaData.getMaxColumnsInTable()
Retrieves the maximum number of columns this database allows in a table. |
int |
DatabaseMetaData.getMaxConnections()
Retrieves the maximum number of concurrent connections to this database that are possible. |
int |
DatabaseMetaData.getMaxCursorNameLength()
Retrieves the maximum number of characters that this database allows in a cursor name. |
int |
Statement.getMaxFieldSize()
Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet
object produced by this Statement object. |