---

Connection.h

#ifndef __CONNECTION_H_
#define __CONNECTION_H_

#include "ocicpp.h"
#include "Cursor.h"
#include "BFile.h"

#include "AQQueue.h"

#if ( OCILIBVERMAJOR>=8 && OCILIBVERMINOR>=1 ) || DOXYGEN
#include "TLob.h"
#endif

namespace OCICPP {

using std::string;

class Connection {
private:
    OCIEnv *envhp;
    OCIServer *srvhp;
    OCIError *errhp;
    OCISvcCtx *svchp;
    OCISession *authp;
    OCITrans *trans; /* Only one transaction allowed per connection */
    sword status;
    int Initialized;
public:
    Connection();
    Connection(OCIEnv *env,const string &tnsname,const string &user,const string &password);
    ~Connection(); 
    void drop();
    void init(OCIEnv *env,const string &tnsname,const string &user,const string &password); 
    /* Obsolete should not be used. */
    Cursor *execQuery(const string &);
    /* Cursor execQuery(const string &); */
    /* Use this one... */
    void execQuery(const string &,Cursor &,int prefetch=1);
    void execUpdate(const string &);
    /* Transactions */
    void transStart(int flags=SERIALIZABLE);
    void transCommit();
    void transRollback();
    /* Advanced query execution mechanism */
    void prepare(const string &sql,Cursor &cur,int prefetch=1);
    /* Advanced Queueing */ 
    void getQueue(std::string& queue_name, OCICPP::AQQueue& queue);
    /* Tlob/BFile support */
    void createBFile(const string &,const string &,BFile &);
#if ( OCILIBVERMAJOR>=8 && OCILIBVERMINOR>=1 ) || DOXYGEN
    void createTLob(int lobtype,int cachemode,TLob &);
#endif
    /* Misc. */
    string serverVersion();

};


}


#endif

---