cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Claude Moissinac <jcmoissi...@gmail.com>
Subject Re: MySQL and Cocoon
Date Tue, 27 Dec 2005 15:55:57 GMT
My experience with mySql is:
- you need to have the good driver, typically in WEB-INF/lib, you need a
jdbc connector found in http://dev.mysql.com/downloads/connector/j/3.0.html;
you could have some problem between version of connector and version of Java
- in WEB-INF/cocoon.xconf <http://shadok.enst.fr:8080/tests/sqlcomment#>,
you have to define the access to your database; for example:
<jdbc name="france">
<pool-controller min="5" max="10"/>
<dburl>jdbc:mysql://localhost:3306/france0104?autoReconnect=true</dburl>
<user>cestmoi</user>
<password>zzzzzz</password>
</jdbc>
where france is the name of the data source which will be used in the
sitemap
the database is france104 and the access to the database is defined for the
user cestmoi with the password zzzzzz
- in WEB-INF/web.xml, you have to define the connector used for mysql with
something like
<init-param>
<param-name>load-class</param-name>
<param-value>
<!-- For parent ComponentManager sample:
org.apache.cocoon.samples.parentcm.Configurator -->
<!-- For IBM WebSphere: com.ibm.servlet.classloader.Handler -->
<!-- For MySQL Driver: --> com.mysql.jdbc.Driver
<!-- or use org.gjt.mm.mysql.Driver if you have the older 'Mark Matthews'
driver-->
<!-- For Database Driver: --> org.hsqldb.jdbcDriver
</param-value>
</init-param>

Known problems:
- you need coherent versions: my config is JDK 1.5 with saxon8 and
mysql-connector-java-3.0.16-ga-bin.jar in cocoon 2.2.0
- you could have some problems with the permissions defined for the database

Good luck

On 12/25/05, sergio del amo <sergi@sbox.tugraz.at> wrote:
>
> Hi,
> I am trying to query a mysql database from my cocoon installation. I am
> using Cocoon as a webapp of tomcat.
> I made the next changes:
>
> I added mysql Driver to web.xml:
>
>    <init-param>
>       <param-name>load-class</param-name>
>       <param-value>
>         <!-- For parent ComponentManager sample:
>         org.apache.cocoon.samples.parentcm.Configurator -->
>         <!-- For IBM WebSphere:
>         com.ibm.servlet.classloader.Handler -->
>
>         <!-- For Database Driver: -->
>         <!--org.hsqldb.jdbcDriver-->
>
>         <!-- Example for a MySQL database driver -->
>         com.mysql.jdbc.Driver
>         <!--org.gjt.mm.mysql.Driver-->
>         </param-value>
>     </init-param>
>
>
> I added an entry to cocoon.xconf:
>
>    <jdbc name="mmis2">
>       <pool-controller max="10" min="5"/>
>       <auto-commit>true</auto-commit>
>       <dburl>jdbc:mysql://localhost/mmis2</dburl>
>       <user>user</user>
>       <password>user123</password>
>     </jdbc>
>
> and a match pipeline to sitemap.xmap:
>
>   <map:match pattern="index.html">
>      <map:generate src="style/queries/query.xml"/>
>      <map:transform type="sql">
>          <map:parameter name="use-connection" value="mmis2"/>
>      </map:transform>
>      <map:serialize type="xml"/>
>   </map:match>
>
> query.xml is:
>
>     <?xml version="1.0"?>
>     <results xmlns:sql="http://apache.org/cocoon/SQL/2.0">
>         <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0">
>             <sql:query>
>               select * from collections
>             </sql:query>
>         </sql:execute-query>
>     </results>
>
> I copied the mysql connector (mysql-connector-java-3.0.16-ga-bin.jar) to
> cocoon/WEB-INF/lib
>
> I thought everything was well configured but i get always:
>
> "Failed to obtain connection. Made 5 attempts with 5000ms interval"
>
> Any clue, why i am still getting this error?
>
> thanks in advanced for your future feedback and merry christmas!!
> sergio
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>


--
--
Jean-Claude Moissinac
Department of Computer Science and Networks
ENST Paris
FRANCE

E-mail: moissinac@enst.fr
Tel: (+33) 1.45.81.80.88
Fax: (+33) 1.45.81.71.58

http://shadok.enst.fr/jcm

Mime
View raw message