WebLogic Server 8.1 API Reference

weblogic.jdbc.oci
Class Connection

java.lang.Object
  |
  +--weblogic.jdbc.oci.Connection

Direct Known Subclasses:

XAConnection

public class Connection

extends java.lang.Object

implements java.sql.Connection, Waitable, WLConnectionInfo, weblogic.jdbc.common.OracleConnection, weblogic.jdbc.common.OracleLobCloser

This class is documented only for WebLogic extensions to JDBC. For additional information, see the documentation for java.sql.Connection. To use this extension, cast your Connection object as weblogic.jdbc.oci.Connection

Author:

Copyright © 2002 BEA Systems, Inc. All Rights Reserved.

Field Summary

protected boolean	allowmixedmetadata
protected java.lang.String	driver
protected int	insPieceLength
protected java.util.List	lobs
weblogic.db.oci.OciConnection	ociconn
static int	PRIVATE_CLIB
static java.lang.String	PRIVATE_VERSION
protected int	selPieceLength
protected java.lang.String	url

Constructor Summary

Connection(java.util.Properties info)

Method Summary

void	addLob(weblogic.jdbc.common.OracleLobCloser lob)
boolean	autocommitState()
void	checkIfClosed()
void	clearWarnings()
void	close()
void	closeLob()
void	commit()
java.lang.String	connectionName()
boolean	connectionState()
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency)
java.sql.Statement	createStatement(int a, int b, int c)
int	datewidth()
void	datewidth(int width)
int	driverType()
void	finalize()
static java.util.Hashtable	getAllConnections()
boolean	getAutoCommit()
java.lang.String	getCatalog()
java.lang.String	getDescription()
int	getHoldability()
java.lang.String	getName()
static int	getNumberOfConnections()
int	getNumberOfStatements()
int	getTransactionIsolation()
java.util.Map	getTypeMap()
java.sql.SQLWarning	getWarnings()
boolean	isClosed()
java.lang.String	isolationLevel()
boolean	isReadOnly()
java.lang.String	lastSQL()
java.lang.String	nativeSQL(java.lang.String query)
int	prefetchSize()
java.sql.CallableStatement	prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency)
java.sql.CallableStatement	prepareCall(java.lang.String a, int b, int c, int d)
java.sql.PreparedStatement	prepareStatement(java.lang.String a, int b)
java.sql.PreparedStatement	prepareStatement(java.lang.String a, int[] b)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency)
java.sql.PreparedStatement	prepareStatement(java.lang.String a, int b, int c, int d)
java.sql.PreparedStatement	prepareStatement(java.lang.String a, java.lang.String[] b)
void	releaseSavepoint(java.sql.Savepoint a)
boolean	resourcesQueuing()
void	rollback()
void	rollback(java.sql.Savepoint a)
void	setAutoCommit(boolean enableAutoCommit)
void	setCatalog(java.lang.String catalog)
void	setHoldability(int a)
void	setLockArrayFetch(java.lang.Object value)
void	setLockBindCursorByPosition(java.lang.Object value)
void	setLockBindSelectItem(java.lang.Object value)
void	setLockBindVariableByPosition(java.lang.Object value)
void	setLockCancel(java.lang.Object value)
void	setLockClose(java.lang.Object value)
void	setLockDescribe(java.lang.Object value)
void	setLockExec(java.lang.Object value)
void	setLockExecAndFetch(java.lang.Object value)
void	setLockFetch(java.lang.Object value)
void	setLockOopt(java.lang.Object value)
void	setLockOpen(java.lang.Object value)
void	setLockParse(java.lang.Object value)
void	setOciVerbose(boolean val)
void	setReadOnly(boolean readOnly)
java.sql.Savepoint	setSavepoint()
java.sql.Savepoint	setSavepoint(java.lang.String d)
void	setTransactionIsolation(int level)
void	setTypeMap(java.util.Map map)
int	sharedLibVersion()
int	statementCount()
boolean	supportsPrefetch()
void	waitOnResources(boolean val) Use this method to access the Oracle oopt() function for C (see section 4-97 of The OCI Functions for C).
java.lang.String	weblogicVersion()

Methods inherited from class java.lang.Object

clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

PRIVATE_VERSION

public static final java.lang.String PRIVATE_VERSION

PRIVATE_CLIB

public static final int PRIVATE_CLIB

ociconn

public weblogic.db.oci.OciConnection ociconn

url

protected java.lang.String url

driver

protected java.lang.String driver

lobs

protected java.util.List lobs

allowmixedmetadata

protected boolean allowmixedmetadata

selPieceLength

protected int selPieceLength

insPieceLength

protected int insPieceLength

Constructor Detail

Connection

public Connection(java.util.Properties info)
           throws java.sql.SQLException

Method Detail

waitOnResources

public void waitOnResources(boolean val)

Use this method to access the Oracle oopt() function for C (see section 4-97 of The OCI Functions for C). The Oracle C function sets options in cases where requested resources are not available; for example, whether to wait for locks.

When the argument to this method is true, this WebLogic extension to JDBC sets this option so that your program will receive an error return code whenever a resource is requested but is unavailable. Use of this method can cause several error return codes while waiting for internal resources that are locked for short durations.

Specified by:

waitOnResources in interface Waitable

Parameters:

val - True if the connection should wait on resources

datewidth

public int datewidth()

datewidth

public void datewidth(int width)

checkIfClosed

public void checkIfClosed()
                   throws java.sql.SQLException

getName

public java.lang.String getName()

getDescription

public java.lang.String getDescription()

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Specified by:

getWarnings in interface java.sql.Connection

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Specified by:

clearWarnings in interface java.sql.Connection

nativeSQL

public java.lang.String nativeSQL(java.lang.String query)
                           throws java.sql.SQLException

Specified by:

nativeSQL in interface java.sql.Connection

setAutoCommit

public void setAutoCommit(boolean enableAutoCommit)
                   throws java.sql.SQLException

Specified by:

setAutoCommit in interface java.sql.Connection

getNumberOfConnections

public static int getNumberOfConnections()

getNumberOfStatements

public int getNumberOfStatements()

getAutoCommit

public boolean getAutoCommit()

Specified by:

getAutoCommit in interface java.sql.Connection

commit

public void commit()
            throws java.sql.SQLException

Specified by:

commit in interface java.sql.Connection

rollback

public void rollback()
              throws java.sql.SQLException

Specified by:

rollback in interface java.sql.Connection

close

public void close()
           throws java.sql.SQLException

Specified by:

close in interface java.sql.Connection

finalize

public void finalize()

Overrides:

finalize in class java.lang.Object

isClosed

public boolean isClosed()
                 throws java.sql.SQLException

Specified by:

isClosed in interface java.sql.Connection

setReadOnly

public void setReadOnly(boolean readOnly)
                 throws java.sql.SQLException

Specified by:

setReadOnly in interface java.sql.Connection

isReadOnly

public boolean isReadOnly()
                   throws java.sql.SQLException

Specified by:

isReadOnly in interface java.sql.Connection

setTransactionIsolation

public void setTransactionIsolation(int level)
                             throws java.sql.SQLException

Specified by:

setTransactionIsolation in interface java.sql.Connection

getTransactionIsolation

public int getTransactionIsolation()
                            throws java.sql.SQLException

Specified by:

getTransactionIsolation in interface java.sql.Connection

setCatalog

public void setCatalog(java.lang.String catalog)
                throws java.sql.SQLException

Specified by:

setCatalog in interface java.sql.Connection

getCatalog

public java.lang.String getCatalog()
                            throws java.sql.SQLException

Specified by:

getCatalog in interface java.sql.Connection

addLob

public void addLob(weblogic.jdbc.common.OracleLobCloser lob)

closeLob

public void closeLob()

Specified by:

closeLob in interface weblogic.jdbc.common.OracleLobCloser

setOciVerbose

public void setOciVerbose(boolean val)

setLockOpen

public void setLockOpen(java.lang.Object value)

setLockParse

public void setLockParse(java.lang.Object value)

setLockDescribe

public void setLockDescribe(java.lang.Object value)

setLockOopt

public void setLockOopt(java.lang.Object value)

setLockBindCursorByPosition

public void setLockBindCursorByPosition(java.lang.Object value)

