| library: libOracle #include "TOracleServer.h" |
| Inheritance Chart: | |||||||||||||
|
public:
TOracleServer(const char* db, const char* uid, const char* pw)
TOracleServer(const TOracleServer&)
~TOracleServer()
static TClass* Class()
virtual void Close(Option_t* opt = "")
virtual Bool_t Commit()
virtual Int_t CreateDataBase(const char* dbname)
virtual Int_t DropDataBase(const char* dbname)
virtual Bool_t Exec(const char* sql)
virtual TSQLResult* GetColumns(const char* dbname, const char* table, const char* wild = "0")
virtual TSQLResult* GetDataBases(const char* wild = "0")
virtual Int_t GetMaxIdentifierLength()
virtual TSQLTableInfo* GetTableInfo(const char* tablename)
virtual TSQLResult* GetTables(const char* dbname, const char* wild = "0")
virtual TList* GetTablesList(const char* wild = "0")
virtual TClass* IsA() const
virtual Bool_t IsConnected() const
virtual Bool_t IsSupportStatement() const
TOracleServer& operator=(const TOracleServer&)
virtual TSQLResult* Query(const char* sql)
virtual Int_t Reload()
virtual Bool_t Rollback()
virtual Int_t SelectDataBase(const char* dbname)
virtual const char* ServerInfo()
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)
private:
Environment* fEnv environment of Oracle access
Connection* fConn connection to Oracle server
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.
Execute SQL command. Result object must be deleted by the user. Returns a pointer to a TSQLResult object if successful, 0 otherwise.
Execute sql command wich does not produce any result set. Return kTRUE if succesfull
Produces SQL table info Object must be deleted by user
Reload permission tables. Returns 0 if successful, non-zero otherwise. User must have reload permissions. NOT IMPLEMENTED.
Shutdown the database server. Returns 0 if successful, non-zero otherwise. User must have shutdown permissions. NOT IMPLEMENTED.
Call Commit() to submit all chanes, done before. Commit() ot Rollback() must be used to complete submitted actions or cancel them
Commits all changes made since the previous Commit() or Rollback() Return kTRUE if OK
Drops all changes made since the previous Commit() or Rollback() Return kTRUE if OK