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