cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Muhammad Irfan" <>
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="">
  <para>This is SQL Test</para>
        select * from employee

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:match pattern="test/*">
      <map:generate src="test/sql-test.xml"/>
      <map:transform type="sql">
      <map:parameter name="use-connection" value="mydb"/>
      <map:serialize type="xml"/>

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



Send and receive Hotmail on your mobile device:

Please check that your question has not already been answered in the
FAQ before posting. <>

To unsubscribe, e-mail: <>
For additional commands, e-mail: <>

View raw message