2

I am new to Java-based databases. I want to start with Java DB as it comes as a part of JDK. I cannot find enough resources to understand: is Java DB and Apache Derby the same thing? If yes, which one is easier to use from Eclipse? Is it solely command line based database system?

I tried to follow the official Getting Started guide for Java DB which says

The Java DB product includes Derby without any modification whatsoever to the underlying source code.

but I cannot figure out the best way to use it.

Limbo Exile
  • 1,321
  • 2
  • 21
  • 41

2 Answers2

6

JavaDB is the the oracle supported version of Apache Derby (some kind of fork), technically the same exact functionality (same documentation).

which one is easier to use from Eclipse?

So there is no difference from the Eclipse part.

Otherwise, think of H2 as the best alternative of Derby (JavaDB), fairly faster and simple to use, FlyWay will be a good complement as database migration tool (and a good practice).

mikera
  • 105,238
  • 25
  • 256
  • 415
Salah Eddine Taouririt
  • 24,925
  • 20
  • 60
  • 96
  • I considered H2 but from what I read it has minor stability issues. Anyway, is it all command line administration for pure Java databases? Nothing more user-friendly? – Limbo Exile Apr 04 '13 at 23:42
2

As a tool to use with Derby, try Squirrel: http://squirrel-sql.sourceforge.net/

It's a great tool, and it works very well with Derby.

Bryan Pendleton
  • 16,128
  • 3
  • 32
  • 56