cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "von Schwerdtner, Thomas (GXS, FPI)" <Thomas.vonSchwerdt...@gxs.ge.com>
Subject jdbc or xsp or esql problem
Date Wed, 20 Mar 2002 18:21:37 GMT
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
========================================================================


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

Mime
View raw message