Index of all Fields and Methods
All Packages  Class Hierarchy

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Index of all Fields and Methods

A

abs(). Method in class java.math.BigDecimal
Returns a BigDecimal whose value is the absolute value of this number, and whose scale is this.scale().
abs(). Method in class java.math.BigInteger
Returns a BigInteger whose value is the absolute value of this number.
acceptsURL(String). Method in interface java.sql.Driver
Returns true if the driver thinks that it can open a connection to the given URL.
add(BigDecimal). Method in class java.math.BigDecimal
Returns a BigDecimal whose value is (this + val), and whose scale is MAX(this.scale(), val.scale).
add(BigInteger). Method in class java.math.BigInteger
Returns a BigInteger whose value is (this + val).
after(Timestamp). Method in class java.sql.Timestamp
Is this timestamp later than the timestamp argument?
allProceduresAreCallable(). Method in interface java.sql.DatabaseMetaData
Can all the procedures returned by getProcedures be called by the current user?
allTablesAreSelectable(). Method in interface java.sql.DatabaseMetaData
Can all the tables returned by getTable be SELECTed by the current user?

B

before(Timestamp). Method in class java.sql.Timestamp
Is this timestamp earlier than the timestamp argument?
bestRowNotPseudo. Static variable in interface java.sql.DatabaseMetaData
BEST ROW PSEUDO_COLUMN - is NOT a pseudo column.
bestRowPseudo. Static variable in interface java.sql.DatabaseMetaData
BEST ROW PSEUDO_COLUMN - is a pseudo column.
bestRowSession. Static variable in interface java.sql.DatabaseMetaData
BEST ROW SCOPE - valid for remainder of current session.
bestRowTemporary. Static variable in interface java.sql.DatabaseMetaData
BEST ROW SCOPE - very temporary, while using row.
bestRowTransaction. Static variable in interface java.sql.DatabaseMetaData
BEST ROW SCOPE - valid for remainder of current transaction.
bestRowUnknown. Static variable in interface java.sql.DatabaseMetaData
BEST ROW PSEUDO_COLUMN - may or may not be pseudo column.
BigDecimal(BigInteger). Constructor for class java.math.BigDecimal
Translates a BigInteger into a BigDecimal.
BigDecimal(BigInteger, int). Constructor for class java.math.BigDecimal
Translates a BigInteger and a scale into a BigDecimal.
BigDecimal(double). Constructor for class java.math.BigDecimal
Translates a double into a BigDecimal.
BigDecimal(String). Constructor for class java.math.BigDecimal
Constructs a BigDecimal from a string containing an optional minus sign followed by a sequence of zero or more decimal digits, optionally followed by a fraction, which consists of a decimal point followed by zero or more decimal digits.
BIGINT. Static variable in class java.sql.Types
BigInteger(String). Constructor for class java.math.BigInteger
Translates a string containing an optional minus sign followed by a sequence of one or more decimal digits into a BigInteger.
BigInteger(String, int). Constructor for class java.math.BigInteger
Translates a string containing an optional minus sign followed by a sequence of one or more digits in the specified radix into a BigInteger.
BINARY. Static variable in class java.sql.Types
BIT. Static variable in class java.sql.Types

C

cancel(). Method in interface java.sql.Statement
Cancel can be used by one thread to cancel a statement that is being executed by another thread.
CHAR. Static variable in class java.sql.Types
choices. Variable in class java.sql.DriverPropertyInfo
If the value may be selected from a particular set of values, then this is an array of the possible values.
clearParameters(). Method in interface java.sql.PreparedStatement

In general, parameter values remain in force for repeated use of a Statement.

clearWarnings(). Method in interface java.sql.Connection
After this call, getWarnings returns null until a new warning is reported for this Connection.
clearWarnings(). Method in interface java.sql.ResultSet
After this call getWarnings returns null until a new warning is reported for this ResultSet.
clearWarnings(). Method in interface java.sql.Statement
After this call, getWarnings returns null until a new warning is reported for this Statement.
close(). Method in interface java.sql.Connection
In some cases, it is desirable to immediately release a Connection's database and JDBC resources instead of waiting for them to be automatically released; the close method provides this immediate release.
close(). Method in interface java.sql.ResultSet
In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.
close(). Method in interface java.sql.Statement
In many cases, it is desirable to immediately release a Statements's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.
columnNoNulls. Static variable in interface java.sql.DatabaseMetaData
COLUMN NULLABLE - might not allow NULL values.
columnNoNulls. Static variable in interface java.sql.ResultSetMetaData
Does not allow NULL values.
columnNullable. Static variable in interface java.sql.DatabaseMetaData
COLUMN NULLABLE - definitely allows NULL values.
columnNullable. Static variable in interface java.sql.ResultSetMetaData
Allows NULL values.
columnNullableUnknown. Static variable in interface java.sql.DatabaseMetaData
COLUMN NULLABLE - nullability unknown.
columnNullableUnknown. Static variable in interface java.sql.ResultSetMetaData
Nullability unknown.
commit(). Method in interface java.sql.Connection
Commit makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.
compareTo(BigDecimal). Method in class java.math.BigDecimal
Returns -1, 0 or 1 as this number is less than, equal to, or greater than val.
compareTo(BigInteger). Method in class java.math.BigInteger
Returns -1, 0 or 1 as this number is less than, equal to, or greater than val.
connect(String, Properties). Method in interface java.sql.Driver
Try to make a database connection to the given URL.
createStatement(). Method in interface java.sql.Connection
SQL statements without parameters are normally executed using Statement objects.

D

dataDefinitionCausesTransactionCommit(). Method in interface java.sql.DatabaseMetaData
Does a data definition statement within a transaction force the transaction to commit?
dataDefinitionIgnoredInTransactions(). Method in interface java.sql.DatabaseMetaData
Is a data definition statement within a transaction ignored?
DataTruncation(int, boolean, boolean, int, int). Constructor for class java.sql.DataTruncation

Create a DataTruncation object.

DATE. Static variable in class java.sql.Types
Date(int, int, int). Constructor for class java.sql.Date
Construct a Date
Date(long). Constructor for class java.sql.Date
Construct a Date using a milliseconds time value
DECIMAL. Static variable in class java.sql.Types
deregisterDriver(Driver). Static method in class java.sql.DriverManager
Drop a Driver from the DriverManager's list.
description. Variable in class java.sql.DriverPropertyInfo
A brief description of the property.
divide(BigDecimal, int). Method in class java.math.BigDecimal
Returns a BigDecimal whose value is (this / val), and whose scale is this.scale().
divide(BigDecimal, int, int). Method in class java.math.BigDecimal
Returns a BigDecimal whose value is (this / val), and whose scale is as specified.
divide(BigInteger). Method in class java.math.BigInteger
Returns a BigInteger whose value is (this / val).
divideAndRemainder(BigInteger). Method in class java.math.BigInteger
Returns an array of two BigIntegers.
doesMaxRowSizeIncludeBlobs(). Method in interface java.sql.DatabaseMetaData
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
DOUBLE. Static variable in class java.sql.Types
doubleValue(). Method in class java.math.BigDecimal
Converts the number to a double.
doubleValue(). Method in class java.math.BigInteger
Converts the number to a double.
DriverPropertyInfo(String, String). Constructor for class java.sql.DriverPropertyInfo
Constructor a DriverPropertyInfo with a name and value; other members default to their initial values.

