MultiConnection (MMBase API)

Overview

Package

Class

Tree

Deprecated

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.mmbase.module.database
Class MultiConnection

java.lang.Object
  org.mmbase.module.database.MultiConnection

All Implemented Interfaces:: java.sql.Connection

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

MultiConnection is a replacement class for Connection it provides you a multiplexed and reuseable connections from the connection pool. The main function of this class is to 'log' (keep) the last sql statement passed to it. Another function is to keep state (i.e. notifying that it is busy), and to make itself available again to teh connectionpool once it is finished (closed).

Version:: $Id: MultiConnection.java,v 1.33.2.4 2004/08/26 12:40:14 michiel Exp $
Author:: vpro, Pierre van Rooden
Warning: Contains Database Legacy Code: It would possibly be better to pass the logging of the sql query to the code that calls the conenction, rather than place it in the conenction itself, as it's implementation leads to conflicts between various JDBC versions. This also goes for freeing the connection once it is 'closed'.

Field Summary
`static int`	`CON_BUSY`
`static int`	`CON_FAILED`
`static int`	`CON_FINISHED`
`static int`	`CON_UNUSED`
`int`	`state`

Fields inherited from interface java.sql.Connection

TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Constructor Summary
`protected`	`MultiConnection()` protected constructor for extending classes, so they can use this with for example only a connection..
	`MultiConnection(MultiPool parent, java.sql.Connection con)`

Method Summary
`protected boolean`	`checkAfterException()` Tries to fix the this connection, if it proves to be broken.
`boolean`	`checkSQLError(java.lang.Exception e)`
`void`	`claim()`
`void`	`clearWarnings()` clear Warnings
`void`	`close()` Close connections
`void`	`commit()` Perform commit
`java.sql.Statement`	`createStatement()` createStatement returns an SQL Statement object
`java.sql.Statement`	`createStatement(int i, int y)` createStatement returns an SQL Statement object
`java.sql.Statement`	`createStatement(int type, int concurrency, int holdability)` Creates a Statement object that will generate ResultSet objects with the given type, concurrency, and holdability.
`boolean`	`getAutoCommit()` get AutoCommit mode
`java.lang.String`	`getCatalog()` The "catalog" name
`int`	`getHoldability()` Retrieves the current holdability of ResultSet objects created using this Connection object.
`java.lang.String`	`getLastSQL()`
`java.sql.DatabaseMetaData`	`getMetaData()` Advanced features: You can obtain a DatabaseMetaData object to get information about the target database.
`int`	`getStartTime()` Returns the moment on which the last SQL statement was started in seconds after 1970.
`long`	`getStartTimeMillis()` Returns the moment on which the last SQL statement was started in milliseconds after 1970.
`java.lang.String`	`getStateString()`
`int`	`getTransactionIsolation()`
`java.util.Map`	`getTypeMap()`
`int`	`getUsage()`
`java.sql.SQLWarning`	`getWarnings()` getWarnings will return any warning information related to the current connection.
`boolean`	`isClosed()` isClosed returns true if the connection is closed, which can occur either due to an explicit call on "close" or due to some fatal error on the connection.
`boolean`	`isReadOnly()` Is this database readonly ?
`java.lang.String`	`nativeSQL(java.lang.String query)` Convert the given generic SQL statement to the drivers native SQL.
`java.sql.CallableStatement`	`prepareCall(java.lang.String sql)` prepareCall create a pre-compiled SQL statement that is a call on a stored procedure.
`java.sql.CallableStatement`	`prepareCall(java.lang.String sql, int i, int y)` prepareCall create a pre-compiled SQL statement that is a call on a stored procedure.
`java.sql.CallableStatement`	`prepareCall(java.lang.String sql, int type, int concurrency, int holdability)` Creates a CallableStatement object that will generate ResultSet objects with the given type, concurrency, and holdability.
`java.sql.PreparedStatement`	`prepareStatement(java.lang.String sql)` prepareStatement creates a pre-compiled SQL PreparedStatement object.
`java.sql.PreparedStatement`	`prepareStatement(java.lang.String sql, int autoGeneratedKeys)` Creates a default PreparedStatement object that has the capability to retrieve auto-generated keys.
`java.sql.PreparedStatement`	`prepareStatement(java.lang.String sql, int[] columnIndexes)` Creates a default PreparedStatement object capable of returning the auto-generated keys designated by the given array.
`java.sql.PreparedStatement`	`prepareStatement(java.lang.String sql, int i, int y)` prepareStatement creates a pre-compiled SQL PreparedStatement object.
`java.sql.PreparedStatement`	`prepareStatement(java.lang.String sql, int type, int concurrency, int holdability)` Creates a PreparedStatement object that will generate ResultSet objects with the given type, concurrency, and holdability.
`java.sql.PreparedStatement`	`prepareStatement(java.lang.String sql, java.lang.String[] columnNames)` Creates a default PreparedStatement object capable of returning the auto-generated keys designated by the given array.
`void`	`realclose()` Close connections
`void`	`release()`
`void`	`releaseSavepoint(java.sql.Savepoint savepoint)` Removes the given Savepoint object from the current transaction.
`void`	`rollback()` Perform rollback
`void`	`rollback(java.sql.Savepoint savepoint)` Undoes all changes made after the given Savepoint object was set.
`void`	`setAutoCommit(boolean enableAutoCommit)` If "autoCommit" is true, then all subsequent SQL statements will be executed and committed as individual transactions.
`void`	`setCatalog(java.lang.String catalog)` The "catalog" selects a sub-space of the target database.
`void`	`setHoldability(int holdability)` Changes the holdability of ResultSet objects created using this Connection object to the given holdability.
`void`	`setLastSQL(java.lang.String sql)`
`void`	`setReadOnly(boolean readOnly)` You can put a connection in read-only mode as a hint to enable database optimizations.
`java.sql.Savepoint`	`setSavepoint()` Creates an unnamed savepoint in the current transaction and returns the new Savepoint object that represents it.
`java.sql.Savepoint`	`setSavepoint(java.lang.String name)` Creates a savepoint with the given name in the current transaction and returns the new Savepoint object that represents it.
`void`	`setTransactionIsolation(int level)` You can call the following method to try to change the transaction isolation level on a newly opened connection, using one of the TRANSACTION_* values.
`void`	`setTypeMap(java.util.Map mp)`
`java.lang.String`	`toString()`

Methods inherited from class java.lang.Object

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

Field Detail

CON_UNUSED

public static final int CON_UNUSED

See Also:: Constant Field Values

CON_BUSY

public static final int CON_BUSY

See Also:: Constant Field Values

CON_FINISHED

public static final int CON_FINISHED

See Also:: Constant Field Values

CON_FAILED

public static final int CON_FAILED

See Also:: Constant Field Values

state

public int state

Constructor Detail