Package: libphp-adodb
Version: 4.93a-1.1
Severity: minor
Tags: patch
thanks
*** Please type your report below this line ***
Hi,
it appears oracle have broken some of the links in the (extensive!)
documentation provided with this package.
I've patched the URLs I found to be broken in the file
/usr/share/doc/libphp-adodb/docs-oracle.htm,
see attached. This is almost certainly incomplete coverage of the
URLs that have changed.
This is the 'stable' package, perhaps the issue has been addressed in
later uploads. However I could not see an update in the archived bugs.
Cheers
Vince
-- System Information:
Debian Release: 4.0
APT prefers stable
APT policy: (500, 'stable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-6-686
Locale: LANG=, LC_CTYPE= (charmap=ANSI_X3.4-1968)
Versions of packages libphp-adodb depends on:
ii debconf [debconf-2.0] 1.5.11etch1 Debian configuration management sy
ii php5 5.2.0-8+etch10 server-side, HTML-embedded scripti
Versions of packages libphp-adodb recommends:
ii php5-mysql 5.2.0-8+etch10 MySQL module for php5
ii php5-odbc 5.2.0-8+etch10 ODBC module for php5
pn php5-pgsql | php4-pgsql <none> (no description available)
pn php5-sybase | php4-sybase <none> (no description available)
-- debconf information:
* libphp-adodb/pathmove:
--- /usr/share/doc/libphp-adodb/docs-oracle.htm 2006-11-21 16:34:36.000000000
+1100
+++ docs-oracle.htm.new 2008-03-17 10:28:38.699882000 +1100
@@ -35,7 +35,7 @@
<li>ADOdb library</li>
</ul>
<p>The wide range of choices is confusing to someone just starting with Oracle
and PHP. I will briefly summarize the differences, and show you the advantages
of using <a href="http://adodb.sourceforge.net/";>ADOdb</a>. </p>
-<p>First we have the C extensions which provide low-level access to Oracle
functionality. These C extensions are precompiled into PHP, or linked in
dynamically when the web server starts up. Just in case you need it, here's a
<a
href=http://www.oracle.com/technology/tech/opensource/php/apache/inst_php_apache_linux.html>guide
to installing Oracle and PHP on Linux</a>.</p>
+<p>First we have the C extensions which provide low-level access to Oracle
functionality. These C extensions are precompiled into PHP, or linked in
dynamically when the web server starts up. Just in case you need it, here's a
<a
href=http://www.oracle.com/technology/tech/htdocs/inst_php_apache_linux.html>guide
to installing Oracle and PHP on Linux</a>.</p>
<table width="75%" border="1" align="center">
<tr valign="top">
<td nowrap><b>Oracle extension</b></td>
@@ -457,7 +457,7 @@
$db->Execute("insert into atable (f1, f2) values (?,?)",
array(12, 'abc'));</pre>
<p> <a name=connecting></a>
<h3>9. Connecting to Oracle</h3>
-<p>Before you can use ADOdb, you need to have the Oracle client installed and
setup the oci8 extension. This extension comes pre-compiled for Windows (but
you still need to enable it in the php.ini file). For information on compiling
the oci8 extension for PHP and Apache on Unix, there is an excellent guide at
<a
href="http://www.oracle.com/technology/tech/opensource/php/apache/inst_php_apache_linux.html";>oracle.com</a>.
</p>
+<p>Before you can use ADOdb, you need to have the Oracle client installed and
setup the oci8 extension. This extension comes pre-compiled for Windows (but
you still need to enable it in the php.ini file). For information on compiling
the oci8 extension for PHP and Apache on Unix, there is an excellent guide at
<a
href="http://www.oracle.com/technology/tech/htdocs/inst_php_apache_linux.html";>oracle.com</a>.
</p>
<h4>Should You Use Persistent Connections</h4>
<p>One question that is frequently asked is should you use persistent
connections to Oracle. Persistent connections allow PHP to recycle existing
connections, reusing them after the previous web pages have completed.
Non-persistent connections close automatically after the web page has
completed. Persistent connections are faster because the cost of reconnecting
is expensive, but there is additional resource overhead. As an alternative,
Oracle allows you to pool and reuse server processes; this is called <a
href="http://www.cise.ufl.edu/help/database/oracle-docs/server.920/a96521/manproc.htm#13132";>Shared
Server</a> (also known as MTS).</p>
<p>The author's benchmarks suggest that using non-persistent connections and
the Shared Server configuration offer the best performance. If Shared Server
is not an option, only then consider using persistent connections.</p>
