cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Roberto" <rma...@montefiore.ch>
Subject Re: MSAccess database problem
Date Thu, 20 Jan 2005 12:55:40 GMT
Stupid reply...but do you have the properly jar file in the properly folder?
Cheers
Roberto

----- Original Message ----- 
From: "yssr" <yssr_555@yahoo.com>
To: <users@cocoon.apache.org>
Sent: Thursday, January 20, 2005 12:43 PM
Subject: Re: MSAccess database problem


> Hi 
>   the below also I tried but it is saying that
> "Datasource not found"(in log)
> 1. my web.xml entry in load classes
>   <!-- For ODBC -->
>         sun.jdbc.odbc.JdbcOdbcDriver
>    
> 2.my cocoon.xconf entry
>  <jdbc name="JDBCODBCdb">
>               <pool-controller min="2" max="20"/>
>               <auto-commit>false</auto-commit>
>               <dburl>jdbc:odbc:SSPer</dburl>
>               <user></user>
>               <password></password>
>     </jdbc>
> 
> SSPer is datasource name I gave in ODBC(control panel 
> etc....)
> 3.in XSP
>  <?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>JDBCODBCdb</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>
> 
> 
> But still a problem...
> 
> any sugession.
> ===========
> Thanks
> yssr
> 
> 
> --- gounis@osmosis.gr wrote:
> 
> > 
> > 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
> > 
> > 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> 
> ---------------------------------------------------------------------
> 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