ConnectionHolder (Cameleon OSP Specification)

java.lang.Object
- de.must.dataobj.ConnectionHolder

public class ConnectionHolder
extends java.lang.Object

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`ACCESS_NOT_SET_YET`
`static int`	`DB2_400`
`static int`	`DBASE`
`static int`	`DERBY`
`static int`	`FIREBIRD`
`static int`	`JAVA_DB_ACCESS`
`static int`	`MARIA_DB`
`static int`	`MS_ACCESS`
`static int`	`MS_SQL_SERVER`
`static int`	`MYSQL`
`static int`	`ODBC_ACCESS`
`static int`	`ODBC_ACCESS_BY_MDB_FILE_NAME`
`static int`	`ORACLE`
`static int`	`OTHER_ACCESS`
`static int`	`POSTGRESQL`
`static int`	`SQLBASE`
`static int`	`SQLITE`
`static int`	`U_CAN_ACCESS`

Constructor Summary

Constructors
Constructor and Description

ConnectionHolder(ConnectionSpecification connectionSpecification)
Constructs a new connection holder.

Constructors
Constructor and Description
`ConnectionHolder(ConnectionSpecification connectionSpecification)` Constructs a new connection holder.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`boolean`	`checkAndReactivateDbConnIfNecessary()` Checks the connection and reactivates it, if the connection is broken.
`void`	`closeConnection()` Closes the current connection.
`java.sql.Connection`	`createConnection()` Creates and returns the connection based on the previously set connection specification.
`java.sql.Connection`	`createConnection(ConnectionSpecification connectionSpecification)`
`SqlDialect`	`createSqlDialect()` Returns a new instance of the SQL dialect supporting class of the database
`static SqlDialect`	`createSqlDialect(java.sql.Connection connection)` Returns a new instance of the SQL dialect supporting class of the database as found in the specified connection.
`static SqlDialect`	`createSqlDialect(int databaseType)`
`protected void`	`finalize()`
`java.sql.Connection`	`getConnection()` Returns the connection.
`ConnectionSpecification`	`getConnectionSpecification()` Returns the used connection specification.
`int`	`getDatabaseType()` Returns the database type of the current connection.
`static int`	`getDatabaseType(java.sql.Connection connection)` Returns the database type of the specified connection.
`static java.lang.String`	`getLastCreateExceptionDescription()` Returns the description if the last create exception.
`long`	`getLockTime()`
`boolean`	`hasOrHad(java.sql.Connection connection)` Returns true if connection holder holds this connection or has been the holder of the specified connection.
`boolean`	`isConnected()` Returns true if the connection holder is connected.
`boolean`	`isConnectionBroken()` Returns true if the connection is broken.
`boolean`	`isVacant()` Returns true if the hold connection is vacant to be reused as private connection of another owner.
`void`	`lock()` Locks the connection as privately use.
`void`	`unlock()` Unlocks the connection as privately use.

Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - ACCESS_NOT_SET_YET
```
public static final int ACCESS_NOT_SET_YET
```
    See Also:
    
    Constant Field Values
  - ODBC_ACCESS
```
public static final int ODBC_ACCESS
```
    See Also:
    
    Constant Field Values
  - ODBC_ACCESS_BY_MDB_FILE_NAME
```
public static final int ODBC_ACCESS_BY_MDB_FILE_NAME
```
    See Also:
    
    Constant Field Values
  - OTHER_ACCESS
```
public static final int OTHER_ACCESS
```
    See Also:
    
    Constant Field Values
  - JAVA_DB_ACCESS
```
public static final int JAVA_DB_ACCESS
```
    See Also:
    
    Constant Field Values
  - MS_ACCESS
```
public static final int MS_ACCESS
```
    See Also:
    
    Constant Field Values
  - DBASE
```
public static final int DBASE
```
    See Also:
    
    Constant Field Values
  - ORACLE
```
public static final int ORACLE
```
    See Also:
    
    Constant Field Values
  - MYSQL
```
public static final int MYSQL
```
    See Also:
    
    Constant Field Values
  - DB2_400
```
public static final int DB2_400
```
    See Also:
    
    Constant Field Values
  - MS_SQL_SERVER
```
public static final int MS_SQL_SERVER
```
    See Also:
    
    Constant Field Values
  - SQLITE
```
public static final int SQLITE
```
    See Also:
    
    Constant Field Values
  - SQLBASE
```
public static final int SQLBASE
```
    See Also:
    
    Constant Field Values
  - POSTGRESQL
```
public static final int POSTGRESQL
```
    See Also:
    
    Constant Field Values
  - DERBY
```
public static final int DERBY
```
    See Also:
    
    Constant Field Values
  - U_CAN_ACCESS
```
public static final int U_CAN_ACCESS
```
    See Also:
    
    Constant Field Values
  - MARIA_DB
```
public static final int MARIA_DB
```
    See Also:
    
    Constant Field Values
  - FIREBIRD
```
public static final int FIREBIRD
```
    See Also:
    
    Constant Field Values
