java - App with derby database - client access needs changing to embedded? -

i'm still rather new java , think i've started project problem.

i created job friend in there employees, shifts, sites , these needed loaded @ beginning.

i went looking solutions , decided use derby database. i've programmed application , works fine database. loads parameters , creates objects handling,

now need deploy project friends computer can use , think have database set wrong. think needed embedded? goes application.

so questions choices,

i read can change database 'embedded' 1 making database class? have no idea how , maybe because i'm new java, i'm finding write ups on subject difficult understand.

alternatively thought maybe can install derby separately , connect that?

or maybe can drop derby idea , switch entirely database entirely,

i'm bit confused on choices here, i've built application around installation of derby db using line connect it. jdbc:derby://localhost:1527/sg_database

if can give me 'plain english' options here appreciate it.

to reconfigure application use derby embedded database, have change jdbc connection url jdbc:derby:sg_database, , change classpath program references derby.jar rather derbyclient.jar. should possibly add ;create=true end of url that, first time friend runs application, database created on machine.

but yes, have other choices, , without knowing fair amount application it's hard give detailed guidance.

when friend using application, want , friend sharing same set of data? or application designed data , friend's data have nothing in common?

if want sharing data, yes important have single instance of database, , both of have share it, in case client-server configuration can work quite well.

if want 2 separate applications, nothing shared, , each of has own copy of data, embedded configuration can work quite well.

perhaps try embedded configuration, see how behaves application, , return here if have more specific question ask?