Where can I download JDBC for Ms. Access ?

**newbiejava** · 01-20-2010, 02:53 AM

Hello All,

Where can I download JDBC for Ms. Access ?

please advise

Thanks & Regards

**masijade** · 01-20-2010, 09:06 AM

There is only one Type 4.0 (I.E. Java only driver, which is not, or at least not supposed to be, a simple proxy) JDBC Driver for MS Access (by HXTT or something like that, so Google that), and is not free. You would be much better off using a different database. If it must be an "embedded" DB than look into Apache Derby (I.E. JavaDB which is distributed bundled with JDK 6).

**newbiejava** · 01-20-2010, 10:15 AM

Hi, I need to use portable database, could you please advise what database should I use (readable on Windows & Linux) ..

derby is database server and it's not portable ..right? (pls correct me if I'm wrong)

thanks & regards

**masijade** · 01-20-2010, 10:18 AM

It can be run in server/client mode. It does not need to be, and, is most often used in "embedded" mode (i.e. not a server). And, seeing as how it is a DB that is implemented completely in Java, it is the most portable DB you're going to find, which MS Access definately is not. That you need to use it on Linux eliminates MS Access from your possibilites anyway.

**newbiejava** · 01-20-2010, 11:00 AM

noted with thanks, I will try derby now ;>)

**newbiejava** · 01-20-2010, 05:10 PM

btw, how to distribute my db? .. or I just copy the database folder?

**masijade** · 01-20-2010, 06:28 PM

Do need to deliver actual data or just the structure? If just the structure, don't bother. Write a small set of classes that create the tables and the like, and on program start simply get a connection, use DatabaseMetaData and see if the tables are there, and if not create them.

If you need to deliver data, then, yes, just deliver the entire directory (make sure its not in use when you zip it, though), but make that the program is configured properly (as its location is liable to change, of course).