[esql] Unhandled exception type SQLException

[Christina <le...@hotmail.com>]

BlankVery 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( 
      ""