cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Schroeter Christian <Christian.Schroe...@nbg.sbs.de>
Subject Re: SQL-Statment with two (or more) "where" statments
Date Mon, 29 Oct 2001 06:52:27 GMT
Hi Christopher,

now it works...

...after i restarted tomcat and apache and then my server :-] it works...i 
dont know why...

on the same day i got the errormessage that the code cannot be compiled and 
since that errormessage nothing worked anymore...because of this i restarted 
everything...mybe there is a context between both events...???....
sorry for the "excitement" i produced with my question...

cu,
christian


Am Freitag, 26. Oktober 2001 16:49 schrieben Sie:
> Christian,
>
> I can't see anything wrong, but you've not shown us all your code.  Also,
> we have no way of verifying that your column and table names match your
> database.  One reason it is hard to debug ESQL is because all exceptions
> get trapped and turned into generic exceptions, so you don't know what
> actual issue the JDBC driver or database is complaining about.  You should
> first ensure your queries work outside Cocoon (e.g., type them into a query
> tool and see if they blow up).  You can also try building up from simple
> queries that work, adding to them in small increments, e.g., one WHERE
> condition at a time and so forth.  That should help you find what bit is
> causing the trouble.
>
> If you want to see what JDBC is really complaining about, you'll have to
> hack the esql.xsl logicsheet to re-throw the JDBC exceptions instead of
> substituting generic exceptions.
>
> -Christopher
>
>
>
>
> Please respond to cocoon-users@xml.apache.org
>
> To:   cocoon-users@xml.apache.org
> cc:
>
> Subject:  SQL-Statment with two (or more) "where" statments
>
>
> Hi,
>
> i use cocoon1.8.2. Now i have a little problem:
>
> i want to query my db like this:
>
> <esql:connect>
> ...
>      <esql:connect>
>      ...
>        SELECT
>                            a.name
>                         FROM
>                            a, b
>                         WHERE
>           b.fk2 = a.pk
>           AND
>                             b.fk1 = <esql:parameter type="string">
> <esql:get-string ancestor="1" column="fk_x"/> </esql:parameter>
>      ...
>      </esql:connection>
> </esql:connection>
>
> But i get the errormessage:
>
> Error executed prepared statement: SELECT a.name FROM a, b WHERE b.fk2 =
> a.pk
> AND b.fk1 = ?
>
> When i only use one where statment it works, but with 2 it wount
>
> What must i change ?
>
>
> cu
> Christian
>
>
>
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
> To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message