Package com.webmethods.portal.service.sql

Interface IConnectionProvider

public interface IConnectionProvider
This is generic interface which creates and manages database connections, and implements their pooling if neccessary

  • Field Details

  • Method Details

    • getConnection

      Connection getConnection(IConnectionInfo connInfo)
      Returns opened connection to a database by DatasourceName
      Parameters:
      connInfo - information about the connection to be opened.
      Returns:
      an open connection to the requested database

    • getTemporaryConnection

      Connection getTemporaryConnection(IConnectionInfo connInfo)
      Creates connection using temporary pool which is not being registered
      Parameters:
      connInfo -
      Returns:
      valid Connection or null

    • releaseConnection

      void releaseConnection(Connection connection)
      Release used connection. Must be called after getConnection()
      Parameters:
      connection - the connection to be released

    • release

      void release()
      Releases all Connection resources aquired by that time

    • testConnection

      boolean testConnection(IConnectionInfo connInfo, Connection connection)
      Tests connection. Returns false if diconnected from db

    • closeConnection

      void closeConnection(IConnectionInfo connInfo, Connection connection)
      Closes connection and remove from pool

    • closeConnectionPool

      void closeConnectionPool(IConnectionInfo connInfo)
      Closes any connection pool associated with given connection info
      Parameters:
      connInfo -