ROOT logo
HYDRA - THE HADES ANALYSIS PACKAGE » BUILD » PC » HOra2Conn

class HOra2Conn: public TObject

_HADES_CLASS_DESCRIPTION

 HOra2Conn

 Connection class to database Oracle in Hydra2
 (uses the Oracle C/C++ precompiler)


Function Members (Methods)

public:
HOra2Conn()
HOra2Conn(const HOra2Conn&)
virtual~HOra2Conn()
voidTObject::AbstractMethod(const char* method) const
virtual voidTObject::AppendPad(Option_t* option = "")
virtual voidTObject::Browse(TBrowser* b)
static TClass*Class()
virtual const char*TObject::ClassName() const
virtual voidTObject::Clear(Option_t* = "")
virtual TObject*TObject::Clone(const char* newname = "") const
voidclose()
virtual Int_tTObject::Compare(const TObject* obj) const
virtual voidTObject::Copy(TObject& object) const
virtual voidTObject::Delete(Option_t* option = "")MENU
voiddisconnect()
virtual Int_tTObject::DistancetoPrimitive(Int_t px, Int_t py)
virtual voidTObject::Draw(Option_t* option = "")
virtual voidTObject::DrawClass() constMENU
virtual TObject*TObject::DrawClone(Option_t* option = "") constMENU
virtual voidTObject::Dump() constMENU
virtual voidTObject::Error(const char* method, const char* msgfmt) const
virtual voidTObject::Execute(const char* method, const char* params, Int_t* error = 0)
virtual voidTObject::Execute(TMethod* method, TObjArray* params, Int_t* error = 0)
virtual voidTObject::ExecuteEvent(Int_t event, Int_t px, Int_t py)
virtual voidTObject::Fatal(const char* method, const char* msgfmt) const
virtual TObject*TObject::FindObject(const char* name) const
virtual TObject*TObject::FindObject(const TObject* obj) const
Int_tgetActRunId()
Int_tgetActRunStart()
Int_tgetAlignmentOutputVersion()
virtual Option_t*TObject::GetDrawOption() const
static Long_tTObject::GetDtorOnly()
const Char_t*getExpLocation()
const Char_t*getHistoryDate()
virtual const char*TObject::GetIconName() const
virtual const char*TObject::GetName() const
virtual char*TObject::GetObjectInfo(Int_t px, Int_t py) const
static Bool_tTObject::GetObjectStat()
virtual Option_t*TObject::GetOption() const
Int_tgetRunStart(Int_t)
virtual const char*TObject::GetTitle() const
virtual UInt_tTObject::GetUniqueID() const
virtual Bool_tTObject::HandleTimer(TTimer* timer)
virtual ULong_tTObject::Hash() const
virtual voidTObject::Info(const char* method, const char* msgfmt) const
virtual Bool_tTObject::InheritsFrom(const char* classname) const
virtual Bool_tTObject::InheritsFrom(const TClass* cl) const
virtual voidTObject::Inspect() constMENU
voidTObject::InvertBit(UInt_t f)
virtual TClass*IsA() const
virtual Bool_tTObject::IsEqual(const TObject* obj) const
virtual Bool_tTObject::IsFolder() const
Bool_tTObject::IsOnHeap() const
Bool_tisOpen()
virtual Bool_tTObject::IsSortable() const
Bool_tTObject::IsZombie() const
virtual voidTObject::ls(Option_t* option = "") const
voidTObject::MayNotUse(const char* method) const
virtual Bool_tTObject::Notify()
voidTObject::Obsolete(const char* method, const char* asOfVers, const char* removedFromVers) const
Bool_topen()
Bool_topen(Char_t*)
Bool_topen(Char_t*, Char_t*)
static voidTObject::operator delete(void* ptr)
static voidTObject::operator delete(void* ptr, void* vp)
static voidTObject::operator delete[](void* ptr)
static voidTObject::operator delete[](void* ptr, void* vp)
void*TObject::operator new(size_t sz)
void*TObject::operator new(size_t sz, void* vp)
void*TObject::operator new[](size_t sz)
void*TObject::operator new[](size_t sz, void* vp)
HOra2Conn&operator=(const HOra2Conn&)
virtual voidTObject::Paint(Option_t* option = "")
virtual voidTObject::Pop()
voidprint()
virtual voidTObject::Print(Option_t* option = "") const
virtual Int_tTObject::Read(const char* name)
Bool_treconnect()
virtual voidTObject::RecursiveRemove(TObject* obj)
voidTObject::ResetBit(UInt_t f)
virtual voidTObject::SaveAs(const char* filename = "", Option_t* option = "") constMENU
virtual voidTObject::SavePrimitive(ostream& out, Option_t* option = "")
voidsetAlignmentOutputVersion(Int_t v)
voidTObject::SetBit(UInt_t f)
voidTObject::SetBit(UInt_t f, Bool_t set)
virtual voidTObject::SetDrawOption(Option_t* option = "")MENU
static voidTObject::SetDtorOnly(void* obj)
Bool_tsetHistoryDate(const Char_t*)
static voidTObject::SetObjectStat(Bool_t stat)
Bool_tsetParamRelease(const Char_t*)
Bool_tsetParamRelease(Int_t)
virtual voidTObject::SetUniqueID(UInt_t uid)
virtual voidShowMembers(TMemberInspector&)
voidshowSqlError(const Char_t*, const Char_t* msg = 0)
virtual voidStreamer(TBuffer&)
voidStreamerNVirtual(TBuffer& ClassDef_StreamerNVirtual_b)
virtual voidTObject::SysError(const char* method, const char* msgfmt) const
Bool_tTObject::TestBit(UInt_t f) const
Int_tTObject::TestBits(UInt_t f) const
virtual voidTObject::UseCurrentStyle()
virtual voidTObject::Warning(const char* method, const char* msgfmt) const
virtual Int_tTObject::Write(const char* name = 0, Int_t option = 0, Int_t bufsize = 0)
virtual Int_tTObject::Write(const char* name = 0, Int_t option = 0, Int_t bufsize = 0) const
protected:
virtual voidTObject::DoError(int level, const char* location, const char* fmt, va_list va) const
voidTObject::MakeZombie()

