Type 4 JDBC driver for MS ACCESS(.mdb) database

旧城等待， 2022-05-16 03:27 200阅读 0赞

# [Type 4 JDBC driver for MS ACCESS(.mdb) database?][Type 4 JDBC driver for MS ACCESS_.mdb_ database] #

[Ask Question][]

up vote4down vote[favorite][]

**2**

My Java application uses a .mdb database and i want to run this application on MAC OS for that am definitely gonna nead a TYPE 4 JDBC driver i have google and came across two - HXTT & StelsMDB but both are out of my reach

So if any body has some alternative or suggestions please reply.

Thanks in advance

[java][] [ms-access][] [jdbc][]

[share][][improve this question][]

[edited Nov 26 '10 at 11:05][edited_Nov 26 _10 at 11_05]

[![Drui0.jpg_s_32_g_1][]][Drui0.jpg_s_32_g_1 1]

[skaffman][Drui0.jpg_s_32_g_1 1]

330k81715714

asked Nov 26 '10 at 10:57

[![405b5a5ccbfbdff860ec8e254c0c75da_s_32_d_identicon_r_PG][]][405b5a5ccbfbdff860ec8e254c0c75da_s_32_d_identicon_r_PG 1]

[Jinith][405b5a5ccbfbdff860ec8e254c0c75da_s_32_d_identicon_r_PG 1]

52731025

*  May be of interest: [sourceforge.net/projects/jackcess/files][sourceforge.net_projects_jackcess_files] – [Fionnuala][] Nov 26 '10 at 11:28
 *  Jackcess is not a JDBC driver but a special purpose library. You cannot use it as a drop-in replacement and would have to re-factor all of your database code if you did. Rather than support SQL statements, you have to create database objects and invoke methods on those objects to interact with the database. – [PeterToTheThird][] Nov 12 '12 at 15:23

add a comment

## 5 Answers ##

[active][][oldest][][votes][]

up vote4down voteaccepted

MS Access databases on MS Windows are driven by the [Microsoft Jet Engine][]. Different from client server database management systems like MS SQL Server or MySQL the connection to a MS Access database runs in embedded mode via OLE and some DLLs.

As far as I know there is no Jet Engine implementation for operating systems other than MS Windows. So if you want to connect to a MDB file on Mac OS a simple JDBC driver is not enough. There has to be some kind of emulation layer to emulate the Jet Engine DLLs. According to the [HXTT website][] this is exactly the way the HXTT JDBC driver works.

From the HXTT website:

> It contains a fast database engine written in Java, which supports embedded and server modes.

If the usage of the MS Access database format is an absolute requirement, then these kind of emulation might be the best way for you. But you have to testify if the compatibility level is high enough. (Maybe there is no way to access VBA macros contained in the MDB file.)

It seems there is no open source project doing the same kind of emulation like HXTT.

There are several alternatives. If you want an embedded database system then you can use for example

*  [SQLite][] ([this JDBC driver][] supports Mac Os) (one database file, requires some native libraries),
 *  [H2][] (only a few database files, pure Java) or
 *  [Apache Derby][] (many database files, pure Java).

Or you can use a client server database management system, install the server on a host and connect to that host from your Mac OS machine. For that you can use for example

*  [PostgreSQL][]
 *  [Firebird][]
 *  [MySQL][]

Even the pure Java databases H2 and Derby have client server modes.

[share][share 1][improve this answer][]

answered Nov 28 '10 at 8:19

[![ae31fbc7d031008822f8e149f54478f2_s_32_d_identicon_r_PG][]][ae31fbc7d031008822f8e149f54478f2_s_32_d_identicon_r_PG 1]

[vanje][ae31fbc7d031008822f8e149f54478f2_s_32_d_identicon_r_PG 1]

8,14022336

*  1
    
    Jet has been superseded by its successor, ACE, which is really just an upgrade to Jet. All of what you say still applies, but your answer would be more complete if you incorporated the ACE reference. – [David-W-Fenton][] Nov 30 '10 at 1:04
 *  This answer is outdated. See [this answer][] for a free open-source JDBC driver for Access databases ([UCanAccess][]). More information available from [this question][]. – [Gord Thompson][] May 7 '15 at 14:59

add a comment

up vote6down vote

I've used [jackcess][] to read the tables from an MDB and convert the database to sqlite3. Not ideal if you need to keep the .mdb format, but it allowed me to keep the database in a single file and made the database cross-platform.

[share][share 2][improve this answer][improve this answer 1]

[edited Jun 29 '12 at 17:26][edited_Jun 29 _12 at 17_26]

[![f8c60eb5f46783d753e86238a9c18cd9_s_32_d_identicon_r_PG][]][f8c60eb5f46783d753e86238a9c18cd9_s_32_d_identicon_r_PG 1]

[jtahlborn][f8c60eb5f46783d753e86238a9c18cd9_s_32_d_identicon_r_PG 1]

46.3k55693

answered Nov 26 '10 at 14:04

[![f7af04c34ca6126e6fd74d4144473f96_s_32_d_identicon_r_PG][]][f7af04c34ca6126e6fd74d4144473f96_s_32_d_identicon_r_PG 1]

[Jeff Knecht][f7af04c34ca6126e6fd74d4144473f96_s_32_d_identicon_r_PG 1]

2,28911111

add a comment

up vote3down vote

I suppose [UCanAccess][] is what you are looking for.

It is an **open source Java JDBC Driver** implementation which allows Java developers and jdbc client programs (e.g., DBeaver, NetBeans, SQLeo, Open Office Base, Libre Office Base, Squirrell) **to read/write Microsoft Access database**. Because it is a pure java implementation **it run in both Windows and non-Windows Operative Systems (e.g., linux/unix). No ODBC needed.**

[share][share 3][improve this answer][improve this answer 2]

answered May 7 '15 at 14:29

[![cV0N4.png_s_32_g_1][]][cV0N4.png_s_32_g_1 1]

[lu\_ko][cV0N4.png_s_32_g_1 1]

2,19911624

add a comment

up vote2down vote

StelsMDB is not as expensive as HXTT, still not open source...

[http://www.csv-jdbc.com/stels\_mdb\_jdbc.htm][http_www.csv-jdbc.com_stels_mdb_jdbc.htm]

Have'n tried it, but evaluation copy is available.

Anyone else got suggestions? I'm looking for an opensource variant myself. Shouldn't be impossible to build on top of jaccess ...

[share][share 4][improve this answer][improve this answer 3]

answered Oct 18 '11 at 4:09

[![fb47dc5db41df9f38ec78ba07f1696e7_s_32_d_identicon_r_PG][]][fb47dc5db41df9f38ec78ba07f1696e7_s_32_d_identicon_r_PG 1]

[Jon Martin Solaas][fb47dc5db41df9f38ec78ba07f1696e7_s_32_d_identicon_r_PG 1]

6271819

add a comment

up vote0down vote

We use stelsMDB JDBC driver at our server to read/write MDB files. It is platform-independent, so you can use it in MacOS as well.

[share][share 5][improve this answer][improve this answer 4]

answered Mar 28 '13 at 7:20

[![d791bb4a26e2aed785fc9f32a131d8d9_s_32_d_identicon_r_PG][]][d791bb4a26e2aed785fc9f32a131d8d9_s_32_d_identicon_r_PG 1]

[serg kunz][d791bb4a26e2aed785fc9f32a131d8d9_s_32_d_identicon_r_PG 1]

1066

add a comment

[Type 4 JDBC driver for MS ACCESS_.mdb_ database]: https://stackoverflow.com/questions/4284661/type-4-jdbc-driver-for-ms-access-mdb-database
[Ask Question]: https://stackoverflow.com/questions/ask
[favorite]: https://stackoverflow.com/questions/4284661/type-4-jdbc-driver-for-ms-access-mdb-database#
[java]: https://stackoverflow.com/questions/tagged/java
[ms-access]: https://stackoverflow.com/questions/tagged/ms-access
[jdbc]: https://stackoverflow.com/questions/tagged/jdbc
[share]: https://stackoverflow.com/q/4284661
[improve this question]: https://stackoverflow.com/posts/4284661/edit
[edited_Nov 26 _10 at 11_05]: https://stackoverflow.com/posts/4284661/revisions
[Drui0.jpg_s_32_g_1]: https://i.stack.imgur.com/Drui0.jpg?s=32&g=1
[Drui0.jpg_s_32_g_1 1]: https://stackoverflow.com/users/21234/skaffman
[405b5a5ccbfbdff860ec8e254c0c75da_s_32_d_identicon_r_PG]: https://www.gravatar.com/avatar/405b5a5ccbfbdff860ec8e254c0c75da?s=32&d=identicon&r=PG
[405b5a5ccbfbdff860ec8e254c0c75da_s_32_d_identicon_r_PG 1]: https://stackoverflow.com/users/403067/jinith
[sourceforge.net_projects_jackcess_files]: http://sourceforge.net/projects/jackcess/files/
[Fionnuala]: https://stackoverflow.com/users/2548/fionnuala
[PeterToTheThird]: https://stackoverflow.com/users/684616/petertothethird
[active]: https://stackoverflow.com/questions/4284661/type-4-jdbc-driver-for-ms-access-mdb-database?answertab=active#tab-top
[oldest]: https://stackoverflow.com/questions/4284661/type-4-jdbc-driver-for-ms-access-mdb-database?answertab=oldest#tab-top
[votes]: https://stackoverflow.com/questions/4284661/type-4-jdbc-driver-for-ms-access-mdb-database?answertab=votes#tab-top
[Microsoft Jet Engine]: http://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine
[HXTT website]: http://www.hxtt.com/access.html
[SQLite]: http://www.sqlite.org/
[this JDBC driver]: http://www.zentus.com/sqlitejdbc/
[H2]: http://www.h2database.com/
[Apache Derby]: http://db.apache.org/derby/
[PostgreSQL]: http://www.postgresql.org/
[Firebird]: http://www.firebirdsql.org/
[MySQL]: http://www.mysql.com/
[share 1]: https://stackoverflow.com/a/4295954
[improve this answer]: https://stackoverflow.com/posts/4295954/edit
[ae31fbc7d031008822f8e149f54478f2_s_32_d_identicon_r_PG]: https://www.gravatar.com/avatar/ae31fbc7d031008822f8e149f54478f2?s=32&d=identicon&r=PG
[ae31fbc7d031008822f8e149f54478f2_s_32_d_identicon_r_PG 1]: https://stackoverflow.com/users/459557/vanje
[David-W-Fenton]: https://stackoverflow.com/users/9787/david-w-fenton
[this answer]: http://stackoverflow.com/a/30104041/2144390
[UCanAccess]: http://ucanaccess.sourceforge.net/site.html
[this question]: http://stackoverflow.com/q/21955256/2144390
[Gord Thompson]: https://stackoverflow.com/users/2144390/gord-thompson
[jackcess]: http://jackcess.sourceforge.net/
[share 2]: https://stackoverflow.com/a/4285915
[improve this answer 1]: https://stackoverflow.com/posts/4285915/edit
[edited_Jun 29 _12 at 17_26]: https://stackoverflow.com/posts/4285915/revisions
[f8c60eb5f46783d753e86238a9c18cd9_s_32_d_identicon_r_PG]: https://www.gravatar.com/avatar/f8c60eb5f46783d753e86238a9c18cd9?s=32&d=identicon&r=PG
[f8c60eb5f46783d753e86238a9c18cd9_s_32_d_identicon_r_PG 1]: https://stackoverflow.com/users/552759/jtahlborn
[f7af04c34ca6126e6fd74d4144473f96_s_32_d_identicon_r_PG]: https://www.gravatar.com/avatar/f7af04c34ca6126e6fd74d4144473f96?s=32&d=identicon&r=PG
[f7af04c34ca6126e6fd74d4144473f96_s_32_d_identicon_r_PG 1]: https://stackoverflow.com/users/142263/jeff-knecht
[share 3]: https://stackoverflow.com/a/30104041
[improve this answer 2]: https://stackoverflow.com/posts/30104041/edit
[cV0N4.png_s_32_g_1]: https://i.stack.imgur.com/cV0N4.png?s=32&g=1
[cV0N4.png_s_32_g_1 1]: https://stackoverflow.com/users/3271406/lu-ko
[http_www.csv-jdbc.com_stels_mdb_jdbc.htm]: http://www.csv-jdbc.com/stels_mdb_jdbc.htm
[share 4]: https://stackoverflow.com/a/7802326
[improve this answer 3]: https://stackoverflow.com/posts/7802326/edit
[fb47dc5db41df9f38ec78ba07f1696e7_s_32_d_identicon_r_PG]: https://www.gravatar.com/avatar/fb47dc5db41df9f38ec78ba07f1696e7?s=32&d=identicon&r=PG
[fb47dc5db41df9f38ec78ba07f1696e7_s_32_d_identicon_r_PG 1]: https://stackoverflow.com/users/275886/jon-martin-solaas
[share 5]: https://stackoverflow.com/a/15676287
[improve this answer 4]: https://stackoverflow.com/posts/15676287/edit
[d791bb4a26e2aed785fc9f32a131d8d9_s_32_d_identicon_r_PG]: https://www.gravatar.com/avatar/d791bb4a26e2aed785fc9f32a131d8d9?s=32&d=identicon&r=PG
[d791bb4a26e2aed785fc9f32a131d8d9_s_32_d_identicon_r_PG 1]: https://stackoverflow.com/users/1929288/serg-kunz