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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
