Bob, Perhaps you discussed this in an earlier thread, if so, ignore... But the PATH env variable does not need the jars, instead, you need to add the jars to a new variable, CLASSPATH. Or you can start your java command with something like java -cp "[path to\]derburun.jar youMainClass.
(With derbyrun.jar in the CLASSPATH, java will find the other derby jars if they live in the same place on your computer). Hth Myrna Sent from my iPhone On Sep 27, 2013, at 5:43 AM, Rick Hillegas <[email protected]> wrote: > Hi Bob, > > What happens if the connection url is the following: > > jdbc:derby:memory:db;create=true > > Thanks, > -Rick > > > On 9/26/13 10:17 PM, Bob M wrote: >> Hi Rick and others >> >> Have moved on slightly but still cannot get the Derby example java program >> to fire............ >> >> The messages I get are as follows:- >> >> 2013-09-27 03:48:15 DerbyApp finished >> 2013-09-27 03:48:15 Message: No suitable driver found for >> jdbc:derby:C:/Databases/test_dBase;create=true >> 2013-09-27 03:48:15 Error Code: 0 >> 2013-09-27 03:48:15 SQL State: 08001 >> 2013-09-27 03:48:15 ----- SQLException ----- >> 2013-09-27 03:48:15 Please check your CLASSPATH. >> 2013-09-27 03:48:15 Unable to load the JDBC driver >> org.apache.derby.jdbc.EmbeddedDriver >> 2013-09-27 03:48:15 DerbyApp starting in embedded mode >> >> Windows 7 operating system >> PATH variable includes the following................ >> C:\Apache\db-derby-10.10.1.1-bin\lib\derby.jar >> C:\Apache\db-derby-10.10.1.1-bin\lib\derbytools.jar >> C:\Apache\db-derby-10.10.1.1-bin\lib\derbyclient.jar >> >> Help !!! >> >> >> >> >> -- >> View this message in context: >> http://apache-database.10148.n7.nabble.com/beginner-s-question-tp134127p134232.html >> Sent from the Apache Derby Users mailing list archive at Nabble.com. >
