cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Geoff Howard <coc...@leverageweb.com>
Subject Re: Cocoon and MySQL databases
Date Mon, 28 Jul 2003 11:47:10 GMT
What happens if you put the mysql jar in WEB-INF\lib?  Also, is this a 
binary version of 2.0.4 or did you build from source?

Geoff

Kieran Kirwan wrote:
> I'm using Apache Tomcat 4.0 and Cocoon 2.0.4.
> I've got a MySQL database called 'abc' which contains a table 'TroubleTickets'.
> I can view this using mySQL.exe and it appears to be fine.
> 
> ... however I can't seem to access this from Cocoon.  I'm following the steps in 'Cocoon
Developers Handbook' as follows.
> 
> 1	Place mysql-connector-java-3.0.8-stable-bin.jar in C:\Program Files\Apache Tomcat 4.0\common\lib
> 2	Preload JDBC driver
> 3	Define connection pool
> 4	Create ESQL query
> 5	Sitemap Entry
> 
> 
> The key inputs i'm using are as follows.
> 
> 2	Preload JDBC driver (web.xml)
> <init-param>
>       <param-name>load-class</param-name>
>       <param-value>
>         org.gjt.mm.mysql.Driver
>       </param-value>
> </init-param>
> 
> 
> 2	Define connection pool (cocooon.xconf)
> <jdbc name="abc" logger="core.datasources.abc">
> <pool-controller min="5" max="10"/>
> <auto-commit>false</auto-commit>
> <dburl>jdbc:mysql://localhost/abc</dburl>  
> <user>root</user>
> <password/>
> </jdbc>
> 
> 
> 3	Create ESQL query (tickets.xsp)
> 
> <?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">
> <page>
>  <content>
>   <esql:connection>
>    <esql:pool>abc</esql:pool>
>    <esql:execute-query>
>     <esql:query>
> 		select * from TroubleTickets
>     </esql:query>
>     <esql:results>
>      <tickets>
>       <esql:row-results>
>        <ticket>
>         <esql:get-columns/>
>        </ticket>
>       </esql:row-results>
>      </tickets>
>     </esql:results>
>    </esql:execute-query>
>   </esql:connection>
>  </content>
> </page>
> </xsp:page>
> 
> 
> 4	Sitemap Entry
> <map:match pattern="tickets">
> 	<map:generate type="serverpages" src="tickets.xsp"/>
> 	<map:serialize type="xml"/>
> </map:match>
> 
> 
> 
> I'm getting an error in core.log as follows:
> 
> DEBUG   (2003-07-28) 12:07.41:467   [core.datasources.abc] (/cocoon/traffic-xml/ticketsXML)
HttpProcessor[8080][4]/JdbcConnectionFactory: Exception in JdbcConnectionFactory.newInstance:
> java.lang.ClassNotFoundException: org.apache.avalon.excalibur.datasource.Jdbc3Connection
> 
> Am I doing something silly? Or is this a Cocoon bug?
> I also found this link: http://archives.real-time.com/pipermail/cocoon-devel/2003-June/015269.html
> 
> 
> Thanks for you help,
> 
> Kieran
> 
> _____________________________________________
> Kieran Kirwan
> Executive Transportation Planner
> Transportation Modelling Department
>  
> Dublin Transportation Office
> Hainault House,
> 69/71 St. Stephen's Green,
> Dublin 2,
> Ireland.
> Tel: +353 (0)1 4778113
> Fax: +353 (0) 1 478 5935
> website: www.dto.ie <http://www.dto.ie/> 
>  
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> 
> This footnote also confirms that this email message has been swept by
> Mail Marshal for the presence of computer viruses.
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
> 
> 
> 
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message