|
Java Platform 1.2 Beta 4 |
|||||||||
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 | |
BatchUpdateException
JDBC 2.0 The BatchUpdateException class provides information on an error that occurs during a batch update operation. |
|
DataTruncation
When JDBC unexpectedly truncates a data value, it reports a DataTruncation warning (on reads) or throws a DataTruncation exception (on writes). |
|
SQLWarning
The SQLWarning class provides information on a database access warnings. |
Methods in java.sql that return SQLException | |
SQLException | SQLException.getNextException()
Get the exception chained to this one. |
Methods in java.sql with parameters of type SQLException | |
void | SQLException.setNextException(SQLException ex)
Add an SQLException to the end of the chain. |
Methods in java.sql that throw SQLException | |
String | Array.getBaseTypeName()
Return the fully qualified SQL type name of the elements of this array. |
int | Array.getBaseType()
Determine the code, from java.sql. |
Object | Array.getArray()
Retrieve the contents of the SQL array designated by the object. |
Object | Array.getArray(Map map)
Retrieve the contents of the SQL array designated by this object. |
Object | Array.getArray(long index,
int count)
Like getArray() above, but returns an array containing a slice of the SQL array, beginning with the given @index and containing up to @count successive elements of the SQL array. |
Object | Array.getArray(long index,
int count,
Map map)
Like getArray() above, but returns an array containing a slice of the SQL array, beginning with the given @index and containing up to @count successive elements of the SQL array. |
ResultSet | Array.getResultSet()
Materialize the item designated by the Array as a ResultSet that contains a row for each element of the Array. |
ResultSet | Array.getResultSet(Map map)
Materialize the item designated by the Array as a ResultSet that contains a row for each element of the Array. |
ResultSet | Array.getResultSet(long index,
int count)
Materialize the designated sub-array as a ResultSet that contains a row for each element of the sub-array. |
ResultSet | Array.getResultSet(long index,
int count,
Map map)
Materialize the designated sub-array as a ResultSet that contains a row for each element of the sub-array. |
ResultSet | PreparedStatement.executeQuery()
A prepared SQL query is executed and its ResultSet is returned. |
int | PreparedStatement.executeUpdate()
Execute a SQL INSERT, UPDATE or DELETE statement. |
void | PreparedStatement.setNull(int parameterIndex,
int sqlType)
Set a parameter to SQL NULL. Note: You must specify the parameter's SQL type. |
void | PreparedStatement.setBoolean(int parameterIndex,
boolean x)
Set a parameter to a Java boolean value. |
void | PreparedStatement.setByte(int parameterIndex,
byte x)
Set a parameter to a Java byte value. |
void | PreparedStatement.setShort(int parameterIndex,
short x)
Set a parameter to a Java short value. |
void | PreparedStatement.setInt(int parameterIndex,
int x)
Set a parameter to a Java int value. |
void | PreparedStatement.setLong(int parameterIndex,
long x)
Set a parameter to a Java long value. |
void | PreparedStatement.setFloat(int parameterIndex,
float x)
Set a parameter to a Java float value. |
void | PreparedStatement.setDouble(int parameterIndex,
double x)
Set a parameter to a Java double value. |
void | PreparedStatement.setBigDecimal(int parameterIndex,
BigDecimal x)
Set a parameter to a java.lang. |
void | PreparedStatement.setString(int parameterIndex,
String x)
Set a parameter to a Java String value. |
void | PreparedStatement.setBytes(int parameterIndex,
byte[] x)
Set a parameter to a Java array of bytes. |
void | PreparedStatement.setDate(int parameterIndex,
Date x)
Set a parameter to a java.sql. |
void | PreparedStatement.setTime(int parameterIndex,
Time x)
Set a parameter to a java.sql. |
void | PreparedStatement.setTimestamp(int parameterIndex,
Timestamp x)
Set a parameter to a java.sql. |
void | PreparedStatement.setAsciiStream(int parameterIndex,
InputStream x,
int length)
When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io. |
void | PreparedStatement.setUnicodeStream(int parameterIndex,
InputStream x,
int length)
Deprecated. |
void | PreparedStatement.setBinaryStream(int parameterIndex,
InputStream x,
int length)
When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io. |
void | PreparedStatement.clearParameters()
In general, parameter values remain in force for repeated use of a Statement. |
void | PreparedStatement.setObject(int parameterIndex,
Object x,
int targetSqlType,
int scale)
Set the value of a parameter using an object; use the java.lang equivalent objects for integral values. |
void | PreparedStatement.setObject(int parameterIndex,
Object x,
int targetSqlType)
This method is like setObject above, but assumes a scale of zero. |
void | PreparedStatement.setObject(int parameterIndex,
Object x)
Set the value of a parameter using an object; use the java.lang equivalent objects for integral values. |
boolean | PreparedStatement.execute()
Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate. |
void | PreparedStatement.addBatch()
JDBC 2.0 Add a set of parameters to the batch. |
void | PreparedStatement.setCharacterStream(int parameterIndex,
Reader reader,
int length)
JDBC 2.0 When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io. |
void | PreparedStatement.setRef(int i,
Ref x)
JDBC 2.0 Set a REF(<structured-type>) parameter. |
void | PreparedStatement.setBlob(int i,
Blob x)
JDBC 2.0 Set a BLOB parameter. |
void | PreparedStatement.setClob(int i,
Clob x)
JDBC 2.0 Set a CLOB parameter. |
void | PreparedStatement.setArray(int i,
Array x)
JDBC 2.0 Set an Array parameter. |
ResultSetMetaData | PreparedStatement.getMetaData()
The number, types and properties of a ResultSet's columns are provided by the getMetaData method. |
void | PreparedStatement.setDate(int parameterIndex,
Date x,
Calendar cal)
Set a parameter to a java.sql. |
void | PreparedStatement.setTime(int parameterIndex,
Time x,
Calendar cal)
Set a parameter to a java.sql. |
void | PreparedStatement.setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal)
Set a parameter to a java.sql. |
long | Clob.length()
The length of the Character Large Object in characters. |
String | Clob.getSubString(long pos,
int length)
Return copy of the substring of the CLOB at the requested position. |
Reader | Clob.getCharacterStream()
Get the Clob contents as a Unicode stream. |
InputStream | Clob.getAsciiStream()
Get the Clob contents as an ascii stream. |
long | Clob.position(String searchstr,
long start)
Determine the character position at which the given substring |
long | Clob.position(Clob searchstr,
long start)
Determine the character position at which the given substring |
String | Ref.getBaseTypeName()
Get the fully qualified SQL structured type name of the referenced item. |
boolean | ResultSet.next()
A ResultSet is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc. |
void | ResultSet.close()
In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release. |
boolean | ResultSet.wasNull()
A column may have the value of SQL NULL; wasNull reports whether the last column read had this special value. |
String | ResultSet.getString(int columnIndex)
Get the value of a column in the current row as a Java String. |
boolean | ResultSet.getBoolean(int columnIndex)
Get the value of a column in the current row as a Java boolean. |
byte | ResultSet.getByte(int columnIndex)
Get the value of a column in the current row as a Java byte. |
short | ResultSet.getShort(int columnIndex)
Get the value of a column in the current row as a Java short. |
int | ResultSet.getInt(int columnIndex)
Get the value of a column in the current row as a Java int. |
long | ResultSet.getLong(int columnIndex)
Get the value of a column in the current row as a Java long. |
float | ResultSet.getFloat(int columnIndex)
Get the value of a column in the current row as a Java float. |
double | ResultSet.getDouble(int columnIndex)
Get 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)
Get the value of a column in the current row as a Java byte array. |
Date | ResultSet.getDate(int columnIndex)
Get the value of a column in the current row as a java.sql. |
Time | ResultSet.getTime(int columnIndex)
Get the value of a column in the current row as a java.sql. |
Timestamp | ResultSet.getTimestamp(int columnIndex)
Get the value of a column in the current row as a java.sql. |
InputStream | ResultSet.getAsciiStream(int columnIndex)
A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream. |
InputStream | ResultSet.getUnicodeStream(int columnIndex)
Deprecated. |
InputStream | ResultSet.getBinaryStream(int columnIndex)
A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream. |
String | ResultSet.getString(String columnName)
Get the value of a column in the current row as a Java String. |
boolean | ResultSet.getBoolean(String columnName)
Get the value of a column in the current row as a Java boolean. |
byte | ResultSet.getByte(String columnName)
Get the value of a column in the current row as a Java byte. |
short | ResultSet.getShort(String columnName)
Get the value of a column in the current row as a Java short. |
int | ResultSet.getInt(String columnName)
Get the value of a column in the current row as a Java int. |
long | ResultSet.getLong(String columnName)
Get the value of a column in the current row as a Java long. |
float | ResultSet.getFloat(String columnName)
Get the value of a column in the current row as a Java float. |
double | ResultSet.getDouble(String columnName)
Get 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)
Get the value of a column in the current row as a Java byte array. |
Date | ResultSet.getDate(String columnName)
Get the value of a column in the current row as a java.sql. |
Time | ResultSet.getTime(String columnName)
Get the value of a column in the current row as a java.sql. |
Timestamp | ResultSet.getTimestamp(String columnName)
Get the value of a column in the current row as a java.sql. |
InputStream | ResultSet.getAsciiStream(String columnName)
A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream. |
InputStream | ResultSet.getUnicodeStream(String columnName)
Deprecated. |
InputStream | ResultSet.getBinaryStream(String columnName)
A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream. |
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()
Get the name of the SQL cursor used by this ResultSet. |
ResultSetMetaData | ResultSet.getMetaData()
The number, types and properties of a ResultSet's columns are provided by the getMetaData method. |
Object | ResultSet.getObject(int columnIndex)
Get the value of a column in the current row as a Java object. |
Object | ResultSet.getObject(String columnName)
Get the value of a column in the current row as a Java object. |
int | ResultSet.findColumn(String columnName)
Map a Resultset column name to a ResultSet column index. |
Reader | ResultSet.getCharacterStream(int columnIndex)
JDBC 2.0 Get the value of a column in the current row as a java.io. |
Reader | ResultSet.getCharacterStream(String columnName)
JDBC 2.0 Get the value of a column in the current row as a java.io. |
BigDecimal | ResultSet.getBigDecimal(int columnIndex)
JDBC 2.0 Get the value of a column in the current row as a java.math. |
BigDecimal | ResultSet.getBigDecimal(String columnName)
JDBC 2.0 Get the value of a column in the current row as a java.math. |
boolean | ResultSet.isBeforeFirst()
JDBC 2.0 Determine if the cursor is before the first row in the result set. |
boolean | ResultSet.isAfterLast()
JDBC 2.0 Determine if the cursor is after the last row in the result set. |
boolean | ResultSet.isFirst()
JDBC 2.0 Determine if the cursor is on the first row of the result set. |
boolean | ResultSet.isLast()
JDBC 2.0 Determine if the cursor is on the last row of the result set. |
void | ResultSet.beforeFirst()
JDBC 2.0 Moves to the front of the result set, just before the first row. |
void | ResultSet.afterLast()
JDBC 2.0 Moves to the end of the result set, just after the last row. |
boolean | ResultSet.first()
JDBC 2.0 Moves to the first row in the result set. |
boolean | ResultSet.last()
JDBC 2.0 Moves to the last row in the result set. |
int | ResultSet.getRow()
JDBC 2.0 Determine the current row number. |
boolean | ResultSet.absolute(int row)
JDBC 2.0 Move to an absolute row number in the result set. |
boolean | ResultSet.relative(int rows)
JDBC 2.0 Moves a relative number of rows, either positive or negative. |
boolean | ResultSet.previous()
JDBC 2.0 Moves to the previous row in the result set. |
void | ResultSet.setFetchDirection(int direction)
JDBC 2.0 Give a hint as to the direction in which the rows in this result set will be processed. |
int | ResultSet.getFetchDirection()
JDBC 2.0 Return the fetch direction for this result set. |
void | ResultSet.setFetchSize(int rows)
JDBC 2.0 Give 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 Return the fetch size for this result set. |
int | ResultSet.getType()
JDBC 2.0 Return the type of this result set. |
int | ResultSet.getConcurrency()
JDBC 2.0 Return the concurrency of this result set. |
boolean | ResultSet.rowUpdated()
JDBC 2.0 Determine if the current row has been updated. |
boolean | ResultSet.rowInserted()
JDBC 2.0 Determine if the current row has been inserted. |
boolean | ResultSet.rowDeleted()
JDBC 2.0 Determine if this 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 Update a column with a boolean value. |
void | ResultSet.updateByte(int columnIndex,
byte x)
JDBC 2.0 Update a column with a byte value. |
void | ResultSet.updateShort(int columnIndex,
short x)
JDBC 2.0 Update a column with a short value. |
void | ResultSet.updateInt(int columnIndex,
int x)
JDBC 2.0 Update a column with an integer value. |
void | ResultSet.updateLong(int columnIndex,
long x)
JDBC 2.0 Update a column with a long value. |
void | ResultSet.updateFloat(int columnIndex,
float x)
JDBC 2.0 Update a column with a float value. |
void | ResultSet.updateDouble(int columnIndex,
double x)
JDBC 2.0 Update a column with a Double value. |
void | ResultSet.updateBigDecimal(int columnIndex,
BigDecimal x)
JDBC 2.0 Update a column with a BigDecimal value. |
void | ResultSet.updateString(int columnIndex,
String x)
JDBC 2.0 Update a column with a String value. |
void | ResultSet.updateBytes(int columnIndex,
byte[] x)
JDBC 2.0 Update a column with a byte array value. |
void | ResultSet.updateDate(int columnIndex,
Date x)
JDBC 2.0 Update a column with a Date value. |
void | ResultSet.updateTime(int columnIndex,
Time x)
JDBC 2.0 Update a column with a Time value. |
void | ResultSet.updateTimestamp(int columnIndex,
Timestamp x)
JDBC 2.0 Update a column with a Timestamp value. |
void | ResultSet.updateAsciiStream(int columnIndex,
InputStream x,
int length)
JDBC 2.0 Update a column with an ascii stream value. |
void | ResultSet.updateBinaryStream(int columnIndex,
InputStream x,
int length)
JDBC 2.0 Update a column with a binary stream value. |
void | ResultSet.updateCharacterStream(int columnIndex,
Reader x,
int length)
JDBC 2.0 Update a column with a character stream value. |
void | ResultSet.updateObject(int columnIndex,
Object x,
int scale)
JDBC 2.0 Update a column with an Object value. |
void | ResultSet.updateObject(int columnIndex,
Object x)
JDBC 2.0 Update a column with an Object value. |
void | ResultSet.updateNull(String columnName)
JDBC 2.0 Update a column with a null value. |
void | ResultSet.updateBoolean(String columnName,
boolean x)
JDBC 2.0 Update a column with a boolean value. |
void | ResultSet.updateByte(String columnName,
byte x)
JDBC 2.0 Update a column with a byte value. |
void | ResultSet.updateShort(String columnName,
short x)
JDBC 2.0 Update a column with a short value. |
void | ResultSet.updateInt(String columnName,
int x)
JDBC 2.0 Update a column with an integer value. |
void | ResultSet.updateLong(String columnName,
long x)
JDBC 2.0 Update a column with a long value. |
void | ResultSet.updateFloat(String columnName,
float x)
JDBC 2.0 Update a column with a float value. |
void | ResultSet.updateDouble(String columnName,
double x)
JDBC 2.0 Update a column with a double value. |
void | ResultSet.updateBigDecimal(String columnName,
BigDecimal x)
JDBC 2.0 Update a column with a BigDecimal value. |
void | ResultSet.updateString(String columnName,
String x)
JDBC 2.0 Update a column with a String value. |
void | ResultSet.updateBytes(String columnName,
byte[] x)
JDBC 2.0 Update a column with a byte array value. |
void | ResultSet.updateDate(String columnName,
Date x)
JDBC 2.0 Update a column with a Date value. |
void | ResultSet.updateTime(String columnName,
Time x)
JDBC 2.0 Update a column with a Time value. |
void | ResultSet.updateTimestamp(String columnName,
Timestamp x)
JDBC 2.0 Update a column with a Timestamp value. |
void | ResultSet.updateAsciiStream(String columnName,
InputStream x,
int length)
JDBC 2.0 Update a column with an ascii stream value. |
void | ResultSet.updateBinaryStream(String columnName,
InputStream x,
int length)
JDBC 2.0 Update a column with a binary stream value. |
void | ResultSet.updateCharacterStream(String columnName,
Reader reader,
int length)
JDBC 2.0 Update a column with a character stream value. |
void | ResultSet.updateObject(String columnName,
Object x,
int scale)
JDBC 2.0 Update a column with an Object value. |
void | ResultSet.updateObject(String columnName,
Object x)
JDBC 2.0 Update a column with an Object value. |
void | ResultSet.insertRow()
JDBC 2.0 Insert the contents of the insert row into the result set and the database. |
void | ResultSet.updateRow()
JDBC 2.0 Update the underlying database with the new contents of the current row. |
void | ResultSet.deleteRow()
JDBC 2.0 Delete the current row from the result set and the underlying database. |
void | ResultSet.refreshRow()
JDBC 2.0 Refresh the value of the current row with its current value in the database. |
void | ResultSet.cancelRowUpdates()
JDBC 2.0 The cancelRowUpdates() method may be called after calling an updateXXX() method(s) and before calling updateRow() to rollback the updates made to a row. |
void | ResultSet.moveToInsertRow()
JDBC 2.0 Move to the insert row. |
void | ResultSet.moveToCurrentRow()
JDBC 2.0 Move the cursor to the remembered cursor position, usually the current row. |
Statement | ResultSet.getStatement()
JDBC 2.0 Return the Statement that produced the ResultSet. |
Object | ResultSet.getObject(int i,
Map map)
JDBC 2.0 Returns the value of column @i as a Java object. |
Ref | ResultSet.getRef(int i)
JDBC 2.0 Get a REF(<structured-type>) column. |
Blob | ResultSet.getBlob(int i)
JDBC 2.0 Get a BLOB column. |
Clob | ResultSet.getClob(int i)
JDBC 2.0 Get a CLOB column. |
Array | ResultSet.getArray(int i)
JDBC 2.0 Get an array column. |
Object | ResultSet.getObject(String colName,
Map map)
JDBC 2.0 Returns the value of column @i as a Java object. |
Ref | ResultSet.getRef(String colName)
JDBC 2.0 Get a REF(<structured-type>) column. |
Blob | ResultSet.getBlob(String colName)
JDBC 2.0 Get a BLOB column. |
Clob | ResultSet.getClob(String colName)
JDBC 2.0 Get a CLOB column. |
Array | ResultSet.getArray(String colName)
JDBC 2.0 Get an array column. |
Date | ResultSet.getDate(int columnIndex,
Calendar cal)
JDBC 2.0 Get the value of a column in the current row as a java.sql. |
Date | ResultSet.getDate(String columnName,
Calendar cal)
Get the value of a column in the current row as a java.sql. |
Time | ResultSet.getTime(int columnIndex,
Calendar cal)
Get the value of a column in the current row as a java.sql. |
Time | ResultSet.getTime(String columnName,
Calendar cal)
Get the value of a column in the current row as a java.sql. |
Timestamp | ResultSet.getTimestamp(int columnIndex,
Calendar cal)
Get the value of a column in the current row as a java.sql. |
Timestamp | ResultSet.getTimestamp(String columnName,
Calendar cal)
Get the value of a column in the current row as a java.sql. |
Connection | Driver.connect(String url,
Properties info)
Try to make a database connection to the given URL. The driver should return "null" if it realizes it is the wrong kind of driver to connect to the given URL. This will be common, as when the JDBC driver manager is asked to connect to a given URL it passes the URL to each loaded driver in turn. |
boolean | Driver.acceptsURL(String url)
Returns true if the driver thinks that it can open a connection to the given URL. Typically drivers will return true if they understand the subprotocol specified in the URL and false if they don't. |
DriverPropertyInfo[] | Driver.getPropertyInfo(String url,
Properties info)
The getPropertyInfo method is intended to allow a generic GUI tool to discover what properties it should prompt a human for in order to get enough information to connect to a database. |
static Connection | DriverManager.getConnection(String url,
Properties info)
Attempt to establish a connection to the given database URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers. |
static Connection | DriverManager.getConnection(String url,
String user,
String password)
Attempt to establish a connection to the given database URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers. |
static Connection | DriverManager.getConnection(String url)
Attempt to establish a connection to the given database URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers. |
static Driver | DriverManager.getDriver(String url)
Attempt to locate a driver that understands the given URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers. |
static void | DriverManager.registerDriver(Driver driver)
A newly loaded driver class should call registerDriver to make itself known to the DriverManager. |
static void | DriverManager.deregisterDriver(Driver driver)
Drop a Driver from the DriverManager's list. |
String | SQLInput.readString()
Read the next attribute in the stream as a Java String. |
boolean | SQLInput.readBoolean()
Read the next attribute in the stream as a Java boolean. |
byte | SQLInput.readByte()
Read the next attribute in the stream as a Java byte. |
short | SQLInput.readShort()
Read the next attribute in the stream as a Java short. |
int | SQLInput.readInt()
Read the next attribute in the stream as a Java int. |
long | SQLInput.readLong()
Read the next attribute in the stream as a Java long. |
float | SQLInput.readFloat()
Read the next attribute in the stream as a Java float. |
double | SQLInput.readDouble()
Read the next attribute in the stream as a Java double. |
BigDecimal | SQLInput.readBigDecimal()
Read the next attribute in the stream as a java.math. |
byte[] | SQLInput.readBytes()
Read the next attribute in the stream as an array of bytes. |
Date | SQLInput.readDate()
Read the next attribute in the stream as a java.sql. |
Time | SQLInput.readTime()
Read the next attribute in the stream as a java.sql. |
Timestamp | SQLInput.readTimestamp()
Read the next attribute in the stream as a java.sql. |
Reader | SQLInput.readCharacterStream()
Return the next attribute in the stream as a stream of Unicode characters. |
InputStream | SQLInput.readAsciiStream()
Return the next attribute in the stream as a stream of ASCII characters. |
InputStream | SQLInput.readBinaryStream()
Return the next attribute in the stream as a stream of uninterpreted bytes. |
Object | SQLInput.readObject()
Return the datum at the head of the stream as a Java object. |
Ref | SQLInput.readRef()
Read a REF(<structured-type>) from the stream. |
Blob | SQLInput.readBlob()
Read a BLOB from the stream. |
Clob | SQLInput.readClob()
Read a CLOB from the stream. |
Array | SQLInput.readArray()
Read an array from the stream. |
boolean | SQLInput.wasNull()
|
void | CallableStatement.registerOutParameter(int parameterIndex,
int sqlType)
Before executing a stored procedure call, you must explicitly call registerOutParameter to register the java.sql. |
void | CallableStatement.registerOutParameter(int parameterIndex,
int sqlType,
int scale)
Use this version of registerOutParameter for registering Numeric or Decimal out parameters. |
boolean | CallableStatement.wasNull()
An OUT parameter may have the value of SQL NULL; wasNull reports whether the last value read has this special value. |
String | CallableStatement.getString(int parameterIndex)
Get the value of a CHAR, VARCHAR, or LONGVARCHAR parameter as a Java String. |
boolean | CallableStatement.getBoolean(int parameterIndex)
Get the value of a BIT parameter as a Java boolean. |
byte | CallableStatement.getByte(int parameterIndex)
Get the value of a TINYINT parameter as a Java byte. |
short | CallableStatement.getShort(int parameterIndex)
Get the value of a SMALLINT parameter as a Java short. |
int | CallableStatement.getInt(int parameterIndex)
Get the value of an INTEGER parameter as a Java int. |
long | CallableStatement.getLong(int parameterIndex)
Get the value of a BIGINT parameter as a Java long. |
float | CallableStatement.getFloat(int parameterIndex)
Get the value of a FLOAT parameter as a Java float. |
double | CallableStatement.getDouble(int parameterIndex)
Get the value of a DOUBLE parameter as a Java double. |
BigDecimal | CallableStatement.getBigDecimal(int parameterIndex,
int scale)
Deprecated. |
byte[] | CallableStatement.getBytes(int parameterIndex)
Get the value of a SQL BINARY or VARBINARY parameter as a Java byte[] |
Date | CallableStatement.getDate(int parameterIndex)
Get the value of a SQL DATE parameter as a java.sql. |
Time | CallableStatement.getTime(int parameterIndex)
Get the value of a SQL TIME parameter as a java.sql. |
Timestamp | CallableStatement.getTimestamp(int parameterIndex)
Get the value of a SQL TIMESTAMP parameter as a java.sql. |
Object | CallableStatement.getObject(int parameterIndex)
Get the value of a parameter as a Java object. |
BigDecimal | CallableStatement.getBigDecimal(int parameterIndex)
JDBC 2.0 Get the value of a NUMERIC parameter as a java.math. |
Object | CallableStatement.getObject(int i,
Map map)
JDBC 2.0 Returns an object representing the value of OUT parameter @i. |
Ref | CallableStatement.getRef(int i)
JDBC 2.0 Get a REF(<structured-type>) OUT parameter. |
Blob | CallableStatement.getBlob(int i)
JDBC 2.0 Get a BLOB OUT parameter. |
Clob | CallableStatement.getClob(int i)
JDBC 2.0 Get a CLOB OUT parameter. |
Array | CallableStatement.getArray(int i)
JDBC 2.0 Get an Array OUT parameter. |
Date | CallableStatement.getDate(int parameterIndex,
Calendar cal)
Get the value of a SQL DATE parameter as a java.sql. |
Time | CallableStatement.getTime(int parameterIndex,
Calendar cal)
Get the value of a SQL TIME parameter as a java.sql. |
Timestamp | CallableStatement.getTimestamp(int parameterIndex,
Calendar cal)
Get the value of a SQL TIMESTAMP parameter as a java.sql. |
String | Struct.getSQLTypeName()
|
Object[] | Struct.getAttributes()
Produce the ordered values of the attributes of the SQL * structured type. |
Object[] | Struct.getAttributes(Map map)
Produce the ordered values of the attributes of the SQL structured type. |
Statement | Connection.createStatement()
SQL statements without parameters are normally executed using Statement objects. |
PreparedStatement | Connection.prepareStatement(String sql)
A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. |
CallableStatement | Connection.prepareCall(String sql)
A SQL stored procedure call statement is handled by creating a CallableStatement for it. |
String | Connection.nativeSQL(String sql)
A driver may convert the JDBC sql grammar into its system's native SQL grammar prior to sending it; nativeSQL returns the native form of the statement that the driver would have sent. |
void | Connection.setAutoCommit(boolean autoCommit)
If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions. |
boolean | Connection.getAutoCommit()
Get the current auto-commit state. |
void | Connection.commit()
Commit makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection. |
void | Connection.rollback()
Rollback drops all changes made since the previous commit/rollback and releases any database locks currently held by the Connection. |
void | Connection.close()
In some cases, it is desirable to immediately release a Connection's database and JDBC resources instead of waiting for them to be automatically released; the close method provides this immediate release. |
boolean | Connection.isClosed()
Tests to see if a Connection is closed. |
DatabaseMetaData | Connection.getMetaData()
A Connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, etc. |
void | Connection.setReadOnly(boolean readOnly)
You can put a 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)
A sub-space of this Connection's database may be selected by setting a catalog name. |
String | Connection.getCatalog()
Return the Connection's current catalog name. |
void | Connection.setTransactionIsolation(int level)
You can call this method to try to change the transaction isolation level using one of the TRANSACTION_* values. |
int | Connection.getTransactionIsolation()
Get this Connection's current transaction isolation mode. |
SQLWarning | Connection.getWarnings()
The first warning reported by calls on this Connection is returned. |
void | Connection.clearWarnings()
After this call, getWarnings returns null until a new warning is reported for this Connection. |
Statement | Connection.createStatement(int resultSetType,
int resultSetConcurrency)
JDBC 2.0 Same as createStatement() above, but allows the default result set type and result set concurrency type to be overridden. |
PreparedStatement | Connection.prepareStatement(String sql,
int resultSetType,
int resultSetConcurrency)
JDBC 2.0 Same as prepareStatement() above, but allows the default result set type and result set concurrency type to be overridden. |
CallableStatement | Connection.prepareCall(String sql,
int resultSetType,
int resultSetConcurrency)
JDBC 2.0 Same as prepareCall() above, but allows the default result set type and result set concurrency type to be overridden. |
Map | Connection.getTypeMap()
JDBC 2.0 * Get the type-map object associated with this connection. |
void | Connection.setTypeMap(Map map)
JDBC 2.0 * Install a type-map object as the default type-map for * this connection. |
long | Blob.length()
The length of the Binary Large OBject in bytes. |
byte[] | Blob.getBytes(long pos,
int length)
Return a copy of the contents of the BLOB at the requested position. |
InputStream | Blob.getBinaryStream()
Retrieve the entire BLOB as a stream. |
long | Blob.position(byte[] pattern,
long start)
Determine the byte position at which the given byte pattern |
long | Blob.position(Blob pattern,
long start)
Determine the byte position at which the given pattern |
ResultSet | Statement.executeQuery(String sql)
Execute a SQL statement that returns a single ResultSet. |
int | Statement.executeUpdate(String sql)
Execute a SQL INSERT, UPDATE or DELETE statement. |
void | Statement.close()
In many cases, it is desirable to immediately release a Statements's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release. |
int | Statement.getMaxFieldSize()
The maxFieldSize limit (in bytes) is the maximum amount of data returned for any column value; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR columns. |
void | Statement.setMaxFieldSize(int max)
The maxFieldSize limit (in bytes) is set to limit the size of data that can be returned for any column value; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR fields. |
int | Statement.getMaxRows()
The maxRows limit is the maximum number of rows that a ResultSet can contain. |
void | Statement.setMaxRows(int max)
The maxRows limit is set to limit the number of rows that any ResultSet can contain. |
void | Statement.setEscapeProcessing(boolean enable)
If escape scanning is on (the default), the driver will do escape substitution before sending the SQL to the database. |
int | Statement.getQueryTimeout()
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute. |
void | Statement.setQueryTimeout(int seconds)
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute. |
void | Statement.cancel()
Cancel can be used by one thread to cancel a statement that is being executed by another thread. |
SQLWarning | Statement.getWarnings()
The first warning reported by calls on this Statement is returned. |
void | Statement.clearWarnings()
After this call, getWarnings returns null until a new warning is reported for this Statement. |
void | Statement.setCursorName(String name)
setCursorname defines the SQL cursor name that will be used by subsequent Statement execute methods. |
boolean | Statement.execute(String sql)
Execute a SQL statement that may return multiple results. |
ResultSet | Statement.getResultSet()
getResultSet returns the current result as a ResultSet. |
int | Statement.getUpdateCount()
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()
getMoreResults moves to a Statement's next result. |
void | Statement.setFetchDirection(int direction)
JDBC 2.0 Give a hint as to the direction in which the rows in a result set will be processed. |
int | Statement.getFetchDirection()
JDBC 2.0 Determine the fetch direction. |
void | Statement.setFetchSize(int rows)
JDBC 2.0 Give 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 Determine the default fetch size. |
int | Statement.getResultSetConcurrency()
JDBC 2.0 Determine 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 Make the set of commands in the current batch empty. |
int[] | Statement.executeBatch()
JDBC 2.0 Submit a batch of commands to the database for execution. |
Connection | Statement.getConnection()
JDBC 2.0 Return the Connection that produced the Statement. |
void | SQLOutput.writeString(String x)
Write the next attribute to the stream as a Java String. |
void | SQLOutput.writeBoolean(boolean x)
Write the next attribute to the stream as a Java boolean. |
void | SQLOutput.writeByte(byte x)
Write the next attribute to the stream as a Java byte. |
void | SQLOutput.writeShort(short x)
Write the next attribute to the stream as a Java short. |
void | SQLOutput.writeInt(int x)
Write the next attribute to the stream as a Java int. |
void | SQLOutput.writeLong(long x)
Write the next attribute to the stream as a Java long. |
void | SQLOutput.writeFloat(float x)
Write the next attribute to the stream as a Java float. |
void | SQLOutput.writeDouble(double x)
Write the next attribute to the stream as a Java double. |
void | SQLOutput.writeBigDecimal(BigDecimal x)
Write the next attribute to the stream as a java.math. |
void | SQLOutput.writeBytes(byte[] x)
Write the next attribute to the stream as an array of bytes. |
void | SQLOutput.writeDate(Date x)
Write the next attribute to the stream as a java.sql. |
void | SQLOutput.writeTime(Time x)
Write the next attribute to the stream as a java.sql. |
void | SQLOutput.writeTimestamp(Timestamp x)
Write the next attribute to the stream as a java.sql. |
void | SQLOutput.writeCharacterStream(Reader x)
Return the next attribute to the stream as a stream of Unicode characters. |
void | SQLOutput.writeAsciiStream(InputStream x)
Return the next attribute to the stream as a stream of ASCII characters. |
void | SQLOutput.writeBinaryStream(InputStream x)
Return the next attribute to the stream as a stream of uninterpreted bytes. |
void | SQLOutput.writeObject(SQLData x)
Write to the stream the data contained in the given object. |
void | SQLOutput.writeRef(Ref x)
Write a REF(<structured-type>) to the stream. |
void | SQLOutput.writeBlob(Blob x)
Write a BLOB to the stream. |
void | SQLOutput.writeClob(Clob x)
Write a CLOB to the stream. |
void | SQLOutput.writeStruct(Struct x)
Write a structured-type to the stream. |
void | SQLOutput.writeArray(Array x)
Write 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? |
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? |
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? |
String | DatabaseMetaData.getSQLKeywords()
Get a comma separated list of all a database's SQL keywords that are NOT also SQL92 keywords. |
String | DatabaseMetaData.getNumericFunctions()
Get a comma separated list of math functions. |
String | DatabaseMetaData.getStringFunctions()
Get a comma separated list of string functions. |
String | DatabaseMetaData.getSystemFunctions()
Get a comma separated list of system functions. |
String | DatabaseMetaData.getTimeDateFunctions()
Get a comma separated list of time and date functions. |
String | DatabaseMetaData.getSearchStringEscape()
This is the string that can be used to escape '_' or '%' in the string pattern style catalog search parameters. |
String | DatabaseMetaData.getExtraNameCharacters()
Get 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? |
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? |
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? |
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? |
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? |
boolean | DatabaseMetaData.supportsMinimumSQLGrammar()
Is the ODBC Minimum SQL grammar supported? |
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? |
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? |
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? |
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? |
boolean | DatabaseMetaData.supportsSubqueriesInExists()
Are subqueries in 'exists' expressions supported? |
boolean | DatabaseMetaData.supportsSubqueriesInIns()
Are subqueries in 'in' statements supported? |
boolean | DatabaseMetaData.supportsSubqueriesInQuantifieds()
Are subqueries in quantified expressions supported? |
boolean | DatabaseMetaData.supportsCorrelatedSubqueries()
Are correlated subqueries supported? |
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? |
int | DatabaseMetaData.getMaxUserNameLength()
What's the maximum length of a user name? |
int | DatabaseMetaData.getDefaultTransactionIsolation()
What's the database's default transaction isolation level? |
boolean | DatabaseMetaData.supportsTransactions()
Are transactions supported? |
boolean | DatabaseMetaData.supportsTransactionIsolationLevel(int level)
Does the 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)
Get a description of stored procedures available in a catalog. |
ResultSet | DatabaseMetaData.getProcedureColumns(String catalog,
String schemaPattern,
String procedureNamePattern,
String columnNamePattern)
Get a description of a catalog's stored procedure parameters and result columns. |
ResultSet | DatabaseMetaData.getTables(String catalog,
String schemaPattern,
String tableNamePattern,
String[] types)
Get a description of tables available in a catalog. |
ResultSet | DatabaseMetaData.getSchemas()
Get the schema names available in this database. |
ResultSet | DatabaseMetaData.getCatalogs()
Get the catalog names available in this database. |
ResultSet | DatabaseMetaData.getTableTypes()
Get the table types available in this database. |
ResultSet | DatabaseMetaData.getColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern)
Get a description of table columns available in a catalog. |
ResultSet | DatabaseMetaData.getColumnPrivileges(String catalog,
String schema,
String table,
String columnNamePattern)
Get a description of the access rights for a table's columns. |
ResultSet | DatabaseMetaData.getTablePrivileges(String catalog,
String schemaPattern,
String tableNamePattern)
Get 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)
Get a description of a table's optimal set of columns that uniquely identifies a row. |
ResultSet | DatabaseMetaData.getVersionColumns(String catalog,
String schema,
String table)
Get 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)
Get a description of a table's primary key columns. |
ResultSet | DatabaseMetaData.getImportedKeys(String catalog,
String schema,
String table)
Get a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table). |
ResultSet | DatabaseMetaData.getExportedKeys(String catalog,
String schema,
String table)
Get 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)
Get a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.) |
ResultSet | DatabaseMetaData.getTypeInfo()
Get 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)
Get 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 Determine whether a result set's own changes visible. |
boolean | DatabaseMetaData.ownDeletesAreVisible(int type)
|
boolean | DatabaseMetaData.ownInsertsAreVisible(int type)
|
boolean | DatabaseMetaData.othersUpdatesAreVisible(int type)
JDBC 2.0 Determine whether changes made by others are visible. |
boolean | DatabaseMetaData.othersDeletesAreVisible(int type)
|
boolean | DatabaseMetaData.othersInsertsAreVisible(int type)
|
boolean | DatabaseMetaData.updatesAreDetected(int type)
JDBC 2.0 Determine whether or not a visible row update can be detected by calling ResultSet.rowUpdated(). |
boolean | DatabaseMetaData.deletesAreDetected(int type)
JDBC 2.0 Determine whether or not a visible row delete can be detected by calling ResultSet.rowDeleted(). |
boolean | DatabaseMetaData.insertsAreDetected(int type)
JDBC 2.0 Determine whether or not a visible row insert can be detected by calling ResultSet.rowInserted(). |
boolean | DatabaseMetaData.supportsBatchUpdates()
JDBC 2.0 Return true if the driver supports batch updates, else return false. |
ResultSet | DatabaseMetaData.getUDTs(String catalog,
String schemaPattern,
String typeNamePattern,
int[] types)
JDBC 2.0 Get a description of the user-defined types defined in a particular schema. |
Connection | DatabaseMetaData.getConnection()
JDBC 2.0 Return the connection that produced this metadata object. |
int | ResultSetMetaData.getColumnCount()
What's the number of columns in the ResultSet? |
boolean | ResultSetMetaData.isAutoIncrement(int column)
Is the column automatically numbered, thus read-only? |
boolean | ResultSetMetaData.isCaseSensitive(int column)
Does a column's case matter? |
boolean | ResultSetMetaData.isSearchable(int column)
Can the column be used in a where clause? |
boolean | ResultSetMetaData.isCurrency(int column)
Is the column a cash value? |
int | ResultSetMetaData.isNullable(int column)
Can you put a NULL in this column? |
boolean | ResultSetMetaData.isSigned(int column)
Is the column a signed number? |
int | ResultSetMetaData.getColumnDisplaySize(int column)
What's the column's normal max width in chars? |
String | ResultSetMetaData.getColumnLabel(int column)
What's the suggested column title for use in printouts and displays? |
String | ResultSetMetaData.getColumnName(int column)
What's a column's name? |
String | ResultSetMetaData.getSchemaName(int column)
What's a column's table's schema? |
int | ResultSetMetaData.getPrecision(int column)
What's a column's number of decimal digits? |
int | ResultSetMetaData.getScale(int column)
What's a column's number of digits to right of the decimal point? |
String | ResultSetMetaData.getTableName(int column)
What's a column's table name? |
String | ResultSetMetaData.getCatalogName(int column)
What's a column's table's catalog name? |
int | ResultSetMetaData.getColumnType(int column)
What's a column's SQL type? |
String | ResultSetMetaData.getColumnTypeName(int column)
What's a column's data source specific type name? |
boolean | ResultSetMetaData.isReadOnly(int column)
Is a column definitely not writable? |
boolean | ResultSetMetaData.isWritable(int column)
Is it possible for a write on the column to succeed? |
boolean | ResultSetMetaData.isDefinitelyWritable(int column)
Will a write on the column definitely succeed? |
String | ResultSetMetaData.getColumnClassName(int column)
JDBC 2.0 Return the fully qualified name of the Java class whose instances are manufactured if ResultSet.getObject() is called to retrieve a value from the column. |
String | SQLData.getSQLTypeName()
Called by the JDBC driver to determine the fully qualified name of the SQL user-defined type that this object represents. |
void | SQLData.readSQL(SQLInput stream,
String typeName)
Populate this object with data read from the database. |
void | SQLData.writeSQL(SQLOutput stream)
Write this object to the given SQL data stream. |
|
Java Platform 1.2 Beta 4 |
|||||||||
PREV NEXT | FRAMES NO FRAMES |