I've tried different avalon and avalon-excalibur versions without
success.
I always get an NoValidDataSourceException Error.
With the simple connection method "Class.forName( .......)" i always
get an successfull connection to my DB.
My System is Win2000 with Forte und JDK 1.4_01
Any help is VERY appreciated.
=============START role.xml ============
<role-list>
<role
name="org.apache.avalon.excalibur.datasource.DataSourceComponentSelector"
shorthand="datasources"
default-class="org.apache.avalon.excalibur.component.ExcaliburComponentSelector">
<hint shorthand="jdbc"
class="org.apache.avalon.excalibur.datasource.JdbcDataSource"/>
<hint shorthand="j2ee"
class="org.apache.avalon.excalibur.datasource.J2eeDataSource"/>
</role>
</role-list>
============ END role.xml ===========
============ START components.xml ===========
<my-system>
<datasources>
<jdbc name="message">
<pool-controller min="5" max="10"/>
<auto-commit>false</auto-commit>
<driver>com.mysql.jdbc.Driver</driver>
<dburl>jdbc:mysql://t26629/test</dburl>
<user>test</user>
<password>test</password>
</jdbc>
</datasources>
</my-system>
============== END components.xml =============
=============== START Main Class====================
import org.apache.avalon.framework.component.Component;
import org.apache.avalon.framework.activity.Initializable;
import org.apache.avalon.framework.activity.Disposable;
import
org.apache.avalon.framework.configuration.DefaultConfigurationBuilder;
import org.apache.avalon.framework.configuration.Configuration;
import org.apache.avalon.framework.context.DefaultContext;
import org.apache.avalon.excalibur.component.DefaultRoleManager;
import
org.apache.avalon.excalibur.component.ExcaliburComponentManager;
import org.apache.log.Hierarchy;
/**
*
* @author schwarzj
*/
public class ContainerComponent implements Component, Initializable,
Disposable {
private ExcaliburComponentManager manager = null;
/** Creates a new instance of ContainerComponent */
public ContainerComponent() {
manager = new ExcaliburComponentManager();
}
public static void main(String[] args) {
try {
ContainerComponent cc =new ContainerComponent();
cc.initialize();
}
catch (Exception e) {
e.printStackTrace();
}
finally {
}
}
public void dispose() {
}
public void initialize() throws java.lang.Exception {
DefaultConfigurationBuilder builder = new
DefaultConfigurationBuilder();
Configuration sysConfig =
builder.buildFromFile("c:\\jas_prog\\Java-prog\\Avalon_DB\\components.xml");
Configuration roleConfig =
builder.buildFromFile("c:\\jas_prog\\Java-prog\\Avalon_DB\\roles.xml");
DefaultRoleManager roles = new DefaultRoleManager();
roles.setLogger(Hierarchy.getDefaultHierarchy().getLoggerFor("messages.roles"));
roles.configure(roleConfig);
manager.setLogger(Hierarchy.getDefaultHierarchy().getLoggerFor("messages"));
this.manager.contextualize(new DefaultContext());
this.manager.setRoleManager(roles);
this.manager.configure(sysConfig);
this.manager.initialize();
}
}
==================== END Main Class =======================
=============== START errorcode ================
DEBUG 2003-03-19 16:58:28.415 [messages] (): Adding hint type jdbc
associated with role
org.apache.avalon.excalibur.datasource.DataSourceComponentSelector and
class org.apache.avalon.excalibur.datasource.JdbcDataSource
DEBUG 2003-03-19 16:58:28.735 [messages] (): Adding hint type j2ee
associated with role
org.apache.avalon.excalibur.datasource.DataSourceComponentSelector and
class org.apache.avalon.excalibur.datasource.J2eeDataSource
DEBUG 2003-03-19 16:58:28.735 [messages] (): added Role
org.apache.avalon.excalibur.datasource.DataSourceComponentSelector with
shorthand datasources for
org.apache.avalon.excalibur.component.ExcaliburComponentSelector
DEBUG 2003-03-19 16:58:28.765 [messages] (): looking up shorthand
datasources, returning
org.apache.avalon.excalibur.datasource.DataSourceComponentSelector
DEBUG 2003-03-19 16:58:28.765 [messages] (): Adding component
(org.apache.avalon.excalibur.datasource.DataSourceComponentSelector =
org.apache.avalon.excalibur.component.ExcaliburComponentSelector)
DEBUG 2003-03-19 16:58:28.775 [messages] (): Attempting to get
Handler for:
org.apache.avalon.excalibur.datasource.DataSourceComponentSelector
DEBUG 2003-03-19 16:58:28.795 [messages] (): Handler type =
org.apache.avalon.excalibur.component.ThreadSafeComponentHandler
DEBUG 2003-03-19 16:58:28.805 [messages] (): ComponentFactory
creating new instance of
org.apache.avalon.excalibur.component.ExcaliburComponentSelector.
DEBUG 2003-03-19 16:58:28.815 [messages] (): ComponentSelector
setting up with root element: datasources
DEBUG 2003-03-19 16:58:28.815 [messages] (): looking up shorthand
datasources, returning
org.apache.avalon.excalibur.datasource.DataSourceComponentSelector
DEBUG 2003-03-19 16:58:28.875 [messages] (): looking up hintmap for
role org.apache.avalon.excalibur.datasource.DataSourceComponentSelector
DEBUG 2003-03-19 16:58:28.875 [messages] (): looking up classname for
hint jdbc
DEBUG 2003-03-19 16:58:28.885 [messages] (): ComponentFactory
creating new instance of
org.apache.avalon.excalibur.datasource.JdbcDataSource.
DEBUG 2003-03-19 16:58:28.885 [messages] (): Loading new driver:
com.mysql.jdbc.Driver
DEBUG 2003-03-19 16:58:30.427 [messages] (): ComponentHandler
initialized for: org.apache.avalon.excalibur.datasource.JdbcDataSource
DEBUG 2003-03-19 16:58:30.427 [messages] (): Adding
org.apache.avalon.excalibur.datasource.JdbcDataSource for message
DEBUG 2003-03-19 16:58:30.427 [messages] (): ComponentHandler
initialized for:
org.apache.avalon.excalibur.component.ExcaliburComponentSelector
DEBUG 2003-03-19 16:58:30.427 [messages] (): factory created class
was null so a new instance could not be created.
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No
valid JdbcConnection class available
at
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:183)
at
org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.java:82)
at
org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(HardResourceLimitingPool.java:95)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(JdbcConnectionPool.java:74)
at
org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(AbstractPool.java:126)
at
org.apache.avalon.excalibur.pool.HardResourceLimitingPool.internalGrow(HardResourceLimitingPool.java:104)
at
org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResourceLimitingPool.java:91)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(JdbcConnectionPool.java:195)
at java.lang.Thread.run(Thread.java:536)
DEBUG 2003-03-19 16:58:30.447 [messages] (): factory created class
was null so a new instance could not be created.
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No
valid JdbcConnection class available
at
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:183)
at
org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.java:82)
at
org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(HardResourceLimitingPool.java:95)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(JdbcConnectionPool.java:74)
at
org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(AbstractPool.java:126)
at
org.apache.avalon.excalibur.pool.HardResourceLimitingPool.internalGrow(HardResourceLimitingPool.java:104)
at
org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResourceLimitingPool.java:91)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(JdbcConnectionPool.java:195)
at java.lang.Thread.run(Thread.java:536)
DEBUG 2003-03-19 16:58:30.468 [messages] (): factory created class
was null so a new instance could not be created.
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No
valid JdbcConnection class available
at
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:183)
at
org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.java:82)
at
org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(HardResourceLimitingPool.java:95)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(JdbcConnectionPool.java:74)
at
org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(AbstractPool.java:126)
at
org.apache.avalon.excalibur.pool.HardResourceLimitingPool.internalGrow(HardResourceLimitingPool.java:104)
at
org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResourceLimitingPool.java:91)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(JdbcConnectionPool.java:195)
at java.lang.Thread.run(Thread.java:536)
DEBUG 2003-03-19 16:58:30.478 [messages] (): factory created class
was null so a new instance could not be created.
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No
valid JdbcConnection class available
at
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:183)
at
org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.java:82)
at
org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(HardResourceLimitingPool.java:95)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(JdbcConnectionPool.java:74)
at
org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(AbstractPool.java:126)
at
org.apache.avalon.excalibur.pool.HardResourceLimitingPool.internalGrow(HardResourceLimitingPool.java:104)
at
org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResourceLimitingPool.java:91)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(JdbcConnectionPool.java:195)
at java.lang.Thread.run(Thread.java:536)
DEBUG 2003-03-19 16:58:30.578 [messages] (): factory created class
was null so a new instance could not be created.
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No
valid JdbcConnection class available
at
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:183)
at
org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.java:82)
at
org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(HardResourceLimitingPool.java:95)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(JdbcConnectionPool.java:74)
at
org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(AbstractPool.java:126)
at
org.apache.avalon.excalibur.pool.HardResourceLimitingPool.internalGrow(HardResourceLimitingPool.java:104)
at
org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResourceLimitingPool.java:91)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(JdbcConnectionPool.java:195)
at java.lang.Thread.run(Thread.java:536)
FATAL_E 2003-03-19 16:58:30.578 [messages] (): Excalibur could not
create any connections. Examine your settings to make sure they are
correct. Make sure you can connect with the same settings on your
machine.
==================== END errorcode =====================
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
