otl3_comm.htm

ISO_C++:C++_OTL开发文档

<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">I was very impressed by your OTL
implementation!</font></i>
I wonder about one thing: Does it support Date data type ?</p>
<p>
</p>
<hr>
<p></p>
<p>Hello,</p>
<p><i><font color="#800000">thanks for your OTL , and it's great for
STL
programmers,</font></i> but do you have (or where can found) a
NO-TEMPLATE
version?</p>
<p>
</p>
<hr>
<p></p>
<p>Dear Mr. Kuchin</p>
<p><i><font color="#800000">I'm a happy OTL user.</font></i></p>
<p>When using the 'otl_out_stream::operator&lt;&lt;(const char* s)'
with
buffer that...</p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">Thnx again, exelent library!</font></i></p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">I have found OTL to be a great class
library,
it's really easy to use. Thanks for giving it for free.</font></i>I
have
several questions however, which concerns my use of OTL (OCI 8 version)
in a program.</p>
<p>
</p>
<hr>
<p></p>
<p>Thank you very much for your help! It is really appreciated. <i><font
 color="#800000">The
OTL library seems like a very interesting approach. It definitely seems
to offer a better alternative to what we had.</font></i></p>
<p>Thanks again!</p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">I just downloaded your freeware OCI class
library
and built an test application with it on Solaris - Seems to work great!!</font></i>
We have a lot of code built with Oracle PRO*C/C++ which I would like to
stay away from for anything we do in the future. </p>
<p>Took a look at your home page - Do you still work for AiC? I have
been
working for them in Atlanta since December '95.</p>
<p>
</p>
<hr>
<p></p>
<p>I was just wondering if you had any sort of general performance
comparisons
between your amazing looking OTL and actually using Oracle's OCI. <i><font
 color="#800000">Obviously
OTL is MILES ahead with respect to development time,</font></i> but I
was
curious as to whether there are any notable performance decreases when
utilizing OTL vs. OCI. If you have any of this information, I would
bemost
interested! <i><font color="#800000">After studying Oracle's OCI, OTL
looks
like a God-send at this point! </font></i></p>
<p>Much thanks!</p>
<p>
</p>
<hr>
<p></p>
<p>Firstly, may <i><font color="#800000">I thank you for donating your
OTL code to the public domain. It is a really nice piece of work</font></i>.
Having looked through the code and examples provided, I have a number
of
questions which I hope you may be able to answer.</p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">And I appreciate the work. I think you have
a good thing here. Making a product like this available is quite
generous!
THANKS!!</font></i></p>
<p>
</p>
<hr>
<p></p>
<p>I recently had to code an oracle pipes based interface to the
computation-server
system I'm working on. Pro*C wasn't flexible enough, because I need to
do dynamic SQL and using DBMS_SQL seemed like a bad idea. Besides, it
doesn't
sit too well with C++, and handling the array inserts I needed to do
was
going to be a pain. I haven't coded in OCI before, and though I've read
the manuals I knew it was going to take me a while for me to feel
comfortable.
Besides, passing all those 0's everywhere,,, uggh. It needed wrapping,
and I didn't have the time.</p>
<p><i><font color="#800000">So I hunted on the net... and found your
stuff...
and it was good... and made my life easier, which I always enjoy.
Thanks
very much, especially for putting it in the public domain. I don't know
how you get the time to do this sort of thing outside work. I've
wondered
about coding a streams-based interface myself - I like your ideas and
your
code</font></i>.</p>
<p>
</p>
<hr>
<p></p>
<p>Thank you for your reply. <i><font color="#800000">I have used your
SQL class library in the past and think it's great. I reviewed the OTL
document and think it will be an even better tool.</font> The code
looks
very clean and the examples are very helpful</i>. I did not see
specific
reference to LOB support though. Did I overlook something in the
document?</p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">Thank you so much for your OTL class
library;
it will be of immense help to me!</font></i></p>
<p>
</p>
<hr>
<p></p>
<p><font color="#800000"><i>Thanks for the fantastic coding tip!</i> </font>I
modified my ocicdr program as you suggested below, and used the
otl_stream.open()
to describe the insert statement, instead of in the contructor, and
WOW!!!
<font color="#800000"><i>I got a performance increase by a factor of
400%</i>.</font>
Here's what I got:...</p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">Thanks for your effort! I want say "I
love your OTL!"...</font></i></p>
<p>Thank you, again</p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">i work with your very comfortable Otl
-Class
Library. The new version V2.0 is 10-20% faster than the older one
1.0.65.
My favorite is the ref cursor because we can manage the memory in the
host
program with it dynamically.</font></i> The fastest way in my
applications
is an stl vector.</p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">First, I wanted to thank you for your
generousity
for posting a much needed C++ interface for Oracle OCI. There isn't
much
out there, </font></i>and my serach brought me to your website. <i><font
 color="#800000">Your
