views:

136

answers:

2

Hi,

we need some data which is stored on several Microsoft Access databases on our servers, and our application will be executed on a Linux machine.

So, our only alternative consist in using a JDBC Type 4 driver. In our research, we found two alternatives:

Has anyone here ever used one of these? How was your experience? Are they really good? Can we trust them?

+1  A: 

We bought the StelsMDB driver and the result (and the pricing) is good.

Our application is not very complex but enough to break the ODBC-JDBC bridge.

RealHowTo
How about the ammount of data? Does it work well with databases which carry something like 10.000 to 50.000 records?
Kico Lobo
A: 

If the databases are in Access 2000 format you could take a look at Jackcess: http://jackcess.sourceforge.net/

obscuredlogic
We take a look at that, but theres a problem: it doesn't accept SQL queries. We have to iterate over records instead of just writing SQL against the database.But it's an option. Thanks for the tip!
Kico Lobo