faq.html

来自「perl教程」· HTML 代码 · 共 1,069 行 · 第 1/4 页

    5. Interacting with the Database
        Issuing Simple Queries
        Executing Non-SELECT Statements
        Binding Parameters to Statements
        Binding Output Columns
        do() Versus prepare()
        Atomic and Batch Fetching
    6. Advanced DBI
        Handle Attributes and Metadata
        Handling LONG/LOB Data
        Transactions, Locking, and Isolation
    7. ODBC and the DBI
        ODBC -- Embraced and Extended
        DBI -- Thrashed and Mutated
        The Nuts and Bolts of ODBC
        ODBC from Perl
        The Marriage of DBI and ODBC
        Questions and Choices
        Moving Between Win32::ODBC and the DBI
        And What About ADO?
    8. DBI Shell and Database Proxying
        dbish -- The DBI Shell
        Database Proxying
    A. DBI Specification
    B. Driver and Database Characteristics
    C. ASLaN Sacred Site Charter
    Index</pre>
</dd>
<dd>
<p>The book should be available from all good bookshops and can be ordered online
either &lt;I&gt;via&lt;/I&gt; O'Reilly &amp; Associates</p>
</dd>
<dd>
<pre>
    <a href="http://www.oreilly.com/catalog/perldbi">http://www.oreilly.com/catalog/perldbi</a></pre>
</dd>
<dd>
<p>or Amazon</p>
</dd>
<dd>
<pre>
    <a href="http://www.amazon.com/exec/obidos/ASIN/1565926994/dbi">http://www.amazon.com/exec/obidos/ASIN/1565926994/dbi</a></pre>
</dd>
</li>
<dt><strong><a name="item_pod_documentation"><em>POD documentation</em></a></strong>

<dd>
<p><em>POD</em>s are chunks of documentation usually embedded within perl programs
that document the code ``<em>in place</em>'', providing a useful resource for
programmers and users of modules. POD for DBI and drivers is beginning to 
become more commonplace, and documentation for these modules can be read
with the <code>perldoc</code> program included with Perl.</p>
</dd>
<dl>
<dt><strong><a name="item_the_dbi_specification">The DBI Specification</a></strong>

<dd>
<p>The POD for the DBI Specification can be read with the:</p>
</dd>
<dd>
<pre>
    <a href="../../lib/Pod/perldoc.html">perldoc</a> DBI</pre>
</dd>
<dd>
<p>command. The Specification also forms Appendix A of &quot;Programming the Perl
DBI&quot;.</p>
</dd>
</li>
<dt><strong><a name="item_oraperl">Oraperl</a></strong>

<dd>
<p>Users of the Oraperl emulation layer bundled with <em>DBD::Oracle</em>, may read
up on how to program with the Oraperl interface by typing:</p>
</dd>
<dd>
<pre>
    <a href="../../lib/Pod/perldoc.html">perldoc</a> Oraperl</pre>
</dd>
<dd>
<p>This will produce an updated copy of the original oraperl man page written by
Kevin Stock for perl4. The oraperl API is fully listed and described there.</p>
</dd>
</li>
<dt><strong><a name="item_drivers">Drivers</a></strong>

<dd>
<p>Users of the DBD modules may read about some of the private functions
and quirks of that driver by typing:</p>
</dd>
<dd>
<pre>
    <a href="../../lib/Pod/perldoc.html">perldoc</a> &lt;driver&gt;</pre>
</dd>
<dd>
<p>For example, the <em>DBD::mSQL</em> driver is bundled with driver-specific 
documentation that can be accessed by typing</p>
</dd>
<dd>
<pre>
    <a href="../../lib/Pod/perldoc.html">perldoc</a> DBD::mSQL</pre>
</dd>
</li>
<dt><strong><a name="item_frequently_asked_questions">Frequently Asked Questions</a></strong>

<dd>
<p>This document, the <em>Frequently Asked Questions</em> is also available as POD
documentation! You can read this on your own system by typing:</p>
</dd>
<dd>
<pre>
    <a href="../../lib/Pod/perldoc.html">perldoc</a> DBI::FAQ</pre>
</dd>
<dd>
<p>This may be more convenient to persons not permanently, or conveniently,
connected to the Internet. The <em>DBI::FAQ</em> module should be downloaded and
installed for the more up-to-date version.</p>
</dd>
<dd>
<p>The version of <em>DBI::FAQ</em> shipped with the <code>DBI</code> module may be slightly out
of date.</p>
</dd>
</li>
<dt><strong><a name="item_pod_in_general">POD in general</a></strong>

<dd>
<p>Information on writing POD, and on the philosophy of POD in general, can be
read by typing:</p>
</dd>
<dd>
<pre>
    <a href="../../lib/Pod/perldoc.html">perldoc</a> <a href="../../lib/Pod/perlpod.html">perlpod</a></pre>
</dd>
<dd>
<p>Users with the Tk module installed may be interested to learn there is a
Tk-based POD reader available called <code>tkpod</code>, which formats POD in a convenient
and readable way. This is available <em>via</em> CPAN as the module called 
<em>Tk::POD</em> and is highly recommended.</p>
</dd>
</li>
</dl>
<dt><strong><a name="item_driver_and_database_characteristics"><em>Driver and Database Characteristics</em></a></strong>

