EcalDBConnection Class Reference

#include <EcalDBConnection.h>

Inheritance diagram for EcalDBConnection:

Public Member Functions
void	commit ()
oracle::occi::Statement *	createStatement ()
	EcalDBConnection (std::string host, std::string sid, std::string user, std::string pass, int port=1521) noexcept(false)
	EcalDBConnection (std::string sid, std::string user, std::string pass) noexcept(false)
oracle::occi::Clob	getClobLocator ()
oracle::occi::Connection *	getConn () const
oracle::occi::Environment *	getEnv () const
void	rollback ()
void	terminateStatement (oracle::occi::Statement *stmt)
virtual	~EcalDBConnection () noexcept(false)

Protected Attributes
oracle::occi::Connection *	conn
oracle::occi::Environment *	env
std::string	host
std::string	pass
int	port
std::string	sid
oracle::occi::Statement *	stmt
std::string	user

Detailed Description

A wrapper class for the oracle Connection and Environment classes along with any OCCI-dependent methods that are useful for any database

Definition at line 16 of file EcalDBConnection.h.

Constructor & Destructor Documentation

EcalDBConnection::EcalDBConnection ( std::string  host, std::string  sid, std::string  user, std::string  pass, int  port = 1521  )

noexcept

Constructor Makes a connection to an oracle database without TNS_ADMIN

EcalDBConnection::EcalDBConnection ( std::string  sid, std::string  user, std::string  pass  )

noexcept

Constructor Makes a connection to an oracle database using TNS_ADMIN

EcalDBConnection::~EcalDBConnection ( )

virtualnoexcept

Destructor

Definition at line 61 of file EcalDBConnection.cc.

References web.browse_db::env, and AlCaHLTBitMon_QueryRunRegistry::string.

                                                     {
  //Close database conection and terminate environment
  try {
    conn->terminateStatement(stmt);
    env->terminateConnection(conn);
    Environment::terminateEnvironment(env);
  } catch (SQLException &e) {
    throw(std::runtime_error(std::string("ERROR:  Destructor Failed:  ") + getOraMessage(&e)));
  }
}

Member Function Documentation

void EcalDBConnection::commit ( )

inline

Tranaction manaagement

Definition at line 70 of file EcalDBConnection.h.

References conn.

{ conn->commit(); }

oracle::occi::Statement* EcalDBConnection::createStatement ( )

inline

Get a new Statement

Definition at line 55 of file EcalDBConnection.h.

References conn, and gather_cfg::cout.

    {
      std::cout << "Creating statement" << std::endl;
      return conn->createStatement();
    }

oracle::occi::Clob EcalDBConnection::getClobLocator ( )

inline

Get a new clob locator

Definition at line 76 of file EcalDBConnection.h.

References conn.

    {
      return oracle::occi::Clob(conn);
    }

oracle::occi::Connection* EcalDBConnection::getConn ( ) const

inline

Definition at line 82 of file EcalDBConnection.h.

References conn, and env.

Referenced by LMFCorrCoefDat::LMFCorrCoefDat(), LMFDefFabric::LMFDefFabric(), LMFIOV::LMFIOV(), and LMFUnique::LMFUnique().

{ return conn; };

oracle::occi::Environment* EcalDBConnection::getEnv ( ) const

inline

Definition at line 81 of file EcalDBConnection.h.

References env.

Referenced by LMFCorrCoefDat::LMFCorrCoefDat(), LMFDefFabric::LMFDefFabric(), LMFIOV::LMFIOV(), and LMFUnique::LMFUnique().

{ return env; };

void EcalDBConnection::rollback ( )

inline

Definition at line 71 of file EcalDBConnection.h.

References conn.

{ conn->rollback(); }

void EcalDBConnection::terminateStatement ( oracle::occi::Statement *  stmt )

inline

Definition at line 61 of file EcalDBConnection.h.

References conn, and gather_cfg::cout.

    {
      std::cout << "Creating statement" << std::endl;
      conn->terminateStatement(stmt);
    }

Member Data Documentation

oracle::occi::Connection* EcalDBConnection::conn

protected

Definition at line 91 of file EcalDBConnection.h.

Referenced by commit(), createStatement(), EcalCondDBInterface::EcalCondDBInterface(), EcalCondDBInterface::fetchConfigDataSet(), EcalCondDBInterface::fetchConfigSet(), EcalCondDBInterface::fetchDataSet(), EcalCondDBInterface::fetchDataSetWithMap(), EcalCondDBInterface::fetchDCSDataSet(), EcalCondDBInterface::fetchLastConfigSet(), EcalCondDBInterface::fetchValidDataSet(), getClobLocator(), getConn(), EcalCondDBInterface::insertConfigDataArraySet(), EcalCondDBInterface::insertConfigDataSet(), EcalCondDBInterface::insertConfigSet(), EcalCondDBInterface::insertDataArraySet(), EcalCondDBInterface::insertDataSet(), EcalCondDBInterface::insertDataSetVector(), rollback(), IDBObject::setConnection(), and terminateStatement().

oracle::occi::Environment* EcalDBConnection::env

protected

Definition at line 82 of file EcalDBConnection.h.

Referenced by EcalCondDBInterface::EcalCondDBInterface(), EcalCondDBInterface::fetchConfigDataSet(), EcalCondDBInterface::fetchConfigSet(), EcalCondDBInterface::fetchDataSet(), EcalCondDBInterface::fetchDataSetWithMap(), EcalCondDBInterface::fetchDCSDataSet(), EcalCondDBInterface::fetchLastConfigSet(), EcalCondDBInterface::fetchValidDataSet(), getConn(), getEnv(), EcalCondDBInterface::insertConfigDataArraySet(), EcalCondDBInterface::insertConfigDataSet(), EcalCondDBInterface::insertConfigSet(), EcalCondDBInterface::insertDataArraySet(), EcalCondDBInterface::insertDataSet(), and EcalCondDBInterface::insertDataSetVector().

std::string EcalDBConnection::host

protected

Definition at line 94 of file EcalDBConnection.h.

std::string EcalDBConnection::pass

protected

Definition at line 98 of file EcalDBConnection.h.

int EcalDBConnection::port

protected

Definition at line 95 of file EcalDBConnection.h.

Referenced by Vispa.Gui.ConnectableWidget.ConnectableWidget::sinkPort(), and Vispa.Gui.ConnectableWidget.ConnectableWidget::sourcePort().

std::string EcalDBConnection::sid

protected

Definition at line 96 of file EcalDBConnection.h.

oracle::occi::Statement* EcalDBConnection::stmt

protected

Definition at line 92 of file EcalDBConnection.h.

Referenced by LMFUnique::fetchIdSql(), LMFDat::getKeyList(), LMFTrigType::operator!=(), LMFColor::operator!=(), LMFRunIOV::operator!=(), and LMFSeqDat::setVmax().

std::string EcalDBConnection::user

protected

Definition at line 97 of file EcalDBConnection.h.

Referenced by cmsPerfSuite.PerfSuite::optionParse(), dataset.BaseDataset::printInfo(), DTWorkflow.DTWorkflow::remote_out_path(), production_tasks.CheckDatasetExists::run(), production_tasks.GenerateMask::run(), production_tasks.SourceCFG::run(), production_tasks.FullCFG::run(), production_tasks.MonitorJobs::run(), and production_tasks.CleanJobFiles::run().