|
JavaTM 2 Platform Standard Edition |
|||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use SQLException | |
java.sql | Provides the JDBC package. |
Uses of SQLException in java.sql |
Subclasses of SQLException in java.sql | |
interface |
BatchUpdateException
JDBC 2.0 |
interface |
DataTruncation
An exception that reports a DataTruncation warning (on reads) or throws a DataTruncation exception (on writes) when JDBC unexpectedly truncates a data value. |
interface |
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 | |
String |
Array.getBaseTypeName()
Returns the SQL type name of the elements in the array designated by this Array object. |
int |
Array.getBaseType()
Returns the JDBC type of the elements in the array designated by this Array object. |
Object |
Array.getArray()
Retrieves the contents of the SQL array designated by this Array object in the form of an array in the Java
programming language. |
Object |
Array.getArray(Map map)
Retrieves the contents of the SQL array designated by this Array
object, using the specified map for type map
customizations. |
Object |
Array.getArray(long index,
int count)
Returns an array containing a slice of the SQL array, beginning with the specified index and containing up to count
successive elements of the SQL array. |
Object |
Array.getArray(long index,
int count,
Map map)
Returns an array containing a slice of the SQL array object designated by this object, beginning with the specified index and containing up to count
successive elements of the SQL array. |
ResultSet |
Array.getResultSet()
Returns a result set that contains the elements of the array designated by this Array object. |
ResultSet |
Array.getResultSet(Map map)
Returns a result set that contains the elements of the array designated by this Array object and uses the given
map to map the array elements. |
ResultSet |
Array.getResultSet(long index,
int count)
Returns a result set holding the elements of the subarray that starts at index index and contains up to
count successive elements. |
ResultSet |
Array.getResultSet(long index,
int count,
Map map)
Returns a result set holding the elements of the subarray that starts at index index and contains up to
count successive elements. |
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.lang.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 java.sql.Date 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 a parameter using an 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 a parameter using an object; use the java.lang equivalent objects for integral values. |
boolean |
PreparedStatement.execute()
Executes any kind of SQL statement. |
void |
PreparedStatement.addBatch()
JDBC 2.0 Adds a set of parameters to the batch. |
void |
PreparedStatement.setCharacterStream(int parameterIndex,
Reader reader,
int length)
JDBC 2.0 Sets the designated parameter to the given Reader
object, which is the given number of characters long. |
void |
PreparedStatement.setRef(int i,
Ref x)
JDBC 2.0 Sets a REF(<structured-type>) parameter. |
void |
PreparedStatement.setBlob(int i,
Blob x)
JDBC 2.0 Sets a BLOB parameter. |
void |
PreparedStatement.setClob(int i,
Clob x)
JDBC 2.0 Sets a CLOB parameter. |
void |
PreparedStatement.setArray(int i,
Array x)
JDBC 2.0 Sets an Array parameter. |
ResultSetMetaData |
PreparedStatement.getMetaData()
JDBC 2.0 Gets the number, types and properties of a ResultSet's columns. |
void |
PreparedStatement.setDate(int parameterIndex,
Date x,
Calendar cal)
JDBC 2.0 Sets the designated parameter to a java.sql.Date value, using the given Calendar object. |
void |
PreparedStatement.setTime(int parameterIndex,
Time x,
Calendar cal)
JDBC 2.0 Sets the designated parameter to a java.sql.Time value, using the given Calendar object. |
void |
PreparedStatement.setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal)
JDBC 2.0 Sets the designated parameter to a java.sql.Timestamp value, using the given Calendar object. |
void |
PreparedStatement.setNull(int paramIndex,
int sqlType,
String typeName)
JDBC 2.0 Sets the designated parameter to SQL NULL. |
long |
Clob.length()
Returns the number of characters in the CLOB value
designated by this Clob object. |
String |
Clob.getSubString(long pos,
int length)
Returns a copy of the specified substring in the CLOB value
designated by this Clob object. |
Reader |
Clob.getCharacterStream()
Gets the Clob contents as a Unicode stream. |
InputStream |
Clob.getAsciiStream()
Gets the CLOB value designated by this Clob
object as a stream of Ascii bytes. |
long |
Clob.position(String searchstr,
long start)
Determines the character position at which the specified substring searchstr appears in the CLOB . |
long |
Clob.position(Clob searchstr,
long start)
Determines the character position at which the specified Clob object searchstr appears in this
Clob object. |
String |
Ref.getBaseTypeName()
Gets the fully-qualified SQL structured type name of the referenced item. |
boolean |
ResultSet.next()
Moves the cursor down one row from its current position. |
void |
ResultSet.close()
Releases this ResultSet object's database and
JDBC resources immediately instead of waiting for
this to happen when it is automatically closed. |
boolean |
ResultSet.wasNull()
Reports whether the last column read had a value of SQL NULL. |
String |
ResultSet.getString(int columnIndex)
Gets the value of a column in the current row as a Java String. |
boolean |
ResultSet.getBoolean(int columnIndex)
Gets the value of a column in the current row as a Java boolean. |
byte |
ResultSet.getByte(int columnIndex)
Gets the value of a column in the current row as a Java byte. |
short |
ResultSet.getShort(int columnIndex)
Gets the value of a column in the current row as a Java short. |
int |
ResultSet.getInt(int columnIndex)
Gets the value of a column in the current row as a Java int. |
long |
ResultSet.getLong(int columnIndex)
Gets the value of a column in the current row as a Java long. |
float |
ResultSet.getFloat(int columnIndex)
Gets the value of a column in the current row as a Java float. |
double |
ResultSet.getDouble(int columnIndex)
Gets the value of a column in the current row as a Java double. |
BigDecimal |
ResultSet.getBigDecimal(int columnIndex,
int scale)
Deprecated. |
byte[] |
ResultSet.getBytes(int columnIndex)
Gets the value of a column in the current row as a Java byte array. |
Date |
ResultSet.getDate(int columnIndex)
Gets the value of a column in the current row as a java.sql.Date object. |
Time |
ResultSet.getTime(int columnIndex)
Gets the value of a column in the current row as a java.sql.Time object. |
Timestamp |
ResultSet.getTimestamp(int columnIndex)
Gets the value of a column in the current row as a java.sql.Timestamp object. |
InputStream |
ResultSet.getAsciiStream(int columnIndex)
Gets the value of a column in the current row as a stream of ASCII characters. |
InputStream |
ResultSet.getUnicodeStream(int columnIndex)
Deprecated. |
InputStream |
ResultSet.getBinaryStream(int columnIndex)
Gets the value of a column in the current row as a stream of uninterpreted bytes. |
String |
ResultSet.getString(String columnName)
Gets the value of a column in the current row as a Java String. |
boolean |
ResultSet.getBoolean(String columnName)
Gets the value of a column in the current row as a Java boolean. |
byte |
ResultSet.getByte(String columnName)
Gets the value of a column in the current row as a Java byte. |
short |
ResultSet.getShort(String columnName)
Gets the value of a column in the current row as a Java short. |
int |
ResultSet.getInt(String columnName)
Gets the value of a column in the current row as a Java int. |
long |
ResultSet.getLong(String columnName)
Gets the value of a column in the current row as a Java long. |
float |
ResultSet.getFloat(String columnName)
Gets the value of a column in the current row as a Java float. |
double |
ResultSet.getDouble(String columnName)
Gets the value of a column in the current row as a Java double. |
BigDecimal |
ResultSet.getBigDecimal(String columnName,
int scale)
Deprecated. |
byte[] |
ResultSet.getBytes(String columnName)
Gets the value of a column in the current row as a Java byte array. |
Date |
ResultSet.getDate(String columnName)
Gets the value of a column in the current row as a java.sql.Date object. |
Time |
ResultSet.getTime(String columnName)
Gets the value of a column in the current row as a java.sql.Time object. |
Timestamp |
ResultSet.getTimestamp(String columnName)
Gets the value of a column in the current row as a java.sql.Timestamp object. |
InputStream |
ResultSet.getAsciiStream(String columnName)
Gets the value of a column in the current row as a stream of ASCII characters. |
InputStream |
ResultSet.getUnicodeStream(String columnName)
Deprecated. |
InputStream |
ResultSet.getBinaryStream(String columnName)
Gets the value of a column in the current row as a stream of uninterpreted bytes. |
SQLWarning |
ResultSet.getWarnings()
The first warning reported by calls on this ResultSet is returned. |
void |
ResultSet.clearWarnings()
After this call getWarnings returns null until a new warning is reported for this ResultSet. |
String |
ResultSet.getCursorName()
Gets the name of the SQL cursor used by this ResultSet. |
ResultSetMetaData |
ResultSet.getMetaData()
Retrieves the number, types and properties of a ResultSet's columns. |
Object |
ResultSet.getObject(int columnIndex)
Gets the value of a column in the current row as a Java object. |
Object |
ResultSet.getObject(String columnName)
Gets the value of a column in the current row as a Java object. |
int |
ResultSet.findColumn(String columnName)
Maps the given Resultset column name to its ResultSet column index. |
Reader |
ResultSet.getCharacterStream(int columnIndex)
JDBC 2.0 |
Reader |
ResultSet.getCharacterStream(String columnName)
JDBC 2.0 |
BigDecimal |
ResultSet.getBigDecimal(int columnIndex)
JDBC 2.0 Gets the value of a column in the current row as a java.math.BigDecimal object with full precision. |
BigDecimal |
ResultSet.getBigDecimal(String columnName)
JDBC 2.0 Gets the value of a column in the current row as a java.math.BigDecimal object with full precision. |
boolean |
ResultSet.isBeforeFirst()
JDBC 2.0 |
boolean |
ResultSet.isAfterLast()
JDBC 2.0 |
boolean |
ResultSet.isFirst()
JDBC 2.0 |
boolean |
ResultSet.isLast()
JDBC 2.0 |
void |
ResultSet.beforeFirst()
JDBC 2.0 |
void |
ResultSet.afterLast()
JDBC 2.0 |
boolean |
ResultSet.first()
JDBC 2.0 |
boolean |
ResultSet.last()
JDBC 2.0 |
int |
ResultSet.getRow()
JDBC 2.0 |
boolean |
ResultSet.absolute(int row)
JDBC 2.0 |
boolean |
ResultSet.relative(int rows)
JDBC 2.0 |
boolean |
ResultSet.previous()
JDBC 2.0 |
void |
ResultSet.setFetchDirection(int direction)
JDBC 2.0 Gives a hint as to the direction in which the rows in this result set will be processed. |
int |
ResultSet.getFetchDirection()
JDBC 2.0 Returns the fetch direction for this result set. |
void |
ResultSet.setFetchSize(int rows)
JDBC 2.0 Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this result set. |
int |
ResultSet.getFetchSize()
JDBC 2.0 Returns the fetch size for this result set. |
int |
ResultSet.getType()
JDBC 2.0 Returns the type of this result set. |
int |
ResultSet.getConcurrency()
JDBC 2.0 Returns the concurrency mode of this result set. |
boolean |
ResultSet.rowUpdated()
JDBC 2.0 Indicates whether the current row has been updated. |
boolean |
ResultSet.rowInserted()
JDBC 2.0 Indicates whether the current row has had an insertion. |
boolean |
ResultSet.rowDeleted()
JDBC 2.0 Indicates whether a row has been deleted. |
void |
ResultSet.updateNull(int columnIndex)
JDBC 2.0 Give a nullable column a null value. |
void |
ResultSet.updateBoolean(int columnIndex,
boolean x)
JDBC 2.0 Updates a column with a boolean value. |
void |
ResultSet.updateByte(int columnIndex,
byte x)
JDBC 2.0 Updates a column with a byte value. |
void |
ResultSet.updateShort(int columnIndex,
short x)
JDBC 2.0 Updates a column with a short value. |
void |
ResultSet.updateInt(int columnIndex,
int x)
JDBC 2.0 Updates a column with an integer value. |
void |
ResultSet.updateLong(int columnIndex,
long x)
JDBC 2.0 Updates a column with a long value. |
void |
ResultSet.updateFloat(int columnIndex,
float x)
JDBC 2.0 Updates a column with a float value. |
void |
ResultSet.updateDouble(int columnIndex,
double x)
JDBC 2.0 Updates a column with a Double value. |
void |
ResultSet.updateBigDecimal(int columnIndex,
BigDecimal x)
JDBC 2.0 Updates a column with a BigDecimal value. |
void |
ResultSet.updateString(int columnIndex,
String x)
JDBC 2.0 Updates a column with a String value. |
void |
ResultSet.updateBytes(int columnIndex,
byte[] x)
JDBC 2.0 Updates a column with a byte array value. |
void |
ResultSet.updateDate(int columnIndex,
Date x)
JDBC 2.0 Updates a column with a Date value. |
void |
ResultSet.updateTime(int columnIndex,
Time x)
JDBC 2.0 Updates a column with a Time value. |
void |
ResultSet.updateTimestamp(int columnIndex,
Timestamp x)
JDBC 2.0 Updates a column with a Timestamp value. |
void |
ResultSet.updateAsciiStream(int columnIndex,
InputStream x,
int length)
JDBC 2.0 Updates a column with an ascii stream value. |
void |
ResultSet.updateBinaryStream(int columnIndex,
InputStream x,
int length)
JDBC 2.0 Updates a column with a binary stream value. |
void |
ResultSet.updateCharacterStream(int columnIndex,
Reader x,
int length)
JDBC 2.0 Updates a column with a character stream value. |
void |
ResultSet.updateObject(int columnIndex,
Object x,
int scale)
JDBC 2.0 Updates a column with an Object value. |
void |
ResultSet.updateObject(int columnIndex,
Object x)
JDBC 2.0 Updates a column with an Object value. |
void |
ResultSet.updateNull(String columnName)
JDBC 2.0 Updates a column with a null value. |
void |
ResultSet.updateBoolean(String columnName,
boolean x)
JDBC 2.0 Updates a column with a boolean value. |
void |
ResultSet.updateByte(String columnName,
byte x)
JDBC 2.0 Updates a column with a byte value. |
void |
ResultSet.updateShort(String columnName,
short x)
JDBC 2.0 Updates a column with a short value. |
void |
ResultSet.updateInt(String columnName,
int x)
JDBC 2.0 Updates a column with an integer value. |
void |
ResultSet.updateLong(String columnName,
long x)
JDBC 2.0 Updates a column with a long value. |
void |
ResultSet.updateFloat(String columnName,
float x)
JDBC 2.0 Updates a column with a float value. |
void |
ResultSet.updateDouble(String columnName,
double x)
JDBC 2.0 Updates a column with a double value. |
void |
ResultSet.updateBigDecimal(String columnName,
BigDecimal x)
JDBC 2.0 Updates a column with a BigDecimal value. |
void |
ResultSet.updateString(String columnName,
String x)
JDBC 2.0 Updates a column with a String value. |
void |
ResultSet.updateBytes(String columnName,
byte[] x)
JDBC 2.0 Updates a column with a byte array value. |
void |
ResultSet.updateDate(String columnName,
Date x)
JDBC 2.0 Updates a column with a Date value. |
void |
ResultSet.updateTime(String columnName,
Time x)
JDBC 2.0 Updates a column with a Time value. |
void |
ResultSet.updateTimestamp(String columnName,
Timestamp x)
JDBC 2.0 Updates a column with a Timestamp value. |
void |
ResultSet.updateAsciiStream(String columnName,
InputStream x,
int length)
JDBC 2.0 Updates a column with an ascii stream value. |
void |
ResultSet.updateBinaryStream(String columnName,
InputStream x,
int length)
JDBC 2.0 Updates a column with a binary stream value. |
void |
ResultSet.updateCharacterStream(String columnName,
Reader reader,
int length)
JDBC 2.0 Updates a column with a character stream value. |
void |
ResultSet.updateObject(String columnName,
Object x,
int scale)
JDBC 2.0 Updates a column with an Object value. |
void |
ResultSet.updateObject(String columnName,
Object x)
JDBC 2.0 Updates a column with an Object value. |
void |
ResultSet.insertRow()
JDBC 2.0 Inserts the contents of the insert row into the result set and the database. |
void |
ResultSet.updateRow()
JDBC 2.0 Updates the underlying database with the new contents of the current row. |
void |
ResultSet.deleteRow()
JDBC 2.0 Deletes the current row from the result set and the underlying database. |
void |
ResultSet.refreshRow()
JDBC 2.0 Refreshes the current row with its most recent value in the database. |
void |
ResultSet.cancelRowUpdates()
JDBC 2.0 Cancels the updates made to a row. |
void |
ResultSet.moveToInsertRow()
JDBC 2.0 Moves the cursor to the insert row. |
void |
ResultSet.moveToCurrentRow()
JDBC 2.0 Moves the cursor to the remembered cursor position, usually the current row. |
Statement |
ResultSet.getStatement()
JDBC 2.0 Returns the Statement that produced this ResultSet object. |
Object |
ResultSet.getObject(int i,
Map map)
JDBC 2.0 Returns the value of a column in the current row as a Java object. |
Ref |
ResultSet.getRef(int i)
JDBC 2.0 Gets a REF(<structured-type>) column value from the current row. |
Blob |
ResultSet.getBlob(int i)
JDBC 2.0 Gets a BLOB value in the current row of this ResultSet object. |
Clob |
ResultSet.getClob(int i)
JDBC 2.0 Gets a CLOB value in the current row of this ResultSet object. |
Array |
ResultSet.getArray(int i)
JDBC 2.0 Gets an SQL ARRAY value from the current row of this ResultSet object. |
Object |
ResultSet.getObject(String colName,
Map map)
JDBC 2.0 Returns the value in the specified column as a Java object. |
Ref |
ResultSet.getRef(String colName)
JDBC 2.0 Gets a REF(<structured-type>) column value from the current row. |
Blob |
ResultSet.getBlob(String colName)
JDBC 2.0 Gets a BLOB value in the current row of this ResultSet object. |
Clob |
ResultSet.getClob(String colName)
JDBC 2.0 Gets a CLOB value in the current row of this ResultSet object. |
Array |
ResultSet.getArray(String colName)
JDBC 2.0 Gets an SQL ARRAY value in the current row of this ResultSet object. |
Date |
ResultSet.getDate(int columnIndex,
Calendar cal)
JDBC 2.0 Gets the value of a column in the current row as a java.sql.Date object. |
Date |
ResultSet.getDate(String columnName,
Calendar cal)
Gets the value of a column in the current row as a java.sql.Date object. |
Time |
ResultSet.getTime(int columnIndex,
Calendar cal)
Gets the value of a column in the current row as a java.sql.Time object. |
Time |
ResultSet.getTime(String columnName,
Calendar cal)
Gets the value of a column in the current row as a java.sql.Time object. |
Timestamp |
ResultSet.getTimestamp(int columnIndex,
Calendar cal)
Gets the value of a column in the current row as a java.sql.Timestamp object. |
Timestamp |
ResultSet.getTimestamp(String columnName,
Calendar cal)
Gets the value of a column in the current row as a java.sql.Timestamp object. |
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. |
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. |
String |
SQLInput.readString()
Reads the next attribute in the stream as a Java String. |
boolean |
SQLInput.readBoolean()
Reads the next attribute in the stream as a Java boolean. |
byte |
SQLInput.readByte()
Reads the next attribute in the stream as a Java byte. |
short |
SQLInput.readShort()
Reads the next attribute in the stream as a Java short. |
int |
SQLInput.readInt()
Reads the next attribute in the stream as a Java int. |
long |
SQLInput.readLong()
Reads the next attribute in the stream as a Java long. |
float |
SQLInput.readFloat()
Reads the next attribute in the stream as a Java float. |
double |
SQLInput.readDouble()
Reads the next attribute in the stream as a Java double. |
BigDecimal |
SQLInput.readBigDecimal()
Reads the next attribute in the stream as a java.math.BigDecimal object. |
byte[] |
SQLInput.readBytes()
Reads the next attribute in the stream as an array of bytes. |
Date |
SQLInput.readDate()
Reads the next attribute in the stream as a java.sql.Date object. |
Time |
SQLInput.readTime()
Reads the next attribute in the stream as a java.sql.Time object. |
Timestamp |
SQLInput.readTimestamp()
Reads the next attribute in the stream as a java.sql.Timestamp object. |
Reader |
SQLInput.readCharacterStream()
Returns the next attribute in the stream as a stream of Unicode characters. |
InputStream |
SQLInput.readAsciiStream()
Returns the next attribute in the stream as a stream of ASCII characters. |
InputStream |
SQLInput.readBinaryStream()
Returns the next attribute in the stream as a stream of uninterpreted bytes. |
Object |
SQLInput.readObject()
Returns the datum at the head of the stream as a Java object. |
Ref |
SQLInput.readRef()
Reads a REF(<structured-type>) from the stream. |
Blob |
SQLInput.readBlob()
Reads a BLOB from the stream. |
Clob |
SQLInput.readClob()
Reads a CLOB from the stream. |
Array |
SQLInput.readArray()
Reads an array from the stream. |
boolean |
SQLInput.wasNull()
Determines whether the last value read was null. |
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 vlaures 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)
JDBC 2.0 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)
JDBC 2.0 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)
JDBC 2.0 Gets the value of a JDBC REF(<structured-type>)
parameter as a Ref object in the Java programming language. |
Blob |
CallableStatement.getBlob(int i)
JDBC 2.0 Gets the value of a JDBC BLOB parameter as a
Blob object in the Java programming language. |
Clob |
CallableStatement.getClob(int i)
JDBC 2.0 Gets the value of a JDBC CLOB parameter as a
Clob object in the Java programming language. |
Array |
CallableStatement.getArray(int i)
JDBC 2.0 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)
JDBC 2.0 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. |
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)
JDBC 2.0 Creates a Statement object that will generate
ResultSet objects with the given type and concurrency. |
PreparedStatement |
Connection.prepareStatement(String sql,
int resultSetType,
int resultSetConcurrency)
JDBC 2.0 Creates a PreparedStatement object that will generate
ResultSet objects with the given type and concurrency. |
CallableStatement |
Connection.prepareCall(String sql,
int resultSetType,
int resultSetConcurrency)
JDBC 2.0 Creates a CallableStatement object that will generate
ResultSet objects with the given type and concurrency. |
Map |
Connection.getTypeMap()
JDBC 2.0 Gets the type map object associated with this connection. |
void |
Connection.setTypeMap(Map map)
JDBC 2.0 Installs the given type map as the type map for this connection. |
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. |
ResultSet |
Statement.executeQuery(String sql)
Executes a SQL statement that returns a single ResultSet. |
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 can contain. |
void |
Statement.setMaxRows(int max)
Sets the limit for the maximum number of rows that any ResultSet 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 to execute. |
void |
Statement.setQueryTimeout(int seconds)
Sets the number of seconds the driver will wait for a Statement 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. |
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 execute methods. |
boolean |
Statement.execute(String sql)
Executes a 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 or there are no more results, -1 is returned. |
boolean |
Statement.getMoreResults()
Moves to a Statement's next result. |
void |
Statement.setFetchDirection(int direction)
JDBC 2.0 Gives the driver a hint as to the direction in which the rows in a result set will be processed. |
int |
Statement.getFetchDirection()
JDBC 2.0 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)
JDBC 2.0 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()
JDBC 2.0 Retrieves the number of result set rows that is the default fetch size for result sets generated from this Statement object. |
int |
Statement.getResultSetConcurrency()
JDBC 2.0 Retrieves the result set concurrency. |
int |
Statement.getResultSetType()
JDBC 2.0 Determine the result set type. |
void |
Statement.addBatch(String sql)
JDBC 2.0 Adds a SQL command to the current batch of commmands for the statement. |
void |
Statement.clearBatch()
JDBC 2.0 Makes the set of commands in the current batch empty. |
int[] |
Statement.executeBatch()
JDBC 2.0 Submits a batch of commands to the database for execution. |
Connection |
Statement.getConnection()
JDBC 2.0 Returns the Connection object
that produced this Statement object. |
void |
SQLOutput.writeString(String x)
Writes the next attribute to the stream as a Java String. |
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)
Returns the next attribute to the stream as a stream of Unicode characters. |
void |
SQLOutput.writeAsciiStream(InputStream x)
Returns the next attribute to the stream as a stream of ASCII characters. |
void |
SQLOutput.writeBinaryStream(InputStream x)
Returns 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 a REF(<structured-type>) to the stream. |
void |
SQLOutput.writeBlob(Blob x)
Writes a BLOB to the stream. |
void |
SQLOutput.writeClob(Clob x)
Writes a CLOB to the stream. |
void |
SQLOutput.writeStruct(Struct x)
Writes a structured-type to the stream. |
void |
SQLOutput.writeArray(Array x)
Writes an array to the stream. |
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? A JDBC CompliantTM driver always returns 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 ResultSets 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()
What's the maximum length of an index (in bytes)? |
int |
DatabaseMetaData.getMaxSchemaNameLength()
What's the maximum length allowed for a schema name? |
int |
DatabaseMetaData.getMaxProcedureNameLength()
What's the maximum length of a procedure name? |
int |
DatabaseMetaData.getMaxCatalogNameLength()
What's the maximum length of a catalog name? |
int |
DatabaseMetaData.getMaxRowSize()
What's the maximum length of a single row? |
boolean |
DatabaseMetaData.doesMaxRowSizeIncludeBlobs()
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs? |
int |
DatabaseMetaData.getMaxStatementLength()
What's the maximum length of a SQL statement? |
int |
DatabaseMetaData.getMaxStatements()
How many active statements can we have open at one time to this database? |
int |
DatabaseMetaData.getMaxTableNameLength()
What's the maximum length of a table name? |
int |
DatabaseMetaData.getMaxTablesInSelect()
What's the maximum number of tables in a SELECT statement? |
int |
DatabaseMetaData.getMaxUserNameLength()
What's the maximum length of a user name? |
int |
DatabaseMetaData.getDefaultTransactionIsolation()
What's the database's default transaction isolation level? The values are defined in java.sql.Connection . |
boolean |
DatabaseMetaData.supportsTransactions()
Are transactions supported? If not, invoking the method commit is a noop and the
isolation level is TRANSACTION_NONE. |
boolean |
DatabaseMetaData.supportsTransactionIsolationLevel(int level)
Does this database support the given transaction isolation level? |
boolean |
DatabaseMetaData.supportsDataDefinitionAndDataManipulationTransactions()
Are both data definition and data manipulation statements within a transaction supported? |
boolean |
DatabaseMetaData.supportsDataManipulationTransactionsOnly()
Are only data manipulation statements within a transaction supported? |
boolean |
DatabaseMetaData.dataDefinitionCausesTransactionCommit()
Does a data definition statement within a transaction force the transaction to commit? |
boolean |
DatabaseMetaData.dataDefinitionIgnoredInTransactions()
Is a data definition statement within a transaction ignored? |
ResultSet |
DatabaseMetaData.getProcedures(String catalog,
String schemaPattern,
String procedureNamePattern)
Gets a description of the stored procedures available in a catalog. |
ResultSet |
DatabaseMetaData.getProcedureColumns(String catalog,
String schemaPattern,
String procedureNamePattern,
String columnNamePattern)
Gets a description of a catalog's stored procedure parameters and result columns. |
ResultSet |
DatabaseMetaData.getTables(String catalog,
String schemaPattern,
String tableNamePattern,
String[] types)
Gets a description of tables available in a catalog. |
ResultSet |
DatabaseMetaData.getSchemas()
Gets the schema names available in this database. |
ResultSet |
DatabaseMetaData.getCatalogs()
Gets the catalog names available in this database. |
ResultSet |
DatabaseMetaData.getTableTypes()
Gets the table types available in this database. |
ResultSet |
DatabaseMetaData.getColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern)
Gets a description of table columns available in the specified catalog. |
ResultSet |
DatabaseMetaData.getColumnPrivileges(String catalog,
String schema,
String table,
String columnNamePattern)
Gets a description of the access rights for a table's columns. |
ResultSet |
DatabaseMetaData.getTablePrivileges(String catalog,
String schemaPattern,
String tableNamePattern)
Gets a description of the access rights for each table available in a catalog. |
ResultSet |
DatabaseMetaData.getBestRowIdentifier(String catalog,
String schema,
String table,
int scope,
boolean nullable)
Gets a description of a table's optimal set of columns that uniquely identifies a row. |
ResultSet |
DatabaseMetaData.getVersionColumns(String catalog,
String schema,
String table)
Gets a description of a table's columns that are automatically updated when any value in a row is updated. |
ResultSet |
DatabaseMetaData.getPrimaryKeys(String catalog,
String schema,
String table)
Gets a description of a table's primary key columns. |
ResultSet |
DatabaseMetaData.getImportedKeys(String catalog,
String schema,
String table)
Gets a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table). |
ResultSet |
DatabaseMetaData.getExportedKeys(String catalog,
String schema,
String table)
Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table). |
ResultSet |
DatabaseMetaData.getCrossReference(String primaryCatalog,
String primarySchema,
String primaryTable,
String foreignCatalog,
String foreignSchema,
String foreignTable)
Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.) This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ. |
ResultSet |
DatabaseMetaData.getTypeInfo()
Gets a description of all the standard SQL types supported by this database. |
ResultSet |
DatabaseMetaData.getIndexInfo(String catalog,
String schema,
String table,
boolean unique,
boolean approximate)
Gets a description of a table's indices and statistics. |
boolean |
DatabaseMetaData.supportsResultSetType(int type)
JDBC 2.0 Does the database support the given result set type? |
boolean |
DatabaseMetaData.supportsResultSetConcurrency(int type,
int concurrency)
JDBC 2.0 Does the database support the concurrency type in combination with the given result set type? |
boolean |
DatabaseMetaData.ownUpdatesAreVisible(int type)
JDBC 2.0 Indicates whether a result set's own updates are visible. |
boolean |
DatabaseMetaData.ownDeletesAreVisible(int type)
JDBC 2.0 Indicates whether a result set's own deletes are visible. |
boolean |
DatabaseMetaData.ownInsertsAreVisible(int type)
JDBC 2.0 Indicates whether a result set's own inserts are visible. |
boolean |
DatabaseMetaData.othersUpdatesAreVisible(int type)
JDBC 2.0 Indicates whether updates made by others are visible. |
boolean |
DatabaseMetaData.othersDeletesAreVisible(int type)
JDBC 2.0 Indicates whether deletes made by others are visible. |
boolean |
DatabaseMetaData.othersInsertsAreVisible(int type)
JDBC 2.0 Indicates whether inserts made by others are visible. |
boolean |
DatabaseMetaData.updatesAreDetected(int type)
JDBC 2.0 Indicates whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated . |
boolean |
DatabaseMetaData.deletesAreDetected(int type)
JDBC 2.0 Indicates whether or not a visible row delete can be detected by calling ResultSet.rowDeleted(). |
boolean |
DatabaseMetaData.insertsAreDetected(int type)
JDBC 2.0 Indicates whether or not a visible row insert can be detected by calling ResultSet.rowInserted(). |
boolean |
DatabaseMetaData.supportsBatchUpdates()
JDBC 2.0 Indicates whether the driver supports batch updates. |
ResultSet |
DatabaseMetaData.getUDTs(String catalog,
String schemaPattern,
String typeNamePattern,
int[] types)
JDBC 2.0 Gets a description of the user-defined types defined in a particular schema. |
Connection |
DatabaseMetaData.getConnection()
JDBC 2.0 Retrieves the connection that produced this metadata object. |
int |
ResultSetMetaData.getColumnCount()
Returns the number of columns in this ResultSet. |
boolean |
ResultSetMetaData.isAutoIncrement(int column)
Indicates whether the column is automatically numbered, thus read-only. |
boolean |
ResultSetMetaData.isCaseSensitive(int column)
Indicates whether a column's case matters. |
boolean |
ResultSetMetaData.isSearchable(int column)
Indicates whether the column can be used in a where clause. |
boolean |
ResultSetMetaData.isCurrency(int column)
Indicates whether the column is a cash value. |
int |
ResultSetMetaData.isNullable(int column)
Indicates the nullability of values in the designated column. |
boolean |
ResultSetMetaData.isSigned(int column)
Indicates whether values in the column are signed numbers. |
int |
ResultSetMetaData.getColumnDisplaySize(int column)
Indicates the column's normal max width in chars. |
String |
ResultSetMetaData.getColumnLabel(int column)
Gets the suggested column title for use in printouts and displays. |
String |
ResultSetMetaData.getColumnName(int column)
Gets a column's name. |
String |
ResultSetMetaData.getSchemaName(int column)
Gets a column's table's schema. |
int |
ResultSetMetaData.getPrecision(int column)
Gets a column's number of decimal digits. |
int |
ResultSetMetaData.getScale(int column)
Gets a column's number of digits to right of the decimal point. |
String |
ResultSetMetaData.getTableName(int column)
Gets a column's table name. |
String |
ResultSetMetaData.getCatalogName(int column)
Gets a column's table's catalog name. |
int |
ResultSetMetaData.getColumnType(int column)
Retrieves a column's SQL type. |
String |
ResultSetMetaData.getColumnTypeName(int column)
Retrieves a column's database-specific type name. |
boolean |
ResultSetMetaData.isReadOnly(int column)
Indicates whether a column is definitely not writable. |
boolean |
ResultSetMetaData.isWritable(int column)
Indicates whether it is possible for a write on the column to succeed. |
boolean |
ResultSetMetaData.isDefinitelyWritable(int column)
Indicates whether a write on the column will definitely succeed. |
String |
ResultSetMetaData.getColumnClassName(int column)
JDBC 2.0 |
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. |
|
JavaTM 2 Platform Standard Edition |
|||||||||
PREV NEXT | FRAMES NO FRAMES |