|
Very simple query, but doesn't work. :(
My cocoon is 2.1.4 and my jdk is 1.4.2. I am using mysql. The same query
works fine with sql transformer.
<?xml version="1.0"?>
<xsp:page language="java" xmlns:xsp="http://apache.org/xsp" xmlns:esql="http://apache.org/cocoon/SQL/v2">
<esql:connection>
<esql:pool>MYDB</esql:pool>
<esql:execute-query>
<esql:query>select uid
from users</esql:query>
<esql:results>
<users>
<esql:row-results>
<user>
<login><esql:get-string
column="uid"/></login>
</user>
</esql:row-results>
</users>
</esql:results>
<esql:no-results>
<p>Sorry,
no results!</p>
</esql:no-results>
<esql:error-results>
There is
error happened
</esql:error-results>
</esql:connection>
</xsp:page>
Error message:
Original Exception: org.apache.cocoon.components.language.LanguageException:
Error compiling mydb_xsp:
ERROR 1
(org\apache\cocoon\www\han\esql\mydb_xsp.java):
...
if
(_esql_query != null) {
_esql_queries.push(_esql_query);
}
// start
error (lines 306-306) "Unhandled exception type
SQLException"
_esql_query = _esql_connection.createQuery(
// end
error
String.valueOf(""),
String.valueOf(
""
|
<<Blank Bkgrd.gif>>
