I have seen this error when there is an error in the table name. Check the spelling of the table name in the database and make sure it matches the name in the query including upper/lower case.
marty > -----Original Message----- > From: Muhammad Irfan [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 17, 2002 12:14 PM > To: [EMAIL PROTECTED] > Subject: Help Requested!!!! > > > > Dear All, > > I am trying a simple process to execute the sql query that > should give me the output in xml, but It seems to me that I > am stuckup with this. Below is the detailed description of > what I have done:- I have created a file named sql-test.xml > under "test" folder within tomcat/cocoon that just consist of > a single query:- <?xml version="1.0"?> <test > xmlns:sql="http://apache.org/cocoon/SQL/2.0";> > <title>Hello</title> > <content> > <para>This is SQL Test</para> > <sql:execute-query> > <query> > select * from employee > </query> > </sql:execute-query> > </content> > </test> > > I have updated the entries for driver and db within the > web.xml and cocoon.xconf file to use with MS Access database. > Having done that, I have inserted the following lines within > the main sitemap:- <map:pipeline> <map:match pattern="test/*"> > <map:generate src="test/sql-test.xml"/> > <map:transform type="sql"> > <map:parameter name="use-connection" value="mydb"/> > </map:transform> > <map:serialize type="xml"/> > </map:match> > </map:pipeline> > > I am getting the following errors:- > > " System can't find the specified resource" > " java.sql.SQLException: [Microsoft][ODBC Microsoft Access > Driver]Invalid use of null pointer " > > I will be grateful for your kind help > > Regards > > Irfan. > > > > > > > _________________________________________________________________ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp. > > > > --------------------------------------------------------------------- > 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]>
