cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Johns...@netscape.net
Subject Re: problem with database connection
Date Fri, 27 Sep 2002 12:01:15 GMT
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 <Olivier.Guckert@loria.fr> wrote:

>
>
>JohnsBrn@netscape.net 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:     <cocoon-users-unsubscribe@xml.apache.org>
>For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>
>
>

__________________________________________________________________
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message