0

I want to create a small java application which allows to connect to a database and exchange information. It should be possible to start the DB via Java, so I don't need anything but my application to work with the DB. (Not like XAMPP where I need the XAMPP menu to start the DB server for example)

What DB should I use for such a project?

Dyrdek
  • 401
  • 3
  • 11
  • 31

3 Answers3

2

The JDK comes bundled with Java DB which is a fully functional RDBMS that is suited for small scale apps and small scale databases.

Sharon Ben Asher
  • 13,127
  • 5
  • 31
  • 44
  • http://stackoverflow.com/questions/9725376/how-can-i-start-apache-derby-programmatically-jar-file – Sharon Ben Asher Oct 21 '15 at 12:53
  • Java DB unfortunately looks not quite comfortable for me. I created a database via ij. But the administration in java code, like create table, cofuses me. I'm looking for a good tutorial but didn't find one yet :/ – Dyrdek Oct 21 '15 at 14:13
  • http://docs.oracle.com/javadb/10.8.3.0/getstart/index.html take a look at "Activity 3: Run a JDBC program using the embedded driver" and "The WwdEmbedded program" – Sharon Ben Asher Oct 22 '15 at 06:16
  • Java DB SQL reference http://db.apache.org/derby/docs/10.11/ref/index.html – Sharon Ben Asher Oct 22 '15 at 06:22
1

Why dont you try H2 DB, its pretty light weight and suited for small applications. If you want to move the same application at a later stage to any RDBMS, you can take mysql.

Saurabh Jhunjhunwala
  • 2,706
  • 2
  • 26
  • 54
0

If you just want to experiment with your small application use Java DB (Previously known as Derby). If you are using JDK 7 then it comes bundled with the JDK. For older versions of JDK you have to download the Derby database from https://db.apache.org/derby/derby_downloads.html

kkishere
  • 154
  • 2
  • 13