You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by zze-STIENNE Nicolas FTRD/DMI/CAE <ni...@rd.francetelecom.com> on 2002/05/22 13:20:44 UTC
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 !!
RE: Access97 - Cocoon2
Posted by Berin Loritsch <bl...@apache.org>.
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:nicolas.stienne@rd.francetelecom.com]
Sent: Wednesday, May 22, 2002 7:21 AM
To: 'cocoon-users@xml.apache.org'
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>