Data Members

protected:
Int_tactRunIdactual runId (can be -1 if there are no data in Oracle)
Int_talignmentOutVerscurrent output version for alignment
Char_tdbName[31]database name (may be a remote database)
Char_texpLocation[11]Beam or simulation run
Char_thistoryDate[21]timestamp to retrieve historic data
Bool_tisConnected==kTRUE if connection is open
Bool_tneedsServerCheckkTRUE before first call to getRunStart
Int_trunStartstart time of actual run
Char_tuserName[21]name of user

Class Charts

Inheritance Inherited Members Includes Libraries
Class Charts

Function documentation

HOra2Conn()
 default constructor
 defines default values for user ("hades_ana") and the database
   ("db-hades", the HADES Oracle 8 database on Linux at GSI)
 User "hades_ana" has Readonly access to the Oracle tables.
 The connection to Oracle is not opened!
~HOra2Conn()
 default destructor (closes connection)
Bool_t open()
 opens default connection with readonly access
Bool_t open(Char_t* )
 opens connection to database Hades for user given by name
 asks for password
Bool_t open(Char_t* , Char_t* )
 opens connection to database with name dbName for user given by name
 asks for password
Bool_t reconnect()
 opens connection (contains the SQL-statements)
void close()
 disconnects from ORACLE
 A transaction will be automatically rolled back,
 that means changes in the database are not stored
 without an explicit COMMIT
void disconnect()
 disconnects from ORACLE
 may be opened again via reconnect()
void print()
 prints information about the database connection
void showSqlError(const Char_t* , const Char_t* msg = 0)
 shows SQL error messages
Char_t* getPassword()
 asks for the password
Bool_t openConnection(Char_t* )
 opens connection (contains the SQL-statements)
Int_t checkServerLoad()
EXEC SQL BEGIN DECLARE SECTION;
Int_t getRunStart(Int_t )
 Gets the actual run id from the current event file and compares it with
 the last used actRunId for fetching data.
 If they are different, the run start time (converted to a number od seconds) is
 read from Oracle and stored together with the run id in the data members
 run_id and runStart
Bool_t setHistoryDate(const Char_t* )
 Sets the date to retrieve historic data
 Returns kFALSE when the date string cannot be converted to a valid date.
EXEC SQL BEGIN DECLARE SECTION;
Bool_t setParamRelease(const Char_t* )
 Sets the history date to the creation date of the parameter release give by name
EXEC SQL BEGIN DECLARE SECTION;
Bool_t setParamRelease(Int_t )
 Sets the history date to the creation date of the parameter release
 for the corresponding experiment
EXEC SQL BEGIN DECLARE SECTION;
HOra2Conn()
Bool_t isOpen()
{return isConnected;}
Int_t getActRunId(void)
{ return actRunId; }
Int_t getActRunStart()
{ return runStart; }
const Char_t* getExpLocation()
{ return expLocation; }
const Char_t* getHistoryDate()
{ return historyDate; }
Int_t getAlignmentOutputVersion()
{ return alignmentOutVers; }
void setAlignmentOutputVersion(Int_t v)