oracle.jdbc.driver.oracleconnection.html

Oracle JDBC 的javaDoc

	<a href="#setReadOnly(boolean)"><b>setReadOnly</b></a>(boolean)
  <dd> We do not support read-only connections

  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#setRemarksReporting(boolean)"><b>setRemarksReporting</b></a>(boolean)
  <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.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#setTransactionIsolation(int)"><b>setTransactionIsolation</b></a>(int)
  <dd> We only support dirty reads.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#setTypeMap(java.util.Dictionary)"><b>setTypeMap</b></a>(Dictionary)
  <dd> 
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#setUsingXAFlag(boolean)"><b>setUsingXAFlag</b></a>(boolean)
  <dd> 
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#setXAErrorFlag(boolean)"><b>setXAErrorFlag</b></a>(boolean)
  <dd> 
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#shutdown(int)"><b>shutdown</b></a>(int)
  <dd> 
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#startup(java.lang.String, int)"><b>startup</b></a>(String, int)
  <dd> 
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#trace(java.lang.String)"><b>trace</b></a>(String)
  <dd> 
</dl>
<a name="variables"></a>
<h2>
  <img src="images/variables.gif" width=153 height=38 alt="Variables">
</h2>
<a name="DEBUG"><img src="images/blue-ball.gif" width=12 height=12 alt=" o "></a>
<b>DEBUG</b>
<pre>
 public static final boolean DEBUG
</pre>
<a name="db_access"><img src="images/magenta-ball.gif" width=12 height=12 alt=" o "></a>
<b>db_access</b>
<pre>
 public DBAccess db_access
</pre>
<a name="conversion"><img src="images/magenta-ball.gif" width=12 height=12 alt=" o "></a>
<b>conversion</b>
<pre>
 public DBConversion conversion
</pre>
<a name="XA_wants_error"><img src="images/magenta-ball.gif" width=12 height=12 alt=" o "></a>
<b>XA_wants_error</b>
<pre>
 public boolean XA_wants_error
</pre>
<a name="UsingXA"><img src="images/magenta-ball.gif" width=12 height=12 alt=" o "></a>
<b>UsingXA</b>
<pre>
 public boolean UsingXA
</pre>
<a name="CHAR_TO_ASCII"><img src="images/blue-ball.gif" width=12 height=12 alt=" o "></a>
<b>CHAR_TO_ASCII</b>
<pre>
 public static final int CHAR_TO_ASCII
</pre>
<a name="CHAR_TO_UNICODE"><img src="images/blue-ball.gif" width=12 height=12 alt=" o "></a>
<b>CHAR_TO_UNICODE</b>
<pre>
 public static final int CHAR_TO_UNICODE
</pre>
<a name="RAW_TO_ASCII"><img src="images/blue-ball.gif" width=12 height=12 alt=" o "></a>
<b>RAW_TO_ASCII</b>
<pre>
 public static final int RAW_TO_ASCII
</pre>
<a name="RAW_TO_UNICODE"><img src="images/blue-ball.gif" width=12 height=12 alt=" o "></a>
<b>RAW_TO_UNICODE</b>
<pre>
 public static final int RAW_TO_UNICODE
</pre>
<a name="UNICODE_TO_CHAR"><img src="images/blue-ball.gif" width=12 height=12 alt=" o "></a>
<b>UNICODE_TO_CHAR</b>
<pre>
 public static final int UNICODE_TO_CHAR
</pre>
<a name="ASCII_TO_CHAR"><img src="images/blue-ball.gif" width=12 height=12 alt=" o "></a>
<b>ASCII_TO_CHAR</b>
<pre>
 public static final int ASCII_TO_CHAR
</pre>
<a name="NONE"><img src="images/blue-ball.gif" width=12 height=12 alt=" o "></a>
<b>NONE</b>
<pre>
 public static final int NONE
</pre>
<a name="JAVACHAR_TO_CHAR"><img src="images/blue-ball.gif" width=12 height=12 alt=" o "></a>
<b>JAVACHAR_TO_CHAR</b>
<pre>
 public static final int JAVACHAR_TO_CHAR
</pre>
<a name="RAW_TO_JAVACHAR"><img src="images/blue-ball.gif" width=12 height=12 alt=" o "></a>
<b>RAW_TO_JAVACHAR</b>
<pre>
 public static final int RAW_TO_JAVACHAR
</pre>
<a name="CHAR_TO_JAVACHAR"><img src="images/blue-ball.gif" width=12 height=12 alt=" o "></a>
<b>CHAR_TO_JAVACHAR</b>
<pre>
 public static final int CHAR_TO_JAVACHAR
</pre>
<a name="constructors"></a>
<h2>
  <img src="images/constructors.gif" width=231 height=38 alt="Constructors">
</h2>
<a name="OracleConnection"></a>
<a name="OracleConnection(oracle.jdbc.dbaccess.DBAccess, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.util.Properties)"><img src="images/yellow-ball.gif" width=12 height=12 alt=" o "></a>
<b>OracleConnection</b>
<pre>
 public OracleConnection(DBAccess access,
                         String ur,
                         String us,
                         String p,
                         String db,
                         Properties info) throws SQLException
