I've got some trouble with my cocoon configuration.
I've got :
mysql ver. 3.23.54
the driver is mysql-connector-java-3.0.8-stable-bin.jar in webapps/cocoon/WEB-INF/lib/
cocoon 2.0.4
my sitemap.xmap file contain :
*<map:sitemap xmlns:map="http://apache.org/cocoon/sitemap/1.0";>
<map:components>
<map:generators>
<map:generator name="serverpages" src="org.apache.cocoon.generation.ServerPagesGenerator"/>
</map:generators>
<map:serializers>
<map:serializer name="xml" mime-type="text/xml" src="org.apache.cocoon.serialization.XMLSerializer"/>
</map:serializers>
<map:matchers default="wildcard">
<map:matcher name="wildcard" src="org.apache.cocoon.matching.WildcardURIMatcher"/>
</map:matchers>
</map:components>
<map:pipelines>
<map:pipeline>
<map:match pattern="*.xsp">
<map:generate type="serverpages" src="{1}.xsp"/>
<map:serialize type="xml"/>
</map:match>
</map:pipeline>
</map:pipelines>
</map:sitemap>
*
the web.xml contain :
* <init-param>
<param-name>load-class</param-name>
<param-value>
org.hsqldb.jdbcDriver
com.mysql.jdbc.Driver
</param-value>
</init-param>
*
the cocoon.xconf contain :
* <datasources>
<jdbc logger="core.datasources.personnel" name="personnel">
<pool-controller max="10" min="5"/>
<dburl>jdbc:hsqldb:hsql://localhost:9002</dburl>
<user>sa</user>
<password/>
</jdbc>
<jdbc name="ma_table_tbl" logger="core.datasources.ma_table_tbl">
<pool-controller min="5" max="10"/>
<dburl>jdbc:mysql://localhost/ma_table_tbl</dburl>
<user>username</user>
<password>password</password>
</jdbc>
</datasources>
*
my xsp file contains :
*<?xml version="1.0" encoding="iso-8859-1"?>
<xsp:page language="java" xmlns:xsp="http://apache.org/xsp"; xmlns:esql="http://apache.org/cocoon/SQL/v2";>
<liste_mc>
<esql:connection>
<esql:driver>com.mysql.jdbc.Driver</esql:driver>
<esql:dburl>jdbc:mysql://localhost/ma_table_tbl</esql:dburl>
<esql:username>username</esql:username>
<esql:password>password</esql:password>
<esql:execute-query>
<esql:query>
SELECT type FROM type_tbl </esql:query>
<esql:results>
<esql:row-results>
<type><esql:get-string column="type"/></type>
</esql:row-results>
</esql:results>
<esql:error-results><erreure>erreure</erreure></esql:error-results>
<esql:no-results><pasres>no result</pasres></esql:no-results>
</esql:execute-query>
</esql:connection>
</liste_mc>
</xsp:page>
*
The query works properly when i use it in command-line, the cocoon-xsp work properly (i try it with a script of factorial calculus).
The problem is tha there is no connection to my database (the long-format log of mysql is not informed of this kind of connection) and the WEB-INF/log/error.log says :
*ERROR (2003-06-17) 19:34.44:382 [core.manager] (/cocoon/mount/xsp/form_recherche.xsp) Thread-10/sitemap_xmap: Sitemap
org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Error opening connection to dburl: jdbc:mysql://localhost/ma_table_tbl: Server configuration denies access to data source
at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:270)
*
I search the web and the mail archive but i don't find any response.
I search the answer since three days and i become to be a little bit upset...
If someone can help me..
thx a lot
Alex
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
