File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes NoClassDefFoundError re JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "NoClassDefFoundError re JDBC " Watch "NoClassDefFoundError re JDBC " New topic

NoClassDefFoundError re JDBC

Frances Fang

Joined: Dec 01, 2000
Posts: 17
I am learning JDBC from the book "Core Java2 Volumn II".
I installed the PointBase Mobile Edition database under the directory which I already put in CLASSPATH,the Java program and its properties file are in the same subdirectory and that subdirectory is under the same directory as the database's.
The compile is fine. But there is always a runtime exception stating that NoClassDefFoundError:filename. How to solve this problem?I am totally lost.Please help!
Thank you!
Frances Fang

Joined: Dec 01, 2000
Posts: 17
Forget about the title of this question. I have more detailed info about it. I debugged and found out where the problem is but I don't know why.
The code caused the problem is as follows, this is a method which will be called in main(),the main() handled exceptions:-
public static Connection getConnection()
throws SQLException, IOException
{ Properties props = new Properties();
String fileName = "";
FileInputStream in = new FileInputStream(fileName);
String drivers = props.getProperty("jdbc.drivers");
if (drivers != null)
System.setProperty("jdbc.drivers", drivers);
String url = props.getProperty("jdbc.url");
String username = props.getProperty("jdbc.username");
String password = props.getProperty("jdbc.password");
DriverManager.getConnection(url, username, password);

The SQLException was thrown by DriverManager.getConnection(url,username,password),the error messages are as follows:-
the SQLState is :08001;
the error message is :no suitable driver
the vendor-specific info is: 0
In the corresponding proprieties file,it is:--
jdbc.url=jdbc ointbase:corejava
I put the directory AA in classpath via
The pointbase is in c:\AA,the program and its properties file are in c:\AA\B\C. Is this a problem or am I missing something here? Please help!

I agree. Here's the link:
subject: NoClassDefFoundError re JDBC
It's not a secret anymore!