Yes, I've gotten it working fine now, I was plagued by trying to fix things in too many places, however, one should note that if you place the original zip in the lib directory, there are no errors given, all the instructions say to look for an error, the absence of which is supposed to indicate that everything is OK.
I guess that's why the guy that wrote it used to put instructs right into the filename "unjar-me" Now that its on mysql.com and part of their libraries "officially" he's stopped that practice, a shame, but as soon as I saw that I had it fixed. Thanks everyone for the help, I've also proceeded and gotten Cocoon talking with Oracle 8.1.7, using the 9iR2 version of the jdbd driver, with no issues! Christopher Watson wrote: > Vaskin > > I'm guessing (from the class name in your web.xml) you've just downloaded > the new Connector/J from www.mysql.com ?? > In which case ... > > See my annotations below > > >>-----Original Message----- >>From: Vaskin Kissoyan [mailto:[EMAIL PROTECTED]] >>Sent: 06 September 2002 16:22 >>To: [EMAIL PROTECTED] >>Subject: simple connection to MySQL >> >> >>I've tried to follow the how-to's and tutorials on the net and in the >>docs. Someone plase let me know what step I'm missing: >> >>0) >>* Built 2.0.3 with all the samples and libs, installed war file under >>Tomcat 4.04, under JDK 1.4 >>* Built same tables with given sql file in mysql on a default install of >>3.23.51 on same machine (localhost), database is cocoon >> >> >>1) Dropped the zip file into appropriate place: >>* tried both as zip and renamed to jar >>* tried in server\lib and also cocoon\WEB-INF\lib > > > The file you need to take out of the zip and put in cocoon\WEB-INF\lib is > mysql-connector-java-2.0.14-bin.jar > > >>2) Added the following to cocoon.xconf inside <datasources/> under the >>default built in element <jdbc name="personnel"/> >> <jdbc name="mypool"> >> <pool-controller min="1" max="5"/> >> <dburl>jdbc:mysql://localhost/cocoon</dburl> >> <user>root</user> >> <password/> >> </jdbc> >> > > Try <dburl>jdbc:mysql://localhost:3306/cocoon</dburl> > where cocoon is whatever you've called your mysql database > 3306 is the port number used by mysql, and I don't think the driver defaults > to use 3306 - you have to tell it > > >>4) Added the load-class in cocoon's web.xml as follows >> <init-param> >> <param-name>load-class</param-name> >> <param-value> >> <!-- For IBM WebSphere: >> com.ibm.servlet.classloader.Handler --> >> >> <!-- For Database Driver: --> >> org.hsqldb.jdbcDriver >> com.mysql.jdbc.Driver > > > That's right for the new Connector/J > > (The old Mark Matthews JDBC library - from wich Connector/J was derived - > used a class name org.gjt.mm.mysql.Driver, which is what some other people > who've replied to you are referring to.) > > >> <!-- For parent ComponentManager sample: >> org.apache.cocoon.samples.parentcm.Configurator >> --> >> </param-value> >> </init-param> >> >>4) Getting the following error: >>org.apache.cocoon.ProcessingException: Exception in >>ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not >>get the datasource java.sql.SQLException: No suitable driver >> >>When I try to pull up the ESQL sample > > > Have you changed the ESQL sample to use YOUR pool, which, from the above, > you've called "mypool" ? > You'll also need to have populated your mysql database, which, from the > above, you've called cocoon ... > > >>Any help would be appreciated. >> > > > I've tried. Hope it works! > > Christopher Watson > --------------------------------------------------------------------- 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]>
