database - Embedded Java DB in Netbeans -

database - Embedded Java DB in Netbeans -

i have finished project developing simple image catalogue application using java , netbeans.

i have realised database not embedded when create jar file , seek run (external netbenas) error (error connecting localhost).

this code @ nowadays connects database. works fine when run in netbeans.

//conect database string host = "jdbc:derby://localhost:1527/catalogue"; con = drivermanager.getconnection(host);

my question (and can't seem find simple solution) there way create new embedded db same name , table , rows etc , adjust code when run jar file externally netbeans work ok?

i imagining code like:

string host = "jdbc:derby:'path db'/catalogue;

am on right track? have tried (i think) not seem work…

thanks assistance

<<<<<< update >>>>>>>

i have created embedded database , created table (named photos) same details original (non-embedded) database.

i have changed connection in code be:

string host = "jdbc:derby:catalogueembed;create=true";

now when run programme in netbeans says: "table/view photos not exist"

do need run , sql statement in code create table , row data?

thanks assistance

java database netbeans embedded-database