RE: [C2] Connection pool problem with SQL

[HALLOWELL,KARL (HP-Cupertino,ex1)]

Ok, my esql problems went away with a cvs update of the cocoon 2 source
tree. Still getting the same ProcessingException with the "simple SQL"
example. I've made sure that my xerces 1.4 jar appears ahead of the xalan
jar.


Karl Hallowell                 [EMAIL PROTECTED]


> -----Original Message-----
> 
> This is a pretty urgent problem for me (and it's conceivable 
> that this is a
> bug in soon-to-be beta code). I cannot run the SQL examples 
> in cocoon 2. I'm
> using Tomcat 4.0b5, Cocoon 2a7, and Oracle 8i. Here's the 
> problem. When I

<snip>

> Here's some of my configuration information.
> 
> from web.xml:
> 
> ---
>       <param-name>load-class</param-name>
>       <param-value>
>         <!-- For IBM WebSphere: -->
>         com.ibm.servlet.classloader.Handler
> 
>         <!-- For Database Driver: -->
>         oracle.jdbc.driver.OracleDriver
>       </param-value>
>     </init-param>
> ---
> 
> from cocoon.xconf
> 
> ---
>   <datasources>
>     <jdbc name="personnel">
>       <!--
>           If you have an Oracle database, and are using the the
>       pool-controller below, you should add the attribute
>       "oradb" and set it to true.
> 
>       <pool-controller min="5" max="10" oradb="true"/>
> 
>       That way the test to see if the server has disconnected
>       the JdbcConnection will function properly.
>       -->
>       <pool-controller min="5" max="10" oradb="true"/>
>       <!--
>           If you need to ensure an autocommit is set to true or
>       false, then create the "auto-commit" element below.
> 
>       <auto-commit>false</auto-commit>
> 
>       The default is true.
>       -->
>       <dburl>jdbc:oracle:thin:@xxx.yyy.hp.com:1521:ORCL</dburl>
>       <user>scott</user>
>       <password>tiger</password>
>     </jdbc>
>   </datasources>
> ---
> 
> The database URL appears to be correct. I've telneted to the 
> host and port
> in question. The URL was copied in mass from a program where 
> it was working.
> I've verified the tables and data exist by looking in the 
> database via a
> shell. The oracle driver is copied into 
> $TOMCAT_HOME/webapps/cocoon/lib and
> appears to be just fine.
> 
> I've mentioned that I can't get some of the other SQL 
> examples to run. The
> "simple SQL" returns the exception 
> "org.apache.cocoon.ProcessingException:
> Failed to execute 
> pipeline.:org.apache.cocoon.ProcessingException: Failed to
> execute pipeline.:java.lang.NullPointerException". I seem to 
> recall that
> this error appeared before in a sitemap. And the stack trace 
> starts with:
> 
> ---
> org.apache.cocoon.ProcessingException: Failed to execute
> pipeline.:java.lang.NullPointerException
>       at
> org.apache.cocoon.components.pipeline.CachingEventPipeline.pro
> cess(CachingEv
> entPipeline.java, Compiled Code)
>       at
> org.apache.cocoon.components.pipeline.CachingStreamPipeline.pr
> ocess(CachingS
> treamPipeline.java, Compiled Code)
>       at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java,
> Compiled Code)
>       at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java,
> Compiled Code)
>       at 
> org.apache.cocoon.sitemap.Handler.process(Handler.java, Compiled
> Code)
> ---
> 
> What am I missing? Do you need to see my sitemap (or other 
> config files)?
> Thank you very much!

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>