cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ntic <n...@lespetitsdebrouillards.org>
Subject newby with cocoon esql mysql linux
Date Tue, 17 Jun 2003 19:00:40 GMT
Hello,
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: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


Mime
View raw message