Win a copy of Micro Frontends in Action this week in the Server-Side JavaScript and NodeJS forum!

Arie Kaufman

Greenhorn
+ Follow
since Aug 07, 2013
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Arie Kaufman

I am pretty new to Java and I'd like to be able to use my Ubuntu Computer to extract information from MS Access files (using sql statements)

Is that a hopeless venture?

I've already tried using code like this:
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
import java.sql.*;
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String database = "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=/home/stupiddatabase.mdb;";
Connection myConnection = DriverManager.getConnection(database,"","");
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

This, however, throws a ClassNotFoundException: "sun.jdbc.odbc.JdbcOdbcDriver"

So, I don't have that driver... ok. Obviously it didn't come with my Java 7 installation.

I've heard that I can find this odbc-driver in the jar-file rt.jar but the problem is that it seems to have disappeared from there some years ago from the jre version 1.6.0.

So here comes my newbee-questions:

Is it possible to download older versions of jar-files and use them in combination with new ones? Or can I extract certain java classes from old jar-files and use them i combination with the latest JRE?

I've just started using Eclipse btw.

Help and hints greatly appreciated

I've been using windows for many years and I think it would be great if it was possible to migrate over to Linux even though I still (because of my job) need to be able to deal with some MS-stuff like access-files.

Ps: I've seen something called Jackcess but apparently it can't utilize sql-statements (which is crucial for me).

Cheers
/Arie