You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Stavros Kounis <go...@osmosis.gr> on 2003/05/24 20:44:28 UTC
cocoon ODBC driver?
hello
is it possible cocoon to work with ODBC database?
in a win XP massine there is a access database served via ODBC
is it possible cocoon (that run in the same machine) to get data from this
database
i cant find a suitable driver for this
i have found an example with the follow entry in web.xml:
sun.jdbc.odbc.JdbcOdbcDriver
but i can not find from where can i download this driver
thxn
---stavros
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
Re: cocoon ODBC driver?
Posted by Stavros Kounis <go...@osmosis.gr>.
it a very small project for a friend. there is an access database without
a big ammount of data an we want to create a web report interfaace
so we will not have performan ce or reliability problems
but we can not find a driver .
in sun web site are many referencees to jdbc odbc driver
but without download links
---- stavros
On Sat, 24 May 2003, Alexander Schatten wrote:
> Stavros Kounis wrote:
>
> >hello
> >
> >is it possible cocoon to work with ODBC database?
> >
> >in a win XP massine there is a access database served via ODBC
> >is it possible cocoon (that run in the same machine) to get data from this
> >database
> >
> >
> >i cant find a suitable driver for this
> >
> >i have found an example with the follow entry in web.xml:
> > sun.jdbc.odbc.JdbcOdbcDriver
> >
> >but i can not find from where can i download this driver
> >
> >
> >
> (1) First of all, using Access as server application is definitly no
> good idea after my experiences. Use some other solid database server
> like PostgreSQL, mySQL, SAPDB or the like.
>
> (2) The mentioned ODBC bridge should be part of the Sun J2SE
>
> (3) Do not use this bridge in another context then in a sample
> application. If you really want to use access as server, then get a real
> JDBC driver for access, they are available from other vendors. Search
> the Java/Sun pages for JDBC drivers, they always had a database with
> driver vendors.
>
> (4) A good solution could be exporting the data via ODBC to
> mySQL/PostgresQL; Then you could use Access as frontend storing the data
> in the database server and the access from Cocoon is easy and solid too.
>
>
> Alex
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
Re: cocoon ODBC driver?
Posted by Alexander Schatten <al...@gmx.at>.
Stavros Kounis wrote:
>hello
>
>is it possible cocoon to work with ODBC database?
>
>in a win XP massine there is a access database served via ODBC
>is it possible cocoon (that run in the same machine) to get data from this
>database
>
>
>i cant find a suitable driver for this
>
>i have found an example with the follow entry in web.xml:
> sun.jdbc.odbc.JdbcOdbcDriver
>
>but i can not find from where can i download this driver
>
>
>
(1) First of all, using Access as server application is definitly no
good idea after my experiences. Use some other solid database server
like PostgreSQL, mySQL, SAPDB or the like.
(2) The mentioned ODBC bridge should be part of the Sun J2SE
(3) Do not use this bridge in another context then in a sample
application. If you really want to use access as server, then get a real
JDBC driver for access, they are available from other vendors. Search
the Java/Sun pages for JDBC drivers, they always had a database with
driver vendors.
(4) A good solution could be exporting the data via ODBC to
mySQL/PostgresQL; Then you could use Access as frontend storing the data
in the database server and the access from Cocoon is easy and solid too.
Alex
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org