problem in Lenya MySql database connection

Prabhjot <[email protected]> Wed, 17 Aug 2011 15:24:15 +0530
Newsgroups gmane.comp.cms.lenya.user
Message-ID <[email protected]> 
--------------070907080803040707090102
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi All

I have a problem in Lenya MySql database connection. I am using Lenya2.0 
Firedocs. Apparently I have done the following things :

1. I downloaded  "mysql-connector-java-3.1.14" and I put the copy of the 
driver jar in the Lenya/web-inf/lib*// *directory.

2. Then I set the /init-param/ in web.xml as follows :

<init-param>
   <param-name>load-class</param-name>
   <param-value>com.mysql.jdbc.Driver</param-value>
<init-param>

3. Next , I set the datasource in cocoon.xconf as follows :

But it is still giving some problems. I debugged it and here is what the 
error it is raising:

"Failed to obtain connection from datasource 'prabhjot'. Made 5 attempts 
with 5000ms interval"

Please suggest me how I can fix the same.

Thanks

--------------070907080803040707090102
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body text="#000000" bgcolor="#ffffff">
    Hi All<br>
    <br>
    I have a problem in Lenya MySql database connection. I am using
    Lenya2.0 Firedocs. Apparently I have done the following things :<br>
    <br>
    1. I downloaded&nbsp; "mysql-connector-java-3.1.14" and I put the copy of
    the driver jar in the Lenya/web-inf/lib<strong><em></em> </strong>directory.

    <br>
    <br>
    2. Then I set the <em>init-param</em> in web.xml as follows :<br>
    <pre>&lt;init-param&gt;
  &lt;param-name&gt;load-class&lt;/param-name&gt;
  &lt;param-value&gt;<tt>com.mysql.jdbc.Driver</tt>&lt;/param-value&gt;
&lt;init-param&gt;</pre>
    3. Next , I set the datasource in cocoon.xconf as follows :<br>
    <br>
    But it is still giving some problems. I debugged it and here is what
    the error it is raising:<br>
    <br>
    "Failed to obtain connection from datasource 'prabhjot'. Made 5
    attempts with 5000ms interval"<br>
    <br>
    Please suggest me how I can fix the same.<br>
    <br>
    Thanks<br>
  </body>
</html>

--------------070907080803040707090102--