I am using cocoon 2.0.3 under tomcat 4.0.4 to try the employee example. It works on Oracle database, but fail for Informix database. Found the following comment from org/apache/avalon/excalibur/datasource/InformixDataSource.java
* Informix doesn't like the JdbcDataSource Component, so we gave it it's own. * Do not use this datasource if you are planning on using your J2EE server's * connection pooling. * * You must have Informix's JDBC 2.2 or higher jar file, as well as the extensions * jar file (<code>ifxjdbc.jar</code> and <code>ifxjdbcx.jar</code>). Also, this * DataSource requires the Avalon Cadastre package because it uses the MemoryContext. Both jar exist and I force the driver loaded in wem.xml. But it still fails and cannot figure out myself from the code. Please help. thanks -----------------------------error message from core.log org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid JdbcConnection class available at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(Jdb cConnectionFactory.java:185) at org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(ResourceLi mitingPool.java:629) at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(V alidatedResourceLimitingPool.java:136) at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.ne wPoolable(ResourceLimitingJdbcConnectionPool.java:79) at org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimitingPo ol.java:359) at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(Validated ResourceLimitingPool.java:88) at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getCon nection(ResourceLimitingJdbcDataSource.java:174) at org.apache.cocoon.www.edi_out.forms.employee_xsp.generate(C:\tom\Apache Tomcat 4.0\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/edi_ out/forms\employee_xsp.java:467) at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenera tor.java:258) at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv entPipeline.java:250) at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS treamPipeline.java:399) at org.apache.cocoon.www.sitemap_xmap.matchN10833(C:\tom\Apache Tomcat 4.0\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www\site map_xmap.java:10216) at org.apache.cocoon.www.sitemap_xmap.process(C:\tom\Apache Tomcat 4.0\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www\site map_xmap.java:3737) at org.apache.cocoon.www.sitemap_xmap.process(C:\tom\Apache Tomcat 4.0\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www\site map_xmap.java:3122) at org.apache.cocoon.sitemap.Handler.process(Handler.java:224) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179) --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>