Jeff
Thank you! It works now :)
Christina
----- Original Message -----
From: "Jeff Jones" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 28, 2004 7:38 AM
Subject: Re: [esql] Unhandled exception type SQLException
>
> Christina,
>
> 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"...>
> <users>
> <esql:connection>
> ...
> <esql:results>
> <esql:row-results>
> ....
> </esql:row-results>
> </esql:results>
> </esql:connection>
> </users>
> </xsp:page>
>
> Give that a try.
>
> </Jeff>
>
>
>
>
> "Christina"
> <[EMAIL PROTECTED] To:
<[EMAIL PROTECTED]>
> il.com> cc:
> Subject: [esql] Unhandled
exception type SQLException
> 06/27/2004 08:20
> PM
> Please respond to
> users
>
>
>
>
>
>
> 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(
> ""
>
>
>
>
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> 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]
