Re: Installing mysql JDBC Driver

[Jeremy Aston]

Hi Jessica,

You should have something like this in web.xml

    <init-param>
      <param-name>load-class</param-name>
      <param-value>
          org.gjt.mm.mysql.Driver
      </param-value>
    </init-param>

and something like this in cocoon.xconf

  <datasources>
    <jdbc name="mysqlds">
      <pool-controller min="5" max="10"/>
      <dburl>jdbc:mysql://127.0.0.1/databasename</dburl>
      <user>root</user>
      <password></password>
    </jdbc>
  </datasources>

If there are no config problems then post your web.xml and cocoon.xconf extracts and I'll have a look.  the jar should be fine in WEB-INF/lib.

Jez

 

 

  Jessica Niewint <[EMAIL PROTECTED]> wrote:

My configuration:
tomcat 4.0.4, cocoon 2.0.3, java jdk1.2.2

In copied the mm.mysql-2.0.4-bin.jar file into the lib folder of
cocoon/WEB-INF. I loaded the driver in the web.xml file. When I check now
the installation in the access.log file I got the following message:
DEBUG (2002-08-28) 16:35.15:025 [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Trying to load class: org.gjt.mm.mysql.Driver
INFO (2002-08-28) 16:35.15:088 [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Reloading from:
jndi:/localhost/cocoon/WEB-INF/cocoon.xconf

if I try to configure my connection pool in cocoon.xconf : I got the
following exeption:

DEBUG (2002-08-09) 17:42.10:231 [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Trying to load class: org.gjt.mm.mysql.Driver
WARN (2002-08-09) 17:42.10:287 [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Could not force-load class:
org.gjt.mm.mysql.Driver
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1406)
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1254)
at org.apache.cocoon.util.ClassUtils.loadClass(ClassUtils.java:88)
at org.apache.cocoon.servlet.CocoonServlet.forceLoad(CocoonServlet.java:842)
at
org.apache.cocoon.servlet.CocoonServlet.createCocoon(CocoonServlet.java:1219)
at org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:435)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:918)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:810)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3279)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3421)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:785)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:478)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:738)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:324)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:389)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:232)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:155)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1131)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:638)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
at org.apache.catalina.core.StandardService.start(StandardService.java:388)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
INFO (2002-08-09) 17:42.10:432 [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Reloading from:
jndi:/localhost/cocoon/WEB-INF/cocoon.xconf

I really have no clue. Why is it impossible to define a connection pool for
mysql ? Do I have to change the name of the mm.mysql-2.0.4-bin.jar file ?
What can I do to make everything work ?
Thanks in advance, Jessi


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting.

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

jez
[EMAIL PROTECTED]
+44 (0)7768 277092
+44 (0)1903 715458
ICQ 67849002

---

Get a bigger mailbox -- choose a size that fits your needs.

http://uk.docs.yahoo.com/mail_storage.html