cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marty McClelland" <mmcclell...@eduprise.com>
Subject RE: Help Requested!!!!
Date Wed, 17 Apr 2002 16:52:01 GMT
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:irfanm24@hotmail.com] 
> Sent: Wednesday, April 17, 2002 12:14 PM
> To: cocoon-users@xml.apache.org
> 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: <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/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