Good Morning to all,
I'm having some problems in using ESQL... really I can't yet use it...
I'm trying to use mySQL database on cocoon 2.1.7 running under Tomcat
5.5.9 on a Windows XP machine...
I'have done all the steps I need (maybe I think):
1) I have putted the connector-j to the $COCOON$/WEB-INF/lib directory
2) added to the $COCOON$/WEB-INF/cocoon.xconfig the following code
<datasources>
<jdbc name="test_mysql_pool">
<pool-controller min="5" max="10"/>
<auto-commit>true</auto-commit>
<dburl>jdbc:mysql://localhost:3306/prova</dburl>
<user>root</user>
<password></password>
</jdbc>
</datasources>
Yes, my DB is called prova and has no password (it's just a test db)
3) Added to $COCOON$/WEB-INF/web.xml the following code:
<init-param>
<param-name>load-class</param-name>
<param-value>
com.mysql.jdbc.Driver
</param-value>
</init-param>
then I have written a XSP page with the following code:
<?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";
>
<esql:connection>
<esql:pool>test_mysql_pool</esql:pool>
<esql:execute-query>
<esql:query>SELECT * FROM test</esql:query>
<esql:results>
<table>
<esql:row-results>
<tr>
<td><esql:get-string column="cognome"/></td>
<td><esql:get-string column="nome"/></td>
</tr>
</esql:row-results>
</table>
</esql:results>
<esql:error-results>
Error:<br/>
<esql:get-message/>
<esql:to-string/>
<esql:get-stacktrace/>
</esql:error-results>
<esql:no-results>
<p>Sorry, no results!</p>
</esql:no-results>
</esql:execute-query>
</esql:connection>
</xsp:page>
Now, my question is: There is any mistake in my configuration? Why I
cant' have back any message also if I'm using the tags between
<esql:error-results>??
I hope to be clear, if not, please ask me for what's not understandable!
Thanks in advice,
Omar
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
