class TOracleServer: public TSQLServer
TOracleServer This class implements an OCCI interface to Oracle data bases. It uses the instantclient10 software available from Oracle. To install this client software do: 1) Download Instant Client Packages (4 files) from: http://www.oracle.com/technology/software/tech/oci/instantclient/index.html 2) Unzip the files into instantclient10_1 (Mac OS X example here): unzip instantclient-basic-macosx-10.1.0.3.zip unzip instantclient-sqlplus-macosx-10.1.0.3.zip unzip instantclient-sdk-macosx-10.1.0.3.zip unzip instantclient-jdbc-macosx-10.1.0.3.zip 3) Create two symbolic links for the files that have the version appended: ln -s libclntsh.dylib.10.1 libclntsh.dylib ln -s libocci.dylib.10.1 libocci.dylib 4) Add instantclient10_1 directory to your (DY)LD_LIBRARY_PATH in your .profile: export DYLD_LIBRARY_PATH="<pathto>/instantclient10_1" Use DY only on Mac OS X. 5) If you also want to use the sqlplus command line app add also export SQLPATH="<pathto>/instantclient10_1" 6) If you want to connect to a remote db server you will also need to create a tnsname.ora file which describes the local_name for the remote db servers (at CERN most public machines have this file in /etc). If it is not in /etc create TNS_ADMIN: export TNS_ADMIN="<path-to-dir-containing-tnsname.ora>" 7) Test it our with the sqlplus command line app: sqlplus [username][/password]@<local_name> or sqlplus [username][/password]@//[hostname][:port][/database] ATTENTION: This plugin will not work on Mac OS X / Intel as Oracle has no intention to release a universal binary of the instantclient libraries.
Function Members (Methods)
public:
| TOracleServer(const TOracleServer&) | |
| TOracleServer(const char* db, const char* uid, const char* pw) | |
| virtual | ~TOracleServer() |
| void | TObject::AbstractMethod(const char* method) const |
| virtual void | TObject::AppendPad(Option_t* option = "") |
| virtual void | TObject::Browse(TBrowser* b) |
| static TClass* | Class() |
| virtual const char* | TObject::ClassName() const |
| virtual void | TObject::Clear(Option_t* = "") |
| virtual TObject* | TObject::Clone(const char* newname = "") const |
| virtual void | Close(Option_t* opt = "") |
| virtual Bool_t | Commit() |
| virtual Int_t | TObject::Compare(const TObject* obj) const |
| static TSQLServer* | TSQLServer::Connect(const char* db, const char* uid, const char* pw) |
| virtual void | TObject::Copy(TObject& object) const |
| virtual Int_t | CreateDataBase(const char* dbname) |
| virtual void | TObject::Delete(Option_t* option = "")MENU |
| virtual Int_t | TObject::DistancetoPrimitive(Int_t px, Int_t py) |
| virtual void | TObject::Draw(Option_t* option = "") |
| virtual void | TObject::DrawClass() constMENU |
| virtual TObject* | TObject::DrawClone(Option_t* option = "") constMENU |
| virtual Int_t | DropDataBase(const char* dbname) |
| virtual void | TObject::Dump() constMENU |
| virtual void | TSQLServer::EnableErrorOutput(Bool_t on = kTRUE) |
| virtual void | TObject::Error(const char* method, const char* msgfmt) const |
| virtual Bool_t | Exec(const char* sql) |
| virtual void | TObject::Execute(const char* method, const char* params, Int_t* error = 0) |
| virtual void | TObject::Execute(TMethod* method, TObjArray* params, Int_t* error = 0) |
| virtual void | TObject::ExecuteEvent(Int_t event, Int_t px, Int_t py) |
| virtual void | TObject::Fatal(const char* method, const char* msgfmt) const |
| virtual TObject* | TObject::FindObject(const char* name) const |
| virtual TObject* | TObject::FindObject(const TObject* obj) const |
| virtual TSQLResult* | GetColumns(const char* dbname, const char* table, const char* wild = 0) |
| virtual TSQLResult* | GetDataBases(const char* wild = 0) |
| static const char* | GetDatimeFormat() |
| const char* | TSQLServer::GetDB() const |
| const char* | TSQLServer::GetDBMS() const |
| virtual Option_t* | TObject::GetDrawOption() const |
| static Long_t | TObject::GetDtorOnly() |
| virtual Int_t | TSQLServer::GetErrorCode() const |
| virtual const char* | TSQLServer::GetErrorMsg() const |
| static const char* | TSQLServer::GetFloatFormat() |
| const char* | TSQLServer::GetHost() const |
| virtual const char* | TObject::GetIconName() const |
| virtual Int_t | GetMaxIdentifierLength() |
| virtual const char* | TObject::GetName() const |
| virtual char* | TObject::GetObjectInfo(Int_t px, Int_t py) const |
| static Bool_t | TObject::GetObjectStat() |
| virtual Option_t* | TObject::GetOption() const |
| Int_t | TSQLServer::GetPort() const |
| virtual TSQLTableInfo* | GetTableInfo(const char* tablename) |
| virtual TSQLResult* | GetTables(const char* dbname, const char* wild = 0) |
| virtual TList* | GetTablesList(const char* wild = 0) |
| virtual const char* | TObject::GetTitle() const |
| virtual UInt_t | TObject::GetUniqueID() const |
| virtual Bool_t | TObject::HandleTimer(TTimer* timer) |
| virtual ULong_t | TObject::Hash() const |
| virtual Bool_t | HasStatement() const |
| virtual Bool_t | TSQLServer::HasTable(const char* tablename) |
| virtual void | TObject::Info(const char* method, const char* msgfmt) const |
| virtual Bool_t | TObject::InheritsFrom(const char* classname) const |
| virtual Bool_t | TObject::InheritsFrom(const TClass* cl) const |
| virtual void | TObject::Inspect() constMENU |
| void | TObject::InvertBit(UInt_t f) |
| virtual TClass* | IsA() const |
| virtual Bool_t | IsConnected() const |
| virtual Bool_t | TObject::IsEqual(const TObject* obj) const |
| virtual Bool_t | TSQLServer::IsError() const |
| virtual Bool_t | TObject::IsFolder() const |
| Bool_t | TObject::IsOnHeap() const |
| virtual Bool_t | TObject::IsSortable() const |
| Bool_t | TObject::IsZombie() const |
| virtual void | TObject::ls(Option_t* option = "") const |
| void | TObject::MayNotUse(const char* method) const |
| virtual Bool_t | TObject::Notify() |
| static void | TObject::operator delete(void* ptr) |
| static void | TObject::operator delete(void* ptr, void* vp) |
| static void | TObject::operator delete[](void* ptr) |
| static void | TObject::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) |
| TOracleServer& | operator=(const TOracleServer&) |
| virtual void | TObject::Paint(Option_t* option = "") |
| virtual Int_t | TSQLServer::Ping() |
| virtual Bool_t | TSQLServer::PingVerify() |
| virtual void | TObject::Pop() |
| virtual void | TObject::Print(Option_t* option = "") const |
| virtual TSQLResult* | Query(const char* sql) |
| virtual Int_t | TObject::Read(const char* name) |
| virtual void | TObject::RecursiveRemove(TObject* obj) |
| virtual Int_t | Reload() |
| void | TObject::ResetBit(UInt_t f) |
| virtual Bool_t | Rollback() |
| virtual void | TObject::SaveAs(const char* filename = "", Option_t* option = "") constMENU |
| virtual void | TObject::SavePrimitive(basic_ostream<char,char_traits<char> >& out, Option_t* option = "") |
| virtual Int_t | SelectDataBase(const char* dbname) |
| virtual const char* | ServerInfo() |
| void | TObject::SetBit(UInt_t f) |
| void | TObject::SetBit(UInt_t f, Bool_t set) |
| static void | SetDatimeFormat(const char* fmt = "MM/DD/YYYY, HH24:MI:SS") |
| virtual void | TObject::SetDrawOption(Option_t* option = "")MENU |
| static void | TObject::SetDtorOnly(void* obj) |
| static void | TSQLServer::SetFloatFormat(const char* fmt = "%e") |
| static void | TObject::SetObjectStat(Bool_t stat) |
| virtual void | TObject::SetUniqueID(UInt_t uid) |
| virtual void | ShowMembers(TMemberInspector& insp, char* parent) |
| virtual Int_t | Shutdown() |
| virtual Bool_t | StartTransaction() |
| virtual TSQLStatement* | Statement(const char* sql, Int_t niter = 100) |
| virtual void | Streamer(TBuffer& b) |
| void | StreamerNVirtual(TBuffer& b) |
| virtual void | TObject::SysError(const char* method, const char* msgfmt) const |
| Bool_t | TObject::TestBit(UInt_t f) const |
| Int_t | TObject::TestBits(UInt_t f) const |
| virtual void | TObject::UseCurrentStyle() |
| virtual void | TObject::Warning(const char* method, const char* msgfmt) const |
| virtual Int_t | TObject::Write(const char* name = 0, Int_t option = 0, Int_t bufsize = 0) |
| virtual Int_t | TObject::Write(const char* name = 0, Int_t option = 0, Int_t bufsize = 0) const |
protected:
| void | TSQLServer::ClearError() |
| virtual void | TObject::DoError(int level, const char* location, const char* fmt, va_list va) const |
| void | TObject::MakeZombie() |
| void | TSQLServer::SetError(Int_t code, const char* msg, const char* method = 0) |
Data Members
public:
| enum TSQLServer::ESQLDataTypes { | kSQL_NONE | |
| kSQL_CHAR | ||
| kSQL_VARCHAR | ||
| kSQL_INTEGER | ||
| kSQL_FLOAT | ||
| kSQL_DOUBLE | ||
| kSQL_NUMERIC | ||
| kSQL_BINARY | ||
| kSQL_TIMESTAMP | ||
| }; | ||
| enum TObject::EStatusBits { | kCanDelete | |
| kMustCleanup | ||
| kObjInCanvas | ||
| kIsReferenced | ||
| kHasUUID | ||
| kCannotPick | ||
| kNoContextMenu | ||
| kInvalidObject | ||
| }; | ||
| enum TObject::[unnamed] { | kIsOnHeap | |
| kNotDeleted | ||
| kZombie | ||
| kBitMask | ||
| kSingleKey | ||
| kOverwrite | ||
| kWriteDelete | ||
| }; |
protected:
| TString | TSQLServer::fDB | currently selected DB |
| Int_t | TSQLServer::fErrorCode | error code of last operation |
| TString | TSQLServer::fErrorMsg | error message of last operation |
| Bool_t | TSQLServer::fErrorOut | enable error output |
| TString | TSQLServer::fHost | host to which we are connected |
| Int_t | TSQLServer::fPort | port to which we are connected |
| TString | TSQLServer::fType | type of DBMS (MySQL, Oracle, SysBase, ...) |
| static const char* | TSQLServer::fgFloatFmt | ! printf argument for floats and doubles, either "%f" or "%e" or "%10f" and so on |
private:
| Connection* | fConn | connection to Oracle server |
| Environment* | fEnv | environment of Oracle access |
| TString | fInfo | info string with Oracle version information |
| static const char* | fgDatimeFormat | ! format for converting date and time stamps into string |
Class Charts
Function documentation
TOracleServer(const char* db, const char* uid, const char* pw)
Open a connection to a Oracle DB server. The db arguments should be of the form "oracle://connection_identifier[/<database>]", e.g.: "oracle://cmscald.fnal.gov/test". The uid is the username and pw the password that should be used for the connection.
TSQLStatement * Statement(const char* sql, Int_t niter = 100)
TSQLResult * Query(const char* sql)
Execute SQL command. Result object must be deleted by the user. Returns a pointer to a TSQLResult object if successful, 0 otherwise.
TSQLResult * GetTables(const char* dbname, const char* wild = 0)
List all tables in the specified database. Wild is for wildcarding "t%" list all tables starting with "t". Returns a pointer to a TSQLResult object if successful, 0 otherwise. The result object must be deleted by the user.
TList* GetTablesList(const char* wild = 0)
TSQLTableInfo * GetTableInfo(const char* tablename)
Produces SQL table info Object must be deleted by user
TSQLResult * GetColumns(const char* dbname, const char* table, const char* wild = 0)
List all columns in specified table in the specified database. Wild is for wildcarding "t%" list all columns starting with "t". Returns a pointer to a TSQLResult object if successful, 0 otherwise. The result object must be deleted by the user.
Int_t SelectDataBase(const char* dbname)
Select a database. Returns 0 if successful, non-zero otherwise. NOT IMPLEMENTED.
TSQLResult * GetDataBases(const char* wild = 0)
List all available databases. Wild is for wildcarding "t%" list all databases starting with "t". Returns a pointer to a TSQLResult object if successful, 0 otherwise. The result object must be deleted by the user. NOT IMPLEMENTED.
Int_t CreateDataBase(const char* dbname)
Create a database. Returns 0 if successful, non-zero otherwise. NOT IMPLEMENTED.
Int_t DropDataBase(const char* dbname)
Drop (i.e. delete) a database. Returns 0 if successful, non-zero otherwise. NOT IMPLEMENTED.
Int_t Reload()
Reload permission tables. Returns 0 if successful, non-zero otherwise. User must have reload permissions. NOT IMPLEMENTED.
Int_t Shutdown()
Shutdown the database server. Returns 0 if successful, non-zero otherwise. User must have shutdown permissions. NOT IMPLEMENTED.
void SetDatimeFormat(const char* fmt = "MM/DD/YYYY, HH24:MI:SS")
set format for converting timestamps or date field into string
default value is "MM/DD/YYYY, HH24:MI:SS"
const char* GetDatimeFormat()
return value of actul convertion format from timestamps or date to string
TOracleServer(const char* db, const char* uid, const char* pw)