E

equals(Object). Method in class java.math.BigDecimal
Returns true iff x is a BigDecimal whose value is equal to this number.
equals(Object). Method in class java.math.BigInteger
Returns true iff x is a BigInteger whose value is equal to this number.
equals(Timestamp). Method in class java.sql.Timestamp
Test Timestamp values for equality
execute(). Method in interface java.sql.PreparedStatement
Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate.
execute(String). Method in interface java.sql.Statement
Execute a SQL statement that may return multiple results.
executeQuery(). Method in interface java.sql.PreparedStatement
A prepared SQL query is executed and its ResultSet is returned.
executeQuery(String). Method in interface java.sql.Statement
Execute a SQL statement that returns a single ResultSet.
executeUpdate(). Method in interface java.sql.PreparedStatement
Execute a SQL INSERT, UPDATE or DELETE statement.
executeUpdate(String). Method in interface java.sql.Statement
Execute a SQL INSERT, UPDATE or DELETE statement.

F

findColumn(String). Method in interface java.sql.ResultSet
Map a Resultset column name to a ResultSet column index.
FLOAT. Static variable in class java.sql.Types
floatValue(). Method in class java.math.BigDecimal
Converts this number to a float.
floatValue(). Method in class java.math.BigInteger
Converts this number to a float.

G