<dd>
<p>The driver summaries that were produced for Appendix B of &quot;Programming the
Perl DBI&quot; are available online at:</p>
</dd>
<dd>
<pre>
    <a href="http://dbi.perl.org/">http://dbi.perl.org/</a>
    <a href="http://www.symbolstone.org/technology/perl/DBI">http://www.symbolstone.org/technology/perl/DBI</a></pre>
</dd>
<dd>
<p>in the driver information table. These summaries contain standardised
information on each driver and database which should aid you in selecting
a database to use. It will also inform you quickly of any issues within
drivers or whether a driver is not fully compliant with the DBI Specification.</p>
</dd>
</li>
<dt><strong><a name="item_rambles_2c_tidbits_and_observations"><em>Rambles, Tidbits and Observations</em></a></strong>

<dd>
<pre>
    <a href="http://dbi.perl.org/tidbits">http://dbi.perl.org/tidbits</a>
    <a href="http://www.symbolstone.org/technology/perl/DBI/tidbits">http://www.symbolstone.org/technology/perl/DBI/tidbits</a></pre>
</dd>
<dd>
<p>There are a series of occasional rambles from various people on the
DBI mailing lists who, in an attempt to clear up a simple point, end up
drafting fairly comprehensive documents. These are quite often varying in
quality, but do provide some insights into the workings of the interfaces.</p>
</dd>
<dt><strong><a name="item_articles"><em>Articles</em></a></strong>

<dd>
<p>A list of articles discussing the DBI can be found on the DBI WWW page at:</p>
</dd>
<dd>
<pre>
    <a href="http://dbi.perl.org/">http://dbi.perl.org/</a>
    <a href="http://www.symbolstone.org/technology/perl/DBI">http://www.symbolstone.org/technology/perl/DBI</a></pre>
</dd>
<dd>
<p>These articles are of varying quality and age, from the original Perl Journal
article written by Alligator and Tim, to more recent debacles published online
from about.com.</p>
</dd>
</li>
<dt><strong><a name="item_readme_files"><em>README files</em></a></strong>

<dd>
<p>The <em>README</em> files included with each driver occasionally contains 
some useful information ( no, really! ) that may be pertinent to the user.
Please read them. It makes our worthless existences more bearable. These
can all be read from the main DBI WWW page at:</p>
</dd>
<dd>
<pre>
    <a href="http://dbi.perl.org/">http://dbi.perl.org/</a>
    <a href="http://www.symbolstone.org/technology/perl/DBI">http://www.symbolstone.org/technology/perl/DBI</a></pre>
</dd>
</li>
<dt><strong><a name="item_mailing_lists"><em>Mailing Lists</em></a></strong>

<dd>
<p>There are three mailing lists for DBI:</p>
</dd>
<dd>
<pre>
    [e-mail]     -- for announcements, very low traffic
    [e-mail]        -- general user support
    [e-mail]          -- for driver developers (no user support)</pre>
</dd>
<dd>
<p>For information on how to subscribe, set digest mode etc, and unsubscribe,
send an email message (the content will be ignored) to:</p>
</dd>
<dd>
<pre>
    [e-mail]
    [e-mail]
    [e-mail]</pre>
</dd>
</li>
<dt><strong><a name="item_mailing_list_archives"><em>Mailing List Archives</em></a></strong>

<dl>
<dt><strong><a name="item_us_mailing_list_archives"><em>US Mailing List Archives</em></a></strong>

<dd>
<pre>
    <a href="http://outside.organic.com/mail-archives/dbi-users/">http://outside.organic.com/mail-archives/dbi-users/</a></pre>
</dd>
<dd>
<p>Searchable hypermail archives of the three mailing lists, and some of the
much older traffic have been set up for users to browse.</p>
</dd>
<dt><strong><a name="item_european_mailing_list_archives"><em>European Mailing List Archives</em></a></strong>

<dd>
<pre>
    <a href="http://www.rosat.mpe-garching.mpg.de/mailing-lists/PerlDB-Interest">http://www.rosat.mpe-garching.mpg.de/mailing-lists/PerlDB-Interest</a></pre>
</dd>
<dd>
<p>As per the US archive above.</p>
</dd>
</dl>
</dl>
<p>
</p>
<hr />
<h1><a name="compilation_problems">Compilation Problems</a></h1>
<p>
</p>
<h2><a name="2_1__compilation_problems_or_it_fails_the_test_">2.1. Compilation problems or &quot;It fails the test!&quot;</a></h2>
<p>First off, consult the README for that driver in case there is useful 
information about the problem. It may be a known problem for your given 
architecture and operating system or database. You can check the README
files for each driver in advance online at:</p>
<pre>
    <a href="http://dbi.perl.org/">http://dbi.perl.org/</a>
    <a href="http://www.symbolstone.org/technology/perl/DBI">http://www.symbolstone.org/technology/perl/DBI</a></pre>
<p>If it's a known problem, you'll probably have to wait till it gets fixed. If 
you're <em>really</em> needing it fixed, try the following:</p>
<dl>
<dt><strong><a name="item_attempt_to_fix_it_yourself"><em>Attempt to fix it yourself</em></a></strong>

<dd>
<p>This technique is generally <em>not</em> recommended to the faint-hearted.