|
Oracle10g JDBC | |||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||
BOOLEAN.
Clear SQLWarning. Sets SQLWarning to null.
Physically close all the pooled connections in the cache and free all the resources.
Invoked by the ConnectionEventListener when an error occurs on a PooledConnection/LogicalConnection signaling that it is no longer good to be used and can be closed.
DATALINK.
Statement object
should be made available for retrieval.
oracle.sql.ARRAY object.
ARRAY parameter as an
Array object in the Java programming language.
java.io.InputStream object.
oracle.sql.BFILE object.
oracle.sql.BLOB object.
Array object.
NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains.
java.io.InputStream object.
BLOB parameter as a
Blob object in the Java programming language.
BIT parameter as a
boolean in the Java programming language.
TINYINT parameter as a byte
in the Java programming language.
BINARY or VARBINARY
parameter as an array of byte values in the Java
programming language.
oracle.sql.CHAR object.
oracle.sql.CLOB object.
Get the timeout for FIXED_WAIT_SCHEME
Get the connection cache Inactivity timeout
Get the connection cache TTL timeout
java.io.Reader object.
CLOB parameter as a
Clob object in the Java programming language.
ResultSet.getObject is called to retrieve a value
from the column.
Connection object
that produced this Statement object.
getJavaSqlConnection() or
getInternalConnection(), or
Use getOracleConnection() instead.
createStatementAsRefCursor flag which you can set with the
setCreateStatementAsRefCursor method.
java.sql.ResultSet object.
oracle.sql.DATE object.
DATE parameter as a
java.sql.Date object.
DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date.
DOUBLE parameter as a double
in the Java programming language.
Statement object.
Statement object.
FLOAT parameter as a float
in the Java programming language.
Statement object.
oracle.sql.INTERVALDS object.
oracle.sql.INTERVALYM object.
DatabaseMetaData.getColumns.
INTEGER parameter as an int
in the Java programming language.
BIGINT parameter as a long
in the Java programming language.
Statement object's next result, deals with
any current ResultSet object(s) according to the instructions
specified by the given flag, and returns
true if the next result is a ResultSet object.
oracle.sql.NUMBER object.
oracle.sql.OPAQUE object.
Object in the Java
programming language.
i and uses map for the custom
mapping of the parameter value.
Ref object.
oracle.sql.Datum object.
PreparedStatement.setObject.
PreparedStatement.setObject.
PreparedStatement
object for which this OracleParameterMetaData object
contains information.
PreparedStatement
object for which this ParameterMetaData object contains
information.
oracle.sql.RAW object.
oracle.sql.REF object.
oracle.sql.ROWID object.
REF(<structured-type>)
parameter as a Ref object in the Java programming language.
getTables or
getColumns of the DatabaseMetaData interface will
report the REMARKS column.
DatabaseMetaData.getTables.
Array object.
Array object and uses the given
map to map the array elements.
index and contains up to
count successive elements.
index and contains up to
count successive elements.
ResultSet
object.
ResultSet objects
generated by this Statement object.
SQLException.getSQLState
is X/Open (now known as Open Group) SQL CLI or SQL99.
Struct object represents.
Struct object represents.
oracle.sql.STRUCT object.
OracleSavepoint object represents.
Savepoint object represents.
OracleSavepoint
object represents.
Savepoint
object represents.
SMALLINT parameter as a short
in the Java programming language.
CHAR, VARCHAR,
or LONGVARCHAR parameter as a String in
the Java programming language.
oracle.sql.TIMESTAMP object.
oracle.sql.TIMESTAMPLTZ object.
oracle.sql.TIMESTAMPTZ object.
Get the timeout thread interval
TIME parameter as a
java.sql.Time object.
TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time.
TIMESTAMP parameter as a
java.sql.Timestamp object.
TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object.
DATALINK parameter as a
java.net.URL object.
DATALINK parameter as a
java.net.URL object.
ResultSet object as a java.net.URL
object in the Java programming language.
ResultSet object as a java.net.URL
object in the Java programming language.
java.io.InputStream object.
Return current SQLWarning
OraclePreparedStatement (which
extends the OracleStatement interface) and incorporates standard
JDBC callable statement functionality.java.sql.Connection.Default Constructor. Should have an explicit call to set the URL, User, Password and other DataSource details. A ConnectionPoolDataSource is created with these options from which PooledConnections can be created.
Create an OracleConnectionCacheImpl with the given ConnectionPoolDataSource from which PooledConnections have to created. In which case, url, user name, password, and other DataSource properties set on this Cache are ignored.
java.sql.Driver
interface.PreparedStatement object's parameters.
oracle.jdbc.PreparedStatement object's parameters.
java.sql.ParameterMetaData.java.sql.PreparedStatement.java.sql.Savepoint.java.sql.Statement and is the superinterface of the
OraclePreparedStatement and OracleCallableStatement
interfaces.oracle.jdbc.OracleSavepoint object from the current
transaction.
OracleSavepoint
object was set.
OracleSavepoint object that
represents it.
OracleSavepoint object that
represents it.
NULL values.
NULL values.
parameterName to the JDBC type
sqlType.
parameterName to be of JDBC type
sqlType.
Invoked by the ConnectionEventListener instance when Logical connection handles are closed signaling that the PooledConnection can be recycled into the pool for further use.
oracle.sql.ARRAY.
oracle.sql.ARRAY value.
CLOB value that this Clob object represents,
starting at position pos.
oracle.sql.BFILE value.
oracle.sql.BFILEvalue.
oracle.sql.BLOB value.
oracle.sql.BFILE value.
oracle.sql.BFILEvalue.
java.math.BigDecimal value.
oracle.sql.BINARY_FLOAT
value.
double value.
oracle.sql.BINARY_FLOAT value.
oracle.sql.BINARY_FLOAT value.
float value.
oracle.sql.BINARY_FLOAT value.
BLOB
value that this Blob object represents.
boolean value.
byte value.
BLOB value that
this Blob object represents, starting at position
pos, and returns the number of bytes written.
byte array to the
BLOB value that this Blob object represents
and returns the number of bytes written.
oracle.sql.CHAR value.
oracle.sql.CLOB value.
Set timeout for the FIXED_WAIT_SCHEME
Set the Inactivity timeout for this connection cache
Set the TTL timeout for this connection cache
Reader
object, which is the given number of characters long.
Reader
object, which is the given number of characters long.
CLOB value that this Clob object
represents, at position pos.
true, any new statements created from this
connection will be created as a REF CURSOR.
oracle.sql.DATE value.
java.sql.Date value.
java.sql.Date value,
using the given Calendar object.
Calendar object.
double value.
String and executes a
non-padded comparison with a SQL CHAR.
float value.
int value.
long value.
oracle.sql.NUMBER value.
oracle.sql.NUMBERvalue.
- setNUMBERAtName(String, NUMBER) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.NUMBER.
- setNativeXA(boolean) -
Method in class oracle.jdbc.pool.OracleXAConnectionCacheImpl
- Set the nativeXA flag to the given value.
- setNetworkProtocol(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the network protocol for the connections.
- setNull(String, int) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- JDBC 3.0
Sets the designated parameter to SQL
NULL.
- setNull(String, int, String) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- JDBC 3.0
Sets the designated parameter to SQL
NULL.
- setNull(int, int, String) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setNull(int, int) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setNull(int, int, String) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Implements JDBC 2.0 setNull for object types.
- setNull(int, int) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to SQL NULL.
- setNullAtName(String, int, String) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a SQL NULL value.
- setNullAtName(String, int) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a SQL NULL value.
- setNullAtName(String, int, String) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to Null
- setNullAtName(String, int) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to NULL.
- setOPAQUE(int, OPAQUE) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.OPAQUE value.
- setOPAQUE(int, OPAQUE) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setOPAQUE(int, OPAQUE) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Oracle specific.
- setOPAQUEAtName(String, OPAQUE) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.OPAQUEvalue.
- setOPAQUEAtName(String, OPAQUE) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.OPAQUE.
- setORAData(int, ORAData) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.ORAData value.
- setORAData(int, ORAData) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setORAData(int, ORAData) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Set the designated parameter to an oracle.sql.ORAData value.
- setORADataAtName(String, ORAData) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.ORADatavalue.
- setORADataAtName(String, ORAData) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.ORAData.
- setObject(String, Object, int, int) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- JDBC 3.0
Sets the value of the designated parameter with the given object.
- setObject(String, Object, int) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- JDBC 3.0
Sets the value of the designated parameter with the given object.
- setObject(String, Object) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- JDBC 3.0
Sets the value of the designated parameter with the given object.
- setObject(int, Object, int, int) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setObject(int, Object, int) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setObject(int, Object) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setObject(int, Object, int, int) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the value of a parameter using an object.
- setObject(int, Object, int) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the value of the designated parameter with the given object.
- setObject(int, Object) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the value of the designated parameter with the given object.
- setObject(Object) -
Method in class oracle.sql.REF
- JDBC 3.0
Sets the structured type value that this
Ref
object references to the given instance of Object.
- setObjectAtName(String, Object, int, int) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Object value.
- setObjectAtName(String, Object, int) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Object value.
- setObjectAtName(String, Object) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Object value.
- setObjectAtName(String, Object, int, int) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Java Object
- setObjectAtName(String, Object, int) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Java Object.
- setObjectAtName(String, Object) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Java Object.
- setOracleObject(int, Datum) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.Datum value.
- setOracleObject(int, Datum) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setOracleObject(int, Datum) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Oracle specific.
- setOracleObjectAtName(String, Datum) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.Datumvalue.
- setOracleObjectAtName(String, Datum) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.Datum.
- setParameters(Object[]) -
Method in class oracle.jdbc.driver.OracleSQLException
- Set Oracle error message parameters.
- setPassword(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the password with which connections have to be obtained.
- setPlsqlIndexTable(int, Object, int, int, int, int) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds a PL/SQL index-by table parameter in the IN parameter mode.
- setPlsqlIndexTable(int, Object, int, int, int, int) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setPlsqlIndexTable(int, Object, int, int, int, int) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Oracle OCI driver specific.
- setPlsqlIndexTableAtName(String, Object, int, int, int, int) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Java int value.
- setPlsqlWarnings(String) -
Method in interface oracle.jdbc.OracleConnection
- Enable/Disable PLSQL Compiler Warnings
- setPlsqlWarnings(String) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setPoolConfig(Properties) -
Method in class oracle.jdbc.pool.OracleOCIConnectionPool
-
- setPortNumber(int) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the port number where a server is listening for requests.
- setPrivateTrace(boolean) -
Static method in class oracle.jdbc.driver.OracleLog
- Deprecated. when using jdk 1.4. Use java.util.logging instead.
// _end_m4_ifJDK14
- setProperties(Hashtable) -
Method in class oracle.jdbc.pool.OraclePooledConnection
-
- setQueryTimeout(int) -
Method in class oracle.jdbc.driver.OracleStatement
- The queryTimeout limit is the number of seconds the driver will
wait for a Statement to execute.
- setRAW(int, RAW) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.RAW value.
- setRAW(int, RAW) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setRAW(int, RAW) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Oracle specific.
- setRAWAtName(String, RAW) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.RAWvalue.
- setRAWAtName(String, RAW) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.RAW.
- setREF(int, REF) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.REF value.
- setREF(int, REF) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setREF(int, REF) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Oracle specific.
- setREFAtName(String, REF) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.REFvalue.
- setREFAtName(String, REF) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.REF.
- setROWID(int, ROWID) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.ROWID value.
- setROWID(int, ROWID) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setROWID(int, ROWID) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Oracle specific.
- setROWIDAtName(String, ROWID) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.ROWIDvalue.
- setROWIDAtName(String, ROWID) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a oracle.sql.ROWID.
- setReadOnly(boolean) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setRef(int, Ref) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setRef(int, Ref) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- JDBC 2.0
Sets a Ref(<structured-type>) parameter.
- setRefAtName(String, Ref) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Ref value.
- setRefAtName(String, Ref) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Ref.
- setRefType(int, REF) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.REF value.
- setRefType(int, REF) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setRefType(int, REF) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Oracle specific.
- setRefTypeAtName(String, REF) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.REFvalue.
- setRefTypeAtName(String, REF) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.REF value.
- setRemarksReporting(boolean) -
Method in interface oracle.jdbc.OracleConnection
- Turns on or off the reporting of the REMARKS columns by the
getTables and getColumns calls of the
DatabaseMetaData interface.
- setRemarksReporting(boolean) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setRestrictGetTables(boolean) -
Method in interface oracle.jdbc.OracleConnection
- Turns on or off the restriction of the returned data in
DatabaseMetaData.getTables.
- setRestrictGetTables(boolean) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setResultSetCache(OracleResultSetCache) -
Method in interface oracle.jdbc.OracleStatement
- Lets you use your own client-side cache implementation for scrollable
result sets.
- setResultSetCache(OracleResultSetCache) -
Method in class oracle.jdbc.driver.OracleStatement
- Oracle Extenstion
Override the default result set cache.
- setResultSetCache(OracleResultSetCache) -
Method in class oracle.jdbc.driver.OracleStatement
- Override the default result set cache.
- setRowPrefetch(int) -
Method in interface oracle.jdbc.OracleStatement
- Sets the value of row prefetch for all result sets created from this
statement.
- setRowPrefetch(int) -
Method in class oracle.jdbc.driver.OracleStatement
- setRowPrefetch allows the user to set the row prefetch value
for all result sets created from this statement.
- setSTRUCT(int, STRUCT) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.STRUCT value.
- setSTRUCT(int, STRUCT) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setSTRUCT(int, STRUCT) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Oracle specific.
- setSTRUCTAtName(String, STRUCT) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.STRUCTvalue.
- setSTRUCTAtName(String, STRUCT) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.STRUCT.
- setSavepoint() -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setSavepoint(String) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setServerName(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the name of the Server on which database is running.
- setServiceName(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the service_name of a database on a server.
- setSessionTimeZone(String) -
Method in interface oracle.jdbc.OracleConnection
- Set the session time zone.
- setSessionTimeZone(String) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setShareBytes(byte[]) -
Method in class oracle.sql.Datum
- Sets datum value using a byte array.
- setShort(String, short) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- JDBC 3.0
Sets the designated parameter to the given Java
short value.
- setShort(int, short) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setShort(int, short) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Java short value.
- setShortAtName(String, short) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Short value.
- setShortAtName(String, short) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Java short value.
- setStatementCacheSize(int) -
Method in interface oracle.jdbc.OracleConnection
- setStatementCacheSize
Specifies the size of the size of the application cache (which will be
used by both implicit and explicit caching).
- setStatementCacheSize(int) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setStatementCacheSize(int) -
Method in class oracle.jdbc.pool.OraclePooledConnection
- setStatementCacheSize
Specifies the size of the size of the application cache (which will be
used by both implicit and explicit caching).
- setStmtCacheSize(int) -
Method in interface oracle.jdbc.OracleConnection
- Deprecated. Use setStatementCacheSize() instead.
- setStmtCacheSize(int, boolean) -
Method in interface oracle.jdbc.OracleConnection
- Deprecated. Use setStatementCacheSize() instead.
- setStmtCacheSize(int) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setStmtCacheSize(int, boolean) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setStmtCacheSize(int, boolean) -
Method in class oracle.jdbc.driver.OracleOCIConnection
-
- setStmtCacheSize(int) -
Method in class oracle.jdbc.pool.OracleConnectionCacheImpl
- Deprecated. ... Use JDBC Implicit Connection Caching instead.
Set the statement cache size. Default is 0.
You cannot set this for logicalhandles obtained
from PooledConnections.
If more than size cursors are already
cached than they will be closed. By default the
meta data of the cursor will be saved. Only
data and the state will be cleared. You need to call
this first to enable either type of Statement
caching. When both types of Statement caching are
enabled, the size is the total number
of cursors cached for both the schemes together.
- setStmtCacheSize(int, boolean) -
Method in class oracle.jdbc.pool.OracleConnectionCacheImpl
- Deprecated. ... Use JDBC Implicit Connection Caching instead.
Set the statement cache size. Default is 0.
You cannot set this for logicalhandles obtained
from PooledConnections.
If more than size cursors are already
cached than they will be closed. By default, the
meta data of the cursor will be saved. But if
clearMetaData is set to true, even that will be cleared.
You need to call this first to enable either type of Statement
caching. When both types of Statement caching are
enabled, the size is the total number
of cursors cached for both the schemes together.
- setStmtCacheSize(int) -
Method in class oracle.jdbc.pool.OracleOCIConnectionPool
- Set the statement cache size.
- setStmtCacheSize(int, boolean) -
Method in class oracle.jdbc.pool.OracleOCIConnectionPool
- Set the statement cache size.
- setStmtCacheSize(int) -
Method in class oracle.jdbc.pool.OraclePooledConnection
- Deprecated.
- setStmtCacheSize(int, boolean) -
Method in class oracle.jdbc.pool.OraclePooledConnection
- Deprecated.
- setString(String, String) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- JDBC 3.0
Sets the designated parameter to the given Java
String value.
- setString(int, String) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setString(int, String) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Java String value.
- setString(long, String) -
Method in class oracle.sql.CLOB
- JDBC 3.0
Writes the given Java
String to the CLOB
value that this Clob object designates at the position
pos.
- setString(long, String, int, int) -
Method in class oracle.sql.CLOB
- JDBC 3.0
Writes
len characters of str, starting
at character offset, to the CLOB value
that this Clob represents.
- setStringAtName(String, String) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java String value.
- setStringAtName(String, String) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Java String value.
- setStringForClob(String, String) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to the given Java
String value.
- setStringForClob(int, String) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java String value.
- setStringForClob(String, String) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- Sets the designated parameter to the given Java
String value.
- setStringForClob(int, String) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Java String value.
- setStringForClobAtName(String, String) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java String value.
- setStringForClobAtName(String, String) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Java String value.
- setStructDescriptor(int, StructDescriptor) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the bind type of designated parameter from an oracle.sql.StructDescriptor.
- setStructDescriptor(int, StructDescriptor) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setStructDescriptor(int, StructDescriptor) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Oracle specific.
- setStructDescriptorAtName(String, StructDescriptor) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.StructDescriptor value.
- setStructDescriptorAtName(String, StructDescriptor) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the bind type of the designated parameter from an oracle.sql.StructDescriptor.
- setTIMESTAMP(int, TIMESTAMP) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to an oracle.sql.TIMESTAMP value.
- setTIMESTAMP(int, TIMESTAMP) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setTIMESTAMP(int, TIMESTAMP) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.TIMESTAMP value.
- setTIMESTAMPAtName(String, TIMESTAMP) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.TIMESTAMP value.
- setTIMESTAMPAtName(String, TIMESTAMP) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.TIMESTAMP
- setTIMESTAMPLTZ(int, TIMESTAMPLTZ) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to an
oracle.sql.TIMESTAMPLTZ
value.
- setTIMESTAMPLTZ(int, TIMESTAMPLTZ) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setTIMESTAMPLTZ(int, TIMESTAMPLTZ) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.TIMESTAMPLTZ value.
- setTIMESTAMPLTZAtName(String, TIMESTAMPLTZ) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.TIMESTAMPLTZ value.
- setTIMESTAMPLTZAtName(String, TIMESTAMPLTZ) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.TIMESTAMPLTZ.
- setTIMESTAMPTZ(int, TIMESTAMPTZ) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to an
oracle.sql.TIMESTAMPTZ value.
- setTIMESTAMPTZ(int, TIMESTAMPTZ) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setTIMESTAMPTZ(int, TIMESTAMPTZ) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.TIMESTAMPTZ value.
- setTIMESTAMPTZAtName(String, TIMESTAMPTZ) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.TIMESTAMPTZ value.
- setTIMESTAMPTZAtName(String, TIMESTAMPTZ) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to an oracle.sql.TIMESTAMPTZ.
- setTNSEntryName(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the TNS entry name.
- setThreadWakeUpInterval(long) -
Method in class oracle.jdbc.pool.OracleConnectionCacheImpl
- Deprecated. ... Use JDBC Implicit Connection Caching instead.
Set the interval for connection cache timeout thread
- setTime(String, Time) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- JDBC 3.0
Sets the designated parameter to the given
java.sql.Time value.
- setTime(String, Time, Calendar) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- JDBC 3.0
Sets the designated parameter to the given
java.sql.Time value,
using the given Calendar object.
- setTime(int, Time) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setTime(int, Time, Calendar) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setTime(int, Time) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a java.sql.Time value.
- setTime(int, Time, Calendar) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- JDBC 2.0
Sets the designated parameter to a java.sql.Time value,
using the given
Calendar object.
- setTimeAtName(String, Time) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Time value.
- setTimeAtName(String, Time) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Java Time value.
- setTimestamp(String, Timestamp) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- JDBC 3.0
Sets the designated parameter to the given
java.sql.Timestamp value.
- setTimestamp(String, Timestamp, Calendar) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- JDBC 3.0
Sets the designated parameter to the given
java.sql.Timestamp value,
using the given Calendar object.
- setTimestamp(int, Timestamp) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setTimestamp(int, Timestamp, Calendar) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setTimestamp(int, Timestamp) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a java.sql.Timestamp value.
- setTimestamp(int, Timestamp, Calendar) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- JDBC 2.0
Sets the designated parameter to a java.sql.Timestamp value,
using the given
Calendar object.
- setTimestampAtName(String, Timestamp) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Timestamp value.
- setTimestampAtName(String, Timestamp) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to a Java Timestamp value.
- setTrace(boolean) -
Static method in class oracle.jdbc.driver.OracleLog
- Set the tracing enable variable.
- setTransactionIsolation(int) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setTransactionTimeout(int) -
Method in class oracle.jdbc.xa.OracleXAResource
- Set the current transaction timeout value for this XAResource instance.
- setTypeMap(Map) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setURL(String, URL) -
Method in class oracle.jdbc.driver.OracleCallableStatement
- JDBC 3.0
Sets the designated parameter to the given
java.net.URL object.
- setURL(int, URL) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setURL(int, URL) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- JDBC 3.0
Sets the designated parameter to the given
java.net.URL value.
- setURL(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the URL from which connections have to be obtained.
- setURLAtName(String, URL) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java URL value.
- setURLAtName(String, URL) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Oracle extension
Sets the designated parameter to a java.net.URL value.
- setUnicodeStream(int, InputStream, int) -
Method in class oracle.jdbc.driver.OracleCallableStatement
-
- setUnicodeStream(int, InputStream, int) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Deprecated.
- setUnicodeStreamAtName(String, InputStream, int) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java UnicodeStream value.
- setUnicodeStreamAtName(String, InputStream, int) -
Method in class oracle.jdbc.driver.OraclePreparedStatement
- Sets the designated parameter to the value in a stream.
- setUser(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the user name with which connections have to be obtained.
- setUsingXAFlag(boolean) -
Method in interface oracle.jdbc.OracleConnection
- Deprecated.
- setUsingXAFlag(boolean) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setValue(Object) -
Method in class oracle.sql.REF
- Oracle extension.
- setWrapper(OracleConnection) -
Method in interface oracle.jdbc.OracleConnection
- Set the wrapping object
- setWrapper(OracleConnection) -
Method in class oracle.jdbc.OracleConnectionWrapper
- Set a connection wrapper as the wrapper of this connection.
- setXAErrorFlag(boolean) -
Method in interface oracle.jdbc.OracleConnection
- Deprecated.
- setXAErrorFlag(boolean) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setupFromSystemProperties() -
Static method in class oracle.jdbc.driver.OracleLog
- Deprecated. when using jdk 1.4. Use java.util.logging instead.
// _end_m4_ifJDK14
- shareBytes() -
Method in class oracle.sql.Datum
- Retrieve the data bytes.
- shift(int) -
Method in class oracle.sql.NUMBER
- Returns a new NUMBER object initialized the NUMBER value shifted digits
decimal places.
- shortValue() -
Method in class oracle.sql.NUMBER
- Calls toShort to convert internal Oracle Number to a Java short.
- shutdown(int) -
Method in interface oracle.jdbc.OracleConnection
- Deprecated. This method will be removed in a future version.
- shutdown(int) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- sign() -
Method in class oracle.sql.NUMBER
- Returns -1 if the sign of NUMBER is negative, 0 if NUMBER is 0, and > 0
if NUMBER is positive.
- sin() -
Method in class oracle.sql.NUMBER
- Returns a new NUMBER object initialized to the sine of the NUMBER.
- sinh() -
Method in class oracle.sql.NUMBER
- Returns a new NUMBER object initialized to the hyperbolic sine of NUMBER.
- slash_character -
Static variable in class oracle.jdbc.driver.OracleDriver
-
- sql_exception_string -
Static variable in class oracle.jdbc.pool.OraclePooledConnection
-
- sqljLogger -
Static variable in class oracle.jdbc.driver.OracleLog
-
- sqroot() -
Method in class oracle.sql.NUMBER
- Returns a new NUMBER object initialized to the square root of NUMBER.
- start(Xid, int) -
Method in class oracle.jdbc.xa.OracleXAResource
-
- start(Xid, int) -
Method in class oracle.jdbc.xa.client.OracleXAHeteroResource
- Starts work on behalf of a transaction branch.
- start(Xid, int) -
Method in class oracle.jdbc.xa.client.OracleXAResource
-
- startLogging() -
Static method in class oracle.jdbc.driver.OracleLog
- Deprecated. when using jdk 1.4. Use java.util.logging instead.
// _end_m4_ifJDK14
- startup(String, int) -
Method in interface oracle.jdbc.OracleConnection
- Deprecated. This method will be removed in a future version.
- startup(String, int) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- statement_cache_size -
Static variable in class oracle.jdbc.pool.OraclePooledConnection
-
- stopLogging() -
Static method in class oracle.jdbc.driver.OracleLog
- Deprecated. when using jdk 1.4. Use java.util.logging instead.
// _end_m4_ifJDK14
- storesLowerCaseIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in lower case?
- storesLowerCaseQuotedIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in lower case?
- storesMixedCaseIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in mixed case?
- storesMixedCaseQuotedIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in mixed case?
- storesUpperCaseIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in upper case?
- storesUpperCaseQuotedIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in upper case?
- string32UTF8Length(String) -
Static method in class oracle.sql.CharacterSet
- Returns the number of bytes in the UTF-8 representation of a String
- stringToAL16UTF16Bytes(String) -
Static method in class oracle.sql.CharacterSet
- Convert a String to an array of bytes this function will allocate the
bytes array
- stringToAL16UTF16LEBytes(String) -
Static method in class oracle.sql.CharacterSet
- Convert a String to an array of bytes this function will allocate the
bytes array
- stringToAL32UTF8(String) -
Static method in class oracle.sql.CharacterSet
-
- stringToASCII(String) -
Static method in class oracle.sql.CharacterSet
- convert a String to a byte array in ascii.
- stringToAsciiBytes(String) -
Static method in class oracle.jdbc.driver.DBConversion
- Convert string into its Ascii byte array representation.
- stringToDriverCharBytes(String, short) -
Static method in class oracle.jdbc.driver.DBConversion
- Convert string into a byte array representing characters in one of
the Driver character sets.
- stringToUTF(String) -
Static method in class oracle.sql.CharacterSet
- Convert the str to a byte array that in UTF8 representation.
- stringUTFLength(String) -
Static method in class oracle.sql.CharacterSet
- Returns the number of bytes in the UTF16 representation of a String
- stringValue() -
Method in class oracle.sql.BINARY_DOUBLE
- Convert this data object into a String.
- stringValue() -
Method in class oracle.sql.BINARY_FLOAT
- Convert this data object into a String.
- stringValue() -
Method in class oracle.sql.CHAR
- Convert this data object into a String.
- stringValue() -
Method in class oracle.sql.DATE
- Calls toString to convert internal Oracle Date to a Java String.
- stringValue() -
Method in class oracle.sql.Datum
- Convert to a String representation of the datum object
- stringValue() -
Method in class oracle.sql.NUMBER
- Calls toString to convert internal Oracle Number to a Java String.
- stringValue() -
Method in class oracle.sql.RAW
- Convert this data object into a String.
- stringValue() -
Method in class oracle.sql.ROWID
- Convert this data object into a String.
- stringValue() -
Method in class oracle.sql.TIMESTAMP
- Calls toString to convert internal Oracle TIMESTAMP to a Java String.
- stringValue(Connection) -
Method in class oracle.sql.TIMESTAMPLTZ
- Calls toString(Connection, byte[]) to convert internal Oracle
TIMESTAMPLTZ to a Java String.
- stringValue(Connection, Calendar) -
Method in class oracle.sql.TIMESTAMPLTZ
- Calls toString(Connection, byte[], Calendar) to convert internal Oracle
TIMESTAMPLTZ to a Java String.
- stringValue(Connection) -
Method in class oracle.sql.TIMESTAMPTZ
- Calls toString to convert internal Oracle TIMESTAMPTZ to a Java String.
- sub(NUMBER) -
Method in class oracle.sql.NUMBER
- Returns a new NUMBER object initialized to the difference of NUMBER and n.
- supportsANSI92EntryLevelSQL() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the ANSI92 entry level SQL grammar supported?
All JDBC compliant drivers must return true.
- supportsANSI92FullSQL() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the ANSI92 full SQL grammar supported?
- supportsANSI92IntermediateSQL() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the ANSI92 intermediate SQL grammar supported?
- supportsAlterTableWithAddColumn() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is "ALTER TABLE" with add column supported?
- supportsAlterTableWithDropColumn() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is "ALTER TABLE" with drop column supported?
- supportsBatchUpdates() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Implements JDBC 2.0 DatabaseMetaData::supportBatchUpdates.
- supportsCatalogsInDataManipulation() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a catalog name be used in a data manipulation statement?
- supportsCatalogsInIndexDefinitions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a catalog name be used in a index definition statement?
- supportsCatalogsInPrivilegeDefinitions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a catalog name be used in a privilege definition statement?
- supportsCatalogsInProcedureCalls() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a catalog name be used in a procedure call statement?
- supportsCatalogsInTableDefinitions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a catalog name be used in a table definition statement?
- supportsColumnAliasing() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is column aliasing supported?
- supportsConvert() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the CONVERT function between SQL types supported?
- supportsConvert(int, int) -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is CONVERT between the given SQL types supported?
- supportsCoreSQLGrammar() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the ODBC Core SQL grammar supported?
- supportsCorrelatedSubqueries() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are correlated subqueries supported?
A JDBC compliant driver always returns true.
- supportsDataDefinitionAndDataManipulationTransactions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are both data definition and data manipulation statements
within a transaction supported?
- supportsDataManipulationTransactionsOnly() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are only data manipulation statements within a transaction
supported?
- supportsDifferentTableCorrelationNames() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- If table correlation names are supported, are they restricted
to be different from the names of the tables?
- supportsExpressionsInOrderBy() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are expressions in "ORDER BY" lists supported?
- supportsExtendedSQLGrammar() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the ODBC Extended SQL grammar supported?
- supportsFullOuterJoins() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are full nested outer joins supported?
- supportsGetGeneratedKeys() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- JDBC 3.0
Retrieves whether auto-generated keys can be retrieved after
a statement has been executed.
- supportsGroupBy() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is some form of "GROUP BY" clause supported?
- supportsGroupByBeyondSelect() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a "GROUP BY" clause add columns not in the SELECT
provided it specifies all the columns in the SELECT?
- supportsGroupByUnrelated() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a "GROUP BY" clause use columns not in the SELECT?
- supportsIntegrityEnhancementFacility() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the SQL Integrity Enhancement Facility supported?
- supportsLikeEscapeClause() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the escape character in "LIKE" clauses supported?
A JDBC compliant driver always returns true.
- supportsLimitedOuterJoins() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is there limited support for outer joins? (This will be true
if supportFullOuterJoins is true.)
- supportsMinimumSQLGrammar() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the ODBC Minimum SQL grammar supported?
All JDBC compliant drivers must return true.
- supportsMixedCaseIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case unquoted SQL identifiers as
case sensitive and as a result store them in mixed case?
A JDBC compliant driver will always return false.
- supportsMixedCaseQuotedIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case quoted SQL identifiers as
case sensitive and as a result store them in mixed case?
A JDBC compliant driver will always return false.
- supportsMultipleOpenResults() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- JDBC 3.0
Retrieves whether it is possible to have multiple
ResultSet objects
returned from a CallableStatement object
simultaneously.
- supportsMultipleResultSets() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are multiple ResultSets from a single execute supported?
- supportsMultipleTransactions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can we have multiple transactions open at once (on different
connections)?
- supportsNamedParameters() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- JDBC 3.0
Retrieves whether this database supports named parameters to callable
statements.
- supportsNonNullableColumns() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can columns be defined as non-nullable?
A JDBC compliant driver always returns true.
- supportsOpenCursorsAcrossCommit() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can cursors remain open across commits?
- supportsOpenCursorsAcrossRollback() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can cursors remain open across rollbacks?
- supportsOpenStatementsAcrossCommit() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can statements remain open across commits?
- supportsOpenStatementsAcrossRollback() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can statements remain open across rollbacks?
- supportsOrderByUnrelated() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can an "ORDER BY" clause use columns not in the SELECT?
- supportsOuterJoins() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is some form of outer join supported?
- supportsPositionedDelete() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is positioned DELETE supported?
NOTE: Though Oracle supports positional delete through the use of ROWID
positional delete as specified by SQLJ92 standard is not supported
which is being followed by JDBC 2.1 API Spec.
- supportsPositionedUpdate() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is positioned UPDATE supported?
NOTE: Though Oracle supports positional updates through the use of ROWID
positional updates as specified by SQLJ92 standard is not supported
which is being followed by JDBC 2.1 API Spec.
- supportsResultSetConcurrency(int, int) -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Implements JDBC 2.0 DatabaseMetaData.supportsResultSetConcurrency.
- supportsResultSetHoldability(int) -
Method in class oracle.jdbc.OracleDatabaseMetaData
- JDBC 3.0
Retrieves whether this database supports the given result set holdability.
- supportsResultSetType(int) -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Implements JDBC 2.0 DatabaseMetaData.supportsResultSetType.
- supportsSavepoints() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- JDBC 3.0
Retrieves whether this database supports savepoints.
- supportsSchemasInDataManipulation() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a schema name be used in a data manipulation statement?
- supportsSchemasInIndexDefinitions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a schema name be used in an index definition statement?
- supportsSchemasInPrivilegeDefinitions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a schema name be used in a privilege definition statement?
- supportsSchemasInProcedureCalls() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a schema name be used in a procedure call statement?
- supportsSchemasInTableDefinitions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a schema name be used in a table definition statement?
- supportsSelectForUpdate() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is SELECT for UPDATE supported?
- supportsStatementPooling() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- JDBC 3.0
- supportsStoredProcedures() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are stored procedure calls using the stored procedure escape
syntax supported?
- supportsSubqueriesInComparisons() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are subqueries in comparison expressions supported?
A JDBC compliant driver always returns true.
- supportsSubqueriesInExists() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are subqueries in exists expressions supported?
A JDBC compliant driver always returns true.
- supportsSubqueriesInIns() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are subqueries in "in" statements supported?
A JDBC compliant driver always returns true.
- supportsSubqueriesInQuantifieds() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are subqueries in quantified expressions supported?
A JDBC compliant driver always returns true.
- supportsTableCorrelationNames() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are table correlation names supported?
A JDBC compliant driver always returns true.
- supportsTransactionIsolationLevel(int) -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database support the given transaction isolation level?
- supportsTransactions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are transactions supported? If not, commit is a noop and the
isolation level is TRANSACTION_NONE.
- supportsUnion() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is SQL UNION supported?
- supportsUnionAll() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is SQL UNION ALL supported?
- synonyms_string -
Static variable in class oracle.jdbc.driver.OracleDriver
- Deprecated. use include_synonyms_string
BLOB value that this Blob
object represents to be len bytes in length.
CLOB value that this Clob
designates to have a length of len
characters.
|
Oracle10g JDBC | |||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||