cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "dave Cheseldine" <iss...@bangor.ac.uk>
Subject esql Oracle problem
Date Wed, 18 Apr 2001 11:57:36 GMT
Hi

Cocoon 2.0a3
Tomcat 4
Oracle 8.1.6

having problem establishing connection to Oracle db:  compilation falls down
at
        <esql:execute-query>

with following error:

  org.apache.cocoon.ProcessingException: Error compiling _esql_xsp: Line 0,
column
  0:
/export/WWW/docs/javatemp2/cocoon2/tomcat_4/work/localhost/cocoon/_export/_W
WW/_docs/_javatemp2/_cocoon2/_tomcat_4/_webapps/_cocoon/_docs/_samples/_xsp/
_esql_xsp.java:284:
  Exception java.lang.Exception must be caught, or it must be declared in
the throws clause of this method.
  esqlExecuteQuery_N1F(esqlSessions, esqlSession); ^

cocoon.xconf as follows:

<?xml version="1.0"?>
<cocoon version="2.0">

<!-- ===================== General Components
=========================== -->

  <component role="org.apache.cocoon.components.parser.Parser"
class="org.apache.cocoon.components.parser.XercesParser"/>
  <component role="org.apache.cocoon.components.store.Store"
class="org.apache.cocoon.components.store.MemoryStore"/>

  <component
role="org.apache.cocoon.components.language.programming.ProgrammingLanguageS
elector" class="org.apache.cocoon.CocoonComponentSelector">
    <component-instance name="java"
class="org.apache.cocoon.components.language.programming.java.JavaLanguage">
      <parameter name="compiler"
value="org.apache.cocoon.components.language.programming.java.Javac"/>
      <parameter name="code-formatter"
value="org.apache.cocoon.components.language.programming.java.JstyleFormatte
r"/>
      <parameter name="class-loader"
value="org.apache.cocoon.components.classloader.ClassLoaderManagerImpl"/>
    </component-instance>
  </component>

  <component
role="org.apache.cocoon.components.classloader.ClassLoaderManager"
class="org.apache.cocoon.components.classloader.ClassLoaderManagerImpl"/>

  <component
role="org.apache.cocoon.components.language.markup.MarkupLanguageSelector"
class="org.apache.cocoon.CocoonComponentSelector">
    <component-instance name="xsp"
class="org.apache.cocoon.components.language.markup.xsp.XSPMarkupLanguage">
      <parameter name="prefix" value="xsp"/>
      <parameter name="uri" value="http://apache.org/xsp"/>

      <target-language name="java">
        <parameter name="core-logicsheet"
value="resource://org/apache/cocoon/components/language/markup/xsp/java/xsp.
xsl"/>

        <builtin-logicsheet>
          <parameter name="prefix" value="xsp-request"/>
          <parameter name="uri" value="http://apache.org/xsp/request"/>
          <parameter name="href"
value="resource://org/apache/cocoon/components/language/markup/xsp/java/requ
est.xsl"/>
        </builtin-logicsheet>

        <builtin-logicsheet>
          <parameter name="prefix" value="xsp-response"/>
          <parameter name="uri" value="http://apache.org/xsp/response"/>
          <parameter name="href"
value="resource://org/apache/cocoon/components/language/markup/xsp/java/resp
onse.xsl"/>
        </builtin-logicsheet>

 <builtin-logicsheet>
   <parameter name="prefix" value="esql"/>
   <parameter name="uri" value="http://apache.org/cocoon/SQL/v2"/>
   <parameter name="href"
value="resource://org/apache/cocoon/components/language/markup/xsp/java/esql
.xsl"/>
 </builtin-logicsheet>

 <builtin-logicsheet>
   <parameter name="prefix" value="log"/>
   <parameter name="uri" value="http://apache.org/xsp/log"/>
   <parameter name="href"
value="resource://org/apache/cocoon/components/language/markup/xsp/java/log.
xsl"/>
 </builtin-logicsheet>
      </target-language>
    </component-instance>

    <component-instance name="sitemap"
class="org.apache.cocoon.components.language.markup.sitemap.SitemapMarkupLan
guage">
      <parameter name="prefix" value="map"/>
      <parameter name="uri" value="http://apache.org/cocoon/sitemap/1.0"/>

      <target-language name="java">
        <parameter name="core-logicsheet"
value="resource://org/apache/cocoon/components/language/markup/sitemap/java/
sitemap.xsl"/>
      </target-language>
    </component-instance>
  </component>

  <component
role="org.apache.cocoon.components.language.generator.ProgramGenerator"
class="org.apache.cocoon.components.language.generator.ProgramGeneratorImpl"
>
    <parameter name="auto-reload" value="true"/>
  </component>

  <!-- these components is used as a PoolController for the sitemap
component pools  -->
  <component role="org.apache.avalon.util.pool.PoolController"
class="org.apache.cocoon.util.ComponentPoolController"/>

<datasources>
       <component-instance name="foo"
class="org.apache.avalon.util.datasource.JdbcDataSource">
         <pool-controller min="1" max="5"/>
         <driver>oracle.jdbc.driver.OracleDriver</driver>


<dburl>jdbc:oracle:thin:@mimix.bangor.ac.uk:1521:my-test-database</dburl>
         <user>***</user>
         <password>***</password>
      </component-instance>
  </datasources>

  <sitemap file="sitemap.xmap"/>

</cocoon>


I have to admit to an incomplete understanding of cocoon.xconf, but are
there any obvious conflicts in the above?

Thanks in advance

dave Cheseldine



---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message