Class not found exception

[Bhavana Jain]

I am using Eclipse to write java program and I want to connect to java and open office and I have follwed all the steps correctly i.e, setting the classpath
But still I get the error
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Unhandled exception type ClassNotFoundException

[pbrockway2]

Unresolved compilation problem:

Compile your code before you attempt to run it. In the case of Eclipse, compiler messages will be indicated with little squiggles in the code and the message itself will be indicated with an icon in the left hand margin of the code window. Post that message if you can't understand it, and the code to which it refers.

I have follwed all the steps correctly i.e, setting the classpath

Of course we don't don't know what these steps were... But one thing to bear in mind is that the Eclipse project must be set up correctly so that classes and other resources you reference can be found by both the compiler and the runtime. Setting a CLASSPATH environment variable won't do this. The "steps" must be appropriate to Eclipse.

[Bhavana Jain]

Mine code is


import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

public class DisplayAuthors {
static final String DATABASE_URL = "C:\\mydir\\Books";

public static void main(String[] args)
{
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;

try
{
Class.forName("org.hsqldb.jdbcDriver");
connection = DriverManager.getConnection("jdbc:hsqldb:file:" +DATABASE_URL, "sa", "");
statement = connection.createStatement();
resultSet = statement.executeQuery("SELECT AuthorID, FirstName, LastName FROM Authors");
ResultSetMetaData metaData = resultSet.getMetaData();
int numberOfColumns = metaData.getColumnCount();
System.out.println("Authors Table Of Books Database:\n");
for(int i=1; i<=numberOfColumns; i++)
{
System.out.printf("%-8s\t", metaData.getColumnName(i));
}
System.out.println();

while(resultSet.next())
{
for(int i=1; i<=numberOfColumns; i++)
{
System.out.printf("%-8s\t", resultSet.getObject(i));
}
System.out.println();
}
}
catch(SQLException sqlException)
{
sqlException.printStackTrace();
}
finally
{
try
{
resultSet.close();
statement.close();
connection.close();
}
catch(Exception exception)
{
exception.printStackTrace();
}
}
}
}


Here compiler is unable to load the class org.hsqldb.javaDriver

[pbrockway2]

compiler is unable to load the class org.hsqldb.javaDriver

I have never used hsqldb (so take what I suggest with a grain of salt) but I think this class is located in hsqldb.jar. You should have downloaded this jar archive at some point. Make sure this jar is included in Eclipse's project build path: ie go to Project->Properties->Java Build Path and in the Libraries tab click "Add External Jars..." and add hsqldb.jar from whereever you have it on your disk.

[DarrylBurke]

Mine code is

Forum Rules
Guide For New Members
BB Code List - Java Programming Forum

db

[Bhavana Jain]

go to Project->Properties->Java Build Path and in the Libraries tab click "Add External Jars..." and add hsqldb.jar from whereever you have it on your disk.[/QUOTE]


I have done it but still it is showing the same error please help me out

[Bhavana Jain]

Here the error lies in the code where I forgot to write the exception for classnotfound