|
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.BFILE
value.
oracle.sql.BLOB
value.
oracle.sql.BFILE
value.
oracle.sql.BFILE
value.
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.OPAQUE
value.
- 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.ORAData
value.
- 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.Datum
value.
- 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.RAW
value.
- 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.REF
value.
- 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.ROWID
value.
- 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.REF
value.
- 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.STRUCT
value.
- 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 |