cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ivan Rubin <ia...@mcsla.com.ar>
Subject Re: jdbc or xsp or esql problem
Date Wed, 20 Mar 2002 18:30:20 GMT


von Schwerdtner, Thomas (GXS, FPI) wrote:

> Hey folks,
> 
> Setup:
>  cocoon-2.0.2dev (can give snapshot date if needed, it's from about a 
> week ago)
>  tomcat 4.0.3-LE
>  jdk1.4
>  linux
>  java2/1.2/1.3/1.4 postgresql jdbc driver is in classpath (downloaded 
> bianry from jdbc.postgresql.org which specified that it would work with 
> 1.4 (but it also specified it could not be compiled with it).
> 
> Problem:
> I'm trying to get esql/postgresql setup here, and with a small xsp page 
> I am getting the following errors:
> 
> 
> Fancypants error page reports:
> ========================================================================
> org.apache.cocoon.ProcessingException: Language Exception: 
> org.apache.cocoon.components.language.LanguageException: Error compiling 
> test_xsp:
> 
> Line 315, column 5: ')' expected
> Line 431, column 20: not a statement
> Line 460, column 20: not a statement
> Line 460, column 28: ';' expected
> Line 310, column 36: 'void' type not allowed here
> Line 354, column 84: unreported exception: java.sql.SQLException; must 
> be caught or declared to be thrown
> Line 378, column 84: unreported exception: java.sql.SQLException; must 
> be caught or declared to be thrown
> Line 405, column 51: unreported exception: java.sql.SQLException; must 
> be caught or declared to be thrown
> Line 414, column 27: unreported exception: java.sql.SQLException; must 
> be caught or declared to be thrown
> Line 0, column 0:
> 9 errors
> ========================================================================




Under the work directory you'll find the generated .java for your xsp page.

I think you should enclose your content in between <xsp:content> tags.




> 
> 
> sitemap contains:
> ========================================================================
>                         <map:generator name="serverpages"
>                                 
> src="org.apache.cocoon.generation.ServerPagesGenerator"
>                                 label="content,data"
>                                 logger="sitemap.generator.serverpages"
>                                 pool-max="32" pool-min="4" pool-grow="2"/>
> 
> <!-- and later in the file -->
> 
>                         <map:match pattern="test-esql">
>                                 <map:generate type="serverpages" 
> src="documents/test.xsp"/>
>                                 <map:transform 
> src="stylesheets/databases/view.xsl"/>
>                                 <map:serialize/>
>                         </map:match>
> ========================================================================
> 
> cocoon.xconf contains:
> ========================================================================
>         <datasources>
>                 <jdbc logger="core.datasources.gesupply" name="gesupply">
>                         <pool-controller max="10" min="5"/>
>                         
> <dburl>jdbc:postgresql://localhost:5432/gesupply</dburl>
>                         <user>myUname</user>
>                         <password>myPassword</password>
>                 </jdbc>
>         </datasources>
> ========================================================================
> 
> web.xml contains:
> ========================================================================
>     <init-param>
>       <param-name>load-class</param-name>
>       <param-value>org.postgresql.Driver</param-value>
>     </init-param>
> ========================================================================
> 
> the stylesheet for test.xsp is a copy of the xsp stylesheet(s) from the 
> cocoon samples.
> test.xsp contains:
> ========================================================================
> <xsp:page
>         xmlns:xsp="http://apache.org/xsp"
>         xmlns:xlink="http://www.w3.org/1999/xlink"
>         xmlns:esql="http://apache.org/cocoon/SQL/v2"
>         language="java">
>        
>         <esql:connection>
>                 <esql:pool>gesupply</esql:pool>
>                 <esql:execute-query>
>                         <esql:query>SELECT 
> Id,SupportClassId,Type,Description FROM supporttype<esql:results>
>                                         <table>
>                                                 <esql:row-results>
>                                                         <tr>
>                                                                 <td>
>                                                                         
> <esql:get-string column="Id"/></td><td>
>                                                                         
> <esql:get-string column="Type"/></td>
>                                                         </tr>
>                                                 </esql:row-results>
>                                         </table>
>                                 </esql:results>
>                                 <esql:no-results>
>                                         <p>Sorry, no results!</p>
>                                 </esql:no-results>
>                         </esql:query>
>                 </esql:execute-query>
>         </esql:connection>
> </xsp:page>
> ========================================================================
> 



---------------------------------------------------------------------
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