forrest-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sedziwoj <>
Subject Re: Database Plugin
Date Sun, 05 Feb 2006 22:08:42 GMT
Ross Gardler napisaƂ(a):

> Just change the xconf and xweb configuration (in the conf directory) to 
> use the mySQL driver and your database settings.

This is my config modyfication:


     <jdbc name="telefony">
       <pool-controller min="5" max="10"/> 


	unless="text()[contains(string(.),'com.mysql.jdbc.Driver')] |
         <!-- For Database Driver: -->



<map:sitemap xmlns:map="">
	<map:transformers default="xslt">
	  <map:transformer name="sql" 

	   <map:match pattern="ks_tel.xml">
	    <map:generate src="{project:content.xdocs}/kt/ks_tel.xml"/>
		<map:transform type="sql">
	  	  <map:parameter name="dburl" 
	      <map:parameter name="username" value="MyUser"/>
		  <map:parameter name="password" value="MyPassword"/>
		  <map:parameter name="show-nr-of-rows" value="true"/>
		<map:transform src="resources/stylesheets/sqldata2table.xsl"/>
	    <map:serialize type="xml"/>



My XML file:

   <sql:execute-query xmlns:sql="">
       select * from telefony;

Forrest even not trying connect to DB server (I checked this in server 
logs). I don't know what is wrong. Can you help me? I dont know Java 
lang. or Cocoon.

> The plugin is only a slightly modified version of the Cocoon Database 
> block, the documentation for the Cocoon Block is still relevant.

I checked this documentation, description of SQL Transformer, articles 
in Cocoon Wiki about database connection and "A User's Look at the 
Cocoon Architecture By Matthew Langham, Carsten Ziegeler" - description 
of Cocoon-database connection. I still don't know when I do wrong. Can 
you help me?

Thank you

View raw message