You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Muhammad Irfan <ir...@hotmail.com> on 2002/04/17 18:13:51 UTC
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>