Creating database on client computer for java desktop application (swing)

Question

I'm creating a java desktop application using swing which requires some database persistance for which I'm planning to use Hibernate. I'm pretty new to desktop application development so I wanted to know if and how the database can be created on the client computer when installed.

Is there a script to be run or maybe a hibernate configuration which initiates database creation?

A sample tutorial or example illustrating this will be ideal (although I was not able to find one).

Thanks in advance for any help provided.

you can create database table using hibernate please follow link before that you need to install my sql database — eatSleepCode
– eatSleepCode, Commented Dec 31, 2013 at 6:22
correct, but this requires the manual database connection to be made in mysql. I'm looking at a way in which maybe the database can be exported with the java application or create a new database after installation. My objective is to keep the database creation concealed from the user but be able to use it from the application. Thanks for the swift response though! — Radium
– Radium, Commented Dec 31, 2013 at 6:32
You could take a look at some of the stand Aline databases like H2 or HSQL — MadProgrammer
– MadProgrammer, Commented Dec 31, 2013 at 7:05

Serdar · Accepted Answer · 2013-12-31 08:51:09Z

2

Hibernate is not an database server itself, it is a object-relational mapping framework so you need a either embedded or stanalone database server. Java DB that comes with the JDK will be sufficent for desktop applications.

answered Dec 31, 2013 at 8:51

Serdar

3831 silver badge10 bronze badges

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

Comments

takrishna · Accepted Answer · 2013-12-31 08:43:34Z

0

http://hamidseta.blogspot.in/2008/05/install-mysql-server-50-silently.html

In your package installer scripts perform the steps of silent MySql installation. In the BAT file put the code you find in the above link before triggering your Java application installer.

As per free licensing terms, one should not package MySql bundle for free, just check about the licensing if you bother.

answered Dec 31, 2013 at 8:43

takrishna

5,0273 gold badges22 silver badges36 bronze badges

Comments

Sorter · Accepted Answer · 2013-12-31 09:15:22Z

0

I think it would be better if you can start with javaDB or SQLite. They are perferred embedded database technologies for desktop java applications. You can download the jar for sqlite-jdbc from here.

Take a look at few tutorials on JDBC

If you making swing applications, make sure you learn to use swing worker well. It will be important to perform background processing.

answered Dec 31, 2013 at 9:15

Sorter

10.3k6 gold badges72 silver badges75 bronze badges

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

Hibernate is Framework used as middle layer in project which interact between database and Business layer logic. Hibernate features

J2EE integration
Object/Relational mapping
Automatic primary key generation
Object-oriented query language

So my suggestion is to go with MySQL because

Handles large databases. We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 60,000 tables and about 5,000,000,000 rows.
A very fast thread-based memory allocation system.
Very fast joins using an optimized one-sweep multi-join.
The server can provide error messages to clients in many languages.

This is only few features but you go to official site for more detail. And most important it's open source.

And the post help to install and configure on client system.

Collectives™ on Stack Overflow

Creating database on client computer for java desktop application (swing)

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related