📄 otl3_comm.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>
<head>
<title>Users' Comments</title>
<meta name="GENERATOR"
content="Mozilla/3.03Gold (Win95; I) [Netscape]">
<meta name="AUTHOR" content="Sergei Kuchin">
<meta name="CREATED" content="19991023;13554093">
<meta name="CHANGEDBY" content="">
<meta name="CHANGED" content="19991026;22425675">
</head>
<body>
<h1 align="center">Users' Comments</h1>
<br>
<hr style="width: 100%; height: 2px;">
<p>Personally I would like to thank Sergei for his great work. I've
never had<br>
any problems with his code, and I've seen worse reads. OTL even saved
our company<br>
from having to shut down and pack up. I spent several weeks trying to
compile<br>
and run code using Oracle's OCCI in 64-bit Windows with Visual C++
2005, but<br>
they required version 2003. It was 2007 and you couldn't get any other
versions!<br>
I finally gave up and found OTL. Thinking it might work, I stayed up
all night<br>
porting much of the code. Things were at least 2-3 times as fast! If I
had<br>
any money, I'd feel like I owe some to this project. There should be a
paypal<br>
link somewhere.</p>
<p>
</p>
<hr>While it certainly doesn't have the visibility of Boost, I don't
know<br>
of any programmers using both databases and C++ who aren't at least<br>
aware of OTL.<br>
<p>
</p>
<hr>... is to get hold of the free and very excellent OTL (Oracle
Template
<br>
Library) from sourceforge (I think) and check out the demos and
<br>
docs. It is C++, it is STL and it is bleeding fantastic.
<br>
<br>
All you need to do is #include <otl4.h> and that is it. You also
get
<br>
the full source code as everything is defined in the *.h file. Not
<br>
only that, but it covers OCI7, OCI8, OCI9, DB2, ODBC etc as well - at
<br>
no extra cost.
<br>
<br>
These Russian programmers are some of the best I've seen !!!
<p></p>
<hr>> The [other] area bothers me is database access layer.
All these<br>
> database vendors promote JDBC because there is no standard C++ <br>
<br>
For the equivalent of JDBC, there's always the OTL.<br>
<p></p>
<hr>
<p></p>
<p>I have implemented your OTL library in one of the programs I wrote
replacing
the OO4O interface. <i><font color="#800000">I have noticed a major
performance
increase</font></i>.</p>
<p>
</p>
<hr>
<p></p>
<p>I've been very impressed with the performance of OTL, comparing it
with
our 4GL programs. <i><font color="#800000">The ability to have the
performance
gains from low-level OCI calls without having to actually *do* the
low-level
OCI calls is a great combination!</font></i></p>
<p>
</p>
<hr>
<p></p>
<p><font color="#000000">I received OTL and have since then been
experimenting
a lot with it. Starting with your sample application, we soon
developped
a performance test for db access with Pro*C vs OTL/OCI8. </font><i><font
color="#800000">It
turned out that with embedded SQL OTL is significantly superior to
Pro*C
as for our requirements. At this point I would like to send you thanks
and congratulations for your work of a real expert!</font></i></p>
<p>
</p>
<hr>
<p></p>
<p><font color="#000000">I just found the time to take the first steps
with your OTL and what should I say?</font><i><font color="#800000"> I
only needed a few minutes to get a test application to run! Very
impressive!</font></i></p>
<p><i><font color="#800000">The next steps I tried were some
performance
tests, so I played around with the arr_size parameter. My test
application
with OTL runs about 8 times faster than the raw version which I have
written
with direct OCI calls. Again: Very impressive!! Many thanks for your
excellent
work!</font></i></p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">Thanks for the help. OTL was a big success
in our benchmarks. Looks like Java 1.1.x is pretty severely crippled
when
it comes to performing on large multi-processor machines. C++/OTL isn't.</font></i></p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">Thanks Sergei...I am absolutely amazed at
what
you have done in one header file. It really blows my mind</font><font
color="#800040">.</font></i></p>
<p>
</p>
<hr>
<p></p>
<p><font color="#800000"><i>This is the coolest stuff I've ever seen
for
Oracle open/source! I'd appreciate your effort.</i>.</font></p>
<p>
</p>
<hr>
<p></p>
<p>It seems that I have finaly convinced the others,<i><font
color="#804000">
</font><font color="#800000">that Pro*C Suxx and OTL Rulez</font><font
color="#804000">.</font></i>
I just gave them the OTL-Version I used some months ago and when having
a look at my links I read, that theres a new version. Could you tell me
how to do this ? <font color="#800000"><i>Well I think you have been
told
thousands of times how great your work is, but I think I'll do it again</i>.</font></p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">OTL is great! Thank you for writing it!<br>
With Finest Regards for your most excellent work!</font></i></p>
<p>
</p>
<hr>
<p></p>
<p>You might be interested in OTL see "Oracle and Odbc Template Library
Programmer's Guide." <i><font color="#800000">I use it to access
Oracle
in TAO servers written in C++ (on unix byut OTL will work with anything)</font></i></p>
<p>
</p>
<hr>
<p></p>
<p>For Oracle database _anything_ - <i><font color="#800000">when
speed
is important, or large recordsets are being used - ODBC and DAO are crap</font>.</i>
They gobble up memory, and run incredibly slow. You didn't mention the
version of Oracle, but I've tested the following with v7.2 & 7.3
running
on UNIX servers, and WinNT Servers (and of course the GUI clients). <i><font
color="#800000">I
highly suggest a freeware class by Sergei Kuchin. An excellent utility
wrapper to the OCI API. It's called OTL ( Oracle Template Library
)...It
will end MANY headaches & long waits for huge queries. Of course,
your
still limited by your server, but that's a whole different game. </font></i></p>
<p>
</p>
<hr width="100%">
<p></p>
<p>Hi Sergei </p>
<p>I hope I'm not bothering you. I have just discovered your OTL code.
<i><font color="#800000">I replaced a ton of Oracle PRO/C code with it
and I am very impressed. I've increased in performance and descreased
the
code I need to write</font>.</i> As well, no repetitive code EXEC
DECLARE
etc. My question is:</p>
<p>I need to use the BLOB data type, and I was wondering if you could
describe
briefly what I need to do to add that functionally. I assume I will
need
to:</p>
<ol>
<p>create a type :f1<blob[size]></p>
<p>create the << >> operators.</p>
</ol>
<p>What else should I know before I dive in. </p>
<p>Thanks for any help and once again, <i>nice job.</i></p>
<p>
</p>
<hr>
<p></p>
<p>As I said, I work quite a bit with Perl so I get lazy. It does
everything
for me. When I want to do something, I just want to call a function. I
really don't care to know how it works. <i><font color="#800000">I
like
appliances. That's why I like what you have written. It lets me do what
I need to do without making me think about too much. Plus the tech
support
has proven to be significantly better than I would get from Oracle.</font></i></p>
<p>Thanks for the advice on the extra variables. I'll give what you
suggest
a try.</p>
<p>
</p>
<hr>
<p></p>
<p>Hi Sergei,</p>
<p>Yea, that was me with the NULLs. I got caught being a lazy on that
one.I
tried what you suggested <i><font color="#800000">for the ref cursors
and
it it worked, smooth as silk. Thanks a million.</font></i></p>
<p><i><font color="#800000">Even the tough guy programers who like to
massage
each bit by hand are impressed</font>. </i>I had spent some time
looking
at example 4, but always left in the fetch loop. <i><font
color="#800000">I
guess it never occurred to me that things could be so easy (meaning
well
implemented).</font></i></p>
<p><font color="#800000"><i>I am extremely interested in the next
version
of OTL</i>.</font> Let me know when its ready.</p>
<p>Again, thanks for the prompt help.</p>
<p>
</p>
<hr>
<p></p>
<p>As I said before, <i><font color="#800000">I think you have filled
a
big void in the C++/Oracle relationship, and I have found OTL to be an
extremely useful tool.</font> </i>I have developed apps under MSVC++
5.0
on NT and gcc (glibc) on Linux and AIX boxes for Oracle 8.0.5.</p>
<p>
</p>
<hr>
<p></p>
<p>We have been working with the Oracle Pro*C Precompiler for some time
and have experienced some trouble in using ORACLE nder DIGTAL UNIX with
multithreaded C++ programs. The input- and output-code having to be
used
when using threads and classes is so bad, that we do not want to
present
our buisness partners a program based on this code. The ORACLE support
told us something like "A C++ parser is not going to be implemented
in the future", so we began looking for an alternative and we seemed
to have found one : OTL. I just had one look at the sourcecode and <i><font
color="#800000">I
must say that using the OTL is sort of fun</font></i>. In contrast the
Pro*C was sort of a pain in the neck, whith tons of workarounds and
sometimes
having to spend weeks for solving a simple problem. My question now is
: Has anyone been able to make some experience with the OTL ? Does it
realy
work, even with more complicated SQL-commands ? Is it realy threadsafe
? Is there any more detailed information about it and are there any
known
bugs and problems ? I would appeciate any comments.</p>
<p>
</p>
<hr>
<p></p>
<p>I've tinkered some with the following: </p>
<p>Try the OTL (Oracle call interface Template library) by Sergei
Kuchin,
<a href="otl_1pg.htm">http://home.sprynet.com/~skuchin/otl_1pg.htm</a>.
<font color="#800000">T<i>hin wrapper over OCI, easy to use and high
performance.</i></font></p>
<p><i><font color="#800000">Its pretty slick C++ action that returns
data
from oracle as a stream.</font></i></p>
<p>
</p>
<hr>
<p></p>
<p>First, thanks a lot for replying that fast on my Oracle8 question.</p>
<p><i><font color="#800000">It worked like charm !</font></i></p>
<p>I'm running on a linux machine, with oracle installed on it.</p>
<p><i><font color="#800000">Good to know OTL has an responsive address
:)</font></i></p>
<p>
</p>
<hr>
<p></p>
<p>More power to you. <font color="#800000"><i>I think you really have
a very good & flexible framework, especially if you have an ODBC
implementation</i>.</font>
I wish you the best of luck.</p>
<p>
</p>
<hr>
<p></p>
<p>Obviously when your apps use odbc, pro*c or OCI (<font
color="#800000"><i>have
a look at OTL, the oracle template library for a nice freeware
oci-wrapper
btw</i>)</font> the oracle/pl/sql part isn't hard. C/C++ won't be a
problem
either (try GCC, MS-VC++, Borland/Inprise C++, ZortechC++ etc),
especially
when your programs are ansi-compiliant. I don't thing the posix
"emulator"/subsystem
will be of much help if your apps wander away from "hello world"
too much...</p>
<p>
</p>
<hr>
<p></p>
<p>I am doing some test with the OCI OTL V2.0.0. My question is : do
you
also have somewhere calls concerning Oracle-pipes. <i><font
color="#800000">Congratulation
on the OTL by the way.</font></i></p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -