Please use plain text when posting to the list, it just makes things easier.
Basically the issue is that the last checked in version of Avalon Excalibur's DataSource management had a problem with JDK 1.4. This has since been resolved. Someone has compiled a new version of the DataSourceComponent, and has it available (I don't have a link right now, but look for it in the archives for this list--it was within the past week). -----Original Message----- From: zze-STIENNE Nicolas FTRD/DMI/CAE [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 7:21 AM To: '[EMAIL PROTECTED]' Subject: Access97 - Cocoon2 Hi !! I've got a problem to access to my database Access97 under w2000. I work with Tomcat3.3.2, Java 2 SDK 1.4 and Cocoon2. I made an odbc link (outils d'administration/Sources de donnees odbc/Sources de donnees systemes/Ajouter/AccessDriver/Base de donnees). I test it with a Java program: it works well, I can read my data. But the problem comes with cocoon : org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not get the datasource org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid JdbcConnection class available The files I use: base.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";> <doc> <esql:connection> <esql:pool>pool</esql:pool> </esql:connection> </doc> </xsp:page> web.xml : <init-param> <param-name>load-class</param-name> <param-value>sun.jdbc.odbc.JdbcOdbcDriver</param-value> </init-param> cocoon.xconf : <jdbc name="pool"> <pool-controller min="5" max="10"/> <dburl>jdbc:odbc:bdaccess</dburl> <user></user> <password></password> </jdbc> In my Java, I made the test with: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); db = DriverManager.getConnection("jdbc:odbc:bdaccess"); Does really the sitemap generate a sever page ? sitemap.xmap : <map:pipeline> <map:match pattern="spain/*.xsp"> <map:generate type="serverpages" src="spain/{1}.xsp"/> <map:serialize /> </map:match> </map:pipeline> I don't see what is bad... Thanks for all, Nicolas !! --- Version francaise --- Bonjour, J'ai un probleme pour acceder a ma base Access97 sous Windows2000. J'utilise Tomcat3.3.2, Java 2 SDK 1.4 et Cocoon2. J'ai cree un lien odbc (outils d'administration/Sources de donnees odbc/Sources de donnees systemes/Ajouter/AccessDriver/Base de donnees). J'ai verifie que mon lien odbc fonctionnait avec un petit programme java : impecable, je peux lire les donnees enregistree dans la bd. En revanche, ca coince au moment de l'utilisation de cocoon : org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not get the datasource org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid JdbcConnection class available <!-- les fichiers sont les meme --> Dans mon fichier Java, je faisais le test avec : Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); db = DriverManager.getConnection("jdbc:odbc:bdaccess"); Faut-il bien que le sitemap genere une page serveur ? <!-- idem sitemap.xmap --> Je ne vois pas ce que je fais mal... Merci, Nicolas !! --------------------------------------------------------------------- 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