impliementation of the C++ OCI wrapper looks very slick, and I can wait
to use it with my project!</font></i></p>
<p>
</p>
<hr>
<p></p>
<p>I found your work in a web search. <i>This is extremely interesting
and creative</i>. Are there versions for other database servers? ODBC?
Have other people said they would create other versions? </p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">Very impressive piece of software</font></i>.</p>
<p>
</p>
<hr>
<p></p>
<p>I've been looking through your very extensive library in otl.htm for
the past couple hours now. <i><font color="#800000">It is very
impressive
and looks like you have spent a VERY long time putting it together.</font></i>
I hope you do get a contract for it picked up by a distributor. My
pitiful
little 'simulation' of...</p>
<p>
</p>
<hr>
<p></p>
<p>A while back, I was looking at using Oracle for a project I am
involved
with, and I came across your OTL library. I never actually tried it, <font
 color="#800000"><i>but
I liked very much the approach</i> </font>demonstrated in the docs
that
I read.</p>
<p>
</p>
<hr>
<p></p>
<p><i><font color="#800000">We use Sergei's OTL C++ library and have
found
it to be at least 2x faster than Pro*C. More speed is realized when
using
SQL*NET. Bottom line is that OTL is easier to use than native OCI and
is
faster than Pro*C</font>.</i></p>
<p>
</p>
<hr>
<p></p>
<p><i>T<font color="#800000">hank you million times! You are a genius!
It is really nice piece of work, with very good concept. I think that's
what I'm looking for, and I will try to set up this to work right away!</font></i></p>
<p>
</p>
<hr>
<p></p>
<p>&gt;This OTL looks great for console applications. Does anyone know
if there is one for windows based applications, or even better one that
is based with MFC?</p>
<p><i><font color="#800000">As far as I know, OTL can be plugged in
where
ever OCI is supported. Because you can inline the entire library, you
should
be able to plug it in to any development environment. This is an
advantage
of using C++ templates -- it allows for more portable code. I may be
all
wet about this</font>, </i>but I think you'll be able to use it for
any
type of application, not just console ones.</p>
<p>
</p>
<hr>
<p></p>
<p><font color="#800000"><i>Use the C++ OTL (Oracle Template Library).
It's faster than Pro*C, easier to use than OCI, and because it is an
in-line
library, you don't have to compile a shared-object library (aka DLL in
NT). You can compile it into a library, but you really only have to
#include
thef ile. Best of all, it's distributed free of charge</i>.</font></p>
<p><font color="#800000"><i>We use it in our production system with no
problems.</i> </font>Check out <a href="otl_1pg.htm">http://home.sprynet.com/~skuchin/otl_1pg.htm</a></p>
<p>
</p>
<hr>
<p></p>
<p>If you want to do it in C++ the have a look at
http://home.sprynet.com/~skuchin/otl_1pg.htm<br>
I use this OTL (OCI Template Library) from within MSVC 5.0 for
connecting
Ora7.3 and<font color="#800000"> <i>it works great</i></font>.<br>
It is based on OCI from Oracle.</p>
<p>
</p>
<hr>
<p></p>
<p>We started using your OTL library a couple of weeks ago for our
current
project. We are trying to do multithreading, but our old library wasn't
really thread-safe. <font color="#800000"><i>OTL has performed
remarkably
well in the multithreaded environmen</i>t. <i>Our hats off to you for
this
great piece of open source software.</i></font></p>
<p>
</p>
<hr width="100%">
<p></p>
<p><i><font color="#800000">I must also thank you, this API allows for
much smoother development and compiling than the Pro*C/C++ Precompiler.</font></i></p>
<p>
</p>
<hr width="100%">
<p></p>
<p><i><font color="#800000">Congratulations on the OTL concept</font></i></p>
<center>
<p></p>
<hr>
<p></p>
</center>
<center>
<p><a href="home.htm">Go Home</a></p>
</center>
#define OTL_ODBC_SELECT_STM_EXECUTE_BEFORE_DESCRIBE
href="mailto:[e-mail]"&gt;[e-mail],
a href="mailto:[e-mail]"&gt;[e-mail].
<script language="JavaScript"><!-- hide from oldgmailsers
 var modDate = new Date(document.lastModified)
 document.write("<i> Last Updated:</i> " + (modDate.getMonth()+1) + "/" + 
                modDate.getDate() + "/" + "0"+(modDate.getYear())%100+".");
 //-->
 </script>
<p></p>
<p><i>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. </i></p>
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-5456201-1");
pageTracker._trackPageview();
</script>
</body>
</html>