Very old 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-2024, Sergei Kuchin, email: skuchin@gmail.com, skuchin@gmail.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. THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.