Took a closer look on my config, I also have <driver>com.mysql.jdbc.Driver</driver> in my xconf mysql part. I'm not sure if this could make a difference. Back when I was having problems setting mysql up on a JDK1.3.1 box, someone pointed me to the fact that I'd better use the latest versions possible of required software. Doing so actually solved my mysterious driver problems. Maybe it's worth the effort to try upgrading to JDK1.4...
JW > -----Original Message----- > From: Jessica Niewint [mailto:[EMAIL PROTECTED]] > Sent: donderdag 29 augustus 2002 10:12 > To: [EMAIL PROTECTED] > Subject: Re: Installing mysql JDBC Driver > > > > 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. I got exactly all this. The only point is that > there a still the standard > driver in my installation. > > my web.xml > <init-param> > <param-name>load-class</param-name> > <param-value> > <!-- For IBM WebSphere: > com.ibm.servlet.classloader.Handler --> > > <!-- For Database Driver: --> > org.hsqldb.jdbcDriver > > <!-- For parent ComponentManager sample: > org.apache.cocoon.samples.parentcm.Configurator > --> > org.gjt.mm.mysql.Driver > </param-value> > </init-param> > > > > my cocoon.xconf: > <datasources> > <jdbc logger="core.datasources.personnel" name="personnel"> > <!-- > If you have an Oracle database, and are using the the > pool-controller below, you should add the attribute > "oradb" and set it to true. > > <pool-controller min="5" max="10" oradb="true"/> > > That way the test to see if the server has disconnected > the JdbcConnection will function properly. > --> > <pool-controller max="10" min="5"/> > <!-- > If you need to ensure an autocommit is set to true or > false, then create the "auto-commit" element below. > > <auto-commit>false</auto-commit> > > The default is true. > --> > <dburl>jdbc:hsqldb:hsql://localhost:9002</dburl> > <user>sa</user> > <password/> > </jdbc> > > <!-- my mysql driver --> > <jdbc name="mysql"> > <pool-controller max="10" min="5"/> > <dburl>jdbc:mysql://localhost/test</dburl> > <user>root</user> > <password></password> > </jdbc> > > </datasources> > > > Could there be another problem ? > > > At 16.37 28/08/2002 +0100, you wrote: > > >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 > > > > > > > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
