Package org.openbravo.service.db

Class DalConnectionProvider

java.lang.Object

org.openbravo.service.db.DalConnectionProvider

All Implemented Interfaces:

ConnectionProvider

public class DalConnectionProvider
extends Object
implements ConnectionProvider

A connection provider which is created on the basis of the current connection of the DAL (see OBDal.getConnection()). It read the properties through the OBPropertiesProvider. Note: this implementation

• does not support connection pooling
• does not close the connection
• it flushes the hibernate session before returning a connection by default, but this can be overriden by using the constructor with the flush parameter (OBDal.flush())

DalConnectionProvider is not thread safe, the same instance should never be accessed by two different threads.

Author:

mtaal

Constructor Summary

Constructors

Constructor	Description
DalConnectionProvider()
DalConnectionProvider(boolean flush)

Method Summary

Modifier and Type	Method	Description
void	destroy()
CallableStatement	getCallableStatement(String SQLCallableStatement)
CallableStatement	getCallableStatement(String poolName, String SQLCallableStatement)
CallableStatement	getCallableStatement(Connection conn, String SQLCallableStatement)
Connection	getConnection()
PreparedStatement	getPreparedStatement(String SQLPreparedStatement)
PreparedStatement	getPreparedStatement(String poolName, String SQLPreparedStatement)
PreparedStatement	getPreparedStatement(Connection conn, String SQLPreparedStatement)
Properties	getProperties()
String	getRDBMS()
static DalConnectionProvider	getReadOnlyConnectionProvider()
Statement	getStatement()
Statement	getStatement(String poolName)
Statement	getStatement(Connection conn)
String	getStatus()
Connection	getTransactionConnection()
void	releaseCallableStatement(CallableStatement callableStatement)
void	releaseCommitConnection(Connection conn)
void	releasePreparedStatement(PreparedStatement preparedStatement)
void	releaseRollbackConnection(Connection conn)
void	releaseStatement(Statement statement)
void	releaseTransactionalPreparedStatement(PreparedStatement preparedStatement)
void	releaseTransactionalStatement(Statement statement)
void	setConnection(Connection connection)
void	setProperties(Properties properties)

Methods inherited from class java.lang.Object

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

Constructor Detail

DalConnectionProvider

public DalConnectionProvider()

DalConnectionProvider

public DalConnectionProvider(boolean flush)

Parameters:

flush - if set to true, the getConnection method will flush the OBDal instance.

Method Detail

destroy

public void destroy()
             throws Exception

Specified by:

destroy in interface ConnectionProvider

Throws:

Exception

getReadOnlyConnectionProvider

public static DalConnectionProvider getReadOnlyConnectionProvider()

getConnection

public Connection getConnection()
                         throws NoConnectionAvailableException

Specified by:

getConnection in interface ConnectionProvider

Throws:

NoConnectionAvailableException

setConnection

public void setConnection(Connection connection)

getRDBMS

public String getRDBMS()

Specified by:

getRDBMS in interface ConnectionProvider

getTransactionConnection

public Connection getTransactionConnection()
                                    throws NoConnectionAvailableException,
                                           SQLException

Specified by:

getTransactionConnection in interface ConnectionProvider

Throws:

NoConnectionAvailableException

SQLException

releaseCommitConnection

public void releaseCommitConnection(Connection conn)
                             throws SQLException

Specified by:

releaseCommitConnection in interface ConnectionProvider

Throws:

SQLException

releaseRollbackConnection

public void releaseRollbackConnection(Connection conn)
                               throws SQLException

Specified by:

releaseRollbackConnection in interface ConnectionProvider

Throws:

SQLException

getPreparedStatement

public PreparedStatement getPreparedStatement(String SQLPreparedStatement)
                                       throws Exception

Specified by:

getPreparedStatement in interface ConnectionProvider

Throws:

Exception

getPreparedStatement

public PreparedStatement getPreparedStatement(String poolName,
                                              String SQLPreparedStatement)
                                       throws Exception

Specified by:

getPreparedStatement in interface ConnectionProvider

Throws:

Exception

getPreparedStatement

public PreparedStatement getPreparedStatement(Connection conn,
                                              String SQLPreparedStatement)
                                       throws SQLException

Specified by:

getPreparedStatement in interface ConnectionProvider

Throws:

SQLException

getCallableStatement

public CallableStatement getCallableStatement(String SQLCallableStatement)
                                       throws Exception

Specified by:

getCallableStatement in interface ConnectionProvider

Throws:

Exception

getCallableStatement

public CallableStatement getCallableStatement(String poolName,
                                              String SQLCallableStatement)
                                       throws Exception

Specified by:

getCallableStatement in interface ConnectionProvider

Throws:

Exception

getCallableStatement

public CallableStatement getCallableStatement(Connection conn,
                                              String SQLCallableStatement)
                                       throws SQLException

Specified by:

getCallableStatement in interface ConnectionProvider

Throws:

SQLException

getStatement

public Statement getStatement()
                       throws Exception

Specified by:

getStatement in interface ConnectionProvider

Throws:

Exception

getStatement

public Statement getStatement(String poolName)
                       throws Exception

Specified by:

getStatement in interface ConnectionProvider

Throws:

Exception

getStatement

public Statement getStatement(Connection conn)
                       throws SQLException

Specified by:

getStatement in interface ConnectionProvider

Throws:

SQLException

releasePreparedStatement

public void releasePreparedStatement(PreparedStatement preparedStatement)
                              throws SQLException

Specified by:

releasePreparedStatement in interface ConnectionProvider

Throws:

SQLException

releaseCallableStatement

public void releaseCallableStatement(CallableStatement callableStatement)
                              throws SQLException

Specified by:

releaseCallableStatement in interface ConnectionProvider

Throws:

SQLException

releaseStatement

public void releaseStatement(Statement statement)
                      throws SQLException

Specified by:

releaseStatement in interface ConnectionProvider

Throws:

SQLException

releaseTransactionalStatement

public void releaseTransactionalStatement(Statement statement)
                                   throws SQLException

Specified by:

releaseTransactionalStatement in interface ConnectionProvider

Throws:

SQLException

releaseTransactionalPreparedStatement

public void releaseTransactionalPreparedStatement(PreparedStatement preparedStatement)
                                           throws SQLException

Specified by:

releaseTransactionalPreparedStatement in interface ConnectionProvider

Throws:

SQLException

getStatus

public String getStatus()

Specified by:

getStatus in interface ConnectionProvider

getProperties

public Properties getProperties()

setProperties

public void setProperties(Properties properties)