• Linux
  
• psqlodbc.so,  psqlodbcw.so should be used with #define OTL_ODBC_POSTGRESQL
• libodbcpsql.so should be used with #define OTL_ODBC
  
• Solaris
  
• libodbcpsql.so should be used with #define OTL_ODBC_POSTGRESQL
  
• Windows
• pgsqlodbc30a.dll, pgsqlodbc35w.dll should be used with #define OTL_ODBC_POSTGRESQL
  

• the named notation for bind variables / placeholders
• TT_PRFEFETCH_COUNT ([0..128] range)
  

• the named notation for bind variables / placeholders
• TT_PRFEFETCH_COUNT ([1..128] range)
  

#define OTL_BIGINT __int64 // VC++, Borland C++

#define OTL_BIGINT long long // GNU C++

#if defined(_MSC_VER) // VC++

#define OTL_BIGINT __int64

#define OTL_STR_TO_BIGINT(str,n)                \
{                                               \
  n=_atoi64(str);                               \
}

#define OTL_BIGINT_TO_STR(n,str)                \
{                                               \
  _i64toa(n,str,10);                            \
}
#endif

• otl_tmpl_exception(const char *amsg, const int acode, const char *sqlstm,
                                   const char *varinfo, const void *input_string,
                                   int input_string_size)
  
• otl_tmpl_exception(const char *amsg, const int acode,
                                  const char *sqlstm = nullptr,
                                  const char *varinfo = nullptr)
  

A need for this kind of thing arises when more context has to be passed into the base class which OTL exception is derived from. For example:

#define OTL_EXCEPTION_DERIVED_FROM my_base_exception
#define OTL_EXCEPTION_INITIALIZED_WITH_BASE_CLASS_CONSTRUCTOR_CALL \
my_base_exception(amsg, acode, sqlstm, varinfo)

#define OTL_ODBC_STRING_TO_TIMESTAMP(str,tm)            \
{                                                       \
  sscanf(str,                                           \
         "%04d-%02d-%02d %02d:%02d:%02d.%06ld%hd",      \
         &tm.year,                                      \
         &tm.month,                                     \
         &tm.day,                                       \
         &tm.hour,                                      \
         &tm.minute,                                    \
         &tm.second,                                    \
         &tm.fraction,                                  \
         &tm.tz_hour);                                  \
}

#define OTL_ODBC_STRING_TO_TIMESTAMP(str,tm)            \
{                                                       \
  swscanf(str,                                          \
         L"%04d-%02d-%02d %02d:%02d:%02d.%06ld%hd",     \
         &tm.year,                                      \
         &tm.month,                                     \
         &tm.day,                                       \
         &tm.hour,                                      \
         &tm.minute,                                    \
         &tm.second,                                    \
         &tm.fraction,                                  \
         &tm.tz_hour);                                  \
}

#define OTL_ODBC_STRING_TO_TIMESTAMP(str,tm)              \
{                                                         \
  sscanf(str,                                             \
           "%04d-%02d-%02d %02d:%02d:%02d.%07ld %hd:%hd", \
           &tm.year,                                      \
           &tm.month,                                     \
           &tm.day,                                       \
           &tm.hour,                                      \
           &tm.minute,                                    \
           &tm.second,                                    \
           &tm.fraction,                                  \
           &tm.tz_hour,                                   \
           &tm.tz_minute);                                \
}

#define OTL_ODBC_STRING_TO_TIMESTAMP(str,tm)              \
{                                                         \
  swscanf(str,                                            \
           L"%04d-%02d-%02d %02d:%02d:%02d.%07ld %hd:%hd",\
           &tm.year,                                      \
           &tm.month,                                     \
           &tm.day,                                       \
           &tm.hour,                                      \
           &tm.minute,                                    \
           &tm.second,                                    \
           &tm.fraction,                                  \
           &tm.tz_hour,                                   \
           &tm.tz_minute);                                \
}

#define OTL_ODBC_TIMESTAMP_TO_STRING(tm,str)            \
{                                                       \
  sprintf(str,                                          \
         "%04d-%02d-%02d %02d:%02d:%02d.%06ld %+hd",    \
          tm.year,                                      \
          tm.month,                                     \
          tm.day,                                       \
          tm.hour,                                      \
          tm.minute,                                    \
          tm.second,                                    \
          tm.fraction,                                  \
          tm.tz_hour);                                  \
}

#define OTL_ODBC_TIMESTAMP_TO_STRING(tm,str)             \
{                                                        \
  swprintf(str,                                          \
           L"%04d-%02d-%02d %02d:%02d:%02d.%06ld %+hd",  \
           tm.year,                                      \
           tm.month,                                     \
           tm.day,                                       \
           tm.hour,                                      \
           tm.minute,                                    \
           tm.second,                                    \
           tm.fraction,                                  \
           tm.tz_hour);                                  \
}

