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