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.
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).