OTL v4

1 Set trace level to check what OTL done

 

    unsigned int trace_level = 0x1 | 0x 2 | 0x4 | 0x8 | 0x10 | 0x20;

    #define OTL_TRACE_LEVEL trace_level

    #define OTL_TRACE_LINE_PREFIX "OTL  "

    #define OTL_TRACE_LINE_SUFFIX std::endl

 

2 How to use OTL

 

   a)  define  some MARCO that the OTL library needed

           

  

   unsigned int trace_level = 0x1 | 0x2 | 0x4 | 0x8 |0x10 | 0x20;
    #define OTL_ORA9I
    #define OTL_STL
    #define OTL_ANSI_CPP
    #define OTL_TRACE_LEVEL         trace_level
    #define OTL_TRACE_STREAM        cerr
    #define OTL_TRACE_LINE_PREFIX   "OTL "
    #define OTL_TRACE_LINE_SUFFIX   std::endl

    #include <otlv4.h>

 

    b) intialize otl

 

      otl_connect::otl_initialize(1) ; // 1 means in mutiple-thread

   

   c) create otl_connect object

 

       otl_connect * pConn = new otl_connect()

 

        //connect database

      

       if (!pConn -> connected)

                 pConn->rlogon("usr/pwd")

 

   d) create query stream object

 

       otl_stream query(1, "here is the sql statement",*pConn);

 

   e) exit

   

          delete otl_connect objects

         

          otl_connect::otl_terminate()

  

 

   Note: otl library will throw otl_exception , so please catch exception in the above operation.