cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Muhammad Irfan" <irfan...@hotmail.com>
Subject SQL Problem!!!
Date Tue, 16 Apr 2002 16:32:03 GMT


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.



_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message