Re: no data from db in xsp

[Leszek Gawron]

Carl-Otto Kjellkvist wrote:

i have this code in my xsp:

<content>
<title>Search results</title>
<esql:connection>
  <esql:pool>swingconnection</esql:pool>
  <esql:execute-query>
   <esql:query>select * from doneschedule
   </esql:query>
   <esql:results>

    <resources>
     <esql:row-results>

      <resource>
       <esql:get-columns/>
      </resource>

     </esql:row-results>

    </resources >

   </esql:results>

  </esql:execute-query>

</esql:connection>

</content>

and my pipeline is:

<map:pipeline match="*.xsp">
<map:generate type="serverpages" src="xsp/WSBinder.xsp" />
<map:serialize type="xml"/>
   </map:pipeline>

i have set the swingconnection in cocoon.xconf and web.xml has gotten the driver for jdbc.
Also my db has content but when i execute the file through a browser i only get the title.
Can i somehow set som error handling so i can look up the fault?

regards

c-o

have you declared esql namespace in your xsp?
check web-inf/logs/ for errors.

--
Leszek Gawron                                      [EMAIL PROTECTED]
Project Manager                                    MobileBox sp. z o.o.
+48 (61) 855 06 67                              http://www.mobilebox.pl
mobile: +48 (501) 720 812                       fax: +48 (61) 853 29 65

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]