Hello mat, thancks for your answers, i try some of this things : 1/ For the driver i use the same :
com.mysql.jdbc.Driver
2/ I change the content of my xsp file according to your remarque 3/ I use J2SDK1.4.1_02
But it still the same : no connection to my database (no trace in my log)...
I think it's perhaps cocoon change the formulation of the connection data (b.e: the hostname...)
i don't know...
Mathias Wiegard a écrit :
Try this way: First, make the following entry under
<init-param> <param-name>load-class</param-name> <param-value> ...
<!-- For MySQL Database --> com.mysql.jdbc.Driver </param-value> </init-param>
in WEB-INF/web.xml . This will load the driver at start into the environment. I don'T know your proceeding of defining an conneciton in an xsp page... I use connection-pools: Under the element <datasources> in WEB-INF/cocoon.xconf you can write for you need:
<jdbc name="name-for-the-connection" logger="core.datasources. name-for-the-connection"> <pool-controller max="10" min="5"/> <dburl>jdbc:mysql://localhost:3306/ma_table_tbl?autoReconnect=true</dburl> <user>user</user> <password>password</password> </jdbc>
Now, an example for the xsp could look like this:
<?xml version="1.0" encoding="ISO-8859-1"?> <xsp:page language="java" xmlns:esql="http://apache.org/cocoon/SQL/v2"; xmlns:xsp="http://apache.org/xsp";> <page> <title>Test</title> <content> <esql:connection> <esql:pool>name-for-the-connection</esql:pool> <esql:execute-query> <esql:query>select * from table</esql:query> <esql:results> <entries> <esql:row-results> <esql:get-xml column="type" root="entry"/> </esql:row-results> </entries> </esql:results> </esql:execute-query> </esql:connection> </content> </page> </xsp:page>
By the way: had problems with the mysql driver version 3.x under JDK 1.3.x. The problems vanished after I updated to JDK 1.4.1 that could be another reason for your problem...
Hope it helps! Mat
Von: ntic <[EMAIL PROTECTED]> Antworten an: [EMAIL PROTECTED] Datum: Tue, 17 Jun 2003 21:00:40 +0200 An: [EMAIL PROTECTED] Betreff: newby with cocoon esql mysql linux
Hello, I've got some trouble with my cocoon configuration. I've got : mysql ver. 3.23.54 the driver is mysql-connector-java-3.0.8-stable-bin.jar in webapps/cocoon/WEB-INF/lib/ cocoon 2.0.4
my sitemap.xmap file contain :
*<map:sitemap xmlns:map="http://apache.org/cocoon/sitemap/1.0";> <map:components> <map:generators> <map:generator name="serverpages" src="org.apache.cocoon.generation.ServerPagesGenerator"/> </map:generators> <map:serializers> <map:serializer name="xml" mime-type="text/xml" src="org.apache.cocoon.serialization.XMLSerializer"/> </map:serializers> <map:matchers default="wildcard"> <map:matcher name="wildcard" src="org.apache.cocoon.matching.WildcardURIMatcher"/> </map:matchers> </map:components> <map:pipelines> <map:pipeline> <map:match pattern="*.xsp"> <map:generate type="serverpages" src="{1}.xsp"/> <map:serialize type="xml"/> </map:match> </map:pipeline> </map:pipelines> </map:sitemap> * the web.xml contain : * <init-param> <param-name>load-class</param-name> <param-value> org.hsqldb.jdbcDriver com.mysql.jdbc.Driver </param-value> </init-param> * the cocoon.xconf contain : * <datasources> <jdbc logger="core.datasources.personnel" name="personnel"> <pool-controller max="10" min="5"/> <dburl>jdbc:hsqldb:hsql://localhost:9002</dburl> <user>sa</user> <password/> </jdbc> <jdbc name="ma_table_tbl" logger="core.datasources.ma_table_tbl"> <pool-controller min="5" max="10"/> <dburl>jdbc:mysql://localhost/ma_table_tbl</dburl> <user>username</user> <password>password</password> </jdbc> </datasources> * my xsp file contains : *<?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";> <liste_mc> <esql:connection> <esql:driver>com.mysql.jdbc.Driver</esql:driver> <esql:dburl>jdbc:mysql://localhost/ma_table_tbl</esql:dburl> <esql:username>username</esql:username> <esql:password>password</esql:password> <esql:execute-query> <esql:query> SELECT type FROM type_tbl </esql:query> <esql:results> <esql:row-results> <type><esql:get-string column="type"/></type> </esql:row-results> </esql:results> <esql:error-results><erreure>erreure</erreure></esql:error-results> <esql:no-results><pasres>no result</pasres></esql:no-results> </esql:execute-query> </esql:connection> </liste_mc> </xsp:page> * The query works properly when i use it in command-line, the cocoon-xsp work properly (i try it with a script of factorial calculus). The problem is tha there is no connection to my database (the long-format log of mysql is not informed of this kind of connection) and the WEB-INF/log/error.log says :
*ERROR (2003-06-17) 19:34.44:382 [core.manager]
(/cocoon/mount/xsp/form_recherche.xsp) Thread-10/sitemap_xmap: Sitemap
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
opening connection to dburl: jdbc:mysql://localhost/ma_table_tbl: Server
configuration denies access to data source
at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerato
r.java:270)
*
I search the web and the mail archive but i don't find any response. I search the answer since three days and i become to be a little bit upset... If someone can help me.. thx a lot Alex
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
