cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "JD Daniels" ...@datatrio.com>
Subject RE: Cocoon Resource Not Found Depending On Database Query
Date Mon, 21 Oct 2002 20:33:49 GMT
ARGH

Sorry all, I found in my sitemap.log.....

ServerPagesGenerator: Exception in generate()
java.lang.RuntimeException: Error getting clob data: Column 'lid' not found.

Inside my rowset.. I had a value for a column that did not exist. It could
not find my error2html.xsl. hence the not found error. DOH!

JD



-----Original Message-----
From: Bobby Mitchell [mailto:bobby@niac.usra.edu]
Sent: Monday, October 21, 2002 1:16 PM
To: cocoon-users@xml.apache.org
Subject: Re: Cocoon Resource Not Found Depending On Database Query


JD Daniels wrote:

>Hi All,
>
>I have the following Datasource in my xconf file:
>
>	<jdbc name="database_one">
>		<pool-controller max="10" min="5"/>
>		<dburl>jdbc:mysql://host/database_one/</dburl>
>		<user>user</user>
>		<password>pass</password>
>	</jdbc>
>
>And This xsp:
>
><esql:connection>
>	<esql:pool>database_one</esql:pool>
>	<esql:execute-query>
>		<esql:query>SELECT * FROM thetable LIMIT 1</esql:query>
>		<esql:error-results><esql:get-message/></esql:error-results>
>		<esql:results>
>			<ROWSET>
>				<ROW>
>					<esql:row-results>
>						<SNIP></SNIP>
>					</esql:row-results>
>				</ROW>
>			</ROWSET>
>		</esql:results>
>	</esql:execute-query>
></esql:connection>
>
>
>The weirdness is:
>
>If thetable does not exist in database one, the xsp executes correctly and
>gives me the MySQL Error Saying the table does not exist. But when I create
>a query that should work (ie a table that really does exist), I get Cocoon
2
>error:
>
>The requested URI "/cocoon/mount/test/test.xsp" was not found
>
Does the file listed above exist in that directory?

>
>Why would Cocoon not map it correctly ?? I am confused :(
>
>Sitemap entry:
>
>			<map:match pattern="**.xsp">
>				<map:generate type="serverpages" src="logic/{1}.xsp"/>
>				<map:serialize/>
>			</map:match>
>
>
>I am using Tomcat 4 + RedHat
>
>JD Daniels
>
>
>---------------------------------------------------------------------
>Please check that your question  has not already been answered in the
>FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>
>
>To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
>For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>
>
>

--
Robert J. (Bobby) Mitchell
Systems Administrator
NASA Institute for Advanced Concepts
555A 14th St Atlanta, Ga. 30318
Phone: (404)347-9633 Fax: (404)347-9638





---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.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