getAsciiStream(int). Method in interface java.sql.ResultSet
A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.
getAsciiStream(String). Method in interface java.sql.ResultSet
A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.
getAutoCommit(). Method in interface java.sql.Connection
Get the current auto-commit state.
getBestRowIdentifier(String, String, String, int, boolean). Method in interface java.sql.DatabaseMetaData
Get a description of a table's optimal set of columns that uniquely identifies a row.
getBigDecimal(int, int). Method in interface java.sql.CallableStatement
Get the value of a NUMERIC parameter as a java.math.BigDecimal object.
getBigDecimal(int, int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a java.lang.BigDecimal object.
getBigDecimal(String, int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a java.lang.BigDecimal object.
getBinaryStream(int). Method in interface java.sql.ResultSet
A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.
getBinaryStream(String). Method in interface java.sql.ResultSet
A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.
getBoolean(int). Method in interface java.sql.CallableStatement
Get the value of a BIT parameter as a Java boolean.
getBoolean(int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java boolean.
getBoolean(String). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java boolean.
getByte(int). Method in interface java.sql.CallableStatement
Get the value of a TINYINT parameter as a Java byte.
getByte(int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java byte.
getByte(String). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java byte.
getBytes(int). Method in interface java.sql.CallableStatement
Get the value of a SQL BINARY or VARBINARY parameter as a Java byte[]
getBytes(int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java byte array.
getBytes(String). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java byte array.
getCatalog(). Method in interface java.sql.Connection
Return the Connection's current catalog name.
getCatalogName(int). Method in interface java.sql.ResultSetMetaData
What's a column's table's catalog name?
getCatalogs(). Method in interface java.sql.DatabaseMetaData
Get the catalog names available in this database.
getCatalogSeparator(). Method in interface java.sql.DatabaseMetaData
What's the separator between catalog and table name?
getCatalogTerm(). Method in interface java.sql.DatabaseMetaData
What's the database vendor's preferred term for "catalog"?
getColumnCount(). Method in interface java.sql.ResultSetMetaData
What's the number of columns in the ResultSet?
getColumnDisplaySize(int). Method in interface java.sql.ResultSetMetaData
What's the column's normal max width in chars?
getColumnLabel(int). Method in interface java.sql.ResultSetMetaData
What's the suggested column title for use in printouts and displays?
getColumnName(int). Method in interface java.sql.ResultSetMetaData
What's a column's name?
getColumnPrivileges(String, String, String, String). Method in interface java.sql.DatabaseMetaData
Get a description of the access rights for a table's columns.
getColumns(String, String, String, String). Method in interface java.sql.DatabaseMetaData
Get a description of table columns available in a catalog.
getColumnType(int). Method in interface java.sql.ResultSetMetaData
What's a column's SQL type?
getColumnTypeName(int). Method in interface java.sql.ResultSetMetaData
What's a column's data source specific type name?
getConnection(String). Static method in class java.sql.DriverManager
Attempt to establish a connection to the given database URL.
getConnection(String, Properties). Static method in class java.sql.DriverManager
Attempt to establish a connection to the given database URL.
getConnection(String, String, String). Static method in class java.sql.DriverManager
Attempt to establish a connection to the given database URL.
getCrossReference(String, String, String, String, String, String). Method in interface java.sql.DatabaseMetaData
Get 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.
getCursorName(). Method in interface java.sql.ResultSet
Get the name of the SQL cursor used by this ResultSet.
getDatabaseProductName(). Method in interface java.sql.DatabaseMetaData
What's the name of this database product?
getDatabaseProductVersion(). Method in interface java.sql.DatabaseMetaData
What's the version of this database product?
getDataSize(). Method in class java.sql.DataTruncation
Get the number of bytes of data that should have been transferred.
getDate(). Method in class java.sql.Time
getDate(int). Method in interface java.sql.CallableStatement
Get the value of a SQL DATE parameter as a java.sql.Date object
getDate(int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a java.sql.Date object.
getDate(String). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a java.sql.Date object.
getDay(). Method in class java.sql.Time
getDefaultTransactionIsolation(). Method in interface java.sql.DatabaseMetaData
What's the database's default transaction isolation level? The values are defined in java.sql.Connection.
getDouble(int). Method in interface java.sql.CallableStatement
Get the value of a DOUBLE parameter as a Java double.
getDouble(int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java double.
getDouble(String). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java double.
getDriver(String). Static method in class java.sql.DriverManager
Attempt to locate a driver that understands the given URL.
getDriverMajorVersion(). Method in interface java.sql.DatabaseMetaData
What's this JDBC driver's major version number?
getDriverMinorVersion(). Method in interface java.sql.DatabaseMetaData
What's this JDBC driver's minor version number?
getDriverName(). Method in interface java.sql.DatabaseMetaData
What's the name of this JDBC driver?
getDrivers(). Static method in class java.sql.DriverManager
Return an Enumeration of all the currently loaded JDBC drivers which the current caller has access to.
getDriverVersion(). Method in interface java.sql.DatabaseMetaData
What's the version of this JDBC driver?
getErrorCode(). Method in class java.sql.SQLException
Get the vendor specific exception code
getExportedKeys(String, String, String). Method in interface java.sql.DatabaseMetaData
Get a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table).
getExtraNameCharacters(). Method in interface java.sql.DatabaseMetaData
Get all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
getFloat(int). Method in interface java.sql.CallableStatement
Get the value of a FLOAT parameter as a Java float.
getFloat(int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java float.
getFloat(String). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java float.
getHours(). Method in class java.sql.Date
getIdentifierQuoteString(). Method in interface java.sql.DatabaseMetaData
What's the string used to quote SQL identifiers? This returns a space " " if identifier quoting isn't supported.
getImportedKeys(String, String, String). Method in interface java.sql.DatabaseMetaData
Get a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table).
getIndex(). Method in class java.sql.DataTruncation
Get the index of the column or parameter that was truncated.
getIndexInfo(String, String, String, boolean, boolean). Method in interface java.sql.DatabaseMetaData
Get a description of a table's indices and statistics.
getInt(int). Method in interface java.sql.CallableStatement
Get the value of an INTEGER parameter as a Java int.
getInt(int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java int.
getInt(String). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java int.
getLoginTimeout(). Static method in class java.sql.DriverManager
Get the maximum time in seconds that all drivers can wait when attempting to log in to a database.
getLogStream(). Static method in class java.sql.DriverManager
Get the logging/tracing PrintStream that is used by the DriverManager and all drivers.
getLong(int). Method in interface java.sql.CallableStatement
Get the value of a BIGINT parameter as a Java long.
getLong(int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java long.
getLong(String). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java long.
getMajorVersion(). Method in interface java.sql.Driver
Get the driver's major version number.
getMaxBinaryLiteralLength(). Method in interface java.sql.DatabaseMetaData
How many hex characters can you have in an inline binary literal?
getMaxCatalogNameLength(). Method in interface java.sql.DatabaseMetaData
What's the maximum length of a catalog name?
getMaxCharLiteralLength(). Method in interface java.sql.DatabaseMetaData
What's the max length for a character literal?
getMaxColumnNameLength(). Method in interface java.sql.DatabaseMetaData
What's the limit on column name length?
getMaxColumnsInGroupBy(). Method in interface java.sql.DatabaseMetaData
What's the maximum number of columns in a "GROUP BY" clause?
getMaxColumnsInIndex(). Method in interface java.sql.DatabaseMetaData
What's the maximum number of columns allowed in an index?
getMaxColumnsInOrderBy(). Method in interface java.sql.DatabaseMetaData
What's the maximum number of columns in an "ORDER BY" clause?
getMaxColumnsInSelect(). Method in interface java.sql.DatabaseMetaData
What's the maximum number of columns in a "SELECT" list?
getMaxColumnsInTable(). Method in interface java.sql.DatabaseMetaData
What's the maximum number of columns in a table?
getMaxConnections(). Method in interface java.sql.DatabaseMetaData
How many active connections can we have at a time to this database?
getMaxCursorNameLength(). Method in interface java.sql.DatabaseMetaData
What's the maximum cursor name length?
getMaxFieldSize(). Method in interface java.sql.Statement
The maxFieldSize limit (in bytes) is the maximum amount of data returned for any column value; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR columns.
getMaxIndexLength(). Method in interface java.sql.DatabaseMetaData
What's the maximum length of an index (in bytes)?
getMaxProcedureNameLength(). Method in interface java.sql.DatabaseMetaData
What's the maximum length of a procedure name?
getMaxRows(). Method in interface java.sql.Statement
The maxRows limit is the maximum number of rows that a ResultSet can contain.
getMaxRowSize(). Method in interface java.sql.DatabaseMetaData
What's the maximum length of a single row?
getMaxSchemaNameLength(). Method in interface java.sql.DatabaseMetaData
What's the maximum length allowed for a schema name?
getMaxStatementLength(). Method in interface java.sql.DatabaseMetaData
What's the maximum length of a SQL statement?
getMaxStatements(). Method in interface java.sql.DatabaseMetaData
How many active statements can we have open at one time to this database?
getMaxTableNameLength(). Method in interface java.sql.DatabaseMetaData
What's the maximum length of a table name?
getMaxTablesInSelect(). Method in interface java.sql.DatabaseMetaData
What's the maximum number of tables in a SELECT?
getMaxUserNameLength(). Method in interface java.sql.DatabaseMetaData
What's the maximum length of a user name?
getMetaData(). Method in interface java.sql.Connection
A Connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, etc.
getMetaData(). Method in interface java.sql.ResultSet
The number, types and properties of a ResultSet's columns are provided by the getMetaData method.
getMinorVersion(). Method in interface java.sql.Driver
Get the driver's minor version number.
getMinutes(). Method in class java.sql.Date
getMonth(). Method in class java.sql.Time
getMoreResults(). Method in interface java.sql.Statement
getMoreResults moves to a Statement's next result.
getNanos(). Method in class java.sql.Timestamp
Get the Timestamp's nanos value
getNextException(). Method in class java.sql.SQLException
Get the exception chained to this one.
getNextWarning(). Method in class java.sql.SQLWarning
Get the warning chained to this one
getNumericFunctions(). Method in interface java.sql.DatabaseMetaData
Get a comma separated list of math functions.
getObject(int). Method in interface java.sql.CallableStatement
Get the value of a parameter as a Java object.
getObject(int). Method in interface java.sql.ResultSet

Get the value of a column in the current row as a Java object.

getObject(String). Method in interface java.sql.ResultSet

Get the value of a column in the current row as a Java object.

getParameter(). Method in class java.sql.DataTruncation
Is this a truncated parameter value?
getPrecision(int). Method in interface java.sql.ResultSetMetaData
What's a column's number of decimal digits?
getPrimaryKeys(String, String, String). Method in interface java.sql.DatabaseMetaData
Get a description of a table's primary key columns.
getProcedureColumns(String, String, String, String). Method in interface java.sql.DatabaseMetaData
Get a description of a catalog's stored procedure parameters and result columns.
getProcedures(String, String, String). Method in interface java.sql.DatabaseMetaData
Get a description of stored procedures available in a catalog.
getProcedureTerm(). Method in interface java.sql.DatabaseMetaData
What's the database vendor's preferred term for "procedure"?
getPropertyInfo(String, Properties). Method in interface java.sql.Driver

The getPropertyInfo method is intended to allow a generic GUI tool to discover what properties it should prompt a human for in order to get enough information to connect to a database.

getQueryTimeout(). Method in interface java.sql.Statement
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute.
getRead(). Method in class java.sql.DataTruncation
Was this a read truncation?
getResultSet(). Method in interface java.sql.Statement
getResultSet returns the current result as a ResultSet.
getScale(int). Method in interface java.sql.ResultSetMetaData
What's a column's number of digits to right of the decimal point?
getSchemaName(int). Method in interface java.sql.ResultSetMetaData
What's a column's table's schema?
getSchemas(). Method in interface java.sql.DatabaseMetaData
Get the schema names available in this database.
getSchemaTerm(). Method in interface java.sql.DatabaseMetaData
What's the database vendor's preferred term for "schema"?
getSearchStringEscape(). Method in interface java.sql.DatabaseMetaData
This is the string that can be used to escape '_' or '%' in the string pattern style catalog search parameters.
getSeconds(). Method in class java.sql.Date
getShort(int). Method in interface java.sql.CallableStatement
Get the value of a SMALLINT parameter as a Java short.
getShort(int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java short.
getShort(String). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java short.
getSQLKeywords(). Method in interface java.sql.DatabaseMetaData
Get a comma separated list of all a database's SQL keywords that are NOT also SQL92 keywords.
getSQLState(). Method in class java.sql.SQLException
Get the SQLState
getString(int). Method in interface java.sql.CallableStatement
Get the value of a CHAR, VARCHAR, or LONGVARCHAR parameter as a Java String.
getString(int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java String.
getString(String). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a Java String.
getStringFunctions(). Method in interface java.sql.DatabaseMetaData
Get a comma separated list of string functions.
getSystemFunctions(). Method in interface java.sql.DatabaseMetaData
Get a comma separated list of system functions.
getTableName(int). Method in interface java.sql.ResultSetMetaData
What's a column's table name?
getTablePrivileges(String, String, String). Method in interface java.sql.DatabaseMetaData
Get a description of the access rights for each table available in a catalog.
getTables(String, String, String, String[]). Method in interface java.sql.DatabaseMetaData
Get a description of tables available in a catalog.
getTableTypes(). Method in interface java.sql.DatabaseMetaData
Get the table types available in this database.
getTime(int). Method in interface java.sql.CallableStatement
Get the value of a SQL TIME parameter as a java.sql.Time object.
getTime(int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a java.sql.Time object.
getTime(String). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a java.sql.Time object.
getTimeDateFunctions(). Method in interface java.sql.DatabaseMetaData
Get a comma separated list of time and date functions.
getTimestamp(int). Method in interface java.sql.CallableStatement
Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object.
getTimestamp(int). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a java.sql.Timestamp object.
getTimestamp(String). Method in interface java.sql.ResultSet
Get the value of a column in the current row as a java.sql.Timestamp object.
getTransactionIsolation(). Method in interface java.sql.Connection
Get this Connection's current transaction isolation mode.
getTransferSize(). Method in class java.sql.DataTruncation
Get the number of bytes of data actually transferred.
getTypeInfo(). Method in interface java.sql.DatabaseMetaData
Get a description of all the standard SQL types supported by this database.
getUnicodeStream(int). Method in interface java.sql.ResultSet
A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream.
getUnicodeStream(String). Method in interface java.sql.ResultSet
A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream.
getUpdateCount(). Method in interface java.sql.Statement
getUpdateCount returns the current result as an update count; if the result is a ResultSet or there are no more results, -1 is returned.
getURL(). Method in interface java.sql.DatabaseMetaData
What's the url for this database?
getUserName(). Method in interface java.sql.DatabaseMetaData
What's our user name as known to the database?
getVersionColumns(String, String, String). Method in interface java.sql.DatabaseMetaData
Get a description of a table's columns that are automatically updated when any value in a row is updated.
getWarnings(). Method in interface java.sql.Connection
The first warning reported by calls on this Connection is returned.
getWarnings(). Method in interface java.sql.ResultSet

The first warning reported by calls on this ResultSet is returned.

getWarnings(). Method in interface java.sql.Statement
The first warning reported by calls on this Statement is returned.
getYear(). Method in class java.sql.Time

H

hashCode(). Method in class java.math.BigDecimal
Computes a hash code for this object.
hashCode(). Method in class java.math.BigInteger
Computes a hash code for this object.

I

importedKeyCascade. Static variable in interface java.sql.DatabaseMetaData
IMPORT KEY UPDATE_RULE and DELETE_RULE - for update, change imported key to agree with primary key update; for delete, delete rows that import a deleted key.
importedKeyInitiallyDeferred. Static variable in interface java.sql.DatabaseMetaData
IMPORT KEY DEFERRABILITY - see SQL92 for definition
importedKeyInitiallyImmediate. Static variable in interface java.sql.DatabaseMetaData
IMPORT KEY DEFERRABILITY - see SQL92 for definition
importedKeyNoAction. Static variable in interface java.sql.DatabaseMetaData
IMPORT KEY UPDATE_RULE and DELETE_RULE - do not allow update or delete of primary key if it has been imported.
importedKeyNotDeferrable. Static variable in interface java.sql.DatabaseMetaData
IMPORT KEY DEFERRABILITY - see SQL92 for definition
importedKeyRestrict. Static variable in interface java.sql.DatabaseMetaData
IMPORT KEY UPDATE_RULE and DELETE_RULE - do not allow update or delete of primary key if it has been imported.
importedKeySetDefault. Static variable in interface java.sql.DatabaseMetaData
IMPORT KEY UPDATE_RULE and DELETE_RULE - change imported key to default values if its primary key has been updated or deleted.
importedKeySetNull. Static variable in interface java.sql.DatabaseMetaData
IMPORT KEY UPDATE_RULE and DELETE_RULE - change imported key to NULL if its primary key has been updated or deleted.
INTEGER. Static variable in class java.sql.Types
intValue(). Method in class java.math.BigDecimal
Converts this number to an int.
intValue(). Method in class java.math.BigInteger
Converts this number to an int.
isAutoIncrement(int). Method in interface java.sql.ResultSetMetaData
Is the column automatically numbered, thus read-only?
isCaseSensitive(int). Method in interface java.sql.ResultSetMetaData
Does a column's case matter?
isCatalogAtStart(). Method in interface java.sql.DatabaseMetaData
Does a catalog appear at the start of a qualified table name? (Otherwise it appears at the end)
isClosed(). Method in interface java.sql.Connection
Tests to see if a Connection is closed.
isCurrency(int). Method in interface java.sql.ResultSetMetaData
Is the column a cash value?
isDefinitelyWritable(int). Method in interface java.sql.ResultSetMetaData
Will a write on the column definitely succeed?
isNullable(int). Method in interface java.sql.ResultSetMetaData
Can you put a NULL in this column?
isReadOnly(). Method in interface java.sql.Connection
Tests to see if the connection is in read-only mode.
isReadOnly(). Method in interface java.sql.DatabaseMetaData
Is the database in read-only mode?
isReadOnly(int). Method in interface java.sql.ResultSetMetaData
Is a column definitely not writable?
isSearchable(int). Method in interface java.sql.ResultSetMetaData
Can the column be used in a where clause?
isSigned(int). Method in interface java.sql.ResultSetMetaData
Is the column a signed number?
isWritable(int). Method in interface java.sql.ResultSetMetaData
Is it possible for a write on the column to succeed?

J

jdbcCompliant(). Method in interface java.sql.Driver
Report whether the Driver is a genuine JDBC COMPLIANT (tm) driver.

L

longValue(). Method in class java.math.BigDecimal
Converts this number to a long.
longValue(). Method in class java.math.BigInteger
Converts this number to a long.
LONGVARBINARY. Static variable in class java.sql.Types
LONGVARCHAR. Static variable in class java.sql.Types

M

max(BigDecimal). Method in class java.math.BigDecimal
Returns the BigDecimal whose value is the greater of this and val.
max(BigInteger). Method in class java.math.BigInteger
Returns the BigInteger whose value is the greater of this and val.
min(BigDecimal). Method in class java.math.BigDecimal
Returns the BigDecimal whose value is the lesser of this and val.
min(BigInteger). Method in class java.math.BigInteger
Returns the BigInteger whose value is the lesser of this and val.
movePointLeft(int). Method in class java.math.BigDecimal
Returns a BigDecimal which is equivalent to this one with the decimal point moved n places to the left.
movePointRight(int). Method in class java.math.BigDecimal
Moves the decimal point the specified number of places to the right.
multiply(BigDecimal). Method in class java.math.BigDecimal
Returns a BigDecimal whose value is (this * val), and whose scale is this.scale() + val.scale.
multiply(BigInteger). Method in class java.math.BigInteger
Returns a BigInteger whose value is (this * val).

N

name. Variable in class java.sql.DriverPropertyInfo
The name of the property.
nativeSQL(String). Method in interface java.sql.Connection
A driver may convert the JDBC sql grammar into its system's native SQL grammar prior to sending it; nativeSQL returns the native form of the statement that the driver would have sent.
negate(). Method in class java.math.BigDecimal
Returns a BigDecimal whose value is -1 * this, and whose scale is this.scale().
negate(). Method in class java.math.BigInteger
Returns a BigInteger whose value is (-1 * this).
next(). Method in interface java.sql.ResultSet
A ResultSet is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.
NULL. Static variable in class java.sql.Types
nullPlusNonNullIsNull(). Method in interface java.sql.DatabaseMetaData
Are concatenations between NULL and non-NULL values NULL? A JDBC-Compliant driver always returns true.
nullsAreSortedAtEnd(). Method in interface java.sql.DatabaseMetaData
Are NULL values sorted at the end regardless of sort order?
nullsAreSortedAtStart(). Method in interface java.sql.DatabaseMetaData
Are NULL values sorted at the start regardless of sort order?
nullsAreSortedHigh(). Method in interface java.sql.DatabaseMetaData
Are NULL values sorted high?
nullsAreSortedLow(). Method in interface java.sql.DatabaseMetaData
Are NULL values sorted low?
NUMERIC. Static variable in class java.sql.Types

O

OTHER. Static variable in class java.sql.Types
OTHER indicates that the SQL type is database specific and gets mapped to a Java object which can be accessed via getObject and setObject.

P

pow(int). Method in class java.math.BigInteger
Returns a BigInteger whose value is (this ** exponent).
prepareCall(String). Method in interface java.sql.Connection
A SQL stored procedure call statement is handled by creating a CallableStatement for it.
prepareStatement(String). Method in interface java.sql.Connection
A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object.
println(String). Static method in class java.sql.DriverManager
Print a message to the current JDBC log stream
procedureColumnIn. Static variable in interface java.sql.DatabaseMetaData
COLUMN_TYPE - IN parameter.
procedureColumnInOut. Static variable in interface java.sql.DatabaseMetaData
COLUMN_TYPE - INOUT parameter.
procedureColumnOut. Static variable in interface java.sql.DatabaseMetaData
COLUMN_TYPE - OUT parameter.
procedureColumnResult. Static variable in interface java.sql.DatabaseMetaData
COLUMN_TYPE - result column in ResultSet.
procedureColumnReturn. Static variable in interface java.sql.DatabaseMetaData
COLUMN_TYPE - procedure return value.
procedureColumnUnknown. Static variable in interface java.sql.DatabaseMetaData
COLUMN_TYPE - nobody knows.
procedureNoNulls. Static variable in interface java.sql.DatabaseMetaData
TYPE NULLABLE - does not allow NULL values.
procedureNoResult. Static variable in interface java.sql.DatabaseMetaData
PROCEDURE_TYPE - Does not return a result.
procedureNullable. Static variable in interface java.sql.DatabaseMetaData
TYPE NULLABLE - allows NULL values.
procedureNullableUnknown. Static variable in interface java.sql.DatabaseMetaData
TYPE NULLABLE - nullability unknown.
procedureResultUnknown. Static variable in interface java.sql.DatabaseMetaData
PROCEDURE_TYPE - May return a result.
procedureReturnsResult. Static variable in interface java.sql.DatabaseMetaData
PROCEDURE_TYPE - Returns a result.

R

REAL. Static variable in class java.sql.Types
registerDriver(Driver). Static method in class java.sql.DriverManager
A newly loaded driver class should call registerDriver to make itself known to the DriverManager.
registerOutParameter(int, int). Method in interface java.sql.CallableStatement
Before executing a stored procedure call, you must explicitly call registerOutParameter to register the java.sql.Type of each out parameter.
registerOutParameter(int, int, int). Method in interface java.sql.CallableStatement
Use this version of registerOutParameter for registering Numeric or Decimal out parameters.
remainder(BigInteger). Method in class java.math.BigInteger
Returns a BigInteger whose value is (this % val).
required. Variable in class java.sql.DriverPropertyInfo
"required" is true if a value must be supplied for this property during Driver.connect.
rollback(). Method in interface java.sql.Connection
Rollback drops all changes made since the previous commit/rollback and releases any database locks currently held by the Connection.
ROUND_CEILING. Static variable in class java.math.BigDecimal
If the BigDecimal is positive, behave as for ROUND_UP; if negative, behave as for ROUND_DOWN.
ROUND_DOWN. Static variable in class java.math.BigDecimal
Never increment the digit prior to a discarded fraction (i.e., truncate).
ROUND_FLOOR. Static variable in class java.math.BigDecimal
If the BigDecimal is positive, behave as for ROUND_DOWN; if negative behave as for ROUND_UP.
ROUND_HALF_DOWN. Static variable in class java.math.BigDecimal
Behave as for ROUND_UP if the discarded fraction is > .5; otherwise, behave as for ROUND_DOWN.
ROUND_HALF_EVEN. Static variable in class java.math.BigDecimal
Behave as for ROUND_HALF_UP if the digit to the left of the discarded fraction is odd; behave as for ROUND_HALF_DOWN if it's even.
ROUND_HALF_UP. Static variable in class java.math.BigDecimal
Behave as for ROUND_UP if the discarded fraction is >= .5; otherwise, behave as for ROUND_DOWN.
ROUND_UNNECESSARY. Static variable in class java.math.BigDecimal
This "pseudo-rounding-mode" is actually an assertion that the requested operation has an exact result, hence no rounding is necessary.
ROUND_UP. Static variable in class java.math.BigDecimal
Always increment the digit prior to a non-zero discarded fraction.

S

scale(). Method in class java.math.BigDecimal
Returns the scale of this number.
setAsciiStream(int, InputStream, int). Method in interface java.sql.PreparedStatement
When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream.
setAutoCommit(boolean). Method in interface java.sql.Connection
If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions.
setBigDecimal(int, BigDecimal). Method in interface java.sql.PreparedStatement
Set a parameter to a java.lang.BigDecimal value.
setBinaryStream(int, InputStream, int). Method in interface java.sql.PreparedStatement
When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream.
setBoolean(int, boolean). Method in interface java.sql.PreparedStatement
Set a parameter to a Java boolean value.
setByte(int, byte). Method in interface java.sql.PreparedStatement
Set a parameter to a Java byte value.
setBytes(int, byte[]). Method in interface java.sql.PreparedStatement
Set a parameter to a Java array of bytes.
setCatalog(String). Method in interface java.sql.Connection
A sub-space of this Connection's database may be selected by setting a catalog name.
setCursorName(String). Method in interface java.sql.Statement
setCursorname defines the SQL cursor name that will be used by subsequent Statement execute methods.
setDate(int). Method in class java.sql.Time
setDate(int, Date). Method in interface java.sql.PreparedStatement
Set a parameter to a java.sql.Date value.
setDouble(int, double). Method in interface java.sql.PreparedStatement
Set a parameter to a Java double value.
setEscapeProcessing(boolean). Method in interface java.sql.Statement
If escape scanning is on (the default), the driver will do escape substitution before sending the SQL to the database.
setFloat(int, float). Method in interface java.sql.PreparedStatement
Set a parameter to a Java float value.
setHours(int). Method in class java.sql.Date
setInt(int, int). Method in interface java.sql.PreparedStatement
Set a parameter to a Java int value.
setLoginTimeout(int). Static method in class java.sql.DriverManager
Set the maximum time in seconds that all drivers can wait when attempting to log in to a database.
setLogStream(PrintStream). Static method in class java.sql.DriverManager
Set the logging/tracing PrintStream that is used by the DriverManager and all drivers.
setLong(int, long). Method in interface java.sql.PreparedStatement
Set a parameter to a Java long value.
setMaxFieldSize(int). Method in interface java.sql.Statement
The maxFieldSize limit (in bytes) is set to limit the size of data that can be returned for any column value; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR fields.
setMaxRows(int). Method in interface java.sql.Statement
The maxRows limit is set to limit the number of rows that any ResultSet can contain.
setMinutes(int). Method in class java.sql.Date
setMonth(int). Method in class java.sql.Time
setNanos(int). Method in class java.sql.Timestamp
Set the Timestamp's nanos value
setNextException(SQLException). Method in class java.sql.SQLException
Add an SQLException to the end of the chain.
setNextWarning(SQLWarning). Method in class java.sql.SQLWarning
Add an SQLWarning to the end of the chain.
setNull(int, int). Method in interface java.sql.PreparedStatement
Set a parameter to SQL NULL.
setObject(int, Object). Method in interface java.sql.PreparedStatement

Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.

setObject(int, Object, int). Method in interface java.sql.PreparedStatement
This method is like setObject above, but assumes a scale of zero.
setObject(int, Object, int, int). Method in interface java.sql.PreparedStatement

Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.

setQueryTimeout(int). Method in interface java.sql.Statement
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute.
setReadOnly(boolean). Method in interface java.sql.Connection
You can put a connection in read-only mode as a hint to enable database optimizations.
setScale(int). Method in class java.math.BigDecimal
Returns a BigDecimal whose scale is the specified value, and whose value is exactly equal to this number's.
setScale(int, int). Method in class java.math.BigDecimal
Returns a BigDecimal whose scale is the specified value, and whose integer value is determined by multiplying or dividing this BigDecimal's integer value by the appropriate power of ten to maintain the overall value.
setSeconds(int). Method in class java.sql.Date
setShort(int, short). Method in interface java.sql.PreparedStatement
Set a parameter to a Java short value.
setString(int, String). Method in interface java.sql.PreparedStatement
Set a parameter to a Java String value.
setTime(int, Time). Method in interface java.sql.PreparedStatement
Set a parameter to a java.sql.Time value.
setTime(long). Method in class java.sql.Date
Set a Date using a milliseconds time value
setTime(long). Method in class java.sql.Time
Set a Time using a milliseconds time value
setTimestamp(int, Timestamp). Method in interface java.sql.PreparedStatement
Set a parameter to a java.sql.Timestamp value.
setTransactionIsolation(int). Method in interface java.sql.Connection
You can call this method to try to change the transaction isolation level using one of the TRANSACTION_* values.
setUnicodeStream(int, InputStream, int). Method in interface java.sql.PreparedStatement
When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream.
setYear(int). Method in class java.sql.Time
signum(). Method in class java.math.BigDecimal
Returns the signum function of this number (i.e., -1, 0 or 1 as the value of this number is negative, zero or positive).
signum(). Method in class java.math.BigInteger
Returns the signum function of this number (i.e., -1, 0 or 1 as the value of this number is negative, zero or positive).
SMALLINT. Static variable in class java.sql.Types
SQLException(). Constructor for class java.sql.SQLException
Construct an SQLException; reason defaults to null, SQLState defaults to null and vendorCode defaults to 0.
SQLException(String). Constructor for class java.sql.SQLException
Construct an SQLException with a reason; SQLState defaults to null and vendorCode defaults to 0.
SQLException(String, String). Constructor for class java.sql.SQLException
Construct an SQLException with a reason and SQLState; vendorCode defaults to 0.
SQLException(String, String, int). Constructor for class java.sql.SQLException
Construct a fully-specified SQLException
SQLWarning(). Constructor for class java.sql.SQLWarning
Construct an SQLWarning ; reason defaults to null, SQLState defaults to null and vendorCode defaults to 0.
SQLWarning(String). Constructor for class java.sql.SQLWarning
Construct an SQLWarning with a reason; SQLState defaults to null and vendorCode defaults to 0.
SQLWarning(String, String). Constructor for class java.sql.SQLWarning
Construct an SQLWarning with a reason and SQLState; vendorCode defaults to 0.
SQLWarning(String, String, int). Constructor for class java.sql.SQLWarning
Construct a fully specified SQLWarning.
storesLowerCaseIdentifiers(). Method in interface java.sql.DatabaseMetaData
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in lower case?
storesLowerCaseQuotedIdentifiers(). Method in interface java.sql.DatabaseMetaData
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in lower case?
storesMixedCaseIdentifiers(). Method in interface java.sql.DatabaseMetaData
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in mixed case?
storesMixedCaseQuotedIdentifiers(). Method in interface java.sql.DatabaseMetaData
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in mixed case?
storesUpperCaseIdentifiers(). Method in interface java.sql.DatabaseMetaData
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in upper case?
storesUpperCaseQuotedIdentifiers(). Method in interface java.sql.DatabaseMetaData
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in upper case?
subtract(BigDecimal). Method in class java.math.BigDecimal
Returns a BigDecimal whose value is (this - val), and whose scale is MAX(this.scale(), val.scale).
subtract(BigInteger). Method in class java.math.BigInteger
Returns a BigInteger whose value is (this - val).
supportsAlterTableWithAddColumn(). Method in interface java.sql.DatabaseMetaData
Is "ALTER TABLE" with add column supported?
supportsAlterTableWithDropColumn(). Method in interface java.sql.DatabaseMetaData
Is "ALTER TABLE" with drop column supported?
supportsANSI92EntryLevelSQL(). Method in interface java.sql.DatabaseMetaData
Is the ANSI92 entry level SQL grammar supported? All JDBC-Compliant drivers must return true.
supportsANSI92FullSQL(). Method in interface java.sql.DatabaseMetaData
Is the ANSI92 full SQL grammar supported?
supportsANSI92IntermediateSQL(). Method in interface java.sql.DatabaseMetaData
Is the ANSI92 intermediate SQL grammar supported?
supportsCatalogsInDataManipulation(). Method in interface java.sql.DatabaseMetaData
Can a catalog name be used in a data manipulation statement?
supportsCatalogsInIndexDefinitions(). Method in interface java.sql.DatabaseMetaData
Can a catalog name be used in an index definition statement?
supportsCatalogsInPrivilegeDefinitions(). Method in interface java.sql.DatabaseMetaData
Can a catalog name be used in a privilege definition statement?
supportsCatalogsInProcedureCalls(). Method in interface java.sql.DatabaseMetaData
Can a catalog name be used in a procedure call statement?
supportsCatalogsInTableDefinitions(). Method in interface java.sql.DatabaseMetaData
Can a catalog name be used in a table definition statement?
supportsColumnAliasing(). Method in interface java.sql.DatabaseMetaData
Is column aliasing supported?

If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required.

supportsConvert(). Method in interface java.sql.DatabaseMetaData
Is the CONVERT function between SQL types supported?
supportsConvert(int, int). Method in interface java.sql.DatabaseMetaData
Is CONVERT between the given SQL types supported?
supportsCoreSQLGrammar(). Method in interface java.sql.DatabaseMetaData
Is the ODBC Core SQL grammar supported?
supportsCorrelatedSubqueries(). Method in interface java.sql.DatabaseMetaData
Are correlated subqueries supported? A JDBC-Compliant driver always returns true.
supportsDataDefinitionAndDataManipulationTransactions(). Method in interface java.sql.DatabaseMetaData
Are both data definition and data manipulation statements within a transaction supported?
supportsDataManipulationTransactionsOnly(). Method in interface java.sql.DatabaseMetaData
Are only data manipulation statements within a transaction supported?
supportsDifferentTableCorrelationNames(). Method in interface java.sql.DatabaseMetaData
If table correlation names are supported, are they restricted to be different from the names of the tables?
supportsExpressionsInOrderBy(). Method in interface java.sql.DatabaseMetaData
Are expressions in "ORDER BY" lists supported?
supportsExtendedSQLGrammar(). Method in interface java.sql.DatabaseMetaData
Is the ODBC Extended SQL grammar supported?
supportsFullOuterJoins(). Method in interface java.sql.DatabaseMetaData
Are full nested outer joins supported?
supportsGroupBy(). Method in interface java.sql.DatabaseMetaData
Is some form of "GROUP BY" clause supported?
supportsGroupByBeyondSelect(). Method in interface java.sql.DatabaseMetaData
Can a "GROUP BY" clause add columns not in the SELECT provided it specifies all the columns in the SELECT?
supportsGroupByUnrelated(). Method in interface java.sql.DatabaseMetaData
Can a "GROUP BY" clause use columns not in the SELECT?
supportsIntegrityEnhancementFacility(). Method in interface java.sql.DatabaseMetaData
Is the SQL Integrity Enhancement Facility supported?
supportsLikeEscapeClause(). Method in interface java.sql.DatabaseMetaData
Is the escape character in "LIKE" clauses supported? A JDBC-Compliant driver always returns true.
supportsLimitedOuterJoins(). Method in interface java.sql.DatabaseMetaData
Is there limited support for outer joins? (This will be true if supportFullOuterJoins is true.)
supportsMinimumSQLGrammar(). Method in interface java.sql.DatabaseMetaData
Is the ODBC Minimum SQL grammar supported? All JDBC-Compliant drivers must return true.
supportsMixedCaseIdentifiers(). Method in interface java.sql.DatabaseMetaData
Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC-Compliant driver will always return false.
supportsMixedCaseQuotedIdentifiers(). Method in interface java.sql.DatabaseMetaData
Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC-Compliant driver will always return true.
supportsMultipleResultSets(). Method in interface java.sql.DatabaseMetaData
Are multiple ResultSets from a single execute supported?
supportsMultipleTransactions(). Method in interface java.sql.DatabaseMetaData
Can we have multiple transactions open at once (on different connections)?
supportsNonNullableColumns(). Method in interface java.sql.DatabaseMetaData
Can columns be defined as non-nullable? A JDBC-Compliant driver always returns true.
supportsOpenCursorsAcrossCommit(). Method in interface java.sql.DatabaseMetaData
Can cursors remain open across commits?
supportsOpenCursorsAcrossRollback(). Method in interface java.sql.DatabaseMetaData
Can cursors remain open across rollbacks?
supportsOpenStatementsAcrossCommit(). Method in interface java.sql.DatabaseMetaData
Can statements remain open across commits?
supportsOpenStatementsAcrossRollback(). Method in interface java.sql.DatabaseMetaData
Can statements remain open across rollbacks?
supportsOrderByUnrelated(). Method in interface java.sql.DatabaseMetaData
Can an "ORDER BY" clause use columns not in the SELECT?
supportsOuterJoins(). Method in interface java.sql.DatabaseMetaData
Is some form of outer join supported?
supportsPositionedDelete(). Method in interface java.sql.DatabaseMetaData
Is positioned DELETE supported?
supportsPositionedUpdate(). Method in interface java.sql.DatabaseMetaData
Is positioned UPDATE supported?
supportsSchemasInDataManipulation(). Method in interface java.sql.DatabaseMetaData
Can a schema name be used in a data manipulation statement?
supportsSchemasInIndexDefinitions(). Method in interface java.sql.DatabaseMetaData
Can a schema name be used in an index definition statement?
supportsSchemasInPrivilegeDefinitions(). Method in interface java.sql.DatabaseMetaData
Can a schema name be used in a privilege definition statement?
supportsSchemasInProcedureCalls(). Method in interface java.sql.DatabaseMetaData
Can a schema name be used in a procedure call statement?
supportsSchemasInTableDefinitions(). Method in interface java.sql.DatabaseMetaData
Can a schema name be used in a table definition statement?
supportsSelectForUpdate(). Method in interface java.sql.DatabaseMetaData
Is SELECT for UPDATE supported?
supportsStoredProcedures(). Method in interface java.sql.DatabaseMetaData
Are stored procedure calls using the stored procedure escape syntax supported?
supportsSubqueriesInComparisons(). Method in interface java.sql.DatabaseMetaData
Are subqueries in comparison expressions supported? A JDBC-Compliant driver always returns true.
supportsSubqueriesInExists(). Method in interface java.sql.DatabaseMetaData
Are subqueries in 'exists' expressions supported? A JDBC-Compliant driver always returns true.
supportsSubqueriesInIns(). Method in interface java.sql.DatabaseMetaData
Are subqueries in 'in' statements supported? A JDBC-Compliant driver always returns true.
supportsSubqueriesInQuantifieds(). Method in interface java.sql.DatabaseMetaData
Are subqueries in quantified expressions supported? A JDBC-Compliant driver always returns true.
supportsTableCorrelationNames(). Method in interface java.sql.DatabaseMetaData
Are table correlation names supported? A JDBC-Compliant driver always returns true.
supportsTransactionIsolationLevel(int). Method in interface java.sql.DatabaseMetaData
Does the database support the given transaction isolation level?
supportsTransactions(). Method in interface java.sql.DatabaseMetaData
Are transactions supported? If not, commit is a noop and the isolation level is TRANSACTION_NONE.
supportsUnion(). Method in interface java.sql.DatabaseMetaData
Is SQL UNION supported?
supportsUnionAll(). Method in interface java.sql.DatabaseMetaData
Is SQL UNION ALL supported?

T

tableIndexClustered. Static variable in interface java.sql.DatabaseMetaData
INDEX INFO TYPE - this identifies a clustered index
tableIndexHashed. Static variable in interface java.sql.DatabaseMetaData
INDEX INFO TYPE - this identifies a hashed index
tableIndexOther. Static variable in interface java.sql.DatabaseMetaData
INDEX INFO TYPE - this identifies some other form of index
tableIndexStatistic. Static variable in interface java.sql.DatabaseMetaData
INDEX INFO TYPE - this identifies table statistics that are returned in conjuction with a table's index descriptions
testBit(int). Method in class java.math.BigInteger
Returns true iff the designated bit is set.
TIME. Static variable in class java.sql.Types
Time(int, int, int). Constructor for class java.sql.Time
Construct a Time Object
Time(long). Constructor for class java.sql.Time
Construct a Time using a milliseconds time value
TIMESTAMP. Static variable in class java.sql.Types
Timestamp(int, int, int, int, int, int, int). Constructor for class java.sql.Timestamp
Construct a Timestamp Object
Timestamp(long). Constructor for class java.sql.Timestamp
Construct a Timestamp using a milliseconds time value.
TINYINT. Static variable in class java.sql.Types
toBigInteger(). Method in class java.math.BigDecimal
Converts this number to a BigInteger.
toString(). Method in class java.math.BigDecimal
Returns the string representation of this number.
toString(). Method in class java.math.BigInteger
Returns the string representation of this number, radix 10.
toString(). Method in class java.sql.Date
Format a date in JDBC date escape format
toString(). Method in class java.sql.Time
Format a time in JDBC date escape format
toString(). Method in class java.sql.Timestamp
Format a timestamp in JDBC timestamp escape format
toString(int). Method in class java.math.BigInteger
Returns the string representation of this number in the given radix.
TRANSACTION_NONE. Static variable in interface java.sql.Connection
Transactions are not supported.
TRANSACTION_READ_COMMITTED. Static variable in interface java.sql.Connection
Dirty reads are prevented; non-repeatable reads and phantom reads can occur.
TRANSACTION_READ_UNCOMMITTED. Static variable in interface java.sql.Connection
Dirty reads, non-repeatable reads and phantom reads can occur.
TRANSACTION_REPEATABLE_READ. Static variable in interface java.sql.Connection
Dirty reads and non-repeatable reads are prevented; phantom reads can occur.
TRANSACTION_SERIALIZABLE. Static variable in interface java.sql.Connection
Dirty reads, non-repeatable reads and phantom reads are prevented.
typeNoNulls. Static variable in interface java.sql.DatabaseMetaData
TYPE NULLABLE - does not allow NULL values.
typeNullable. Static variable in interface java.sql.DatabaseMetaData
TYPE NULLABLE - allows NULL values.
typeNullableUnknown. Static variable in interface java.sql.DatabaseMetaData
TYPE NULLABLE - nullability unknown.
typePredBasic. Static variable in interface java.sql.DatabaseMetaData
TYPE INFO SEARCHABLE - Supported except for WHERE ..
typePredChar. Static variable in interface java.sql.DatabaseMetaData
TYPE INFO SEARCHABLE - Only supported with WHERE ..
typePredNone. Static variable in interface java.sql.DatabaseMetaData
TYPE INFO SEARCHABLE - No support.
typeSearchable. Static variable in interface java.sql.DatabaseMetaData
TYPE INFO SEARCHABLE - Supported for all WHERE ...

U

usesLocalFilePerTable(). Method in interface java.sql.DatabaseMetaData
Does the database use a file for each table?
usesLocalFiles(). Method in interface java.sql.DatabaseMetaData
Does the database store tables in a local file?

V

value. Variable in class java.sql.DriverPropertyInfo
"value" specifies the current value of the property, based on a combination of the information supplied to getPropertyInfo, the Java environment, and driver supplied default values.
valueOf(long). Static method in class java.math.BigDecimal
Returns a BigDecimal with the given value and a scale of zero.
valueOf(long). Static method in class java.math.BigInteger
Returns a BigInteger with the specified value.
valueOf(long, int). Static method in class java.math.BigDecimal
Returns a BigDecimal with a value of (val/10**scale).
valueOf(String). Static method in class java.sql.Date
Convert a string in JDBC date escape format to a Date value
valueOf(String). Static method in class java.sql.Time
Convert a string in JDBC time escape format to a Time value
valueOf(String). Static method in class java.sql.Timestamp
Convert a string in JDBC timestamp escape format to a Timestamp value
VARBINARY. Static variable in class java.sql.Types
VARCHAR. Static variable in class java.sql.Types
versionColumnNotPseudo. Static variable in interface java.sql.DatabaseMetaData
VERSION COLUMNS PSEUDO_COLUMN - is NOT a pseudo column.
versionColumnPseudo. Static variable in interface java.sql.DatabaseMetaData
VERSION COLUMNS PSEUDO_COLUMN - is a pseudo column.
versionColumnUnknown. Static variable in interface java.sql.DatabaseMetaData
VERSION COLUMNS PSEUDO_COLUMN - may or may not be pseudo column.

W

wasNull(). Method in interface java.sql.CallableStatement
An OUT parameter may have the value of SQL NULL; wasNull reports whether the last value read has this special value.
wasNull(). Method in interface java.sql.ResultSet
A column may have the value of SQL NULL; wasNull reports whether the last column read had this special value.