cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kieran Kirwan" <KKir...@dto.ie>
Subject Cocoon and MySQL databases: Working Versions
Date Mon, 28 Jul 2003 12:18:22 GMT
Just to let everyone know what works - for future reference

- Apache Tomcat 4.0
- Cocoon 2.0.4.
- mysql-connector-java-3.0.8-stable-bin.jar
- excalibur-datasource-1.1.1.jar
- j2sdk1.4.1_01



> 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.


_____________________________________________
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/>  
 



-----Original Message-----
From: Kieran Kirwan 
Sent: 28 July 2003 13:15
To: users@cocoon.apache.org
Subject: RE: Cocoon and MySQL databases




That did the trick (excalibur-datasource-1.1.1.jar)
Thanks to everyone for your replies.

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/>  
 



-----Original Message-----
From: Geert Van Damme [mailto:geert.vandamme@vdab.be]
Sent: 28 July 2003 12:59
To: users@cocoon.apache.org
Subject: Re: Cocoon and MySQL databases



We had the same problem (not with MySQL).
Problem is that the excalibur-datasource-vm12-20021121.jar distributed with Cocoon2 does not
contain the Jdbc3Connection class, which it should.
Download the correct version from http://jakarta.apache.org/builds/jakarta-avalon/release/excalibur/

If you can't find the specific jar, let me know, I have a working version here so I can mail
it to you directly.

Regards,
Geert



>>> cocoon@leverageweb.com 07/28/03 01:47pm >>>
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 


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

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

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


Mime
View raw message