cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yssr <yssr_...@yahoo.com>
Subject MSAccess database problem
Date Thu, 20 Jan 2005 10:15:36 GMT
Hi All,

   How can i retrieve a MSAccess databases.
now I am using "Atinav Access Component" but I it is
not working properly

1.I placed the jar in the lib
2.Added entry in load-class(web.xml)
3.database pool (cocoon.xconf)
   <jdbc name="MSdb">
          <pool-controller min="2" max="20"/>
          <auto-commit>false</auto-commit>
              
<dburl>jdbc:atinav:localhost:7227:d:\\testdatabase\db1.mdb</dburl>
          <user></user>
          <password></password>
    </jdbc>
4.stated 3rd party service

 Problem is nothing comming , when I place it in
simple xsp i.e,
   <?xml version="1.0"?>
<xsp:page language="java"
	  xmlns:esql="http://apache.org/cocoon/SQL/v2"	
          xmlns:xsp="http://apache.org/xsp">
<emp>
  <esql:connection>
  <esql:pool>MSdb</esql:pool>
  <esql:execute-query>
    <esql:query>SELECT id,name,place FROM
emp</esql:query>
    <esql:results>
      <table>
        <esql:row-results>
          <tr>
             <td><esql:get-string column="id"/></td>
             <td><esql:get-string column="name"/></td>
 	     <td><esql:get-string column="place"/></td>	
          </tr>
        </esql:row-results>
      </table>
    </esql:results>
    <esql:no-results>
       <p>Sorry, no results!</p>
    </esql:no-results>
  </esql:execute-query>
  </esql:connection> 
  <h1>Test</h1>
</emp>
</xsp:page>

when I use serialize type as html
nothing is comming.
when I use serialize type as xml 
it is showing error (root tag is mandatory)[i can
guess i.e, because there is no data in response]

Any sugession will help a lot....

Is there any other way to access "MSAccess"

Thanks
yssr


		
__________________________________ 
Do you Yahoo!? 
Take Yahoo! Mail with you! Get it on your mobile phone. 
http://mobile.yahoo.com/maildemo 

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message