sql - Derby classpath cant connect to databse -

sql - Derby classpath cant connect to databse -

i installed derby , followed instructions here exact same way told me replacing paths paths. reason why seek create connection connect create database , run sql scripts create tables , populate them gives me few errors firstly 1

error 08001: no suitable driver found jdbc:derby:supermarket;create=true

then when sql scripts run error

ij error: unable found connection

i dont see did wrong line used set class path

c:\> set classpath=%derby_install%\lib\derby.jar;%derby_install%\lib\derbytools.jar;.

i included derby.jar file needed cant see problem know did wrong? when run

connect 'jdbc:derby://localhost:1527/mydb';

the server starts fine

c:\derbs\db-derby-10.10.2.0-bin\bin>startnetworkserver thu jun 26 11:56:38 pdt 2014 : security manager installed using basic server security policy. thu jun 26 11:56:39 pdt 2014 : apache derby network server - 10.10.2.0 - (158244 6) started , ready take connections on port 1527

there many troubles when start using derbydb. painful practice.

1. for example, download derby http://db.apache.org/derby/derby_downloads.html#latest+official+releases

2. unzip c:\tools\db-derby-10.11.1.1-bin.

3. press windows key + r, type: systempropertiesadvanced, set environment variables. reference: https://db.apache.org/derby/docs/10.0/manuals/getstart/gspr16.html

4. run cmd, should run additional command:

c:\tools\db-derby-10.11.1.1-bin\bin\networkservercontrol.bat

and type:

c:\tools\db-derby-10.11.1.1-bin\bin\ij.bat

then press enter, , result:

5. set in-memory derby database d:\ directory. folder vy1 must doesn't exit. type command creating new database named vy1:

connect 'jdbc:derby:d:\vy1;create=true';

use windows explorer, go directory d:\vy1, see new folder named vy1 created.

then type command:

connect 'd:\vy1'

6. see sql command create database, table, insert, read database this:

(open images in new web page improve view. note: old screenshot when utilize older version few months ago).

come question, focus @ section 3, , commnand phone call networkservercontrol.bat @ section 4.

good luck! :)

sql database jdbc derby