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: [EMAIL PROTECTED] 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: <[EMAIL PROTECTED]> >For additional commands, e-mail: <[EMAIL PROTECTED]> > > -- 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: <[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/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>