You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Jeremy Beeler <jb...@pa.aacisd.com> on 2002/03/28 17:13:51 UTC
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?
RE: Update on my problem
Posted by Chris Newland <ch...@emorphia.com>.
Hi Jeremy,
Your XSP page looks fine to me and if it is working without pooling then I'm
starting to think that a bug may have been introduced into the latest
database code.
My best suggestion would be to download the latest release version of Cocoon
(2.0.2) and try your XSP page on that. Also, double check your cocoon.xconf
and web.xml for typos. Maybe check that MySQL is running and do
mysqladmin -version to get the query count to see if any queries are making
it to the DB.
Best Regards,
Chris
> -----Original Message-----
> From: Jeremy Beeler [mailto:jbeeler@pa.aacisd.com]
> Sent: 28 March 2002 18:12
> To: cocoon-users@xml.apache.org
> Subject: Re: Update on my problem
>
>
> Chris,
> Thanks again for all the help.
>
> trust me, i'm not pushing the envelope by design, it's just these are the
> versions that i've gotten the farthest with in terms of getting things
> working.
> i've never had db pooling working, in fact this past week or so
> has been my
> first venture into cocoon for any other use than classroom theory.
> the exception is generated when i try to run my test.xsp. cocoon
> loads fine
> otherwise.
>
> here is my code from the test.xsp
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <xsp:page language="java" xmlns:xsp="http://apache.org/xsp"
> xmlns:esql="http://apache.org/cocoon/SQL/v2">
> <page>
> <title>A Database Driven XSP Page to Test</title>
> <content>
> <esql:connection>
> <!--if the pool is commented out and the non-pooled instantiation
> is used it
> works fine-->
> <esql:pool>tester</esql:pool>
>
> <!--this is commented out. if left in and pool is commented out this works
> fine
> <esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
> <esql:dburl>jdbc:mysql://localhost:3306/tester</esql:dburl>
> <esql:username>login</esql:username>
> <esql:password>pass</esql:password>
> -->
>
> <esql:execute-query>
> <esql:query>select * from operator</esql:query>
> <esql:results>
> <esql:row-results>
> <para>
> <esql:get-string column="Name"/>
> </para>
> <esql:get-columns/>
> </esql:row-results>
> </esql:results>
> </esql:execute-query>
> </esql:connection>
> </content>
> </page>
> </xsp:page>
>
> For some reason when using the pool it will throw that exception, but if i
> just instantiate a connection in the xsp if generates the desired output
> just fine. the only problem is, i really need to use pooling.
>
> thanks again.
>
> Jeremy
>
> ----- Original Message -----
> From: "Chris Newland" <ch...@emorphia.com>
> To: <co...@xml.apache.org>
> Sent: Thursday, March 28, 2002 12:39 PM
> Subject: RE: Update on my problem
>
>
> > 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:jbeeler@pa.aacisd.com]
> > > Sent: 28 March 2002 17:08
> > > To: cocoon-users@xml.apache.org
> > > 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" <ch...@emorphia.com>
> > > To: <co...@xml.apache.org>
> > > 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:jbeeler@pa.aacisd.com]
> > > > Sent: 28 March 2002 16:14
> > > > To: cocoon-users@xml.apache.org
> > > > 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: <co...@xml.apache.org>
> > > > For additional commands, e-mail: <co...@xml.apache.org>
> > >
> > >
> > > ---------------------------------------------------------------------
> > > 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: <co...@xml.apache.org>
> > > For additional commands, e-mail: <co...@xml.apache.org>
> > >
> > >
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@xml.apache.org>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Update on my problem
Posted by Jeremy Beeler <jb...@pa.aacisd.com>.
Chris,
Thanks again for all the help.
trust me, i'm not pushing the envelope by design, it's just these are the
versions that i've gotten the farthest with in terms of getting things
working.
i've never had db pooling working, in fact this past week or so has been my
first venture into cocoon for any other use than classroom theory.
the exception is generated when i try to run my test.xsp. cocoon loads fine
otherwise.
here is my code from the test.xsp
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsp:page language="java" xmlns:xsp="http://apache.org/xsp"
xmlns:esql="http://apache.org/cocoon/SQL/v2">
<page>
<title>A Database Driven XSP Page to Test</title>
<content>
<esql:connection>
<!--if the pool is commented out and the non-pooled instantiation is used it
works fine-->
<esql:pool>tester</esql:pool>
<!--this is commented out. if left in and pool is commented out this works
fine
<esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
<esql:dburl>jdbc:mysql://localhost:3306/tester</esql:dburl>
<esql:username>login</esql:username>
<esql:password>pass</esql:password>
-->
<esql:execute-query>
<esql:query>select * from operator</esql:query>
<esql:results>
<esql:row-results>
<para>
<esql:get-string column="Name"/>
</para>
<esql:get-columns/>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
</content>
</page>
</xsp:page>
For some reason when using the pool it will throw that exception, but if i
just instantiate a connection in the xsp if generates the desired output
just fine. the only problem is, i really need to use pooling.
thanks again.
Jeremy
----- Original Message -----
From: "Chris Newland" <ch...@emorphia.com>
To: <co...@xml.apache.org>
Sent: Thursday, March 28, 2002 12:39 PM
Subject: RE: Update on my problem
> 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:jbeeler@pa.aacisd.com]
> > Sent: 28 March 2002 17:08
> > To: cocoon-users@xml.apache.org
> > 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" <ch...@emorphia.com>
> > To: <co...@xml.apache.org>
> > 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:jbeeler@pa.aacisd.com]
> > > Sent: 28 March 2002 16:14
> > > To: cocoon-users@xml.apache.org
> > > 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: <co...@xml.apache.org>
> > > For additional commands, e-mail: <co...@xml.apache.org>
> >
> >
> > ---------------------------------------------------------------------
> > 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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@xml.apache.org>
> >
> >
>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
RE: Update on my problem
Posted by Chris Newland <ch...@emorphia.com>.
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:jbeeler@pa.aacisd.com]
> Sent: 28 March 2002 17:08
> To: cocoon-users@xml.apache.org
> 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" <ch...@emorphia.com>
> To: <co...@xml.apache.org>
> 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:jbeeler@pa.aacisd.com]
> > Sent: 28 March 2002 16:14
> > To: cocoon-users@xml.apache.org
> > 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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@xml.apache.org>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Update on my problem
Posted by Jeremy Beeler <jb...@pa.aacisd.com>.
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" <ch...@emorphia.com>
To: <co...@xml.apache.org>
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:jbeeler@pa.aacisd.com]
> Sent: 28 March 2002 16:14
> To: cocoon-users@xml.apache.org
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
RE: Update on my problem
Posted by Chris Newland <ch...@emorphia.com>.
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:jbeeler@pa.aacisd.com]
Sent: 28 March 2002 16:14
To: cocoon-users@xml.apache.org
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>