setLockBindVariableByPosition

public void setLockBindVariableByPosition(java.lang.Object value)

setLockBindSelectItem

public void setLockBindSelectItem(java.lang.Object value)

setLockExec

public void setLockExec(java.lang.Object value)

setLockExecAndFetch

public void setLockExecAndFetch(java.lang.Object value)

setLockFetch

public void setLockFetch(java.lang.Object value)

setLockArrayFetch

public void setLockArrayFetch(java.lang.Object value)

setLockCancel

public void setLockCancel(java.lang.Object value)

setLockClose

public void setLockClose(java.lang.Object value)

connectionName

public java.lang.String connectionName()

Specified by:

connectionName in interface WLConnectionInfo

connectionState

public boolean connectionState()

Specified by:

connectionState in interface WLConnectionInfo

autocommitState

public boolean autocommitState()

Specified by:

autocommitState in interface WLConnectionInfo

supportsPrefetch

public boolean supportsPrefetch()

Specified by:

supportsPrefetch in interface WLConnectionInfo

prefetchSize

public int prefetchSize()

Specified by:

prefetchSize in interface WLConnectionInfo

isolationLevel

public java.lang.String isolationLevel()

Specified by:

isolationLevel in interface WLConnectionInfo

resourcesQueuing

public boolean resourcesQueuing()

Specified by:

resourcesQueuing in interface WLConnectionInfo

weblogicVersion

public java.lang.String weblogicVersion()

Specified by:

weblogicVersion in interface WLConnectionInfo

driverType

public int driverType()

Specified by:

driverType in interface WLConnectionInfo

sharedLibVersion

public int sharedLibVersion()

Specified by:

sharedLibVersion in interface WLConnectionInfo

lastSQL

public java.lang.String lastSQL()

Specified by:

lastSQL in interface WLConnectionInfo

statementCount

public int statementCount()

Specified by:

statementCount in interface WLConnectionInfo

getAllConnections

public static java.util.Hashtable getAllConnections()

createStatement

public java.sql.Statement createStatement(int resultSetType,
                                          int resultSetConcurrency)
                                   throws java.sql.SQLException

Specified by:

createStatement in interface java.sql.Connection

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int resultSetType,
                                                   int resultSetConcurrency)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql,
                                              int resultSetType,
                                              int resultSetConcurrency)
                                       throws java.sql.SQLException

Specified by:

prepareCall in interface java.sql.Connection

getTypeMap

public java.util.Map getTypeMap()
                         throws java.sql.SQLException

Specified by:

getTypeMap in interface java.sql.Connection

setTypeMap

public void setTypeMap(java.util.Map map)
                throws java.sql.SQLException

Specified by:

setTypeMap in interface java.sql.Connection

releaseSavepoint

public void releaseSavepoint(java.sql.Savepoint a)
                      throws java.sql.SQLException

Specified by:

releaseSavepoint in interface java.sql.Connection

rollback

public void rollback(java.sql.Savepoint a)
              throws java.sql.SQLException

Specified by:

rollback in interface java.sql.Connection

getHoldability

public int getHoldability()
                   throws java.sql.SQLException

Specified by:

getHoldability in interface java.sql.Connection

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String a,
                                              int b,
                                              int c,
                                              int d)
                                       throws java.sql.SQLException

Specified by:

prepareCall in interface java.sql.Connection

setHoldability

public void setHoldability(int a)
                    throws java.sql.SQLException

Specified by:

setHoldability in interface java.sql.Connection

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String a,
                                                   int b,
                                                   int c,
                                                   int d)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String a,
                                                   int b)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String a,
                                                   int[] b)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String a,
                                                   java.lang.String[] b)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

createStatement

public java.sql.Statement createStatement(int a,
                                          int b,
                                          int c)
                                   throws java.sql.SQLException

Specified by:

createStatement in interface java.sql.Connection

setSavepoint

public java.sql.Savepoint setSavepoint()
                                throws java.sql.SQLException

Specified by:

setSavepoint in interface java.sql.Connection

setSavepoint

public java.sql.Savepoint setSavepoint(java.lang.String d)
                                throws java.sql.SQLException

Specified by:

setSavepoint in interface java.sql.Connection