You are viewing a plain text version of this content. The canonical link for it is here.
Posted to cvs@cocoon.apache.org by as...@apache.org on 2007/09/08 22:17:47 UTC

svn commit: r573901 [9/44] - in /cocoon/site: site/ site/2.0/ site/2.0/developing/ site/2.0/faq/ site/2.0/howto/chaperon/ site/2.0/installing/ site/2.0/plan/ site/2.0/snippet/ site/2.0/tutorial/ site/2.0/userdocs/ site/2.0/userdocs/actions/ site/2.0/us...

Modified: cocoon/site/site/2.0/faq/faq-databases.html
URL: http://svn.apache.org/viewvc/cocoon/site/site/2.0/faq/faq-databases.html?rev=573901&r1=573900&r2=573901&view=diff
==============================================================================
--- cocoon/site/site/2.0/faq/faq-databases.html (original)
+++ cocoon/site/site/2.0/faq/faq-databases.html Sat Sep  8 13:17:41 2007
@@ -1,425 +1,425 @@
-<html>
-<head>
-<META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
-<title>Database FAQs</title>
-<STYLE type="text/css">
-a.menu {
-	color: #FFFFFF;
-    text-align:left;               
-    font-size:12px;
-    font-family: Verdana, Arial, Helvetica, sans-serif;
-    font-weight:plain;
-    text-decoration:none;
-    padding-left: 14px
-}
-
-A.menu:hover {
-	color: #FFCC00
-}
-
-
-.menutitle {
-	color: #000000;
-    text-align:left;               
-    font-size:10px;
-    font-family: Verdana, Arial, Helvetica, sans-serif;
-    font-weight:bold;
-    padding-left: 8px
-}
-.menuselected {
-	color: #FFCC00;
-    text-align:left;               
-    font-size:12px;
-    font-family: Verdana, Arial, Helvetica, sans-serif;
-    font-weight:bold;
-    padding-left: 14px
-}
-</STYLE>
-</head>
-<body bgcolor="#ffffff" marginheight="4" marginwidth="4" leftmargin="4" topmargin="4" alink="#cc0000" vlink="#0086b2" link="#039acc" text="#000000">
-<table border="0" cellpadding="0" cellspacing="0" width="100%">
-<tr>
-<td align="left" valign="top" rowspan="3" height="60" width="135"><img border="0" vspace="0" hspace="0" src="images/logo.gif" height="60" width="135"></td><td background="images/line.gif" rowspan="1" colSpan="2" align="left" valign="top" height="0" width="100%"></td><td align="left" valign="top" rowspan="3" height="60" width="29"><img border="0" vspace="0" hspace="0" src="images/right.gif" height="60" width="29"></td>
-</tr>
-<tr>
-<td bgcolor="#0086b2" colspan="2" align="right" valign="top" height="35" width="100%"><font color="#ffffff" face="Verdana, Arial, Helvetica, sans-serif" size="5">Database FAQs</font></td>
-</tr>
-<tr>
-<td background="images/bottom.gif" colspan="2" width="100%" valign="top" height="20" bgcolor="#0086b2" align="right">
-<table width="288" cellspacing="0" cellpadding="0" border="0">
-<tr>
-<td align="left" valign="top" height="20" width="96"><a target="new" href="http://xml.apache.org/"><img border="0" vspace="0" hspace="0" name="xml" src="images/button-xml-lo.gif" height="20" width="96" alt="http://xml.apache.org/"></a></td><td align="left" valign="top" height="20" width="96"><a target="new" href="http://www.apache.org/"><img border="0" vspace="0" hspace="0" name="asf" src="images/button-asf-lo.gif" height="20" width="96" alt="http://www.apache.org/"></a></td><td align="left" valign="top" height="20" width="96"><a target="new" href="http://www.w3.org/"><img border="0" vspace="0" hspace="0" name="w3c" src="images/button-w3c-lo.gif" height="20" width="96" alt="http://www.w3.org/"></a></td>
-</tr>
-</table>
-</td>
-</tr>
-</table>
-<table width="100%" cellspacing="0" cellpadding="0" border="0">
-<tr width="100%">
-<td align="left" valign="top" width="120">
-<table width="120" cellspacing="0" cellpadding="0" border="0" bgcolor="#a0a0a0">
-<tr>
-<td valign="top" align="left"><img width="120" vspace="0" src="images/join.gif" hspace="0" height="14" border="0"><br>
-</td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="../index.html">Main</a></td>
-</tr>
-<tr>
-<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
-<span class="menutitle">FAQs</span></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="index.html">Index</a></td>
-</tr>
-<tr>
-<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
-<span class="menutitle">Getting Started</span></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-install.html">Install</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-configure-environment.html">Configure</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-cvs.html">CVS</a></td>
-</tr>
-<tr>
-<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
-<span class="menutitle">Using</span></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-configure-c2.html">Configure C2</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><span class="menuselected">Databases</span></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-xsp.html">XSP</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-xslt.html">XSLT</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-debugging.html">Debugging</a></td>
-</tr>
-<tr>
-<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
-<span class="menutitle">Sitemap</span></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-sitemap.html">Sitemap</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-generators.html">Generators</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-transformers.html">Transformers</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-serializers.html">Serializers</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-matchers.html">Matchers</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-selectors.html">Selectors</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-actions.html">Actions</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-aggregators.html">Aggregators</a></td>
-</tr>
-<tr>
-<td align="left" valign="top"><img width="120" vspace="0" src="images/close.gif" hspace="0" height="14" border="0"><br>
-</td>
-</tr>
-</table>
-</td><td>
-<table cellspacing="15" cellpadding="0" border="0">
-<tr>
-<td><font face="verdana, helvetica, sans serif" size="+2" color="#0086b2">Questions</font>
-<hr style="color: #0086b2" size="1">
-<blockquote>
-<ul>
-<li>
-<font face="verdana, helvetica, sans serif"><a href="#faq-1">
-    When I try to use the Connection pooling code, I get the following exception:
-    "Could not get the datasource java.sql.SQLException: You cannot
-    get a Poolable before the pool is initialized".  What's going on?
-  </a></font>
-</li>
-<li>
-<font face="verdana, helvetica, sans serif"><a href="#faq-2">
-   The sql samples don't run.
- </a></font>
-</li>
-<li>
-<font face="verdana, helvetica, sans serif"><a href="#faq-3">
-   I've been able to run the database samples, but they don't run anymore.
- </a></font>
-</li>
-<li>
-<font face="verdana, helvetica, sans serif"><a href="#faq-4">
-   I get an AbstractMethodError when Cocoon tries to query my database.
- </a></font>
-</li>
-<li>
-<font face="verdana, helvetica, sans serif"><a href="#faq-5">
-   Where can I find more information about connecting to databases using Cocoon?
- </a></font>
-</li>
-<li>
-<font face="verdana, helvetica, sans serif"><a href="#faq-6">
-  How can I add my FAQ to this document? 
- </a></font>
-</li>
-<li>
-<font face="verdana, helvetica, sans serif"><a href="#faq-7">
-  How can I suggest improvements to existing FAQs?
- </a></font>
-</li>
-</ul>
-</blockquote>
-<font face="verdana, helvetica, sans serif" size="+2" color="#0086b2">Answers</font>
-<hr style="color: #0086b2" size="1">
-<a name="faq-1">
-<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
-    When I try to use the Connection pooling code, I get the following exception:
-    "Could not get the datasource java.sql.SQLException: You cannot
-    get a Poolable before the pool is initialized".  What's going on?
-  </b></font>
-  
-  
-    
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-      The most common reason for this exception is that the driver was not loaded.
-      Cocoon uses an initial parameter in the "web.xml" file to automatically load
-      classes on startup.  This way, the class is loaded only once and the server's
-      time is spent doing more productive things.  Make sure the following entry
-      is in your "web.xml" file.
-    </font>
-</p>
-
-    
-<div align="center">
-<table border="0" cellpadding="0" cellspacing="4">
-<tr>
-<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
-</tr>
-<tr>
-<td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td bgcolor="#ffffff">
-<pre>
-&lt;init-param&gt;
- &lt;param-name&gt;load-class&lt;/param-name&gt;
- &lt;param-value&gt;
-   &lt;!-- comma or whitespace separated list of fully
-     qualified class names to load on startup.
-   --&gt;
-   oracle.jdbc.driver.OracleDriver
- &lt;/param-value&gt;
-&lt;/init-param&gt;
-</pre>
-</td><td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
-</tr>
-<tr>
-<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
-</tr>
-</table>
-</div>
-
-    
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-      If the class is loaded correctly, and you are still getting this error, then there
-      is probably an error in your connection information.  The SQLException
-      above is thrown when there are no open connections to the database.
-    </font>
-</p>
-  
-
-<a name="faq-2">
-<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
-   The sql samples don't run.
- </b></font>
- 
- 
-   
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-     The sql samples are working when deploing the war file using the build
-     system:</font>
-</p>
-       
-<div align="center">
-<table border="0" cellpadding="0" cellspacing="4">
-<tr>
-<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
-</tr>
-<tr>
-<td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td bgcolor="#ffffff">
-<pre>
-./build.sh \
-   -Dinclude.webapp.libs=yes \
-   -Dinstall.war=path/to/tomcat/webapps install
-</pre>
-</td><td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
-</tr>
-<tr>
-<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
-</tr>
-</table>
-</div>
-
-   
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-     This command will take care of the path inside the configuration file to the database resources.
-   </font>
-</p>
- 
-
-<a name="faq-3">
-<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
-   I've been able to run the database samples, but they don't run anymore.
- </b></font>
- 
- 
-   
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-    This happens when the servlet engine has been stopped abruptly (e.g. with ctrl-C).
-   </font>
-</p>
-   
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-    Hsqldb - the database used by C2 samples - is a single-process engine that
-    locks the database by setting the "modified" entry in
-    "WEB-INF/db/cocoondb.properties" to the value "yes" while some JDBC
-    connections exist. 
-   </font>
-</p>
-   
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-    With connection pooling, there's always some connections opened, and they're
-    not closed properly when you stop abruptly the servlet engine, so the database
-    stays in locked state and connections are refused at the next server startup.
-   </font>
-</p>
-   
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-    To unlock the database, change manually "modified" to "no" in the "cocoondb.properties"
-    before restarting the server.
-   </font>
-</p>
- 
-
-<a name="faq-4">
-<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
-   I get an AbstractMethodError when Cocoon tries to query my database.
- </b></font>
- 
- 
-   
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-    In this case Cocoon returns a "500 internal error" result, and the 
-    AbstractMethodError is visible in the tomcat logs after a call to
-    Connection.prepareStatement(...).
-   </font>
-</p>
-   
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-    This happens when the JDBC driver being used does not implement the
-    JDBC 1.2 interfaces: using its default configuration, the SQLTransformer 
-    calls a version of the JDBC Connection.prepareStatement(...) method that is not
-    available in pre-1.2 drivers.
-   </font>
-</p>
-   
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-    To avoid this problem, configure the SQLTransformer with "old-driver=true" in the
-    sitemap, as shown in this example:
-   </font>
-</p>
-    
-        
-<div align="center">
-<table border="0" cellpadding="0" cellspacing="4">
-<tr>
-<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
-</tr>
-<tr>
-<td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td bgcolor="#ffffff">
-<pre>
-        &lt;map:transformer 
-          logger="sitemap.transformer.sql" 
-          name="sql" 
-          src="org.apache.cocoon.transformation.SQLTransformer"
-        &gt;
-          &lt;old-driver&gt;true&lt;/old-driver&gt;
-        &lt;/map:transformer&gt; 
-        </pre>
-</td><td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
-</tr>
-<tr>
-<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
-</tr>
-</table>
-</div>
- 
-
-<a name="faq-5">
-<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
-   Where can I find more information about connecting to databases using Cocoon?
- </b></font>
- 
- 
-  
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-Learn more about connecting to databases by downloading the free chapter, <a href="http://www.newriders.com/books/product.asp?product_id={C3C05052-BE3B-4E06-A60A-13FB40AF58F6}">A User's Look at the Cocoon architecture,</a> from Langham and Ziegeler's <i>Cocoon: Building XML Applications</i> available at the New Riders web site.
-  </font>
-</p>
-
-
-<a name="faq-6">
-<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
-  How can I add my FAQ to this document? 
- </b></font>
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-   Follow the instructions found in <a href="../howto/howto-author-faq.html">How-To Author an FAQ.</a></font>
-</p>
-<a name="faq-7">
-<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
-  How can I suggest improvements to existing FAQs?
- </b></font>
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-  Given the rapid pace of change with Cocoon, many individual FAQs quickly become out-of-date and confusing to new users. If you have the relevant knowledge, please consider updating other FAQs on this page for technical errors. If you see a few typos, please consider fixing them too.  Follow the instructions found in <a href="../howto/howto-author-faq.html">How-To Author an FAQ.</a></font>
-</p>
-</td>
-</tr>
-</table>
-</td>
-</tr>
-</table>
-<table width="100%" cellspacing="0" cellpadding="0" border="0">
-<tr>
-<td bgcolor="#0086b2"><img width="1" src="images/dot.gif" height="1"></td>
-</tr>
-<tr>
-<td align="center"><font size="-1" face="arial,helvetica,sanserif" color="#0086b2"><i>Copyright &copy; 1999-2002 The Apache Software Foundation. All Rights Reserved.</i></font></td>
-</tr>
-</table>
-</body>
-</html>
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+<title>Database FAQs</title>
+<STYLE type="text/css">
+a.menu {
+	color: #FFFFFF;
+    text-align:left;               
+    font-size:12px;
+    font-family: Verdana, Arial, Helvetica, sans-serif;
+    font-weight:plain;
+    text-decoration:none;
+    padding-left: 14px
+}
+
+A.menu:hover {
+	color: #FFCC00
+}
+
+
+.menutitle {
+	color: #000000;
+    text-align:left;               
+    font-size:10px;
+    font-family: Verdana, Arial, Helvetica, sans-serif;
+    font-weight:bold;
+    padding-left: 8px
+}
+.menuselected {
+	color: #FFCC00;
+    text-align:left;               
+    font-size:12px;
+    font-family: Verdana, Arial, Helvetica, sans-serif;
+    font-weight:bold;
+    padding-left: 14px
+}
+</STYLE>
+</head>
+<body bgcolor="#ffffff" marginheight="4" marginwidth="4" leftmargin="4" topmargin="4" alink="#cc0000" vlink="#0086b2" link="#039acc" text="#000000">
+<table border="0" cellpadding="0" cellspacing="0" width="100%">
+<tr>
+<td align="left" valign="top" rowspan="3" height="60" width="135"><img border="0" vspace="0" hspace="0" src="images/logo.gif" height="60" width="135"></td><td background="images/line.gif" rowspan="1" colSpan="2" align="left" valign="top" height="0" width="100%"></td><td align="left" valign="top" rowspan="3" height="60" width="29"><img border="0" vspace="0" hspace="0" src="images/right.gif" height="60" width="29"></td>
+</tr>
+<tr>
+<td bgcolor="#0086b2" colspan="2" align="right" valign="top" height="35" width="100%"><font color="#ffffff" face="Verdana, Arial, Helvetica, sans-serif" size="5">Database FAQs</font></td>
+</tr>
+<tr>
+<td background="images/bottom.gif" colspan="2" width="100%" valign="top" height="20" bgcolor="#0086b2" align="right">
+<table width="288" cellspacing="0" cellpadding="0" border="0">
+<tr>
+<td align="left" valign="top" height="20" width="96"><a target="new" href="http://xml.apache.org/"><img border="0" vspace="0" hspace="0" name="xml" src="images/button-xml-lo.gif" height="20" width="96" alt="http://xml.apache.org/"></a></td><td align="left" valign="top" height="20" width="96"><a target="new" href="http://www.apache.org/"><img border="0" vspace="0" hspace="0" name="asf" src="images/button-asf-lo.gif" height="20" width="96" alt="http://www.apache.org/"></a></td><td align="left" valign="top" height="20" width="96"><a target="new" href="http://www.w3.org/"><img border="0" vspace="0" hspace="0" name="w3c" src="images/button-w3c-lo.gif" height="20" width="96" alt="http://www.w3.org/"></a></td>
+</tr>
+</table>
+</td>
+</tr>
+</table>
+<table width="100%" cellspacing="0" cellpadding="0" border="0">
+<tr width="100%">
+<td align="left" valign="top" width="120">
+<table width="120" cellspacing="0" cellpadding="0" border="0" bgcolor="#a0a0a0">
+<tr>
+<td valign="top" align="left"><img width="120" vspace="0" src="images/join.gif" hspace="0" height="14" border="0"><br>
+</td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="../index.html">Main</a></td>
+</tr>
+<tr>
+<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
+<span class="menutitle">FAQs</span></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="index.html">Index</a></td>
+</tr>
+<tr>
+<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
+<span class="menutitle">Getting Started</span></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-install.html">Install</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-configure-environment.html">Configure</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-cvs.html">CVS</a></td>
+</tr>
+<tr>
+<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
+<span class="menutitle">Using</span></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-configure-c2.html">Configure C2</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><span class="menuselected">Databases</span></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-xsp.html">XSP</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-xslt.html">XSLT</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-debugging.html">Debugging</a></td>
+</tr>
+<tr>
+<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
+<span class="menutitle">Sitemap</span></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-sitemap.html">Sitemap</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-generators.html">Generators</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-transformers.html">Transformers</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-serializers.html">Serializers</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-matchers.html">Matchers</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-selectors.html">Selectors</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-actions.html">Actions</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-aggregators.html">Aggregators</a></td>
+</tr>
+<tr>
+<td align="left" valign="top"><img width="120" vspace="0" src="images/close.gif" hspace="0" height="14" border="0"><br>
+</td>
+</tr>
+</table>
+</td><td>
+<table cellspacing="15" cellpadding="0" border="0">
+<tr>
+<td><font face="verdana, helvetica, sans serif" size="+2" color="#0086b2">Questions</font>
+<hr style="color: #0086b2" size="1">
+<blockquote>
+<ul>
+<li>
+<font face="verdana, helvetica, sans serif"><a href="#faq-1">
+    When I try to use the Connection pooling code, I get the following exception:
+    "Could not get the datasource java.sql.SQLException: You cannot
+    get a Poolable before the pool is initialized".  What's going on?
+  </a></font>
+</li>
+<li>
+<font face="verdana, helvetica, sans serif"><a href="#faq-2">
+   The sql samples don't run.
+ </a></font>
+</li>
+<li>
+<font face="verdana, helvetica, sans serif"><a href="#faq-3">
+   I've been able to run the database samples, but they don't run anymore.
+ </a></font>
+</li>
+<li>
+<font face="verdana, helvetica, sans serif"><a href="#faq-4">
+   I get an AbstractMethodError when Cocoon tries to query my database.
+ </a></font>
+</li>
+<li>
+<font face="verdana, helvetica, sans serif"><a href="#faq-5">
+   Where can I find more information about connecting to databases using Cocoon?
+ </a></font>
+</li>
+<li>
+<font face="verdana, helvetica, sans serif"><a href="#faq-6">
+  How can I add my FAQ to this document? 
+ </a></font>
+</li>
+<li>
+<font face="verdana, helvetica, sans serif"><a href="#faq-7">
+  How can I suggest improvements to existing FAQs?
+ </a></font>
+</li>
+</ul>
+</blockquote>
+<font face="verdana, helvetica, sans serif" size="+2" color="#0086b2">Answers</font>
+<hr style="color: #0086b2" size="1">
+<a name="faq-1">
+<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
+    When I try to use the Connection pooling code, I get the following exception:
+    "Could not get the datasource java.sql.SQLException: You cannot
+    get a Poolable before the pool is initialized".  What's going on?
+  </b></font>
+  
+  
+    
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+      The most common reason for this exception is that the driver was not loaded.
+      Cocoon uses an initial parameter in the "web.xml" file to automatically load
+      classes on startup.  This way, the class is loaded only once and the server's
+      time is spent doing more productive things.  Make sure the following entry
+      is in your "web.xml" file.
+    </font>
+</p>
+
+    
+<div align="center">
+<table border="0" cellpadding="0" cellspacing="4">
+<tr>
+<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
+</tr>
+<tr>
+<td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td bgcolor="#ffffff">
+<pre>
+&lt;init-param&gt;
+ &lt;param-name&gt;load-class&lt;/param-name&gt;
+ &lt;param-value&gt;
+   &lt;!-- comma or whitespace separated list of fully
+     qualified class names to load on startup.
+   --&gt;
+   oracle.jdbc.driver.OracleDriver
+ &lt;/param-value&gt;
+&lt;/init-param&gt;
+</pre>
+</td><td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
+</tr>
+<tr>
+<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
+</tr>
+</table>
+</div>
+
+    
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+      If the class is loaded correctly, and you are still getting this error, then there
+      is probably an error in your connection information.  The SQLException
+      above is thrown when there are no open connections to the database.
+    </font>
+</p>
+  
+
+<a name="faq-2">
+<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
+   The sql samples don't run.
+ </b></font>
+ 
+ 
+   
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+     The sql samples are working when deploing the war file using the build
+     system:</font>
+</p>
+       
+<div align="center">
+<table border="0" cellpadding="0" cellspacing="4">
+<tr>
+<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
+</tr>
+<tr>
+<td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td bgcolor="#ffffff">
+<pre>
+./build.sh \
+   -Dinclude.webapp.libs=yes \
+   -Dinstall.war=path/to/tomcat/webapps install
+</pre>
+</td><td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
+</tr>
+<tr>
+<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
+</tr>
+</table>
+</div>
+
+   
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+     This command will take care of the path inside the configuration file to the database resources.
+   </font>
+</p>
+ 
+
+<a name="faq-3">
+<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
+   I've been able to run the database samples, but they don't run anymore.
+ </b></font>
+ 
+ 
+   
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+    This happens when the servlet engine has been stopped abruptly (e.g. with ctrl-C).
+   </font>
+</p>
+   
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+    Hsqldb - the database used by C2 samples - is a single-process engine that
+    locks the database by setting the "modified" entry in
+    "WEB-INF/db/cocoondb.properties" to the value "yes" while some JDBC
+    connections exist. 
+   </font>
+</p>
+   
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+    With connection pooling, there's always some connections opened, and they're
+    not closed properly when you stop abruptly the servlet engine, so the database
+    stays in locked state and connections are refused at the next server startup.
+   </font>
+</p>
+   
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+    To unlock the database, change manually "modified" to "no" in the "cocoondb.properties"
+    before restarting the server.
+   </font>
+</p>
+ 
+
+<a name="faq-4">
+<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
+   I get an AbstractMethodError when Cocoon tries to query my database.
+ </b></font>
+ 
+ 
+   
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+    In this case Cocoon returns a "500 internal error" result, and the 
+    AbstractMethodError is visible in the tomcat logs after a call to
+    Connection.prepareStatement(...).
+   </font>
+</p>
+   
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+    This happens when the JDBC driver being used does not implement the
+    JDBC 1.2 interfaces: using its default configuration, the SQLTransformer 
+    calls a version of the JDBC Connection.prepareStatement(...) method that is not
+    available in pre-1.2 drivers.
+   </font>
+</p>
+   
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+    To avoid this problem, configure the SQLTransformer with "old-driver=true" in the
+    sitemap, as shown in this example:
+   </font>
+</p>
+    
+        
+<div align="center">
+<table border="0" cellpadding="0" cellspacing="4">
+<tr>
+<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
+</tr>
+<tr>
+<td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td bgcolor="#ffffff">
+<pre>
+        &lt;map:transformer 
+          logger="sitemap.transformer.sql" 
+          name="sql" 
+          src="org.apache.cocoon.transformation.SQLTransformer"
+        &gt;
+          &lt;old-driver&gt;true&lt;/old-driver&gt;
+        &lt;/map:transformer&gt; 
+        </pre>
+</td><td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
+</tr>
+<tr>
+<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
+</tr>
+</table>
+</div>
+ 
+
+<a name="faq-5">
+<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
+   Where can I find more information about connecting to databases using Cocoon?
+ </b></font>
+ 
+ 
+  
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+Learn more about connecting to databases by downloading the free chapter, <a href="http://www.newriders.com/books/product.asp?product_id={C3C05052-BE3B-4E06-A60A-13FB40AF58F6}">A User's Look at the Cocoon architecture,</a> from Langham and Ziegeler's <i>Cocoon: Building XML Applications</i> available at the New Riders web site.
+  </font>
+</p>
+
+
+<a name="faq-6">
+<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
+  How can I add my FAQ to this document? 
+ </b></font>
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+   Follow the instructions found in <a href="../howto/howto-author-faq.html">How-To Author an FAQ.</a></font>
+</p>
+<a name="faq-7">
+<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
+  How can I suggest improvements to existing FAQs?
+ </b></font>
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+  Given the rapid pace of change with Cocoon, many individual FAQs quickly become out-of-date and confusing to new users. If you have the relevant knowledge, please consider updating other FAQs on this page for technical errors. If you see a few typos, please consider fixing them too.  Follow the instructions found in <a href="../howto/howto-author-faq.html">How-To Author an FAQ.</a></font>
+</p>
+</td>
+</tr>
+</table>
+</td>
+</tr>
+</table>
+<table width="100%" cellspacing="0" cellpadding="0" border="0">
+<tr>
+<td bgcolor="#0086b2"><img width="1" src="images/dot.gif" height="1"></td>
+</tr>
+<tr>
+<td align="center"><font size="-1" face="arial,helvetica,sanserif" color="#0086b2"><i>Copyright &copy; 1999-2002 The Apache Software Foundation. All Rights Reserved.</i></font></td>
+</tr>
+</table>
+</body>
+</html>

