Older OTL releases
- Oracle call interface Template Library (OTL), Version
1.0
This is the first implementation of the OTL technology. It works with
the Oracle Call Interface 7.x series. Besides the C++ library, the
page contains Pro*OTL / Pre-Pro*C preprocessor 1.0 which generates OTL
or Pro*C compatible code. This version of the OTL was released in late 1996.
- Oracle Call Interface Template Library (OTL), Version
2.0
This is the second implementation of the OTL technology. There are, in
fact, two OTL libraries: the OTL for the Oracle Call Interface 7.x
(OCI7) and the OTL for the Oracle Call Interface 8.x (OCI8). OTL 1.0
was enhanced and the same framework was migrated to the OCI8. This
version of the OTL was released in the fall of 1998.
- Odbc Template Library (OTL), Version 2.1
This is the implementation of the OTL technology for the ODBC API. It
works with ODBC drivers which are compliant with the ODBC
specification 2.5 or higher. Basically, OTL 2.0 for OCI was migrated
to ODBC and then tested with as many ODBC drivers as it was possible
at the time.
Here is the list of the database backends and ODBC
drivers the OTL for ODBC was tested with:
- Oracle 8.0.3 with the Oracle ODBC driver for Oracle 8.0.3
- Oracle 8.0.4 with the Oracle ODBC driver for Oracle 8.0.4
- Oracle 8.0.5 with the Oracle ODBC driver for Oracle 8.0.5
- MS SQL Server 6.5 with the ODBC driver for MS SQL Server 6.5
- MS SQL Server 7.0 with the ODBC driver for MS SQL Server 7.0
- IBM DB2 5.2 with the ODBC driver for DB2 5.2
- SQL Anywhere 6.x (Sybase 11.x series) with the ODBC driver for SQL
Anywhere 6.x
All of these ODBC drivers support bulk operations in SELECT, INSERT,
UPDATE and DELETE statements. Due to that fact, the OTL for ODBC is
very similar to the OTL for OCI7/OCI8 by performance, maybe with 3-5%
degradation.
This version of the OTL for ODBC was released in early 1999.
Go Home
Copyright © 1996, 2001, Sergei Kuchin, email: skuchin@sprynet.com,
kuchin@hotmail.com
.
Permission to use, copy, modify and redistribute this document for
any purpose is hereby granted without fee, provided that the above copyright
notice appear in all copies.