Iam looking for a driver to access a database in Access I alredy have the code but This is not compiling:
I am getting an error saying that Unhandled Exception type ClassNotFoundException
and when I use the import sun.jdbc.odbc.JdbcOdbcDriver; says that the import sun.jdbc.odbc.JdbcOdbcDriver; is never used.
So I guess is that It cant find the driver! I am using eclipse and I tried to import the sun.jdbc.odbc.JdbcOdbcDriver but I cant find it. I know I have to import the jar files in the eclipse and tomcat and it is ok to do with SQL Server but no luck with MSaccess.
Also I know that it JDBC-ODBC driver comes with the jdk but where?? or which jar file I have to import??
Originally posted by campos teixeira: I am getting an error saying that Unhandled Exception type ClassNotFoundException
This is a basic Java compilation error. It doesn't mean that the class can't be found, it means that you aren't handling the exception properly.
A proper example would look something like:
Joined: May 23, 2004
thanks I did the catch for the exception and manage to connect to the database I think because I havent got a password for the database which is in MSAcess.
But Now I found out that MS Acess dont alow transactions because I tried to select a column from the java Apllication and nothing?
Anyone knows how?? Thanks
Joined: Jul 18, 2001
Sorry, you are out of luck here. MS Access is a desktop database which means it doesn't have the robust features like transactioning. For learning purposes this is absolutely fine. However, MS Access should never be used to back a production application that is meant to scale beyond a handful or users.