library: libOracle
#include "TOracleServer.h"

TOracleServer


class description - header file - source file - inheritance tree (.pdf)

class TOracleServer : public TSQLServer

Inheritance Chart:
TObject
<-
TSQLServer
<-
TOracleServer

    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)

Data Members

    private:
Environment* fEnv environment of Oracle access Connection* fConn connection to Oracle server

Class Description

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.
~TOracleServer()
 Close connection to Oracle DB server.
void Close(Option_t *)
 Close connection to Oracle DB server.
TSQLStatement * Statement(const char *sql, Int_t niter)
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.
Bool_t Exec(const char* sql)
 Execute sql command wich does not produce any result set.
 Return kTRUE if succesfull
TList* GetTablesList(const char* wild)
TSQLTableInfo * GetTableInfo(const char* tablename)
 Produces SQL table info
 Object must be deleted by user
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.
const char * ServerInfo()
 Return server info.
 NOT IMPLEMENTED.
Bool_t StartTransaction()
 Call Commit() to submit all chanes, done before.
 Commit() ot Rollback() must be used to complete submitted actions or cancel them
Bool_t Commit()
 Commits all changes made since the previous Commit() or Rollback()
 Return kTRUE if OK
Bool_t Rollback()
 Drops all changes made since the previous Commit() or Rollback()
 Return kTRUE if OK
TOracleServer(const char *db, const char *uid, const char *pw)
Bool_t IsConnected()
Bool_t IsSupportStatement()
Int_t SelectDataBase(const char *dbname)
Int_t GetMaxIdentifierLength()
Int_t CreateDataBase(const char *dbname)
Int_t DropDataBase(const char *dbname)

Author: Yan Liu and Shaowen Wang 23/11/04
Last update: root/oracle:$Name: $:$Id: TOracleServer.cxx,v 1.13 2006/06/25 18:43:24 brun Exp $
Copyright (C) 1995-2005, Rene Brun and Fons Rademakers. *


ROOT page - Class index - Class Hierarchy - Top of the page

This page has been automatically generated. If you have any comments or suggestions about the page layout send a mail to ROOT support, or contact the developers with any questions or problems regarding ROOT.