TOracleServer Class Reference

#include <TOracleServer.h>

Inheritance diagram for TOracleServer:

TSQLServer TObject TObject List of all members.

Public Member Functions

 TOracleServer (const char *db, const char *uid, const char *pw)
 format for converting date and time stamps into string
 ~TOracleServer ()
void Close (Option_t *opt="")
TSQLResult * Query (const char *sql)
Bool_t Exec (const char *sql)
TSQLStatement * Statement (const char *sql, Int_t niter=100)
Bool_t IsConnected () const
Bool_t HasStatement () const
Int_t SelectDataBase (const char *dbname)
TSQLResult * GetDataBases (const char *wild=0)
TSQLResult * GetTables (const char *dbname, const char *wild=0)
TList * GetTablesList (const char *wild=0)
TSQLTableInfo * GetTableInfo (const char *tablename)
TSQLResult * GetColumns (const char *dbname, const char *table, const char *wild=0)
Int_t GetMaxIdentifierLength ()
Int_t CreateDataBase (const char *dbname)
Int_t DropDataBase (const char *dbname)
Int_t Reload ()
Int_t Shutdown ()
const char * ServerInfo ()
Bool_t StartTransaction ()
Bool_t Commit ()
Bool_t Rollback ()

Static Public Member Functions

static void SetDatimeFormat (const char *fmt="MM/DD/YYYY, HH24:MI:SS")
static const char * GetDatimeFormat ()

Private Attributes

Environment * fEnv
Connection * fConn
TString fInfo

Static Private Attributes

static const char * fgDatimeFormat

Detailed Description

Definition at line 35 of file TOracleServer.h.

Constructor & Destructor Documentation

TOracleServer::TOracleServer ( const char *  db,
const char *  uid,
const char *  pw 
)

format for converting date and time stamps into string

Definition at line 78 of file TOracleServer.cxx.

References CatchError, fConn, TSQLServer::fDB, fEnv, TSQLServer::fHost, TSQLServer::fPort, TSQLServer::fType, TUrl::GetFile(), TUrl::GetHost(), TUrl::GetOptions(), TUrl::GetPort(), TUrl::GetProtocol(), TString::Index(), TUrl::IsValid(), kNPOS, TObject::MakeZombie(), and TSQLServer::SetError().

TOracleServer::~TOracleServer (  ) 

Definition at line 133 of file TOracleServer.cxx.

References Close(), and IsConnected().

Member Function Documentation

void TOracleServer::Close ( Option_t *  opt = ""  )  [virtual]

Implements TSQLServer.

Definition at line 143 of file TOracleServer.cxx.

References CatchError, TSQLServer::ClearError(), fConn, fEnv, and TSQLServer::fPort.

Referenced by ~TOracleServer().

TSQLResult * TOracleServer::Query ( const char *  sql  )  [virtual]

Implements TSQLServer.

Definition at line 182 of file TOracleServer.cxx.

References CatchError, CheckConnect, fConn, and TSQLServer::SetError().

Referenced by GetColumns(), and GetTables().

Bool_t TOracleServer::Exec ( const char *  sql  )  [virtual]

Reimplemented from TSQLServer.

Definition at line 216 of file TOracleServer.cxx.

References CatchError, CheckConnect, fConn, kFALSE, kTRUE, and TSQLServer::SetError().

TSQLStatement * TOracleServer::Statement ( const char *  sql,
Int_t  niter = 100 
) [virtual]

Reimplemented from TSQLServer.

Definition at line 160 of file TOracleServer.cxx.

References CatchError, CheckConnect, fConn, fEnv, TSQLServer::fErrorOut, and TSQLServer::SetError().

Referenced by GetTableInfo(), GetTablesList(), and ServerInfo().

Bool_t TOracleServer::IsConnected (  )  const [inline, virtual]

Reimplemented from TSQLServer.

Definition at line 52 of file TOracleServer.h.

References fConn, and fEnv.

Referenced by ~TOracleServer().

Bool_t TOracleServer::HasStatement (  )  const [inline, virtual]

Reimplemented from TSQLServer.

Definition at line 53 of file TOracleServer.h.

References kTRUE.

Int_t TOracleServer::SelectDataBase ( const char *  dbname  )  [virtual]

Implements TSQLServer.

Definition at line 447 of file TOracleServer.cxx.

References CheckConnect.

TSQLResult * TOracleServer::GetDataBases ( const char *  wild = 0  )  [virtual]

Implements TSQLServer.

Definition at line 459 of file TOracleServer.cxx.

References CheckConnect.

TSQLResult * TOracleServer::GetTables ( const char *  dbname,
const char *  wild = 0 
) [virtual]

Implements TSQLServer.

Definition at line 246 of file TOracleServer.cxx.

References CheckConnect, TString::Data(), and Query().

