HSQLDB makes it very simple to run a server from the command line java ... own SQL database is going to vastly increase the size of your application, but that's not so; HSQLDB's jar file clocks ...

Apache Phoenix is a relatively new open source Java ... run a few queries on it. It is interesting (and somewhat ironic) that NoSQL data stores are categorized by a feature that they lack, namely SQL.