database in desktop application using swing

Question

I am making a desktop application in java and using MSAccess in data base. I want that if i run the setup of the application the database should be created on client machine because there can be different client using the application and how can i create the setup? is there any tools available for this free of cost? please explain me in detail.. thanks

Answer 1

Java 6 (enhanced for desktop application work) comes with a built-in database called JavaDb (formerly IBM's Derby). That will do what you want.

Here's a set of guides and tutorials on how to use it.

I would suggest that when your application first starts, it checks for the presence of the created database, and if it doesn't exist, it builds the database (via the appropriate SQL). I've used this approach before and it works quite well.

Answer 2

I prefer nullsoft. Take a look at Open Source Installers Generators in Java

@pratap: database should be created on client machine..

Add an empty access database to your setup.