I upgraded to the com.mysql.jdbc.Driver, same error. The settings you described are like I already had.
> Try jdk1.4.1 and the cvs HEAD of Cocoon. If your going to be > on the edge, then being one or two versions back can be > rougher than being where the developers are; the developers > are more likely to address any problems you discover if your > working with the cvs HEAD. I thougtht it was better to user j2sdk1.3 when using database connections with cocoon2? JW > -----Original Message----- > From: Roger I Martin PhD [mailto:[EMAIL PROTECTED]] > Sent: vrijdag 16 augustus 2002 21:30 > To: [EMAIL PROTECTED] > Subject: Re: [repost] MySQL no suitable driver > > > Look at http://xml.apache.org/cocoon/developing/datasources.html > > It's good if the pool is initialized long before your xsp's need it. > > In your web.xml file. The you need the following snippet with : > > ... > <init-param> > <param-name>load-class</param-name> > <param-value> > <!-- For MySQL Database: --> > com.mysql.jdbc.Driver > > <!-- For PostgeSQL Database: --> > postgresql.Driver > > <!-- For Oracle Database: --> > oracle.jdbc.driver.OracleDriver > > </param-value> > </init-param> > ... > with the MySQL driver added. Then in your cocoon.xconf you need: > > ... > <datasources> > <jdbc name="MY_POOL"> > <driver>com.mysql.jdbc.Driver</driver> > <pool-controller min="1" max="10"/> > <!--auto-commit>false</auto-commit--> > <dburl>jdbc:mysql://localhost:3306/test</dburl> > <user>root</user> > <password>5h4p3r5</password> > </jdbc> > </datasources> > ... > > Then in one of your xsp's > ... > <esql:connection> > <esql:pool>MY_POOL</esql:pool> > <esql:execute-query> > <esql:query>select * from > MY_DATABASE_TABLE</esql:query> > <esql:results> > <esql:row-results> > <!-- do what you want with the results here--> > </esql:row-results> > </esql:results> > </esql:execute-query> > </esql:connection> > ... > --------------------------------------------------------------------- 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]>
