You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Terry Paddy <bo...@paradise.net.nz> on 2001/10/09 06:05:54 UTC
*resolved-pls-ignore*Re: [c2rc1a] Connection Pooling: No
suitable driver
Apologies,
We have now resolved this. It was a typo in the jdbc URI which sneaked in
during the move from C2b1 to C2rc1.
Terry Paddy
At 20:07 8/10/2001 -0700, you wrote:
>Hello All,
>
>We were successfully using C2b1 with connection
>pooling to a Postgresql database. We updated to c2rc1a
>and now find when a new cocoon object is created a
>connection pool cannot be created. (We are using
>Tomcat 3.2.2)
>
>The following error is in cocoon.log
>
>DEBUG (2001-10-09) 15:50.03:655 [cocoon ]
>(Unknown-URI) Unknown-thread/AbstractPool:
>org.apache.avalon.excalibur.datasource.JdbcConnection:
>could not be instantiated.
>java.sql.SQLException: No suitable driver
> at java.sql.SQLException.<init>(SQLException.java:66)
> at
>java.sql.DriverManager.getConnection(DriverManager.java:543)
> at
>java.sql.DriverManager.getConnection(DriverManager.java:183)
> at
>org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(Unknown
>Source)
> at
>org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(Unknown
>Source)
> at
>org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(Unknown
>Source)
> at
>org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(Unknown
>Source)
> at
>org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(Unknown
>Source)
> at
>org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(Unknown
>Source)
> at
>org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(Unknown
>Source)
> at java.lang.Thread.run(Thread.java:498)
>
>However if we connect to our database using just the
>ESQL taglib and no connection pool, the data is
>extracted correctly.
>
>Our cocoon.xconf jdbc snipit is
>
> <datasources>
> <jdbc name="mydata">
> <pool-controller min="5" max="10"/>
> <auto-commit>true</auto-commit>
> <dburl>jdbc:postgresql//localhost/mysite</dburl>
> <user>anybody</user>
> <password>pass</password>
> </jdbc>
> </datasources>
>
>we have also put the driver in the web.xml file as
>documented
>
> <init-param>
> <param-name>load-class</param-name>
> <param-value>
> org.postgresql.Driver
> </param-value>
> </init-param>
>
>
>Anybody else had this problem... or know where we
>should look now (am believe me, we have been looking
>:-)
>
>=====
>_______________________________________
>Terry Paddy - Christchurch, New Zealand
>
>__________________________________________________
>Do You Yahoo!?
>NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
>http://geocities.yahoo.com/ps/info1
>
>---------------------------------------------------------------------
>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>