otl3_faq.htm

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

than a synonym for OTL_ORA8I, but in subsequent releases, when OTL
starts
using OCI9 specific features, only OTL_ORA9I should be used. See "<a
 href="otl3_whatn.htm#NEW_OTL400">what's
new in OTL 4</a>" for more detail.
</p>
<p><i><font size="+1">Q. OTL: can it work with Interbase 6.x?</font></i>
</p>
<p>The answer is Yes. Starting with version 4.0.0, OTL supports an Open
Source ODBC driver for Interbase. See "<a
 href="otl3_whatn.htm#NEW_OTL400">what's
new in OTL 4</a>" for more detail.
</p>
<p><i><font size="+1">Q. OTL: can it work with PostgreSQL 7.x / 8.x?</font></i>
</p>
<p>The answer is Yes. Starting with version 4.0.0, OTL supports
PostgreSQL
via ODBC. See "<a href="otl3_whatn.htm#NEW_OTL400">what's new in OTL 4</a>"
for more detail.
<br>
&nbsp;
</p>
<p><i><font size="+1">Q. OTL: can it work with DB2, Call Level
Interface
(CLI)?</font></i>
</p>
<p>The answer is Yes. Starting with version 3.2.7, there is a new
flavor
of OTL: OTL/DB2-CLI. OTL/DB2-CLI uses DB2's native database API: the <i>Call
Level Interface.</i> DB2-CLI is 99.5% compatible with the ODBC 3.x
specification,
plus extensions. The OTL header file #includes CLI's native header
files
and can be used with DB2-CLI's native object libraries in Windows or
Unix
(primarily AIX) platforms.
<br>
&nbsp;
</p>
<p><i><font size="+1"><a name="MYSQL"></a>Q. OTL/ODBC: can it work with
MyODBC/MySQL?</font></i>
</p>
<p>The answer is Yes. Starting with OTL 3.2.4, OTL/ODBC is
compatible
with MyODBC. For
more detail on MyODBC see&nbsp; <a href="otl3_examples.htm#MYODBC">MyODBC
for
MySQL</a>. #define <a href="otl3_compile.htm#OTL_ODBC_MYSQL">OTL_ODBC_MYSQL</a>
should be used with the default MySQL table type, because OTL turns off
transactional ODBC function calls in that case. When InnoDB type tables
are used with MyODBC 3.5, #define <a href="otl3_compile.htm#OTL_ODBC">OTL_ODBC</a>
should be used.<br>
</p>
<p><i><font size="+1">Q. OTL/OCI8 and XA-connectivity: can they work
together?</font></i>
</p>
<p>The answer is Yes. When an XA type connection is established,
xaoEnv()
and xaoSvcCtx() functions need to be invoked in order to get OCI8
compatible
environment and service context handles. After that, otl_connect::<a
 href="otl3_connect_class.htm#attach8">rlogon</a>()
can be called to create an OTL connection from the handles. It is the
same
rlogon() that is used with Pro*C 8.x. How to use this type of rlogon()
function, see example <a href="otl3_ex59.htm">59</a> for more detail.
</p>
<p><i><font size="+1">Q. Are C++ strings (std::string) supported, and
how
is OTL integrated with the Standard Template Library (STL)?</font></i>
</p>
<p>OTL 3.2.0 and higher support <i>std::strings</i> (see examples
<a href="otl3_ex72.htm">72</a>,
<a href="otl3_ex73.htm">73</a>,
<a href="otl3_ex74.htm">74</a>).
Also, OTL supports STL-compliant stream iterators: <a
 href="otl3_input_iterator.htm">otl_input_iterator</a>,
<a href="otl3_output_iterator.htm">otl_output_iterator</a>.
</p>
<p><i><font size="+1">Q. What major C++ compilers are supported, anyway?</font></i>
</p>
<ul>
  <li>Sun C++ Workshop 5.x/6.0, Forte C++ (Sun C++ WS 6.1 and higher)</li>
  <li>GNU C++ 3.3.x, 3.4.x, 4.0.x, 4.1.x, 4.2.x, 4.3.x<br>
  </li>
  <li>VC++ 6.0, VC++ 7.1, VC++ 8.0, VC++ 9.0<br>
  </li>
  <li>HP ANSI C++ (aCC) 1.x</li>
  <li>AIX, xlC 4.x and higher</li>
  <li>C++ in OSF Alfa Unix and Oracle 7.3.4</li>
  <li>Borland C++ 5.x</li>
  <li>KAI C++ 3.x and higher (multi-platform)</li>
  <li>Intel C++ 7.0, 8.0, 9.x (Windows, Linux)</li>