TList * TOracleServer::GetTablesList ( const char *  wild = 0  )  [virtual]

Reimplemented from TSQLServer.

Definition at line 270 of file TOracleServer.cxx.

References TList::Add(), CheckConnect, Form(), TSQLStatement::GetString(), kTRUE, TSQLStatement::NextResultRow(), TSQLStatement::Process(), TCollection::SetOwner(), Statement(), and TSQLStatement::StoreResult().

TSQLTableInfo * TOracleServer::GetTableInfo ( const char *  tablename  )  [virtual]

Reimplemented from TSQLServer.

Definition at line 302 of file TOracleServer.cxx.

References TList::Add(), CheckConnect, TString::Contains(), TString::Data(), TString::Form(), TSQLStatement::GetInt(), TSQLStatement::GetString(), info, kFALSE, TSQLServer::kSQL_CHAR, TSQLServer::kSQL_DOUBLE, TSQLServer::kSQL_FLOAT, TSQLServer::kSQL_NONE, TSQLServer::kSQL_NUMERIC, TSQLServer::kSQL_TIMESTAMP, TSQLServer::kSQL_VARCHAR, TSQLStatement::NextResultRow(), TSQLStatement::Process(), Statement(), and TSQLStatement::StoreResult().

TSQLResult * TOracleServer::GetColumns ( const char *  dbname,
const char *  table,
const char *  wild = 0 
) [virtual]

Implements TSQLServer.

Definition at line 420 of file TOracleServer.cxx.

References CheckConnect, TString::Form(), and Query().

Int_t TOracleServer::GetMaxIdentifierLength (  )  [inline, virtual]

Reimplemented from TSQLServer.

Definition at line 60 of file TOracleServer.h.

Int_t TOracleServer::CreateDataBase ( const char *  dbname  )  [virtual]

Implements TSQLServer.

Definition at line 473 of file TOracleServer.cxx.

References CheckConnect.

Int_t TOracleServer::DropDataBase ( const char *  dbname  )  [virtual]

Implements TSQLServer.

Definition at line 484 of file TOracleServer.cxx.

References CheckConnect.

Int_t TOracleServer::Reload (  )  [virtual]

Implements TSQLServer.

Definition at line 496 of file TOracleServer.cxx.

References CheckConnect.

Int_t TOracleServer::Shutdown (  )  [virtual]

Implements TSQLServer.

Definition at line 508 of file TOracleServer.cxx.

References CheckConnect.

const char * TOracleServer::ServerInfo (  )  [virtual]

Implements TSQLServer.

Definition at line 520 of file TOracleServer.cxx.

References CheckConnect, TString::Data(), TSQLStatement::EnableErrorOutput(), fInfo, TSQLStatement::GetString(), kFALSE, TString::Length(), TSQLStatement::NextResultRow(), TSQLStatement::Process(), Statement(), and TSQLStatement::StoreResult().

Bool_t TOracleServer::StartTransaction (  )  [virtual]

Reimplemented from TSQLServer.

Definition at line 545 of file TOracleServer.cxx.

References Commit().

Bool_t TOracleServer::Commit (  )  [virtual]

Reimplemented from TSQLServer.

Definition at line 554 of file TOracleServer.cxx.

References CatchError, CheckConnect, fConn, kFALSE, and kTRUE.

Referenced by StartTransaction().

Bool_t TOracleServer::Rollback (  )  [virtual]

Reimplemented from TSQLServer.

Definition at line 570 of file TOracleServer.cxx.

References CatchError, CheckConnect, fConn, kFALSE, and kTRUE.

void TOracleServer::SetDatimeFormat ( const char *  fmt = "MM/DD/YYYY, HH24:MI:SS"  )  [static]

Definition at line 586 of file TOracleServer.cxx.

References fgDatimeFormat.

const char * TOracleServer::GetDatimeFormat (  )  [static]

Definition at line 596 of file TOracleServer.cxx.

References fgDatimeFormat.

Referenced by TOracleRow::GetRowData().

Member Data Documentation

Environment* TOracleServer::fEnv [private]

Definition at line 38 of file TOracleServer.h.

Referenced by Close(), IsConnected(), Statement(), and TOracleServer().

Connection* TOracleServer::fConn [private]

Definition at line 39 of file TOracleServer.h.

Referenced by Close(), Commit(), Exec(), IsConnected(), Query(), Rollback(), Statement(), and TOracleServer().

TString TOracleServer::fInfo [private]

Definition at line 40 of file TOracleServer.h.

Referenced by ServerInfo().

const char* TOracleServer::fgDatimeFormat [static, private]

Definition at line 42 of file TOracleServer.h.

Referenced by GetDatimeFormat(), and SetDatimeFormat().

The documentation for this class was generated from the following files:
Generated on Tue Jul 5 16:43:35 2011 for ROOT_528-00b_version by  doxygen 1.5.1