quadbase.common.util.internal
Class QbConnection

java.lang.Object
  |
  +--quadbase.common.util.internal.QbConnection

All Implemented Interfaces:

java.sql.Connection

public class QbConnection

extends java.lang.Object

implements java.sql.Connection

This class is a wrapper class for java.sql.Connection. This class is used internally within Quadbase code for allocating ALL jdbc connections. The implementation of this class uses a static ConnectionPool instance for managing all java.sql.Connection objects.

Fields inherited from interface java.sql.Connection

TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Constructor Summary

QbConnection(java.lang.String databaseDriver, java.lang.String databaseURL, java.util.Properties info)
Allocates a new QbConnection object.

QbConnection(java.lang.String databaseDriver, java.lang.String databaseURL, java.lang.String databaseUsername, java.lang.String databasePassword)
Allocates a new QbConnection object.

Method Summary

void	clearWarnings()
void	close() closes the connection, calls close(QbConnection, Connection)
void	closeConnection() same as closeConnection(true)
void	closeConnection(boolean removeFromPool) Closes the connection.
void	commit()
java.sql.Statement	createStatement()
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency)
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)
boolean	getAutoCommit()
java.lang.String	getCatalog()
int	getHoldability()
java.sql.DatabaseMetaData	getMetaData()
static int	getQueryTimeout()
int	getTransactionIsolation()
java.util.Map	getTypeMap()
java.sql.SQLWarning	getWarnings()
void	init() Creates a new connection by using the ConnectionPool
boolean	isClosed()
boolean	isReadOnly()
java.lang.String	nativeSQL(java.lang.String sql)
java.sql.CallableStatement	prepareCall(java.lang.String sql)
java.sql.CallableStatement	prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency)
java.sql.CallableStatement	prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int autoGeneratedKeys)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int[] columnIndexes)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, java.lang.String[] columnNames)
void	releaseSavepoint(quadbase.common.util.internal.Savepoint savepoint)
void	rollback()
void	rollback(quadbase.common.util.internal.Savepoint savepoint)
void	setAutoCommit(boolean autoCommit)
void	setBadConnection() declare that this connection is corrupted/useless
void	setCatalog(java.lang.String catalog)
void	setHoldability(int holdability)
static void	setQueryTimeout(int time)
void	setReadOnly(boolean readOnly)
quadbase.common.util.internal.Savepoint	setSavepoint()
quadbase.common.util.internal.Savepoint	setSavepoint(java.lang.String name)
void	setTransactionIsolation(int level)
void	setTypeMap(java.util.Map map)

Methods inherited from class java.lang.Object

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

Constructor Detail

QbConnection

public QbConnection(java.lang.String databaseDriver,
                    java.lang.String databaseURL,
                    java.util.Properties info)
             throws java.lang.ClassNotFoundException,
                    java.sql.SQLException

Allocates a new QbConnection object. Calls the init() method directly to initialize the connection object.

Parameters:

databaseDriver - the name of the jdbc driver

databaseURL - the url for the database connection

info - properties required to connect to the database. This Properties is passed directly to the java.sql.ConnectionManager to create a new connection.

QbConnection

public QbConnection(java.lang.String databaseDriver,
                    java.lang.String databaseURL,
                    java.lang.String databaseUsername,
                    java.lang.String databasePassword)
             throws java.lang.ClassNotFoundException,
                    java.sql.SQLException

Allocates a new QbConnection object. Calls the init() method directly to initialize the connection object.

Parameters:

databaseDriver - the name of the jdbc driver

databaseURL - the url for the database connection

databaseUsername - username for the database

databasePassword - database password

Method Detail

init

public void init()
          throws java.lang.ClassNotFoundException,
                 java.sql.SQLException

Creates a new connection by using the ConnectionPool

getQueryTimeout

public static int getQueryTimeout()

setQueryTimeout

public static void setQueryTimeout(int time)

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Specified by:

clearWarnings in interface java.sql.Connection

close

public void close()
           throws java.sql.SQLException

closes the connection, calls close(QbConnection, Connection)

Specified by:

close in interface java.sql.Connection

closeConnection

public void closeConnection()
                     throws java.sql.SQLException

same as closeConnection(true)

closeConnection

public void closeConnection(boolean removeFromPool)
                     throws java.sql.SQLException

Closes the connection. If removeFromPool is true, then forces the ConnectionPool to remove this Connection from the pool, so that it will never be reused again.

commit

public void commit()
            throws java.sql.SQLException

Specified by:

commit in interface java.sql.Connection

createStatement

public java.sql.Statement createStatement()
                                   throws java.sql.SQLException

Specified by:

createStatement in interface java.sql.Connection

createStatement

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

Specified by:

createStatement in interface java.sql.Connection

createStatement

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

getAutoCommit

public boolean getAutoCommit()
                      throws java.sql.SQLException

Specified by:

getAutoCommit in interface java.sql.Connection

getCatalog

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

Specified by:

getCatalog in interface java.sql.Connection

getHoldability

public int getHoldability()
                   throws java.sql.SQLException

getMetaData

public java.sql.DatabaseMetaData getMetaData()
                                      throws java.sql.SQLException

Specified by:

getMetaData in interface java.sql.Connection

getTransactionIsolation

public int getTransactionIsolation()
                            throws java.sql.SQLException

Specified by:

getTransactionIsolation in interface java.sql.Connection

getTypeMap

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

Specified by:

getTypeMap in interface java.sql.Connection

getWarnings

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

Specified by:

getWarnings in interface java.sql.Connection

isClosed

public boolean isClosed()
                 throws java.sql.SQLException

Specified by:

isClosed in interface java.sql.Connection

isReadOnly

public boolean isReadOnly()
                   throws java.sql.SQLException

Specified by:

isReadOnly in interface java.sql.Connection

nativeSQL

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

Specified by:

nativeSQL in interface java.sql.Connection

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql)
                                       throws java.sql.SQLException

Specified by:

prepareCall 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

prepareCall

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

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

prepareStatement

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

prepareStatement

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

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

prepareStatement

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

prepareStatement

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

releaseSavepoint

public void releaseSavepoint(quadbase.common.util.internal.Savepoint savepoint)
                      throws java.sql.SQLException

rollback

public void rollback()
              throws java.sql.SQLException

Specified by:

rollback in interface java.sql.Connection

rollback

public void rollback(quadbase.common.util.internal.Savepoint savepoint)
              throws java.sql.SQLException

setAutoCommit

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

Specified by:

setAutoCommit 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

setHoldability

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

setReadOnly

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

Specified by:

setReadOnly in interface java.sql.Connection

setSavepoint

public quadbase.common.util.internal.Savepoint setSavepoint()
                                                     throws java.sql.SQLException

setSavepoint

public quadbase.common.util.internal.Savepoint setSavepoint(java.lang.String name)
                                                     throws java.sql.SQLException

setTransactionIsolation

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

Specified by:

setTransactionIsolation 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

setBadConnection

public void setBadConnection()

declare that this connection is corrupted/useless