oracle.jdbc.driver.oracleconnection.html

Oracle JDBC 的javaDoc

</dl>
<a name="getCatalog()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getCatalog"><b>getCatalog</b></a>
<pre>
 public String getCatalog() throws SQLException
</pre>
<dl>
  <dd> We do not support catalogs.
<p>
</dl>
<a name="setTransactionIsolation(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setTransactionIsolation"><b>setTransactionIsolation</b></a>
<pre>
 public synchronized void setTransactionIsolation(int level) throws SQLException
</pre>
<dl>
  <dd> We only support dirty reads.
<p>
</dl>
<a name="getTransactionIsolation()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getTransactionIsolation"><b>getTransactionIsolation</b></a>
<pre>
 public int getTransactionIsolation() throws SQLException
</pre>
<dl>
  <dd> We only support dirty reads.
<p>
</dl>
<a name="setAutoClose(boolean)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setAutoClose"><b>setAutoClose</b></a>
<pre>
 public synchronized void setAutoClose(boolean autoClose) throws SQLException
</pre>
<dl>
  <dd> We are always in auto-close mode.
<p>
</dl>
<a name="getAutoClose()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getAutoClose"><b>getAutoClose</b></a>
<pre>
 public boolean getAutoClose() throws SQLException
</pre>
<dl>
  <dd> We are always in auto-close mode.
<p>
</dl>
<a name="getWarnings()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getWarnings"><b>getWarnings</b></a>
<pre>
 public SQLWarning getWarnings() throws SQLException
</pre>
<dl>
  <dd> We do not have any connection-level warnings
<p>
</dl>
<a name="clearWarnings()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="clearWarnings"><b>clearWarnings</b></a>
<pre>
 public void clearWarnings() throws SQLException
</pre>
<dl>
  <dd> We do not have any connection-level warnings
<p>
</dl>
<a name="trace(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="trace"><b>trace</b></a>
<pre>
 public void trace(String s)
</pre>
<a name="setDefaultRowPrefetch(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setDefaultRowPrefetch"><b>setDefaultRowPrefetch</b></a>
<pre>
 public synchronized void setDefaultRowPrefetch(int value) throws SQLException
</pre>
<dl>
  <dd> Set the value of row prefetch for all statements associated
with this connection and created after this value was set. <p>
If this value is not set by the user, only 1 row will be 
fetched at a time.<p>
All statements created before this API was called will have
a row prefetch of 1.<p>
Row prefetching allows the JDBC driver to "fetch" multiple rows
in one round-trip to the database. If this value is not set
by the user, only 1 row will be fetched at a time.<p>
To use the <code>setDefaultRowPrefetch</code> entrypoint you have to
cast the Statement object to the type
<code>oracle.jdbc.driver.OracleConnection</code>.<p>
The user can override the row prefetch value set by this
<code>oracle.jdbc.driver.OracleConnection</code> entrypoint
for individual statements, by calling
<code>OracleStatement.setRowPrefetch</code> for those
statements.<p>
The row_prefetch will be turned back to 1 automatically
by the driver if any of the select-column types is
streaming (long data or long raw data). This is overrides
any value the user might set. Also, this will be done regardless
of wether the streaming columns are read or not. <p>
To use the <code>setDefaultRowPrefetch</code> entrypoint you have to
cast the Connection object to the type
<code>oracle.jdbc.driver.OracleConnection</code>.<p>
<p>
  <dd><dl>
    <dt> <b>See Also:</b>
    <dd> <a href="oracle.jdbc.driver.OracleStatement.html#setRowPrefetch">setRowPrefetch</a>, getDefaultRowPrefetch
  </dl></dd>
</dl>
<a name="getDefaultRowPrefetch()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getDefaultRowPrefetch"><b>getDefaultRowPrefetch</b></a>
<pre>
 public synchronized int getDefaultRowPrefetch()
</pre>
<dl>
  <dd> Allows the user to retrieve the row prefetch value for the connection.
<p>
The row prefetch from the connection is used for all statements
associated with this connection. However, the user can also define 
a different row prefetch value for each statement. 
This can be done using <code>Oraclestatement.setRowPrefetch</code>,
which will override the default value provided from the connection. 
Therefore, the row prefetch
value returned by this <code>getDefaultRowPrefetch</code> entrypoint
is valid for statements for which the user has not defined a different
row prefetch.<p>
To use the <code>setDefaultRowPrefetch</code> entrypoint you have to
cast the Connection object to the type
<code>oracle.jdbc.driver.OracleConnection</code>.<p>
<p>
  <dd><dl>
    <dt> <b>See Also:</b>
    <dd> <a href="oracle.jdbc.driver.OracleStatement.html#setRowPrefetch">setRowPrefetch</a>, setDefaultRowPrefetch
  </dl></dd>
</dl>
<a name="setDefaultExecuteBatch(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setDefaultExecuteBatch"><b>setDefaultExecuteBatch</b></a>
<pre>
 public synchronized void setDefaultExecuteBatch(int batch) throws SQLException
</pre>
<dl>
  <dd> Set the batch value for executes for all prepared statements belonging
