SQLite is used in many applications, and even is the default choice when it comes to Android apps (which are written in Java) – so I'd say, by the specifications given, it will be a good choice for your project. The German library's database file just passed the 10 MB limit, and I see no drop in performance or the like. my eBook server uses it), working with different sizes. I'm using SQLite in several of my web apps (e.g. is an embedded DB so that it can easily package along with application: Yes, again that's what Android apps do.

is easily portable along with a Java application like Excel, MS Access: I don't understand that comparision – but yes, it's available cross-platform, and you can simply share the database file to access its data with other apps.can easily install along with application: Definitely.The same for web apps or mobile applications. can be used for standalone desktop application: Yes.This answer makes the assumption that 'medium scale' refers to a few Megabytes at max (as the question gave no further details)

Portable apps java