ClassNotFoundException while loading the JDBC driver for HSQLDB

[Pavan Kumar Dittakavi]

hi All,

I have downloaded the HSQLDB and have created a sample table in it. I have been following the link for the same. Im unable to load the driver using the Class.forName method. It basically complains of the following message. Im relatively new to JDBC please suggest what I might be missing here.

F:\hsqldb-2.2.6\hsqldb-2.2.6\hsqldb>java MainClass
java.lang.ClassNotFoundException: org.hsqldb.jdbc.JDBCDriver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:169)
        at MainClass.main(MainClass.java:12)

Thanks,
Pavan.

[Paul Clapham]

You missed setting your classpath. In particular it has to include the jar which contains the JDBC driver.

[Pavan Kumar Dittakavi]

Hi Paul,

I have already set the class path to the directory that contains the jar file you mentioned. It still is throwing me this error. Am I missing something here.

Thanks.,
Pavan.

[Rob Spoor]

Don't include the folder with the JAR file to your class path, add the JAR file itself.