You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by yssr <ys...@yahoo.com> on 2005/01/20 11:15:36 UTC
MSAccess database problem
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
Re: MSAccess database problem
Posted by Roberto <rm...@montefiore.ch>.
Stupid reply...but do you have the properly jar file in the properly folder?
Cheers
Roberto
----- Original Message -----
From: "yssr" <ys...@yahoo.com>
To: <us...@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
Re: MSAccess database problem
Posted by go...@osmosis.gr.
this work for me
<jdbc name="hotpoints">
<pool-controller min="5" max="10"/>
<dburl>jdbc:odbc:hotpoints-1.1</dburl>
</jdbc>
where just like you "hotpoints-1.1" is how i have register my .mdb in
odbci dont know .. but have you try to remove elements for username and
passwd?
--stavros
On Thu, 20 Jan 2005, yssr wrote:
> 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
Re: MSAccess database problem
Posted by yssr <ys...@yahoo.com>.
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
Re: MSAccess database problem
Posted by go...@osmosis.gr.
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