- Constructor Detail
  - ConnectionHolder
```
public ConnectionHolder(ConnectionSpecification connectionSpecification)
```
    Constructs a new connection holder.
- Method Detail
  - getConnectionSpecification
```
public ConnectionSpecification getConnectionSpecification()
```
    Returns the used connection specification.
    
    Returns:
    
    the used connection specification
  - createConnection
```
public java.sql.Connection createConnection()
                                     throws java.lang.ClassNotFoundException,
                                            java.sql.SQLException
```
    Creates and returns the connection based on the previously set connection specification.
    
    Returns:
    
    newly created connection
    
    Throws:
    
    java.lang.ClassNotFoundException
    
    java.sql.SQLException
  - createConnection
```
public java.sql.Connection createConnection(ConnectionSpecification connectionSpecification)
                                     throws java.lang.ClassNotFoundException,
                                            java.sql.SQLException
```
    Throws:
    
    java.lang.ClassNotFoundException
    
    java.sql.SQLException
  - closeConnection
```
public void closeConnection()
```
    Closes the current connection.
  - isConnected
```
public boolean isConnected()
```
    Returns true if the connection holder is connected.
    
    Returns:
    
    true if the connection holder is connected
  - getConnection
```
public java.sql.Connection getConnection()
```
    Returns the connection.
    
    Returns:
    
    the connection
  - getLastCreateExceptionDescription
```
public static java.lang.String getLastCreateExceptionDescription()
```
    Returns the description if the last create exception.
    
    Returns:
    
    the description if the last create exception
  - getDatabaseType
```
public int getDatabaseType()
```
    Returns the database type of the current connection.
    
    Returns:
    
    the database type of the current connection
  - createSqlDialect
```
public SqlDialect createSqlDialect()
```
    Returns a new instance of the SQL dialect supporting class of the database
    
    Returns:
    
    the SQL dialect supporting class of the specified connection
  - createSqlDialect
```
public static SqlDialect createSqlDialect(java.sql.Connection connection)
```
    Returns a new instance of the SQL dialect supporting class of the database as found in the specified connection.
    
    Parameters:
    
    connection - the connection to check out the database type
    
    Returns:
    
    the SQL dialect supporting class of the specified connection
  - createSqlDialect
```
public static SqlDialect createSqlDialect(int databaseType)
```
  - getDatabaseType
```
public static int getDatabaseType(java.sql.Connection connection)
```
    Returns the database type of the specified connection.
    
    Parameters:
    
    connection - the connection to check
    
    Returns:
    
    the database type of the specified connection
  - isVacant
```
public boolean isVacant()
```
    Returns true if the hold connection is vacant to be reused as private connection of another owner.
    
    Returns:
    
    Returns true if the connection is vacant to be reused
  - lock
```
public void lock()
```
    Locks the connection as privately use. Causes isVacant to return false.
  - unlock
```
public void unlock()
```
    Unlocks the connection as privately use. Causes isVacant to return true.
  - getLockTime
```
public long getLockTime()
```
  - hasOrHad
```
public boolean hasOrHad(java.sql.Connection connection)
```
    Returns true if connection holder holds this connection or has been the holder of the specified connection.
    
    Parameters:
    
    connection - the connection to check
    
    Returns:
    
    true if connection holder holds this connection or has been the holder of the specified connection
  - checkAndReactivateDbConnIfNecessary
```
public boolean checkAndReactivateDbConnIfNecessary()
```
    Checks the connection and reactivates it, if the connection is broken.
    
    Returns:
    
    whether or not the database connection has been recreated
  - isConnectionBroken
```
public boolean isConnectionBroken()
```
    Returns true if the connection is broken. Uses 'statement to be used to check whether connection is broken' if specified - useful for MySQL / MariaDB Tries to close any connection not valid any more to release system resources
    
    Returns:
    
    true if the connection is broken
  - finalize
```
protected void finalize()
                 throws java.lang.Throwable
```
    Overrides:
    
    finalize in class java.lang.Object
    
    Throws:
    
    java.lang.Throwable

Class ConnectionHolder

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

ACCESS_NOT_SET_YET

ODBC_ACCESS

ODBC_ACCESS_BY_MDB_FILE_NAME

OTHER_ACCESS

JAVA_DB_ACCESS

MS_ACCESS

DBASE

ORACLE

MYSQL

DB2_400

MS_SQL_SERVER

SQLITE

SQLBASE

POSTGRESQL

DERBY

U_CAN_ACCESS

MARIA_DB

FIREBIRD

Constructor Detail

ConnectionHolder

Method Detail

getConnectionSpecification

createConnection

createConnection

closeConnection

isConnected

getConnection

getLastCreateExceptionDescription

getDatabaseType

createSqlDialect

createSqlDialect

createSqlDialect

getDatabaseType

isVacant

lock

unlock

getLockTime

hasOrHad

checkAndReactivateDbConnIfNecessary

isConnectionBroken

finalize