to this connection and created after the batch value was set. <p>
All statements created before using this API to set the batch value
will have a batch value of 1.<p>
Batching allows the JDBC driver to avoid making one round-trip
to the RDBMS to execute a prepared statement every time bind
variables change. The driver "batches" multiple executions of
the statement with different bind variables. Actual execution
normally happens when the number of executions reaches 
the pre-defined "batch" value. The set of bind variables along 
with the number of times the statement needs to be executed 
(equal to "batch"), are sent to the RDBMS in one round-trip.<p>
To use the <code>setDefaultExecuteBatch</code> entrypoint you have to
cast the Connection object to the type
<code>oracle.jdbc.driver.OracleConnection</code>.<p>
The user can override the batch value set by this
<code>setDefaultExecuteBatch</code> entrypoint
for individual prepared statements, by calling
<code>OraclePreparedStatement.setExecuteBatch</code> for those
statements.<p>
The default value of batch will be overridden by the driver
for a particular statement if that statement has any streaming
bind values.
<p>
  <dd><dl>
    <dt> <b>See Also:</b>
    <dd> <a href="oracle.jdbc.driver.OracleStatement.html#setRowPrefetch">setRowPrefetch</a>, getDefaultRowPrefetch
  </dl></dd>
</dl>
<a name="getDefaultExecuteBatch()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getDefaultExecuteBatch"><b>getDefaultExecuteBatch</b></a>
<pre>
 public synchronized int getDefaultExecuteBatch()
</pre>
<dl>
  <dd> Allows the user to retrieve the batch value for the connection.
<p>
The batch value from the connection is used for all prepared statements
associated with this connection. However, the user can also define 
a different batch value for individual prepared statements. 
This can be done by using 
<code>OraclePreparedStatement.setExecuteBatch</code>, which 
will override the default value provided from the connection. 
Therefore, the row prefetch
value returned by this <code>getDefaultExecuteBatch</code> entrypoint
is valid for prepared statements for which the user has not 
defined a different batch value.<p>
To use the <code>getDefaultExecuteBatch</code> entrypoint you have to
cast the Connection object to the type
<code>oracle.jdbc.driver.OracleConnection</code>.<p>
<p>
  <dd><dl>
    <dt> <b>See Also:</b>
    <dd> <a href="oracle.jdbc.driver.OracleStatement.html#setRowPrefetch">setRowPrefetch</a>, setDefaultRowPrefetch
  </dl></dd>
</dl>
<a name="setRemarksReporting(boolean)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setRemarksReporting"><b>setRemarksReporting</b></a>
<pre>
 public synchronized void setRemarksReporting(boolean reportRemarks)
</pre>
<dl>
  <dd> Turn on or off the reporting of the REMARKS columns by the
getTables and getColumns calls of the DatabaseMetaData interface.<p>
The DatabaseMetaData calls getTables and getColumns are extremely slow
if the REMARKS column has to be reported as this necessitates an
expensive outer join so by default the JDBC driver does not report
the REMARKS columns.<p>
You can turn the reporting of REMARKS on by passing a true argument
to this method.  You turn it back off by passing a false argument.<p>
You can also control the reporting of REMARKS by passing a property
named "remarksReporting" as "true" to the DriverManager.getConnection
call.
<p>
</dl>
<a name="getRemarksReporting()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getRemarksReporting"><b>getRemarksReporting</b></a>
<pre>
 public synchronized boolean getRemarksReporting()
</pre>
<dl>
  <dd> Return true if the DatabaseMetaData calls getTables and getColumns
will report the REMARKS column.<p>
<p>
</dl>
<a name="setIncludeSynonyms(boolean)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setIncludeSynonyms"><b>setIncludeSynonyms</b></a>
<pre>
 public void setIncludeSynonyms(boolean synonyms)
</pre>
<dl>
  <dd> Turn on or off retrieval of synonym information in DatabaseMetaData.
getColumns.<p>
Similar to setRemarksReporting, getColumns performs extremely slow
if information about synonyms has to be included, because it neccessitates
an outer join.  By default, the JDBC driver will not report information
about table columns when you pass a synonym to getColumns.<p>
You can get synonym information by passing true to this method, and turn
it off by passing false.  You can also control this behavior by passing
a property named "includeSynonyms" as "true" to 
DriverManager.getConnection.<p>
<p>
</dl>
<a name="getIncludeSynonyms()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getIncludeSynonyms"><b>getIncludeSynonyms</b></a>
<pre>
 public boolean getIncludeSynonyms()
</pre>
<dl>
  <dd> Returns true if DatabaseMetaData.getColumns will report information if
a table synonym is passed in, and false otherwise.<p>
<p>
</dl>
<a name="needLine()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="needLine"><b>needLine</b></a>
<pre>
 public synchronized void needLine() throws SQLException
</pre>
<a name="holdLine(oracle.jdbc.driver.OracleStatement)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="holdLine"><b>holdLine</b></a>
<pre>
 public synchronized void holdLine(<a href="oracle.jdbc.driver.OracleStatement.html#_top_">OracleStatement</a> stmt)
</pre>
<a name="releaseLine()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="releaseLine"><b>releaseLine</b></a>
<pre>
 public synchronized void releaseLine()
</pre>
<a name="startup(java.lang.String, int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="startup"><b>startup</b></a>
<pre>
 public synchronized void startup(String startup_str,
                                  int mode) throws SQLException
</pre>
<a name="shutdown(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="shutdown"><b>shutdown</b></a>
<pre>
 public synchronized void shutdown(int mode) throws SQLException
</pre>
<a name="archive(int, int, java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="archive"><b>archive</b></a>
<pre>
 public synchronized void archive(int mode,
                                  int aseq,
                                  String acstext) throws SQLException
</pre>
<a name="registerSQLType(java.lang.String, java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="registerSQLType"><b>registerSQLType</b></a>
<pre>