How can I connect to an Access database from Java using JDBC?

Question

Code provided in OP's comment

public static Connection getConnection() throws SQLException { 
    // connection object
    Connection con = null;

    // database url
    String connectionString = "jdbc:odbc:Driver= " 
            + "{Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + dbPath;

    try {
        Class.forName(driver);
        con = DriverManager.getConnection(connectionString);
    } catch (ClassNotFoundException ex) {
        System.out.println("connot load driver class");
        return con;
    }
}

So maybe you can tell us about your problem, what did you try so far? — home
– home, Commented Dec 14, 2011 at 12:15
public static Connection getConnection() throws SQLException { // connection object Connection con = null; // database url String connectionString = "jdbc:odbc:Driver= " + "{Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + dbPath; try { Class.forName(driver); con = DriverManager.getConnection(connectionString); } catch (ClassNotFoundException ex) { System.out.println("connot load driver class"); } return con; } — soad el-hayek
– soad el-hayek, Commented Dec 14, 2011 at 12:23
@soad el-hayek, instead of posting your code on a post section, update your question rather with your code and the stacktrace that you're getting. — Buhake Sindi
– Buhake Sindi, Commented Dec 14, 2011 at 12:26

Hemant Metalia · Accepted Answer · 2011-12-14 12:15:44Z

1

you can use

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

// set this to a MS Access DB you have on your machine

String filename = "d:/java/mdbTEST.mdb";
String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end 
// now we can get the connection from the DriverManager
Connection con = DriverManager.getConnection( database ,"","");

refer http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lngWId=2

answered Dec 14, 2011 at 12:15

Hemant Metalia

30.8k18 gold badges77 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

soad el-hayek Over a year ago

I'VE use the same public static Connection getConnection() throws SQLException { Connection con = null; String connectionString = "jdbc:odbc:Driver= " + "{Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + dbPath; try { // load the driver class Class.forName(driver); con = DriverManager.getConnection(connectionString); } catch (ClassNotFoundException ex) { System.out.println("connot load driver class"); } // return the connection object return con; }

PhilW · Accepted Answer · 2011-12-14 12:13:30Z

0

You'll need the ODBC-JDBC bridge for that.

See http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lngWId=2 for sample source code. and http://www.youtube.com/watch?v=iXkGMu70HuM so see how to setup the data source (DSN).

answered Dec 14, 2011 at 12:13

PhilW

7511 gold badge6 silver badges23 bronze badges

1 Comment

soad el-hayek Over a year ago

for the video , i've win 7 64 bit

Garry M. Biggs · Accepted Answer · 2011-12-14 12:29:24Z

0

An alternative - JDBC to ODBC Bridge - which has a client/server architecture is also available...

This means the Java application and Access database can reside on different machines.

The following link will give you an idea of what goes where --

OpenLink Milti-tier JDBC to ODBC Bridge

answered Dec 14, 2011 at 12:29

Garry M. Biggs

2401 silver badge1 bronze badge

Comments

LynAs · Accepted Answer · 2011-12-14 13:07:46Z

public class NewClass {
static final String DRIVER = "com.mysql.jdbc.Driver";
static final String DATABASE_URL = "jdbc:mysql://localhost/databasename";
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
public void dataQuery(String queryData) {
    Class.forName(DRIVER);
    connection = DriverManager.getConnection(DATABASE_URL, "root", "");
    statement = connection.createStatement();
    resultSet = statement.executeQuery(queryData);
    while (resultSet.next()) {
        System.out.println(resultSet.getObject(1));
    }
}    
catch (Exception e) {            
    System.out.println("error Accessing");
}finally {
    try {
        resultSet.close();
        statement.close();
        connection.close();
    } catch (Exception exception) {
        System.out.println("error closing ");}
}
}
}

ANAND · Accepted Answer · 2014-11-10 12:12:24Z

0

You can use ODBC connection to connect to Access Database from Java.

See the following example

http://www.csnotes32.com/2014/11/how-to-read-write-update-and-list-data.html

answered Nov 10, 2014 at 12:12

ANAND

112 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 10:26:26Z

0

Now that the JDBC-ODBC Bridge has been removed from Java (since Java SE 8), future readers should consider using the UCanAccess JDBC driver instead. For more information see

Manipulating an Access database from Java without ODBC

edited May 23, 2017 at 10:26

CommunityBot

11 silver badge

answered Nov 10, 2014 at 12:57

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Collectives™ on Stack Overflow

How can I connect to an Access database from Java using JDBC?

6 Answers 6

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related