Java database connectivity exception

Question

I am connecting java to Microsoft access database but I am having following exception

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

try{
     String ProjectPath= System.getProperties().getProperty("user.dir");
     System.out.println(ProjectPath);
     String path,fullstring;
     path=ProjectPath+"\\data.mdb";
     fullstring="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" +path;
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection con=DriverManager.getConnection(fullstring);
     System.out.println("Connected");
 }catch(Exception e){

     System.out.println("Connected Error: "+ e);
     }

How can I solve my problem?

Off-topic, but do you ever use JPA ? It's really more comfortable than JDBC. Take a look, you're going to like it ;) — NiziL
– NiziL, Commented Oct 18, 2013 at 8:09
possible duplicate of How to connect MS Access Database using Java program? — SpringLearner
– SpringLearner, Commented Oct 18, 2013 at 8:09
Is your Java application running in a 64-bit Java Virtual Machine (JVM)? — Gord Thompson
– Gord Thompson, Commented Oct 19, 2013 at 10:27

Gord Thompson · Accepted Answer · 2013-10-19 13:11:09Z

1

{Microsoft Access Driver (*.mdb)} is the name of the older Microsoft Jet driver, which will only work in 32-bit applications. (There are no 64-bit versions of the Jet database engine or the Jet ODBC driver.)

To connect with .mdb and .accdb files from a 64-bit application you need to download and install the 64-bit version of the Access Database Engine (a.k.a. "ACE") from here, and then refer to it in your application by using the driver name {Microsoft Access Driver (*.mdb, *.accdb)}.

answered Oct 19, 2013 at 13:11

Gord Thompson

125k39 gold badges252 silver badges458 bronze badges

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

Comments

Ria · Accepted Answer · 2013-10-20 09:48:08Z

0

    import java.sql.*;
    class dbTst {
public static void main(String args[]) throws Exception{
    try{


    //Driver for JDBC-ODBC Bridge
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

    //Establishing the Connection through DSN
    Connection con= DriverManager.getConnection("jdbc:odbc:db","","");

    //Creating the Statement Object
    Statement st=con.createStatement();


    ResultSet rs=st.executeQuery("Select * from aman");

    while(rs.next()==true){

    System.out.println(rs.getString("name")+" - " + rs.getString("basic"));
    }

    rs.close();
    st.close();
    con.close();
    }
            catch(Exception ee){
                System.out.println(ee.getMessage());
    }
}
}

edited Oct 20, 2013 at 9:48

Ria

10.4k3 gold badges35 silver badges62 bronze badges

answered Oct 20, 2013 at 9:30

Amandeep

1

1 Comment

Sarah Over a year ago

Its is giving same exception [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

justhalf · Accepted Answer · 2013-10-18 08:36:14Z

-1

I think that you want to connect in some strange way..

http://docs.oracle.com/javase/tutorial/jdbc/basics/connecting.html

The code (use DriverManager):

public Connection getConnection() throws SQLException {
    Connection conn = null;
    Properties connectionProps = new Properties();
    connectionProps.put("user", this.userName);
    connectionProps.put("password", this.password);

    if (this.dbms.equals("mysql")) {
        conn = DriverManager.getConnection(
               "jdbc:" + this.dbms + "://" +
               this.serverName +
               ":" + this.portNumber + "/",
               connectionProps);
    } else if (this.dbms.equals("derby")) {
        conn = DriverManager.getConnection(
               "jdbc:" + this.dbms + ":" +
               this.dbName +
               ";create=true",
               connectionProps);
    }
    System.out.println("Connected to database");
    return conn;
}

edited Oct 18, 2013 at 8:36

justhalf

9,1354 gold badges51 silver badges79 bronze badges

answered Oct 18, 2013 at 8:12

Tomasz Waszczyk

3,2196 gold badges46 silver badges81 bronze badges

2 Comments

justhalf Over a year ago

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.

Tomasz Waszczyk Over a year ago

There is also a possibility to connect via eg. Eclipse perspective called: Database perspective.

Collectives™ on Stack Overflow

Java database connectivity exception

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related