</ul>
In order to complete the list, you are welcome to send me an email with
the name of your C++ compiler, if it's not already in the list.
<br>
&nbsp;
<p><i><font size="+1">Q. Is there a way to read / write large BLOBs
without
having to allocate large buffers in memory?</font></i>
</p>
<p>OTL 3.1.4 supports <a href="otl3_lob_stream.htm">stream mode</a>
for
Oracle 8 CLOBs/BLOBs. Fore more detail, see examples <a
 href="otl3_ex56.htm">56</a>,
<a href="otl3_ex57.htm">57.</a>
</p>
<p><i><font size="+1">Q. Is there a way to call a stored procedure
which
takes PL/SQL tables as arguments ?</font></i>
</p>
<p>OTL 3.1 supports PL/SQL table via <a
 href="otl3_bind_variables.htm#pl_tab">otl_streams</a>
and <a href="otl3_pl_tab.htm">special template data containers</a>.Fore
more detail, see examples <a href="otl3_ex49.htm">49</a>, <a
 href="otl3_ex50.htm">50</a>,
<a href="otl3_ex51.htm">51</a>,
<a href="otl3_ex52.htm">52</a>.
</p>
<p><i><font size="+1">Q. Will you stick with email delivery of your
code,
or do you intend to put it on your website later ?</font></i>
</p>
<p>From now on, the OTL header file is available for <a
 href="otlv4_h.zip">download</a>.
</p>
<p><i><font size="+1">Q. What is different in behavior of Large Objects
(LOBs)
compared to other datatypes as far as NULLs are concerned?</font></i>
</p>
<p>For more detail, see "<a href="otl3_long_string.htm#LOB_and_NULL">Large
Objects and NULLs</a>."
</p>
<p><i><font size="+1">Q. How to read/write date&amp;time informarion
from/to
the <a href="otl3_stream_class.htm">otl_stream</a>?</font></i>
</p>
<p>The answer is: use the <a href="otl3_stream_class.htm#otl_datetime">otl_datetime</a>
data container, which was introduced in OTL 3.1.26. For more detail, se
examples <a href="otl3_ex38.htm">38</a>, <a href="otl3_ex39.htm">39</a>,
<a href="otl3_ex40.htm">40</a>.
<br>
Bottom line: Oracle DATE, or, say, MS SQL Server DATETIME, can be
read/written
with the use of otl_datetime variables.
</p>
<p><i><font size="+1">Q. How to get the <b>rows processed count</b>
after
the SQL statement is finished?</font></i>
</p>
<p>The <a href="otl3_const_sql.htm">direct_exec</a>() function returns
a long int value, which, if it is &gt;= 0, it retunrs the rows
processed count
of the constant SQL statement.Also, otl_stream::<a
 href="otl3_stream_class.htm#get_rpc">get_rpc</a>()
returns a long int value, which is the rows processed count. The rows
processed
count is defined for INSERT, UPDATE, and DELETE statements. For any
other
SQL statement, PL/SQL block, or a stored procedure call, the count is
always
0.
<br>
&nbsp;
</p>
<p></p>
<hr width="100%">
<ul>
  <center><a href="home.htm">Go Home</a></center>
  <p>Copyright &copy; 1996, 2008, Sergei Kuchin, email: <a
 href="mailto:[e-mail]">[e-mail]</a>, <a
 href="mailto:[e-mail]">[e-mail]
  <script language="JavaScript"><!-- hide from old browsers
 var modDate = new Date(document.lastModified)
 document.write("<i> Last Updated:</i> " + (modDate.getMonth()+1) + "/" + 
                modDate.getDate() + "/" + "0"+(modDate.getYear())%100+".");
 //-->
 </script></a>.
  </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>
</ul>
<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>