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