connection between java and ms access

Question

I want get data from ms access with my java app. java version 1.8. I watched video from youtube. there was these code:

public class Main {

    public static void main(String[] args) {

        try  {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection("jdbc:odbc:Test");

            Statement st = conn.createStatement();
            String sql = "Select *  from playlist";
            ResultSet rs = st.executeQuery(sql);
            while(rs.next()) {
                System.out.print(rs.getString(1));
            }
        } catch (Exception e){   
            System.out.print(e.getMessage());
        }
    }
}

my output is:

sun.jdbc.odbc.JdbcOdbcDriver
Process finished with exit code 0

what am i doing wrong? if there extras i have to do? please help!

I have seen a couple of questions about a driver named ucanaccess (U can access). I haven’t got any experience and cannot recommend either way, but you may want to investigate yourself. — Ole V.V., Jul 27 '18 at 19:20

score 1 · Accepted Answer · answered Jul 27 '18 at 18:51

1

The JdbcOdbc bridge driver was removed from Java in version 8.

Here is an answer with more info

Your exception contains more useful information than only the message, try printing the exception or printStacktrace method

answered Jul 27 '18 at 18:51

JohannesB

2,214
1
11
18

connection between java and ms access

1 Answers1