yes and in my access log it says trying to load and the driver name. i don't know if this means it failed or it loaded ok. is there any way to tell if it is loaded ok? and if it is loaded ok does the pool know to use that driver by default?
thanks for your help. Jeremy ----- Original Message ----- From: "Chris Newland" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 11:28 AM Subject: RE: Update on my problem > Hi Jeremy, > > Have you added your database driver info to your WEB-INF/web.xml file? > > ------------- > cocoon.xconf: > ------------- > > <datasources> > <jdbc name="tester"> > <pool-controller min="5" max="10"/> > <dburl>jdbc:mysql://localhost:3306/tester</dburl> > <auto-commit>true</auto-commit> > <user>login</user> > <password>pass</password> > </jdbc> > </datasources> > > ---------------- > WEB-INF/web.xml: > ---------------- > > <!-- > This parameter is used to list classes that should be loaded > at initialization time of the servlet. > Usually this classes are JDBC Drivers used > --> > <init-param> > <param-name>load-class</param-name> > <param-value> > <!-- For IBM WebSphere: > com.ibm.servlet.classloader.Handler --> > > <!-- For Database Driver: --> > org.gjt.mm.mysql.Driver > </param-value> > </init-param> > > > Hope this helps, > > Regards, > > Chris > > > -----Original Message----- > From: Jeremy Beeler [mailto:[EMAIL PROTECTED]] > Sent: 28 March 2002 16:14 > To: [EMAIL PROTECTED] > Subject: Update on my problem > > > I am using j2sdk1.4.0, tomcat 4.0.4b2LE, mm.mysql-2.0.11 or mm.mysql-2.0.7 > (tried both), and cocoon 2.0.3-dev. > > Update on my problem: > > I can query the database now by instantiating a connection in my xsp app. > however, the app that i am writing needs to use the pooling capabilities to > handle simultaneous access to the DB. does anyone know how to get this to > work??? i tried creating the pool with a "driver" tag in my cocoon.xconf but > that still generates the exception (NoValidConnectionException: No valid > JdbcConnection class available) > > this is my code: > > <datasources> > <jdbc name="tester"> > <driver>org.gjt.mm.mysql.Driver</driver> > <pool-controller min="5" max="10"/> > <dburl>jdbc:mysql://localhost:3306/tester</dburl> > <auto-commit>true</auto-commit> > <user>login</user> > <password>pass</password> > </jdbc> > </datasources> > > does anyone know if there is a mechanism that allows you to specify the > driver for a pool in the cocoon.xconf? > > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faqs.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/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
