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. _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com --------------------------------------------------------------------- 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]>
