com.elvyx
Class Connection

java.lang.Object
  com.elvyx.Connection

All Implemented Interfaces:

java.sql.Connection

public class Connection
extends java.lang.Object
implements java.sql.Connection

This is a connection wrapper. Indeed this connection includes the connection to db

Since:

1.0

Version:

$Revision: 1.6 $

Author:

Armando Perdomo

Field Summary

Fields inherited from interface java.sql.Connection

TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Constructor Summary

Connection(java.sql.Connection connection, ConnectionProperties dp)
Constructor for Connection.

Method Summary

void	clearWarnings()
void	close()
void	commit() Execute commit command
java.sql.Statement	createStatement()
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency)
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)
protected void	finalize()
boolean	getAutoCommit()
java.lang.String	getCatalog()
int	getConnectionId()
ConnectionProperties	getConnectionProperties()
java.lang.Integer	getCounter() Return how many connection had been opened
int	getHoldability()
int	getId() Return how many connection had been opened
java.sql.DatabaseMetaData	getMetaData()
java.sql.CallableStatement	getRealCall(java.lang.String _sql)
java.sql.CallableStatement	getRealCall(java.lang.String _sql, int resultSetType, int resultSetConcurrency)
java.sql.CallableStatement	getRealCall(java.lang.String _sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
java.sql.PreparedStatement	getRealPreparedStatement(java.lang.String _sql)
java.sql.PreparedStatement	getRealPreparedStatement(java.lang.String _sql, int autoGeneratedKeys)
java.sql.PreparedStatement	getRealPreparedStatement(java.lang.String _sql, int[] columnIndexes)
java.sql.PreparedStatement	getRealPreparedStatement(java.lang.String _sql, int resultSetType, int resultSetConcurrency)
java.sql.PreparedStatement	getRealPreparedStatement(java.lang.String _sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
java.sql.PreparedStatement	getRealPreparedStatement(java.lang.String _sql, java.lang.String[] columnNames)
java.sql.Statement	getRealStatement()
java.sql.Statement	getRealStatement(int resultSetType, int resultSetConcurrency)
java.sql.Statement	getRealStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)
int	getTransactionIsolation()
java.util.Map	getTypeMap()
java.sql.SQLWarning	getWarnings()
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(java.sql.Savepoint savepoint)
void	rollback() Execute roolback command
void	rollback(java.sql.Savepoint savePoint)
void	setAutoCommit(boolean autoCommit)
void	setCatalog(java.lang.String catalog)
void	setHoldability(int holdability)
void	setReadOnly(boolean value)
java.sql.Savepoint	setSavepoint()
java.sql.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, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Connection

public Connection(java.sql.Connection connection,
                  ConnectionProperties dp)
           throws java.sql.SQLException

Constructor for Connection.

Parameters:

connection -

Throws:

java.sql.SQLException

Method Detail

setReadOnly

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

Specified by:

setReadOnly in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.setReadOnly(boolean)

isReadOnly

public boolean isReadOnly()
                   throws java.sql.SQLException

Specified by:

isReadOnly in interface java.sql.Connection

Throws:

java.sql.SQLException

getTransactionIsolation

public int getTransactionIsolation()
                            throws java.sql.SQLException

Specified by:

getTransactionIsolation in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.getTransactionIsolation()

createStatement

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

Specified by:

createStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.releaseSavepoint(java.sql.Savepoint)

createStatement

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

Specified by:

createStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.createStatement(int resultSetType, int resultSetConcurrency)

createStatement

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

Specified by:

createStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.createStatement(int, int, int)

prepareStatement

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

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

java.sql.Connection#preparedStatement(String sql)

prepareStatement

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

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

java.sql.Connection#preparedStatement(String sql, int autoGeneratedKeys)

prepareStatement

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

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

java.sql.Connection#preparedStatement(String sql, int[] columnIndexes)

prepareStatement

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

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

java.sql.Connection#preparedStatement(String sql, String[] columnNames)

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

Throws:

java.sql.SQLException

See Also:

java.sql.Connection#preparedStatement(String sql, int resultSetType, int resultSetConcurrency)

prepareStatement

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

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

java.sql.Connection#preparedStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

prepareCall

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

Specified by:

prepareCall in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

java.sql.Connection#preparedStatement()

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

Throws:

java.sql.SQLException

See Also:

Connection.prepareCall(java.lang.String, int, int, int)

prepareCall

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

Specified by:

prepareCall in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.prepareCall(java.lang.String, int, int, int)

setAutoCommit

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

Specified by:

setAutoCommit in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.setAutoCommit(boolean)

getTypeMap

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

Specified by:

getTypeMap in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.getTypeMap()

setTypeMap

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

Specified by:

setTypeMap in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.setTypeMap(java.util.Map)

setTransactionIsolation

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

Specified by:

setTransactionIsolation in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.setTransactionIsolation(int)

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Specified by:

clearWarnings in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.clearWarnings()

getWarnings

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

Specified by:

getWarnings in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.getWarnings()

releaseSavepoint

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

Specified by:

releaseSavepoint in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.releaseSavepoint(java.sql.Savepoint)

rollback

public void rollback()
              throws java.sql.SQLException

Execute roolback command

Specified by:

rollback in interface java.sql.Connection

Throws:

java.sql.SQLException

rollback

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

Specified by:

rollback in interface java.sql.Connection

Throws:

java.sql.SQLException

commit

public void commit()
            throws java.sql.SQLException

Execute commit command

Specified by:

commit in interface java.sql.Connection

Throws:

java.sql.SQLException

setHoldability

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

Specified by:

setHoldability in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.setHoldability(int holdability)

getHoldability

public int getHoldability()
                   throws java.sql.SQLException

Specified by:

getHoldability in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.getHoldability()

getAutoCommit

public boolean getAutoCommit()
                      throws java.sql.SQLException

Specified by:

getAutoCommit in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.getAutoCommit()

getMetaData

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

Specified by:

getMetaData in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.getMetaData()

setSavepoint

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

Specified by:

setSavepoint in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.setSavepoint()

setSavepoint

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

Specified by:

setSavepoint in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.setSavepoint(String name)

setCatalog

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

Specified by:

setCatalog in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.setCatalog(String catalog)

getCatalog

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

Specified by:

getCatalog in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.getCatalog()

close

public void close()
           throws java.sql.SQLException

Specified by:

close in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.close()

isClosed

public boolean isClosed()
                 throws java.sql.SQLException

Specified by:

isClosed in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.isClosed()

nativeSQL

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

Specified by:

nativeSQL in interface java.sql.Connection

Throws:

java.sql.SQLException

See Also:

Connection.nativeSQL(String sql)

getCounter

public java.lang.Integer getCounter()

Return how many connection had been opened

Returns:

getId

public int getId()

Return how many connection had been opened

Returns:

getRealStatement

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

Throws:

java.sql.SQLException

getRealStatement

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

Throws:

java.sql.SQLException

getRealStatement

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

Throws:

java.sql.SQLException

getRealPreparedStatement

public java.sql.PreparedStatement getRealPreparedStatement(java.lang.String _sql)
                                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

getRealPreparedStatement

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

Throws:

java.sql.SQLException

getRealPreparedStatement

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

Throws:

java.sql.SQLException

getRealPreparedStatement

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

Throws:

java.sql.SQLException

getRealPreparedStatement

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

Throws:

java.sql.SQLException

getRealPreparedStatement

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

Throws:

java.sql.SQLException

getRealCall

public java.sql.CallableStatement getRealCall(java.lang.String _sql)
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getRealCall

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

Throws:

java.sql.SQLException

getRealCall

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

Throws:

java.sql.SQLException

finalize

protected void finalize()
                 throws java.lang.Throwable

Overrides:

finalize in class java.lang.Object

Throws:

java.lang.Throwable

getConnectionId

public int getConnectionId()

getConnectionProperties

public ConnectionProperties getConnectionProperties()