|
Oracle Database JDBC Java API Reference 11g Release 2 E13995-03 |
||||||||
PREV NEXT | FRAMES NO FRAMES |
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z _
BOOLEAN
.Close DataSource API. This removes the associated Connection Cache and frees resources. This must be the last method to invoke, after the user is finished using a cache enabled DataSource.
connection.commit();
.Datum
.DATALINK
.oracle.sql.ARRAY
object.java.io.InputStream
object.OracleResultSet
object.ResultSet
.Array
object.oracle.sql.BFILE
object.oracle.sql.BFILE
object.java.io.InputStream
object.java.io.InputStream
object.oracle.sql.BLOB
object.oracle.sql.CHAR
object.java.io.Reader
object.oracle.sql.CLOB
object.Attempt to obtain a database connection from the Implicit Connection Cache using Connection Attributes
Attempt to obtain a database connection from the Implicit Connection Cache using user, passwd and Connection Attributes
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.DatabaseMetaData.getColumns
.oracle.sql.INTERVALDS
object.oracle.sql.INTERVALYM
object.oracle.sql.NUMBER
object.OracleData
, which is returned by the factory's "create" methodRef
object.Return the ONS configuration string that is used for remote ONS subscription, in the form specified in setONSConfiguration(String). This is used by Fast Connection Failover and Runtime Load Balancing.
oracle.sql.OPAQUE
object.oracle.sql.Datum
object.EVENT_TYPE_QUERYCHANGE
) kind of events, this method returns the description of the changes for each query which result has changed.oracle.sql.RAW
object.oracle.sql.REF
object.registerAQNotification
method.getRegId()
instead.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.oracle.sql.ROWID
object.SQLException.getSQLState
is X/Open (now known as Open Group) SQL CLI or SQL99.Struct
object represents.Struct
object represents.Struct
object represents.oracle.sql.STRUCT
object.EVENT_TYPE_OBJCHANGE
) kind of events, this method returns the description of the changes for each table that was changed.oracle.sql.TIMESTAMP
object.oracle.sql.TIMESTAMPLTZ
object.oracle.sql.TIMESTAMPTZ
object.java.io.InputStream
object.java.io.InputStream
object.true
if this is a SecureFile (LOBs with the STORE AS SECUREFILE option, which were introduced in Oracle Database 11g Release 1).true
if this is a SecureFile (LOBs with the STORE AS SECUREFILE option, which were introduced in Oracle Database 11g Release 1).true
if this is a SecureFile (LOBs with the STORE AS SECUREFILE option, which were introduced in Oracle Database 11g Release 1).true
if this is a SecureFile (LOBs with the STORE AS SECUREFILE option, which were introduced in Oracle Database 11g Release 1).oracle.jdbc
.OraclePreparedStatement
(which extends the OracleStatement
interface) and incorporates standard JDBC callable statement functionality.java.sql.Connection
.java.sql.Driver
interface.PreparedStatement
object's parameters.java.sql.ParameterMetaData
.java.sql.PreparedStatement
.OracleSavepoint
object from the current transaction.OracleSavepoint
object was set.java.sql.Savepoint
.OracleSavepoint
object that represents it.OracleSavepoint
object that represents it.java.sql.Statement
and is the superinterface of the OraclePreparedStatement
and OracleCallableStatement
interfaces.java.sql.Array
value.oracle.sql.ARRAY
value.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.BFILE
value.oracle.sql.BFILE
value.oracle.sql.BFILE
value.oracle.sql.BFILE
value.java.math.BigDecimal
value.oracle.sql.BINARY_FLOAT
value.oracle.sql.BINARY_FLOAT
value.oracle.sql.BINARY_FLOAT
value.float
value.BLOB
value that this Blob
object represents.oracle.sql.BLOB
value.java.sql.Blob
value.oracle.sql.BLOB
value.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.byte[]
value.oracle.sql.CHAR
value.oracle.sql.CHAR
value.Reader
object, which is the given number of characters long.CLOB
value that this Clob
object represents, at position pos
.oracle.sql.CLOB
value.java.sql.Clob
value.oracle.sql.CLOB
value.Setter method to set one or more Implicit Connection Cache properties. If a null value is set, default values will take effect. Below are the list of properties supported. These are the keys (case sensitive) to be used when setting their appropriate values.
Setter method to enable Implicit Connection Caching
true
, any new statements created from this connection will be created as a REF CURSOR
.oracle.sql.CustomDatum
value.oracle.sql.DATE
value.java.sql.Date
value.java.sql.Date
value, using the given Calendar
object.oracle.sql.DATE
value.double
value.String
See the javadoc for the setFixedChar(int, String) method in OraclePreparedStatement.String
and executes a non-padded comparison with a SQL CHAR.float
value.int
value.oracle.sql.INTERVALDS
value.oracle.sql.INTERVALYM
value.long
value.NULL
.NULL
.oracle.sql.NUMBER
value.oracle.sql.NUMBER
value.oracle.sql.NUMBER
value.Ref
object references to the given instance of Object
.Set the configuration string used for remote ONS subscription. The parameter string closely resembles the content of the ONS configuration file "ons.config", and contains a list of "<name>=<value>" pairs separated by newline character '\n', where <name> can be one of "nodes", "walletfile", or "walletpassword". The parameter string should at least specify the ONS configuration attribute "nodes", as a list of host:port pairs separated by comma ','. SSL would be used when the "walletfile" attribute is specified as an Oracle wallet file.
An example ONS configuration string:
"nodes=host1:4200,host2:4200\nwalletfile=wfile\nwalletpassword=wpwd"
This is used primarily by Fast Connection Failover and Runtime Load Balancing.
oracle.sql.OPAQUE
value.oracle.sql.OPAQUE
value.oracle.sql.OPAQUE
value.oracle.sql.Datum
value.oracle.sql.Datum
value.oracle.sql.Datum
value.oracle.sql.ORAData
value.oracle.sql.ORAData
value.oracle.sql.ORAData
value.oracle.sql.RAW
value.oracle.sql.RAW
value.oracle.sql.RAW
value.jdbc.sql.Ref
value.oracle.sql.REF
value.oracle.sql.REF
value.oracle.sql.REF
value.oracle.sql.REF
value.oracle.sql.REF
value.oracle.sql.REF
value.getTables
and getColumns
calls of the DatabaseMetaData
interface.DatabaseMetaData.getTables.
oracle.sql.ROWID
value.oracle.sql.ROWID
value.oracle.sql.ROWID
value.short
value.String
value.String
to the CLOB
value that this Clob
object designates at the position pos
.len
characters of str
, starting at character offset
, to the CLOB
value that this Clob
represents.String
value.oracle.sql.STRUCT
value.oracle.sql.STRUCT
value.oracle.sql.STRUCT
value.oracle.sql.StructDescriptor
value.java.sql.Time
value.java.sql.Time
value, using the given Calendar
object.java.sql.Timestamp
value.oracle.sql.TIMESTAMP
value.java.sql.Timestamp
value, using the given Calendar
object.oracle.sql.TIMESTAMP
value.oracle.sql.TIMESTAMPLTZ
value.oracle.sql.TIMESTAMPLTZ
value.oracle.sql.TIMESTAMPLTZ
value.oracle.sql.TIMESTAMPTZ
value.oracle.sql.TIMESTAMPTZ
value.oracle.sql.TIMESTAMPTZ
value.java.net.URL
object.ResultSet
objects returned from a CallableStatement
object simultaneously.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.A B C D E F G H I J K L M N O P Q R S T U V W X Y Z _
|
Oracle Database JDBC Java API Reference 11g Release 2 E13995-03 |
||||||||
PREV NEXT | FRAMES NO FRAMES |