Maybe it helps if do this: <content> <esql:connection> .... ... .... </esql:connection> </content> Because now you get a xml with multiple <para> and thus multiple root elements...
That at least is a error and maybe this is the sollution Regards Edgar -----Oorspronkelijk bericht----- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 1 mei 2002 15:44 Aan: [EMAIL PROTECTED] Onderwerp: Can't get ESQL in XSP to work.... Hi - I tried the following XSP file... <?xml version="1.0"?> <xsp:page xmlns:xsp="http://apache.org/xsp"; xmlns:esql="http://apache.org/cocoon/SQL/v2";> <esql:connection> <esql:pool>venusPool</esql:pool> <esql:execute-query> <esql:query>select * from ref_country</esql:query> <esql:results> <esql:row-results> <para><esql:get-string column="description"/></para> <esql:get-columns/> </esql:row-results> </esql:results> </esql:execute-query> </esql:connection> </xsp:page> I am using Weblogic 6.0sp2, on Solaris, and Cocoon 2.0.2, and I cannot get this XSP to work - the connection pool is defined in the config.xml as below: <JDBCConnectionPool CapacityIncrement="1" DriverName="oracle.jdbc.driver.OracleDriver" InitialCapacity="0" MaxCapacity="5" Name="venusPool" Properties="user=theuser;password=thepass" Targets="eservices" URL="jdbc:oracle:thin:@venus:1521:thedatabase"/> So venusPool exists - and it's running - but when I try to run the above XSP code, I get this rather unfriendly and unhelpful message: Cocoon 2 - Internal server error type fatal message Exception in ServerPagesGenerator.generate() description org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.NullPointerException sender org.apache.cocoon.servlet.CocoonServlet source Cocoon servlet stack-trace org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.NullPointerException at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenera tor.java:272) at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv entPipeline.java:251) at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS treamPipeline.java:399) at org.apache.cocoon.www.sitemap_xmap.matchN10388(/export/weblogic_6.0/config/v odafone/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_cocoon/coco on-files/org/apache/cocoon/www/sitemap_xmap.java:4185) at org.apache.cocoon.www.sitemap_xmap.process(/export/weblogic_6.0/config/vodaf one/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_cocoon/cocoon-f iles/org/apache/cocoon/www/sitemap_xmap.java:3218) at org.apache.cocoon.www.sitemap_xmap.process(/export/weblogic_6.0/config/vodaf one/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_cocoon/cocoon-f iles/org/apache/cocoon/www/sitemap_xmap.java:3091) at org.apache.cocoon.sitemap.Handler.process(Handler.java:222) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179) at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:154) at org.apache.cocoon.Cocoon.process(Cocoon.java:575) at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:998) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :213) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo ntext.java:1265) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java :1631) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) java.lang.NullPointerException at org.apache.cocoon.components.language.markup.xsp.EsqlQuery.(EsqlQuery.java:9 0) at org.apache.cocoon.www.dealersite.helloworld_xsp.generate(/export/weblogic_6. 0/config/vodafone/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_c ocoon/cocoon-files/org/apache/cocoon/www/dealersite/helloworld_xsp.java:296) at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenera tor.java:260) at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv entPipeline.java:251) at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS treamPipeline.java:399) at org.apache.cocoon.www.sitemap_xmap.matchN10388(/export/weblogic_6.0/config/v odafone/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_cocoon/coco on-files/org/apache/cocoon/www/sitemap_xmap.java:4185) at org.apache.cocoon.www.sitemap_xmap.process(/export/weblogic_6.0/config/vodaf one/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_cocoon/cocoon-f iles/org/apache/cocoon/www/sitemap_xmap.java:3218) at org.apache.cocoon.www.sitemap_xmap.process(/export/weblogic_6.0/config/vodaf one/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_cocoon/cocoon-f iles/org/apache/cocoon/www/sitemap_xmap.java:3091) at org.apache.cocoon.sitemap.Handler.process(Handler.java:222) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179) at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:154) at org.apache.cocoon.Cocoon.process(Cocoon.java:575) at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:998) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :213) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo ntext.java:1265) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java :1631) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) request-uri /dealersite/helloworld.xsp path-info dealersite/helloworld.xsp Anyone have an idea? TIA Chris --------------------------------------------------------------------- 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
