Thread: Installing Java program with database on another computer.

Hey guys

I'm currently developing a gym membership system for my aunt. I'm using Java and mySQL as the database. I'm getting fairly close to finishing it all I need to do is add a few analytical abilities to it and get it to interact with a barcode scanner(that could be very tricky).

But one thing I'm wondering now is how will I set up the database on their computer? Will I have to actually download mySQL and set up the tables etc? I've only done brief searches and what I've come across a few suggestions such as using IzPack or HSQLDB but I'm not really too sure about these (anyone used them?).

I was hoping anyone who has had experience in doing something similar could point me in the right direction.

Regards
Faz

Hello Faz,

Yes, either you'd have to download MySQL and install it on the machine you want to run it on or you could of course use a Java database like H2 Database which you can embed in your application but that will of course make it difficult later on if you want to have multiple applications talking to one database.

Regarding setting up tables etc, this depends on what frameworks etc you might be using to talk to the database but in most cases I'd say yes, you need to somehow create a schema and its tables on the database your self.

For more information on the H2 Database have a look at Tutorial

// Json

Apache Derby is another alternative, and is supported by oracle (see Java DB). I've used it in distributed applications and it works great - just distribute a single jar with your app and you are good to go. MySQL has its own syntax for certain things (InnoDB, autoincrement, etc..) so there will be small porting needed, at least if you use Derby.

Hey Guys

Cheers for the info I will check them out.