Java application with embedded Derby database

Question

I created a java swing application with apache derby database. I want to know how can i do the following things.

The first time the application is double-clicked by a user, that finds a suitable location for the Derby database on the user's machine, creates the database and defines all the tables, views, etc and loads any initial data. Then, on subsequent runs of the application, it will be able to re-open the database and continue using it.

You can use "user.home" from System.getProperty to find the users home directory. You can use this as a base for your path (I'd append the application name to this). The database is stored in a directory with the same name as the database. If this directory exists (and constrains file), the database should exit. Another solution might be to create a connection to the database in the normal way and then check for the existence of one or more tables — MadProgrammer
– MadProgrammer, Commented Sep 15, 2014 at 22:14
You might want to have a look into liquibase and use it programatically for setting up and populating the database. — Markus W Mahlberg
– Markus W Mahlberg, Commented Sep 15, 2014 at 22:19

MadProgrammer · Accepted Answer · 2014-09-16 00:06:56Z

3

You could use the user.home property from System.getProperty which will return you the user's home directory as the main path for the database. On Windows, I would recommend using {user.home}\AppData\Remote\{You application name} as a base path
Derby creates a directory of the same name as the database, you could check for the existence of this directory. The problem with this is there is no guarantee that it contains a valid database.
You could create a normal connection to the database and check for the existence of existing tables and build them as required. This ensures that if, for some reason, not all the tables where created, you can recover at that point.

answered Sep 16, 2014 at 0:06

MadProgrammer

348k22 gold badges243 silver badges379 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohammad Badiuzzaman · Accepted Answer · 2018-01-18 19:59:47Z

0

Following shall start derby database service on default port (1527) on localhost

    NetworkServerControl obj= new NetworkServerControl();
    obj.start(null);

Use dburl with 'create=true', i.e.

    jdbc:derby://localhost:1527/macdb;create=true

Above shall make db dir (macdb), same name as service name on current dir.

answered Jan 18, 2018 at 19:59

Mohammad Badiuzzaman

7489 silver badges9 bronze badges

Collectives™ on Stack Overflow

Java application with embedded Derby database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related