again mySQL, jdbc and ESQL

[fr...@virgilio.it]

>> This is my XML code:
>> ------
>> <xsp:page
>>         laguage="java"
>>         xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>>         xmlns:esql="http://apache.org/cocoon/SQL/v2"
>> >
>>...
>> <esql:connection>
>> <esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
>>         <esql:dburl>jdbc:mysql://localhost/test</esql:dburl>
>>         <esql:username>fku</esql:username>
>>         <esql:password></esql:password>
>>         <esql:execute-query>
>>                 <esql:query>select * from prova</esql:query>
>>
>>                 <esql:results>
>>                         <ROWSET>
>>                          <esql:row-results>
>>                           <ROW>
>>                            <esql:get-columns/>
>>                           </ROW>
>>                          </esql:row-results>
>>                         </ROWSET>
>>                 </esql:results>
>>
>>         </esql:execute-query>
>> </esql:connection>
>
>note you're not even using the connection pool you created, but that's
>beside the poitn. the problem seems to be the the esql:connection element
>doesn't fall underneath a real element, it's right underneath xsp:page.
>
>- donald
>

Many thanks for your prompt answer, Donald!
But I'm a newbie and I don't know how to execute what you say.
Please, would you explain to me your idea in other words?
How I need to change the xml code?

Thank you very much!

Regards, ciao
Francesco

Francesco Casalena
L.U.G. "Il Pinguino"
----------------------------------------------
Virgilio Mail - Il tuo indirizzo E-mail gratis
http://mail.virgilio.it


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org