setting the classpath for derby

[ceyesuma]

I am having a problem with running my Derby embedded db. I have to set the path and I tried
the following commands. the first one is wrong and I would like to learn how to remove it.please.

the other ones do not seem to work . I have a properties sheet to load the driver. I am not sure
how it all links together. Any help would be apreciated. thanks;

classpath set command

Microsoft Windows [Version 6.0.6000]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\Users\Steve>set PATH=%DERBY_HOME%\bin;%PATH% %DERBY_HOME%\bin

C:\Users\Steve>set DERBY_HOME=C:\Users\Public\Downloads

C:\Users\Steve>set PATH=%DERBY_HOME%\C:\Users\Public\Downloads;%PATH% %DERBY_HOM
E%\C:\Users\Public\Downloads;

C:\Users\Steve>

error

properties in the project to load driver

*************************************************** -->
  <comment>DTD FOR Schoolofdb project</comment>
  <!--
  Derby Config
  ******************************************************************************************************** config-->
  <entry key="derbyDriver">org.apache.derby.jdbc.EmbeddedDriver</entry>
  <entry key="derbyURL">jdbc:derby:</entry>
  <!--

run:

java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
        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:307)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:169)
        at model.dao.ConnectDerbyDAO.loadDatabaseDriver(ConnectDerbyDAO.java:174)
        at model.dao.ConnectDerbyDAO.<init>(ConnectDerbyDAO.java:116)
        at model.dao.ConnectDerbyDAO.<init>(ConnectDerbyDAO.java:107)
        at model.dao.DerbyDAOFactory.buildDB(DerbyDAOFactory.java:57)
        at view.Main.main(Main.java:51)
Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:derby:schoolofdb
        at java.sql.DriverManager.getConnection(DriverManager.java:602)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at model.dao.ConnectDerbyDAO.createDatabase(ConnectDerbyDAO.java:192)
        at model.dao.ConnectDerbyDAO.<init>(ConnectDerbyDAO.java:119)
        at model.dao.ConnectDerbyDAO.<init>(ConnectDerbyDAO.java:107)
        at model.dao.DerbyDAOFactory.buildDB(DerbyDAOFactory.java:57)
        at view.Main.main(Main.java:51)
Java Result: 1
BUILD SUCCESSFUL (total time: 2 seconds)