#define OTL_ODBC_TIMESTAMP_TO_STRING(tm,str)                    \
{                                                               \
  sprintf(str,                                                  \
            "%04d-%02d-%02d %02d:%02d:%02d.%07ld %+hd:%hd",     \
            tm.year,                                            \
            tm.month,                                           \
            tm.day,                                             \
            tm.hour,                                            \
            tm.minute,                                          \
            tm.second,                                          \
            tm.fraction,                                        \
            tm.tz_hour,                                         \
            tm.tz_minute);                                      \
}

for MS SQL 2008 and #define OTL_UNICODE:

#define OTL_ODBC_TIMESTAMP_TO_STRING(tm,str)                    \
{                                                               \
  swprintf(str,                                                 \
           L"%04d-%02d-%02d %02d:%02d:%02d.%07ld %+hd:%hd",     \
           tm.year,                                             \
           tm.month,                                            \ 
           tm.day,                                              \
           tm.hour,                                             \
           tm.minute,                                           \
           tm.second,                                           \
           tm.fraction,                                         \
           tm.tz_hour,                                          \
           tm.tz_minute);                                       \
}

#define OTL_ORA_OCI_ENV_CREATE
#define OTL_ORA_OCI_ENV_CREATE_MODE (OCI_THREADED|OCI_OBJECT|OCI_EVENTS)

#if defined(__GNUC__) // GNU C++

#include <stdlib.h>

#define OTL_BIGINT long long

#define OTL_STR_TO_BIGINT(str,n)                \
{                                               \
  n=strtoll(str,0,10);                          \
}

#define OTL_BIGINT_TO_STR(n,str)                \
{                                               \
  sprintf(str,"%lld",n);                        \
}


#endif

• #define OTL_TRACE_LEVEL specifies a level of OTL tracing. Each type of tracing is represented by its own bit in the whole trace level unsigned  int value:
  
  
1. 0x1 -- traces the following functions of the otl_connect class (1st level of tracing): rlogon(), logoff(), commit(), rollback(), auto_commit_on(), auto_commit_off()
   
2. 0x2 -- traces otl_cursor::direct_exec(), direct execution of static SQL statements, no otl_streams (2nd level of tracing).
   
3. 0x4 -- traces the following functions of the otl_stream class: open(), close()
4. 0x8 -- traces internal "execute SQL statement" function, internal "fetch the first bacth of rows" function, internal "fetch the next batch of rows" function (3rd level of tracing).
5. 0x10 -- traces the operator >> and << functions of the otl_stream class (4th level of tracing)
6. 0x20 -- traces all otl_exception's raised by OTL.



• #define OTL_TRACE_STREAM specifies a log stream variable, or a function call that returns a file stream reference. What is defined by this #define is used as an output file stream variable inside OTL.
  
  
• #define OTL_TRACE_LINE_PREFIX can be used to override the default OTL trace line prefix: "OTL TRACE ==>". If it is more convenient to have something different from the default, say, for running a Perl script on an OTL log file to mine for patterns.
  
  
• #define OTL_TRACE_LINE_SUFFIX can be used to override the default OTL trace line suffix: "\n". If it is more convenient to have something different from the default, say, for running a Perl script on an OTL log file to mine for patterns.
  
  
• #define OTL_TRACE_ENABLE_STREAM_LABELS can be used to enable logging of otl_stream labels instead of SQL statement bodies. See The Oracle, DB2-CLI, and ODBC specific otl_stream descriptions for more detail.
  
  
• #define OTL_TRACE_LEVEL_NOCHECK_ON_LOGON can be used to enable the "logon" OTL trace entry unconditionally (see examples below).
  

      unsigned int my_trace_level=
        0x1 | // 1st level of tracing
        0x2 | // 2nd level of tracing
        0x4 | // 3rd level of tracing
        0x8 | // 4th level of tracing
        0x10| // 5th level of tracing
        0x20; // 6th level of tracing
     // each level of tracing is represented by its own bit, 
     // so levels of tracing can be combined in an arbitrary order.

     #define OTL_TRACE_LEVEL my_trace_level 
        // enables OTL tracing, and use my_trace_level 
        // as a trace control variable.

     #define OTL_TRACE_STREAM cerr 
        // directs all OTL tracing to cerr

     #define OTL_TRACE_LINE_PREFIX "MY OTL TRACE ==> " 
        // redefines the default OTL trace line prefix. 
        // This #define is optional

     #define OTL_TRACE_LINE_SUFFIX std::endl 
        // redefines the default OTL trace line suffix. 
        // This #define is optional