I'm trying to connect to an Access database (which resides on my hard-drive as a *.mdb file.) I'm doing Java work on a Fedora Core 5 box in eclipse. I keep getting an error saying the below:
Exception in thread "main" java.lang.ClassNotFoundException: sun.jdb.odbc.JdbcOdbcDriver not found in gnu.gcj.runtime.SystemClassLoader{urls=[file:/lhome/******/workspace/testAccessDBRead/], parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}
at java.net.URLClassLoader.findClass (libgcj.so.7)
at java.lang.ClassLoader.loadClass (libgcj.so.7)
at java.lang.ClassLoader.loadClass (libgcj.so.7)
at java.lang.Class.forName (libgcj.so.7)
at java.lang.Class.forName (libgcj.so.7)
at testAccessDBRead.main (testAccessDBRead.java:12)
This is my code.
import java.sql.*;

public class testAccessDBRead
{
public static void main(String[] args) throws Exception
{
final String DRIVER_NAME = "sun.jdbc.odbc.JdbcOdbcDriver";
final String dbURL = "jdbc:odbc:testDB";

Class.forName(DRIVER_NAME);

Connection connection = null;
Statement statement = null;
ResultSet resultSet = null

try
{
connection = DriverManager.getConnection(dbURL);
statement = connection.createStatement();
resultSet = statement.executeQuery("SELECT * FROM NameTable");

while(resultSet.next())
{
System.out.println(resultSet.getString(1));
}
}
catch(Exception e)
{
System.out.println("Error in main:");
System.out.println(e.getMessage());
}
finally
{
try
{
resultSet.close();
statement.close();
connection.close();
}
catch(Throwable ignore)
{
}
}
}
}
I got the code from the below thread and thought of trying it out in order to make it work for me.

http://www.dev-archive.com/forum/showthread.php?t=382347&highlight=access+database

Anyone know what I'm doing wrong? I haven't touched Java for some time, soo...