|
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()getInternalConnection()getOracleConnection()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.Arrayvalue.oracle.sql.ARRAYvalue.oracle.sql.ARRAY.oracle.sql.ARRAY value.CLOB value that this Clob object represents, starting at position pos.oracle.sql.BFILEvalue.oracle.sql.BFILEvalue.oracle.sql.BFILE value.oracle.sql.BFILE value.oracle.sql.BFILEvalue.oracle.sql.BFILEvalue.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.BLOBvalue.java.sql.Blobvalue.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.CHARvalue.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.CLOBvalue.java.sql.Clobvalue.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.CustomDatumvalue.oracle.sql.DATEvalue.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.INTERVALDSvalue.oracle.sql.INTERVALYMvalue.long value.NULL.NULL.oracle.sql.NUMBERvalue.oracle.sql.NUMBER value.oracle.sql.NUMBERvalue.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.OPAQUEvalue.oracle.sql.OPAQUE value.oracle.sql.OPAQUEvalue.oracle.sql.Datumvalue.oracle.sql.Datum value.oracle.sql.Datumvalue.oracle.sql.ORADatavalue.oracle.sql.ORAData value.oracle.sql.ORADatavalue.oracle.sql.RAWvalue.oracle.sql.RAW value.oracle.sql.RAWvalue.jdbc.sql.Refvalue.oracle.sql.REFvalue.oracle.sql.REF value.oracle.sql.REFvalue.oracle.sql.REFvalue.oracle.sql.REF value.oracle.sql.REFvalue.getTables and getColumns calls of the DatabaseMetaData interface.DatabaseMetaData.getTables.oracle.sql.ROWIDvalue.oracle.sql.ROWID value.oracle.sql.ROWIDvalue.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.STRUCTvalue.oracle.sql.STRUCT value.oracle.sql.STRUCTvalue.oracle.sql.StructDescriptor value.java.sql.Time value.java.sql.Time value, using the given Calendar object.java.sql.Timestamp value.oracle.sql.TIMESTAMPvalue.java.sql.Timestamp value, using the given Calendar object.oracle.sql.TIMESTAMP value.oracle.sql.TIMESTAMPLTZvalue.oracle.sql.TIMESTAMPLTZ value.oracle.sql.TIMESTAMPLTZ value.oracle.sql.TIMESTAMPTZvalue.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 | ||||||||