cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Jones" <>
Subject Re: [esql] Unhandled exception type SQLException
Date Mon, 28 Jun 2004 14:38:48 GMT


I had the same problem when I started using ESQL. What you're missing is that
you need a top-level element of your own as the first and only child of
<xsp:page>. So try moving your "users" element higher up the tree:

<xsp:page language="java"...>

Give that a try.


                      <lechaelnah@hotma        To:       <>
            >                  cc:                                    
                                               Subject:  [esql] Unhandled exception type SQLException
                      06/27/2004 08:20                                                   
                      Please respond to                                                  

    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="" xmlns:esql="">
        <esql:query>select uid from users</esql:query>
               <login><esql:get-string column="uid"/></login>
           <p>Sorry, no results!</p>
           There is error happened

    Error message:

    Original Exception: org.apache.cocoon.components.language.LanguageException:
    Error compiling mydb_xsp:
    ERROR 1 (org\apache\cocoon\www\han\esql\
        if (_esql_query != null) {

    // start error (lines 306-306) "Unhandled exception type SQLException"
        _esql_query = _esql_connection.createQuery(

    // end error

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message