I have been playing around with Java lately, and now, I want to play around with the databases side of things. I am starting with Derby, and now, I am trying to create a database using the command prompt.
I did go Computer > System Properties > Advanced System Settings > Environment Variables. Here I created a new System Variable named CLASSPATH and assigned the location of the derbytools.jar file. (C:\Program Files\Java\jdk1.8.0_25\db\lib\derbytools.jar). After that, I restarted the computer, ran command prompt, and tried creating the database - it worked up until I entered a connect string statement:

It gives me a cannot find driver error. I have tried going to the CLASSPATH and adding filepaths to the derby.jar file, derbytools.jar file, derbynet.jar file, and the derbyclient.jar file (separating each file path with a semicolon).
Is there another way of going about using Derby via command prompt?
Thanks.
I did go Computer > System Properties > Advanced System Settings > Environment Variables. Here I created a new System Variable named CLASSPATH and assigned the location of the derbytools.jar file. (C:\Program Files\Java\jdk1.8.0_25\db\lib\derbytools.jar). After that, I restarted the computer, ran command prompt, and tried creating the database - it worked up until I entered a connect string statement:

It gives me a cannot find driver error. I have tried going to the CLASSPATH and adding filepaths to the derby.jar file, derbytools.jar file, derbynet.jar file, and the derbyclient.jar file (separating each file path with a semicolon).
Is there another way of going about using Derby via command prompt?
Thanks.