You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by za...@nostromocorp.com on 2002/05/01 00:27:44 UTC
Re: C2+ MacOS X + MySQL
i"m sorry about the HTML text, didn't even realize it was enabled.
Here's my XSP code:
<esql:connection>
<esql:pool>mySql</esql:pool>
<esql:execute-query>SELECT ID,Date,Status from
Messages</esql:execute-query>
<esql:results>
<messages>
<esql:row-results>
<message>
<id> <esql:get-long
column="ID"/> </id>
<datetime> <esql:get-date
column="Date"/> </datetime>
<status> <esql:get-string
column="Status"/> </status>
<fetchurl> not yet implemented
</fetchurl>
</message>
</esql:row-results>
</messages>
</esql:results>
</esql:connection>
Here's the Java that's throwing (or not throwing) the exceptions:
Line 397, column 58: method valueOf() not found in class java.lang.String
_esql_query = new EsqlQuery( _esql_connection, String.valueOf() );
Line 508, column 82: unreported exception: java.sql.SQLException; must
be caught or declared to be thrown
XSPObjectHelper.xspExpr(contentHandler,_esql_query.getResultSet().getLong(
"ID"));
Line 535, column 82: unreported exception: java.sql.SQLException; must
be caught or declared to be thrown
XSPObjectHelper.xspExpr(contentHandler,
_esql_query.getResultSet().getDate("Date"));
Line 562, column 84: unreported exception: java.sql.SQLException; must
be caught or declared to be thrown
XSPObjectHelper.xspExpr(contentHandler,
_esql_query.getResultSet().getString("Status")
Line 613, column 51: unreported exception: java.sql.SQLException; must
be caught or declared to be thrown
_esql_query.setKeepGoing( _esql_query.nextRow() );
Line 622, column 27: unreported exception: java.sql.SQLException; must
be caught or declared to be thrown
_esql_query.nextRow()
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
RE: C2+ MacOS X + MySQL
Posted by Zack Angelo <za...@nostromocorp.com>.
Fantastic. It works. Thanks for everything.
-Zack
-----Original Message-----
From: Christian Haul [mailto:haul@dvs1.informatik.tu-darmstadt.de]
Sent: Tuesday, April 30, 2002 5:43 PM
To: cocoon-users@xml.apache.org
Subject: Re: C2+ MacOS X + MySQL
On 30.Apr.2002 -- 05:27 PM, zack@nostromocorp.com wrote:
> i"m sorry about the HTML text, didn't even realize it was enabled.
>
> Here's my XSP code:
>
> <esql:connection>
> <esql:pool>mySql</esql:pool>
> <esql:execute-query>SELECT ID,Date,Status from
> Messages</esql:execute-query>
This is the problem:
esql:execute-query needs to span the entire query, i.e. after
esql:results. In addition you need a esql:query tag around the
query (like you did with the execute-query tag).
> <esql:results>
> <messages>
> <esql:row-results>
> <message>
> <id> <esql:get-long
> column="ID"/> </id>
> <datetime> <esql:get-date
> column="Date"/> </datetime>
> <status> <esql:get-string
> column="Status"/> </status>
> <fetchurl> not yet implemented
> </fetchurl>
> </message>
> </esql:row-results>
> </messages>
> </esql:results>
> </esql:connection>
Chris.
--
C h r i s t i a n H a u l
haul@informatik.tu-darmstadt.de
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: C2+ MacOS X + MySQL
Posted by Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>.
On 30.Apr.2002 -- 05:27 PM, zack@nostromocorp.com wrote:
> i"m sorry about the HTML text, didn't even realize it was enabled.
>
> Here's my XSP code:
>
> <esql:connection>
> <esql:pool>mySql</esql:pool>
> <esql:execute-query>SELECT ID,Date,Status from
> Messages</esql:execute-query>
This is the problem:
esql:execute-query needs to span the entire query, i.e. after
esql:results. In addition you need a esql:query tag around the
query (like you did with the execute-query tag).
> <esql:results>
> <messages>
> <esql:row-results>
> <message>
> <id> <esql:get-long
> column="ID"/> </id>
> <datetime> <esql:get-date
> column="Date"/> </datetime>
> <status> <esql:get-string
> column="Status"/> </status>
> <fetchurl> not yet implemented
> </fetchurl>
> </message>
> </esql:row-results>
> </messages>
> </esql:results>
> </esql:connection>
Chris.
--
C h r i s t i a n H a u l
haul@informatik.tu-darmstadt.de
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>