CODEWITHSUNDEEP
javaderby
user1314834
user1314834

Reputation: 1

Java app with embedded DERBY DB

I am trying for a while to make executable JAVA application having embedded DB (derby DB), but facing some problems, and need your valuable help.

Namely, I am using Eclipse as environment. I export Java app to RUNNABLE JAR file, and it works fine on my desktop machine.

The idea is to make EXE doubleclick icon and send it to another machine which have no JAVA background/environment....so point is to send it to another user who will just get exe file, double click it and work with it.

The DB is not only readable, since application is inserting data in tables. So, it works fine on my machine, but when I send the same JAR file to another machine, I get error: "Schema TEST does not exist" I can see application but without any data, like there is no connection with DB. So, it is useless.

Even I use JSmooth, Install4j.... to convert JAR to exe file, I get the same error. So, first I have to make JAR file working on another machine.

Seems to me, I am doing something wrong with DB files.

Please let me know what info u need more from my side, and let me know how I can do this.

Upvotes: 0

Views: 2519

Answers (1)

Bryan Pendleton
Bryan Pendleton

Reputation: 16389

If the application intends to read AND WRITE data when it is running, then it can't be entirely contained in a JAR file, because you can't put an updatable Derby database in a JAR file. You'll need to have some "installation procedure", perhaps some logic that you run the first time your application is double-clicked by the user, that (a) finds a suitable location for the Derby database on the user's machine, (b) creates the database and defines all the tables, views, etc, (c) loads any initial data.

Then, on subsequent runs of the application, it will be able to re-open the database and continue using it.

Upvotes: 2

Related Questions