|
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 |