Hi, In my root.log file I have
DEBUG (2002-03-26) 15:17.37:230 [root ] (Unknown-URI) Unknown-thread/Coco onServlet: Trying to load class: org.gjt.mm.mysql.Driver Thats the only log file reference I get to my DB driver and I have no problems with DB pooling. I'm using Cocoon 2.0 final, Tomcat 4.0 final, JDK1.3.1_01 but it looks like you're pushing the envelope when it comes to latest versions ;) Have you had DB pooling working with earlier versions of Cocoon / Tomcat / JDK? Does your exception occur when Cocoon tries to start, or when the XSP page is accessed? Can you post a snippet of your XSP page? Thanks, Chris > -----Original Message----- > From: Jeremy Beeler [mailto:[EMAIL PROTECTED]] > Sent: 28 March 2002 17:08 > To: [EMAIL PROTECTED] > Subject: Re: Update on my problem > > > 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]> > > --------------------------------------------------------------------- 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]>
