can't load the driver (hsqldb)

[tomiu]

hi,

i have a strange problem..this code worked well until today..i haven't changed anything so i dont know why doesn't work anymore...

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

public class TestDemobase {
    static String database = "/bsp/database";
    static String sql = "SELECT * FROM Bookmarks";
	static String sql1 = "SELECT url FROM Bookmarks";
	static String sql2 = "INSERT INTO Bookmarks VALUES('Pythoni', 'www.pythoni.com');CHECKPOINT";
    static Connection connection;

    public static void main(String[] args) throws Exception {
	System.out.println("TestDemobase 1\n");	
	

	Class.forName("org.hsqldb.jdbcDriver");

	 
	connection = DriverManager.getConnection("jdbc:hsqldb:" + database, "sa", "");

	    Statement statement = null;
        ResultSet resultSet = null;

        statement = connection.createStatement();
        resultSet = statement.executeQuery(sql);

	while (resultSet.next()) {
	    System.out.println(resultSet.getString("title") + " (" +
			       resultSet.getString("url") + ")");
	    
	}
	
	System.out.println("\nTestDemobase 2\n");
	resultSet = statement.executeQuery(sql1);

	while (resultSet.next()) {
	    System.out.println(" (" +resultSet.getString("url") + ")");
	    
	}
	
	System.out.println("\nTestDemobase 3\n");
	resultSet = statement.executeQuery(sql2);
	//statement.executeUpdate("INSERT INTO Bookmarks " + "VALUES('Pythoni', 'www.pythoni.com')");


	System.out.println("TestDemobase 1\n");	
	resultSet = statement.executeQuery(sql);

	while (resultSet.next()) {
	    System.out.println(resultSet.getString("title") + " (" +
			       resultSet.getString("url") + ")");
	    
	}
	resultSet.close();
	statement.close();
	connection.close();
    }
}

and the error message:

TestDemobase 1

Exception in thread "main" java.lang.ClassNotFoundException: org.hsqldb.jdbcDriver
	at java.net.URLClassLoader$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClassInternal(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at TestDemobase.main(TestDemobase.java:17)

thx in advance for ur help
tomiou

[OrangeDog]

Well something must have changed. The classloader can't find the driver classes any more.

[tomiu]

but i didn't change anything...i just dont know why the code worked before and doesn't work anymore...the code compiles fine with no error, but when i run it the classloader can't find the driver...

[OrangeDog]

Then the driver files got moved or you changed your classpath or execution method. Things don't magically become broken for no reason.

[CJSLMAN]

Things don't magically become broken for no reason.

Yes, they do. That's why Gremlins were invented... they do this kind of stuff all the time and sometimes they even buddy up with Murphy to make things worse.:)

CJSL

[OrangeDog]

Whether it was you or the Gremlins that changed something, something still got changed.

[tomiu]

Whether it was you or the Gremlins that changed something, something still got changed.

i still can't find what got changed...all i did was: SHUT DOWN the PC and the next day showed this error...i didn'T install new software, i didn't deinstalled anything...i checked hsqdlb.jar is in my classpath, so no change there too...
i'll post this problem in other forums and if i find the solution i'll post it here too

[venkatallu]

i think ur driver class(hsql.jar file) has chaged its place.if s, u have to make changes in ur classpath..that is the main problem .