cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gou...@osmosis.gr
Subject Re: MSAccess database problem
Date Thu, 20 Jan 2005 10:19:29 GMT

in windows platform you can create an ODBC entry for your .mdb file
and use the connection string:

jdbc:odbc:{your_dsn_entry}

that work for me 

--stavros 



On Thu, 20 Jan 2005, yssr wrote:

> 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
> 
> 


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


Mime
View raw message