Did you cut and paste the cocoon.xconf? It can't find the url, and the url tag is durl instead of dburl. I think you said this worked in a previous version of cocoon, and I don't know if the cocoon.roles has changed since then. Let me know if it's just a simple typeo before I try to load your config. Thanks. b
Olivier GUCKERT <[EMAIL PROTECTED]> wrote: > > >[EMAIL PROTECTED] a écrit : >> >> What component are you using? SQLTransformer? Database Action? Can you post the >relevant portions of cocoon.xconf/sitemap.xmap? > >here is my configuration : > >In web.xml : > <init-param> > <param-name>load-class</param-name> > <param-value> > > <!-- pour mysql --> > org.gjt.mm.mysql.Driver > > >in access.log : >DEBUG (2002-09-27) 10:40.03:837 [access] (Unknown-URI) >Unknown-thread/CocoonServlet: Trying to load class: >org.gjt.mm.mysql.Driver > >so i think the dirver is OK... > >in cocoon.xconf : > <datasources> > > <jdbc name="mysql_pool"> > <pool-controler min="5" max="10"/> > <auto-commit>true</auto-commit> > <durl>jdbc:mysql://aube.loria.fr/guckdb</durl> > <user>mylogin</user> > <password>mypassword</password> > </jdbc> > >in sitemap.xmap : > <map:match pattern="donnees.xml"> > <map:generate src="documents/donnees.xsp" type="serverpages"/> > <map:transform type="xslt" src="stylesheets/donnees_xml.xsl"/> > <map:serialize type="xml"/> > </map:match> > >in donnees.xsp : ><?xml version="1.0"?> ><xsp:page language="java" > xmlns:xsp="http://apache.org/xsp" > xmlns:esql="http://apache.org/cocoon/SQL/v2" > xmlns:xsp-request="http://apache.org/xsp/request/2.0"> > <lignes> > <esql:connection> > <esql:pool>mysql_pool</esql:pool> > <esql:execute-query> > <esql:query>SELECT * FROM > <xsp-request:get-parameter name="table"/> > </esql:query> > <esql:results> > <table> > <xsp-request:get-parameter name="table"/> > </table> > <esql:row-results> > <ligne> > <esql:get-columns/> > </ligne> > </esql:row-results> > </esql:results> > <esql:no-results/> > <esql:error-results/> > </esql:execute-query> > </esql:connection> > </lignes> ></xsp:page> > >I work on Mandrake Linux release 8.1. >jakarta-tomcat-4.1.10 >jdk1.3.1_01 >cocoon-2.0.3 > >So, if y ask : >http://greau.loria.fr:8080/cocoon/referentiels/donnees/donnees.xml?table=Assistante_Structure > >i become the folowing message : >org.apache.cocoon.ProcessingException: Exception in >ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not >get the datasource java.sql.SQLException: The url cannot be null > >--------------------------------------------------------------------- >Please check that your question has not already been answered in the >FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> > >To unsubscribe, e-mail: <[EMAIL PROTECTED]> >For additional commands, e-mail: <[EMAIL PROTECTED]> > > __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>