</pre>
<dl>
  <dd> Allocate a new OracleConnection.  We get the connection
parameters as arguments.
<p>
We allocate the c_state and call the native method "connect" that
does the work.  If connect fails we raise an exception.
<p>
  <dd><dl>
    <dt> <b>See Also:</b>
    <dd> <a href="#connect">connect</a>
  </dl></dd>
</dl>
<a name="OracleConnection(oracle.jdbc.pool.OraclePooledConnection, oracle.jdbc.driver.OracleConnection, boolean)"><img src="images/yellow-ball.gif" width=12 height=12 alt=" o "></a>
<b>OracleConnection</b>
<pre>
 public OracleConnection(<a href="oracle.jdbc.pool.OraclePooledConnection.html#_top_">OraclePooledConnection</a> par,
                         <a href="#_top_">OracleConnection</a> pc,
                         boolean autoCommit) throws SQLException
</pre>
<a name="methods"></a>
<h2>
  <img src="images/methods.gif" width=151 height=38 alt="Methods">
</h2>
<a name="createStatement()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="createStatement"><b>createStatement</b></a>
<pre>
 public synchronized Statement createStatement() throws SQLException
</pre>
<dl>
  <dd> createStatement just allocates a new statement object.  
The statement has a pointer to the connection object.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> a new OracleStatement object
  </dl></dd>
</dl>
<a name="prepareStatement(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="prepareStatement"><b>prepareStatement</b></a>
<pre>
 public synchronized PreparedStatement prepareStatement(String sql) throws SQLException
</pre>
<dl>
  <dd> This is similar to createStatement.  We accept both ODBC syntax and 
Oracle syntax for SQL statements.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> a new OraclePreparedStatement object
  </dl></dd>
</dl>
<a name="prepareCall(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="prepareCall"><b>prepareCall</b></a>
<pre>
 public synchronized CallableStatement prepareCall(String sql) throws SQLException
</pre>
<dl>
  <dd> This is similar to createStatement.  We accept both ODBC syntax and 
Oracle syntax for SQL statements.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> a new oracle.jdbc.driver.CallableStatement object
  </dl></dd>
</dl>
<a name="nativeSQL(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="nativeSQL"><b>nativeSQL</b></a>
<pre>
 public String nativeSQL(String sql) throws SQLException
</pre>
<dl>
  <dd> This is a bogus and quickly done implementation waiting for something
better
<p>
</dl>
<a name="setAutoCommit(boolean)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setAutoCommit"><b>setAutoCommit</b></a>
<pre>
 public synchronized void setAutoCommit(boolean autoCommit) throws SQLException
</pre>
<a name="getAutoCommit()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getAutoCommit"><b>getAutoCommit</b></a>
<pre>
 public synchronized boolean getAutoCommit() throws SQLException
</pre>
<a name="commit()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="commit"><b>commit</b></a>
<pre>
 public synchronized void commit() throws SQLException
</pre>
<a name="rollback()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="rollback"><b>rollback</b></a>
<pre>
 public synchronized void rollback() throws SQLException
</pre>
<a name="close()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="close"><b>close</b></a>
<pre>
 public synchronized void close() throws SQLException
</pre>
<dl>
  <dd> Rollbacks the current transaction.  See commit for discussion of how the 
PreparedStatements, CallableStatement and ResultSets are closed.
<p>
  <dd><dl>
    <dt> <b>See Also:</b>
    <dd> <a href="#rollback">rollback</a>, <a href="#commit">commit</a>
  </dl></dd>
</dl>
<a name="isClosed()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="isClosed"><b>isClosed</b></a>
<pre>
 public synchronized boolean isClosed() throws SQLException
</pre>
<dl>
  <dd> As we do not keep a state in the Java struct we call native method even
for isClosed.  (The alternative is to test if c_state is 0, but this 
breaks the information hiding strategy.)
<p>
</dl>
<a name="getMetaData()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getMetaData"><b>getMetaData</b></a>
<pre>
 public synchronized DatabaseMetaData getMetaData() throws SQLException
</pre>
<dl>
  <dd> We just return a oracle.oci8.DatabaseMetaData object.  It has a pointer
to the connection.
<p>
</dl>
<a name="setReadOnly(boolean)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setReadOnly"><b>setReadOnly</b></a>
<pre>
 public void setReadOnly(boolean readOnly) throws SQLException
</pre>
<dl>
  <dd> We do not support read-only connections
<p>
</dl>
<a name="isReadOnly()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="isReadOnly"><b>isReadOnly</b></a>
<pre>
 public boolean isReadOnly() throws SQLException
</pre>
<dl>
  <dd> Our connections are never in read-only mode.
<p>
</dl>
<a name="setCatalog(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setCatalog"><b>setCatalog</b></a>
<pre>
 public void setCatalog(String catalog) throws SQLException
</pre>
<dl>
  <dd> We do not support catalogs.
<p>