Cocoon 2.0.2dev, oracle 8

[snpe]

Hello,
   I have tried Cocoon 2.0.2-dev, tomcat 4.0.3 and jdk1.4
I have tried connection in oracle.

Next xsp is fine :

<?xml version="1.0" encoding="ISO-8859-1"?>

<!-- CVS: $Id: esql.xsp,v 1.4 2002/02/09 06:21:57 vgritsenko Exp $ -->

<xsp:page language="java"
          xmlns:xsp="http://apache.org/xsp";
              xmlns:esql="http://apache.org/cocoon/SQL/v2";>

  <page>
   <title>A Database Driven XSP Page</title>

   <content>

   <esql:connection>
     <esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
     <esql:dburl>jdbc:oracle:thin:scott/tiger@spnew:1521:V8</esql:dburl>
     <esql:execute-query>
       <esql:query>select * from emp</esql:query>
       <esql:results>
         <esql:row-results>
           <!--
           <para><esql:get-string column="ename"/></para>
           -->
           <esql:get-columns/>
         </esql:row-results>
       </esql:results>
     </esql:execute-query>
   </esql:connection>

   </content>
  </page>
</xsp:page>

but next sample not  (JdbcConection is not valid)

<?xml version="1.0" encoding="ISO-8859-1"?>

<!-- CVS: $Id: esql.xsp,v 1.4 2002/02/09 06:21:57 vgritsenko Exp $ -->

<xsp:page language="java"
          xmlns:xsp="http://apache.org/xsp";
              xmlns:esql="http://apache.org/cocoon/SQL/v2";>

  <page>
   <title>A Database Driven XSP Page</title>

   <content>

   <esql:connection>
     <esql:pool>oracle_scott</esql:pool>
     <esql:execute-query>
       <esql:query>select * from emp</esql:query>
       <esql:results>
         <esql:row-results>
           <para><esql:get-string column="ename"/></para>
           <esql:get-columns/>
         </esql:row-results>
       </esql:results>
     </esql:execute-query>
   </esql:connection>

   </content>
  </page>
</xsp:page>

 web.xml
...
 <init-param>
      <param-name>load-class</param-name>
      <param-value>
        
        oracle.jdbc.driver.OracleDriver

      </param-value>
    </init-param>
....
cocoon.xconf
...
 <datasources>
    <jdbc name="oracle_scott" >

      <pool-controller min="5" max="10" oradb="true"/>

      <dburl>jdbc:oracle:thin:@spnew:1521:V8</dburl>
      <user>scott</user>
      <password>tiger</password>
    </jdbc>
  </datasources>
...

What is wrong ?

regards
peco


---------------------------------------------------------------------
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]>