Modified: cocoon/site/site/2.0/faq/faq-debugging.html
URL: http://svn.apache.org/viewvc/cocoon/site/site/2.0/faq/faq-debugging.html?rev=573901&r1=573900&r2=573901&view=diff
==============================================================================
--- cocoon/site/site/2.0/faq/faq-debugging.html (original)
+++ cocoon/site/site/2.0/faq/faq-debugging.html Sat Sep  8 13:17:41 2007
@@ -1,245 +1,245 @@
-<html>
-<head>
-<META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
-<title>Debugging FAQs</title>
-<STYLE type="text/css">
-a.menu {
-	color: #FFFFFF;
-    text-align:left;               
-    font-size:12px;
-    font-family: Verdana, Arial, Helvetica, sans-serif;
-    font-weight:plain;
-    text-decoration:none;
-    padding-left: 14px
-}
-
-A.menu:hover {
-	color: #FFCC00
-}
-
-
-.menutitle {
-	color: #000000;
-    text-align:left;               
-    font-size:10px;
-    font-family: Verdana, Arial, Helvetica, sans-serif;
-    font-weight:bold;
-    padding-left: 8px
-}
-.menuselected {
-	color: #FFCC00;
-    text-align:left;               
-    font-size:12px;
-    font-family: Verdana, Arial, Helvetica, sans-serif;
-    font-weight:bold;
-    padding-left: 14px
-}
-</STYLE>
-</head>
-<body bgcolor="#ffffff" marginheight="4" marginwidth="4" leftmargin="4" topmargin="4" alink="#cc0000" vlink="#0086b2" link="#039acc" text="#000000">
-<table border="0" cellpadding="0" cellspacing="0" width="100%">
-<tr>
-<td align="left" valign="top" rowspan="3" height="60" width="135"><img border="0" vspace="0" hspace="0" src="images/logo.gif" height="60" width="135"></td><td background="images/line.gif" rowspan="1" colSpan="2" align="left" valign="top" height="0" width="100%"></td><td align="left" valign="top" rowspan="3" height="60" width="29"><img border="0" vspace="0" hspace="0" src="images/right.gif" height="60" width="29"></td>
-</tr>
-<tr>
-<td bgcolor="#0086b2" colspan="2" align="right" valign="top" height="35" width="100%"><font color="#ffffff" face="Verdana, Arial, Helvetica, sans-serif" size="5">Debugging FAQs</font></td>
-</tr>
-<tr>
-<td background="images/bottom.gif" colspan="2" width="100%" valign="top" height="20" bgcolor="#0086b2" align="right">
-<table width="288" cellspacing="0" cellpadding="0" border="0">
-<tr>
-<td align="left" valign="top" height="20" width="96"><a target="new" href="http://xml.apache.org/"><img border="0" vspace="0" hspace="0" name="xml" src="images/button-xml-lo.gif" height="20" width="96" alt="http://xml.apache.org/"></a></td><td align="left" valign="top" height="20" width="96"><a target="new" href="http://www.apache.org/"><img border="0" vspace="0" hspace="0" name="asf" src="images/button-asf-lo.gif" height="20" width="96" alt="http://www.apache.org/"></a></td><td align="left" valign="top" height="20" width="96"><a target="new" href="http://www.w3.org/"><img border="0" vspace="0" hspace="0" name="w3c" src="images/button-w3c-lo.gif" height="20" width="96" alt="http://www.w3.org/"></a></td>
-</tr>
-</table>
-</td>
-</tr>
-</table>
-<table width="100%" cellspacing="0" cellpadding="0" border="0">
-<tr width="100%">
-<td align="left" valign="top" width="120">
-<table width="120" cellspacing="0" cellpadding="0" border="0" bgcolor="#a0a0a0">
-<tr>
-<td valign="top" align="left"><img width="120" vspace="0" src="images/join.gif" hspace="0" height="14" border="0"><br>
-</td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="../index.html">Main</a></td>
-</tr>
-<tr>
-<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
-<span class="menutitle">FAQs</span></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="index.html">Index</a></td>
-</tr>
-<tr>
-<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
-<span class="menutitle">Getting Started</span></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-install.html">Install</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-configure-environment.html">Configure</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-cvs.html">CVS</a></td>
-</tr>
-<tr>
-<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
-<span class="menutitle">Using</span></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-configure-c2.html">Configure C2</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-databases.html">Databases</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-xsp.html">XSP</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-xslt.html">XSLT</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><span class="menuselected">Debugging</span></td>
-</tr>
-<tr>
-<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
-<span class="menutitle">Sitemap</span></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-sitemap.html">Sitemap</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-generators.html">Generators</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-transformers.html">Transformers</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-serializers.html">Serializers</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-matchers.html">Matchers</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-selectors.html">Selectors</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-actions.html">Actions</a></td>
-</tr>
-<tr>
-<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-aggregators.html">Aggregators</a></td>
-</tr>
-<tr>
-<td align="left" valign="top"><img width="120" vspace="0" src="images/close.gif" hspace="0" height="14" border="0"><br>
-</td>
-</tr>
-</table>
-</td><td>
-<table cellspacing="15" cellpadding="0" border="0">
-<tr>
-<td><font face="verdana, helvetica, sans serif" size="+2" color="#0086b2">Questions</font>
-<hr style="color: #0086b2" size="1">
-<blockquote>
-<ul>
-<li>
-<font face="verdana, helvetica, sans serif"><a href="#faq-1">
-  How do I debug Cocoon using JDK1.3+?
-  </a></font>
-</li>
-<li>
-<font face="verdana, helvetica, sans serif"><a href="#faq-2">
-  How can I add my FAQ to this document? 
- </a></font>
-</li>
-<li>
-<font face="verdana, helvetica, sans serif"><a href="#faq-3">
-  How can I suggest improvements to existing FAQs?
- </a></font>
-</li>
-</ul>
-</blockquote>
-<font face="verdana, helvetica, sans serif" size="+2" color="#0086b2">Answers</font>
-<hr style="color: #0086b2" size="1">
-<a name="faq-1">
-<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
-  How do I debug Cocoon using JDK1.3+?
-  </b></font>
-  
-  
-    
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-    With JDK1.3, set the TOMCAT_OPTS (for Tomcat 3.X) or CATALINA_OPTS 
-    (for Tomcat 4.X) as shown below (on Win2K) and then attach the debugger to
-    localhost:8000 using "<code><font face="courier, monospaced">jdb -attach myhost:8000</font></code>" More information can be found at 
-    <a href="http://java.sun.com/j2se/1.3.0/docs/guide/jpda/conninv.html">JPDA - Connection and Invocation Details</a>.
-    </font>
-</p>
-
-    
-<div align="center">
-<table border="0" cellpadding="0" cellspacing="4">
-<tr>
-<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
-</tr>
-<tr>
-<td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td bgcolor="#ffffff">
-<pre>
-set TOMCAT_OPTS=-classic -Xdebug -Xnoagent -Djava.compiler=NONE
-    -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=8000 
-</pre>
-</td><td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
-</tr>
-<tr>
-<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
-</tr>
-</table>
-</div>
-
-    
-<p>
-<table border="0" cellpadding="0" cellspacing="3" width="100%">
-<tr>
-<td valign="top" width="28"><img alt="Note" border="0" hspace="0" vspace="0" height="29" width="28" src="images/note.gif"></td><td valign="top"><font color="black" face="verdana,helvetica,sanserif" size="-1"><i>
-    This method is supposed to work under JBuilder4.0 as well.
-    </i></font></td>
-</tr>
-</table>
-</p>
-  
-
-<a name="faq-2">
-<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
-  How can I add my FAQ to this document? 
- </b></font>
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-   Follow the instructions found in <a href="../howto/howto-author-faq.html">How-To Author an FAQ.</a></font>
-</p>
-<a name="faq-3">
-<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
-  How can I suggest improvements to existing FAQs?
- </b></font>
-<p>
-<font color="black" face="verdana,helvetica,sanserif">
-  Given the rapid pace of change with Cocoon, many individual FAQs quickly become out-of-date and confusing to new users. If you have the relevant knowledge, please consider updating other FAQs on this page for technical errors. If you see a few typos, please consider fixing them too.  Follow the instructions found in <a href="../howto/howto-author-faq.html">How-To Author an FAQ.</a></font>
-</p>
-</td>
-</tr>
-</table>
-</td>
-</tr>
-</table>
-<table width="100%" cellspacing="0" cellpadding="0" border="0">
-<tr>
-<td bgcolor="#0086b2"><img width="1" src="images/dot.gif" height="1"></td>
-</tr>
-<tr>
-<td align="center"><font size="-1" face="arial,helvetica,sanserif" color="#0086b2"><i>Copyright &copy; 1999-2002 The Apache Software Foundation. All Rights Reserved.</i></font></td>
-</tr>
-</table>
-</body>
-</html>
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+<title>Debugging FAQs</title>
+<STYLE type="text/css">
+a.menu {
+	color: #FFFFFF;
+    text-align:left;               
+    font-size:12px;
+    font-family: Verdana, Arial, Helvetica, sans-serif;
+    font-weight:plain;
+    text-decoration:none;
+    padding-left: 14px
+}
+
+A.menu:hover {
+	color: #FFCC00
+}
+
+
+.menutitle {
+	color: #000000;
+    text-align:left;               
+    font-size:10px;
+    font-family: Verdana, Arial, Helvetica, sans-serif;
+    font-weight:bold;
+    padding-left: 8px
+}
+.menuselected {
+	color: #FFCC00;
+    text-align:left;               
+    font-size:12px;
+    font-family: Verdana, Arial, Helvetica, sans-serif;
+    font-weight:bold;
+    padding-left: 14px
+}
+</STYLE>
+</head>
+<body bgcolor="#ffffff" marginheight="4" marginwidth="4" leftmargin="4" topmargin="4" alink="#cc0000" vlink="#0086b2" link="#039acc" text="#000000">
+<table border="0" cellpadding="0" cellspacing="0" width="100%">
+<tr>
+<td align="left" valign="top" rowspan="3" height="60" width="135"><img border="0" vspace="0" hspace="0" src="images/logo.gif" height="60" width="135"></td><td background="images/line.gif" rowspan="1" colSpan="2" align="left" valign="top" height="0" width="100%"></td><td align="left" valign="top" rowspan="3" height="60" width="29"><img border="0" vspace="0" hspace="0" src="images/right.gif" height="60" width="29"></td>
+</tr>
+<tr>
+<td bgcolor="#0086b2" colspan="2" align="right" valign="top" height="35" width="100%"><font color="#ffffff" face="Verdana, Arial, Helvetica, sans-serif" size="5">Debugging FAQs</font></td>
+</tr>
+<tr>
+<td background="images/bottom.gif" colspan="2" width="100%" valign="top" height="20" bgcolor="#0086b2" align="right">
+<table width="288" cellspacing="0" cellpadding="0" border="0">
+<tr>
+<td align="left" valign="top" height="20" width="96"><a target="new" href="http://xml.apache.org/"><img border="0" vspace="0" hspace="0" name="xml" src="images/button-xml-lo.gif" height="20" width="96" alt="http://xml.apache.org/"></a></td><td align="left" valign="top" height="20" width="96"><a target="new" href="http://www.apache.org/"><img border="0" vspace="0" hspace="0" name="asf" src="images/button-asf-lo.gif" height="20" width="96" alt="http://www.apache.org/"></a></td><td align="left" valign="top" height="20" width="96"><a target="new" href="http://www.w3.org/"><img border="0" vspace="0" hspace="0" name="w3c" src="images/button-w3c-lo.gif" height="20" width="96" alt="http://www.w3.org/"></a></td>
+</tr>
+</table>
+</td>
+</tr>
+</table>
+<table width="100%" cellspacing="0" cellpadding="0" border="0">
+<tr width="100%">
+<td align="left" valign="top" width="120">
+<table width="120" cellspacing="0" cellpadding="0" border="0" bgcolor="#a0a0a0">
+<tr>
+<td valign="top" align="left"><img width="120" vspace="0" src="images/join.gif" hspace="0" height="14" border="0"><br>
+</td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="../index.html">Main</a></td>
+</tr>
+<tr>
+<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
+<span class="menutitle">FAQs</span></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="index.html">Index</a></td>
+</tr>
+<tr>
+<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
+<span class="menutitle">Getting Started</span></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-install.html">Install</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-configure-environment.html">Configure</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-cvs.html">CVS</a></td>
+</tr>
+<tr>
+<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
+<span class="menutitle">Using</span></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-configure-c2.html">Configure C2</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-databases.html">Databases</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-xsp.html">XSP</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-xslt.html">XSLT</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><span class="menuselected">Debugging</span></td>
+</tr>
+<tr>
+<td background="images/label-background_b.gif" bgcolor="#959595" valign="top"><img width="120" height="6" src="images/separator.gif"><br>
+<span class="menutitle">Sitemap</span></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-sitemap.html">Sitemap</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-generators.html">Generators</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-transformers.html">Transformers</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-serializers.html">Serializers</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-matchers.html">Matchers</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-selectors.html">Selectors</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-actions.html">Actions</a></td>
+</tr>
+<tr>
+<td valign="top" bgcolor="#959595" background="images/label-background_a.gif"><a class="menu" href="faq-aggregators.html">Aggregators</a></td>
+</tr>
+<tr>
+<td align="left" valign="top"><img width="120" vspace="0" src="images/close.gif" hspace="0" height="14" border="0"><br>
+</td>
+</tr>
+</table>
+</td><td>
+<table cellspacing="15" cellpadding="0" border="0">
+<tr>
+<td><font face="verdana, helvetica, sans serif" size="+2" color="#0086b2">Questions</font>
+<hr style="color: #0086b2" size="1">
+<blockquote>
+<ul>
+<li>
+<font face="verdana, helvetica, sans serif"><a href="#faq-1">
+  How do I debug Cocoon using JDK1.3+?
+  </a></font>
+</li>
+<li>
+<font face="verdana, helvetica, sans serif"><a href="#faq-2">
+  How can I add my FAQ to this document? 
+ </a></font>
+</li>
+<li>
+<font face="verdana, helvetica, sans serif"><a href="#faq-3">
+  How can I suggest improvements to existing FAQs?
+ </a></font>
+</li>
+</ul>
+</blockquote>
+<font face="verdana, helvetica, sans serif" size="+2" color="#0086b2">Answers</font>
+<hr style="color: #0086b2" size="1">
+<a name="faq-1">
+<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
+  How do I debug Cocoon using JDK1.3+?
+  </b></font>
+  
+  
+    
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+    With JDK1.3, set the TOMCAT_OPTS (for Tomcat 3.X) or CATALINA_OPTS 
+    (for Tomcat 4.X) as shown below (on Win2K) and then attach the debugger to
+    localhost:8000 using "<code><font face="courier, monospaced">jdb -attach myhost:8000</font></code>" More information can be found at 
+    <a href="http://java.sun.com/j2se/1.3.0/docs/guide/jpda/conninv.html">JPDA - Connection and Invocation Details</a>.
+    </font>
+</p>
+
+    
+<div align="center">
+<table border="0" cellpadding="0" cellspacing="4">
+<tr>
+<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
+</tr>
+<tr>
+<td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td bgcolor="#ffffff">
+<pre>
+set TOMCAT_OPTS=-classic -Xdebug -Xnoagent -Djava.compiler=NONE
+    -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=8000 
+</pre>
+</td><td width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
+</tr>
+<tr>
+<td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td><td height="1" width="1" bgcolor="#0086b2"><img border="0" hspace="0" vspace="0" height="1" width="1" src="images/void.gif"></td>
+</tr>
+</table>
+</div>
+
+    
+<p>
+<table border="0" cellpadding="0" cellspacing="3" width="100%">
+<tr>
+<td valign="top" width="28"><img alt="Note" border="0" hspace="0" vspace="0" height="29" width="28" src="images/note.gif"></td><td valign="top"><font color="black" face="verdana,helvetica,sanserif" size="-1"><i>
+    This method is supposed to work under JBuilder4.0 as well.
+    </i></font></td>
+</tr>
+</table>
+</p>
+  
+
+<a name="faq-2">
+<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
+  How can I add my FAQ to this document? 
+ </b></font>
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+   Follow the instructions found in <a href="../howto/howto-author-faq.html">How-To Author an FAQ.</a></font>
+</p>
+<a name="faq-3">
+<!--anchor--></a><font face="verdana, helvetica, sans serif" size="+1" color="#0086b2"><b>
+  How can I suggest improvements to existing FAQs?
+ </b></font>
+<p>
+<font color="black" face="verdana,helvetica,sanserif">
+  Given the rapid pace of change with Cocoon, many individual FAQs quickly become out-of-date and confusing to new users. If you have the relevant knowledge, please consider updating other FAQs on this page for technical errors. If you see a few typos, please consider fixing them too.  Follow the instructions found in <a href="../howto/howto-author-faq.html">How-To Author an FAQ.</a></font>
+</p>
+</td>
+</tr>
+</table>
+</td>
+</tr>
+</table>
+<table width="100%" cellspacing="0" cellpadding="0" border="0">
+<tr>
+<td bgcolor="#0086b2"><img width="1" src="images/dot.gif" height="1"></td>
+</tr>
+<tr>
+<td align="center"><font size="-1" face="arial,helvetica,sanserif" color="#0086b2"><i>Copyright &copy; 1999-2002 The Apache Software Foundation. All Rights Reserved.</i></font></td>
+</tr>
+</table>
+</body>
+</html>