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