You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Faron Dutton <FD...@witness.com> on 2003/04/06 03:52:29 UTC

RE: Newbie: yet ANOTHER problem: db access (NoValidConnectionExce ption)

Hi All,

I was having the same problem with Phoenix. It turns out that the
excalibur-datasource-1.0.jar is missing
org.apache.avalon.excalibur.datasource.JdbcConnection. Must have been a
build problem :( After adding it everything works fine.

Faron

-----Original Message-----
From: Phil Coultard [mailto:cocoon@coultard.com]
Sent: Saturday, April 05, 2003 6:55 PM
To: cocoon-users@xml.apache.org
Subject: RE: Newbie: yet ANOTHER problem: db access
(NoValidConnectionException)


> From: Andrew Savory
> Sent: 05 April 2003 22:29

> On Sat, 5 Apr 2003, Geoff Howard wrote:
>
> > But if clearing up the jdk dependency doesn't work, try explicitly
> > giving root access to the database you're using for the wildcard host:
> > %.
>
> Also, try explicitly adding localhost - MySQL regards localhost as
> different to the wildcard "every host", for goodness knows what reason.
> (Although that will throw a connection error with the command-line client
> as well as Cocoon.)

Nope. That didn't work either... still getting the same message:

"ERROR   (2003-04-06) 00:50.36:940   [sitemap.generator.serverpages]
(/ltd_coultard/tickets.xsp) Thread-11/tickets_xsp: Could not get the
datasource
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid
JdbcConnection class available"

This is one mild mannered Englishman who is off out to buy a baseball bat
soon ;-)

Phil
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.465 / Virus Database: 263 - Release Date: 24/03/03


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


RE: Newbie: yet ANOTHER problem: db access (NoValidConnectionException)

Posted by Phil Coultard <co...@coultard.com>.
> From: Faron Dutton [mailto:FDutton@witness.com]
> Sent: 06 April 2003 02:52

> I was having the same problem with Phoenix. It turns out that the
> excalibur-datasource-1.0.jar is missing
> org.apache.avalon.excalibur.datasource.JdbcConnection. Must have been a
> build problem :( After adding it everything works fine.

Nope - afraid that idea wasn't valid either I appear to have
org.apache.avalon.excalibur.datasource.JdbcConnection in my jar:
META-INF/
META-INF/MANIFEST.MF
org/
org/apache/
org/apache/avalon/
org/apache/avalon/excalibur/
org/apache/avalon/excalibur/datasource/
org/apache/avalon/excalibur/datasource/AbstractJdbcConnection.class
org/apache/avalon/excalibur/datasource/DataSourceComponent$1.class
org/apache/avalon/excalibur/datasource/DataSourceComponent.class
org/apache/avalon/excalibur/datasource/InformixDataSource.class
org/apache/avalon/excalibur/datasource/J2eeDataSource.class
org/apache/avalon/excalibur/datasource/JdbcConnection.class
org/apache/avalon/excalibur/datasource/JdbcConnectionFactory.class
org/apache/avalon/excalibur/datasource/JdbcConnectionPool.class
org/apache/avalon/excalibur/datasource/JdbcDataSource.class
org/apache/avalon/excalibur/datasource/NoAvailableConnectionException.class
org/apache/avalon/excalibur/datasource/NoValidConnectionException.class
org/apache/avalon/excalibur/datasource/ResourceLimitingJdbcConnectionPool.cl
ass
org/apache/avalon/excalibur/datasource/ResourceLimitingJdbcDataSource.class
META-INF/LICENSE.txt

> > From: Andrew Savory
> > Sent: 05 April 2003 22:29
>
> > On Sat, 5 Apr 2003, Geoff Howard wrote:
> >
> > > But if clearing up the jdk dependency doesn't work, try explicitly
> > > giving root access to the database you're using for the wildcard host:
> > > %.
> >
> > Also, try explicitly adding localhost - MySQL regards localhost as
> > different to the wildcard "every host", for goodness knows what reason.
> > (Although that will throw a connection error with the
> command-line client
> > as well as Cocoon.)
>
> Nope. That didn't work either... still getting the same message:
>
> "ERROR   (2003-04-06) 00:50.36:940   [sitemap.generator.serverpages]
> (/ltd_coultard/tickets.xsp) Thread-11/tickets_xsp: Could not get the
> datasource
> org.apache.avalon.excalibur.datasource.NoValidConnectionException:
>  No valid
> JdbcConnection class available"
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.465 / Virus Database: 263 - Release Date: 25/03/03


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


RE: Newbie: yet ANOTHER problem: db access (NoValidConnectionException)

Posted by Phil Coultard <ph...@coultard.com>.
> From: Faron Dutton [mailto:FDutton@witness.com]
> Sent: 06 April 2003 02:52

> I was having the same problem with Phoenix. It turns out that the
> excalibur-datasource-1.0.jar is missing
> org.apache.avalon.excalibur.datasource.JdbcConnection. Must have been a
> build problem :( After adding it everything works fine.

Nope - afraid that idea wasn't valid either I appear to have
org.apache.avalon.excalibur.datasource.JdbcConnection in my jar:
META-INF/
META-INF/MANIFEST.MF
org/
org/apache/
org/apache/avalon/
org/apache/avalon/excalibur/
org/apache/avalon/excalibur/datasource/
org/apache/avalon/excalibur/datasource/AbstractJdbcConnection.class
org/apache/avalon/excalibur/datasource/DataSourceComponent$1.class
org/apache/avalon/excalibur/datasource/DataSourceComponent.class
org/apache/avalon/excalibur/datasource/InformixDataSource.class
org/apache/avalon/excalibur/datasource/J2eeDataSource.class
org/apache/avalon/excalibur/datasource/JdbcConnection.class
org/apache/avalon/excalibur/datasource/JdbcConnectionFactory.class
org/apache/avalon/excalibur/datasource/JdbcConnectionPool.class
org/apache/avalon/excalibur/datasource/JdbcDataSource.class
org/apache/avalon/excalibur/datasource/NoAvailableConnectionException.class
org/apache/avalon/excalibur/datasource/NoValidConnectionException.class
org/apache/avalon/excalibur/datasource/ResourceLimitingJdbcConnectionPool.cl
ass
org/apache/avalon/excalibur/datasource/ResourceLimitingJdbcDataSource.class
META-INF/LICENSE.txt

> > From: Andrew Savory
> > Sent: 05 April 2003 22:29
>
> > On Sat, 5 Apr 2003, Geoff Howard wrote:
> >
> > > But if clearing up the jdk dependency doesn't work, try explicitly
> > > giving root access to the database you're using for the wildcard host:
> > > %.
> >
> > Also, try explicitly adding localhost - MySQL regards localhost as
> > different to the wildcard "every host", for goodness knows what reason.
> > (Although that will throw a connection error with the
> command-line client
> > as well as Cocoon.)
>
> Nope. That didn't work either... still getting the same message:
>
> "ERROR   (2003-04-06) 00:50.36:940   [sitemap.generator.serverpages]
> (/ltd_coultard/tickets.xsp) Thread-11/tickets_xsp: Could not get the
> datasource
> org.apache.avalon.excalibur.datasource.NoValidConnectionException:
>  No valid
> JdbcConnection class available"
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.465 / Virus Database: 263 - Release Date: 25/03/03


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org