Added jpa (hibernate) to dependencies.
Added mysql connector.
Added database configuration.
Added a persistence xml, including the mysql dialect and the naming strategy.
Removed unneeded @Column for methods, fixed joinColumn name for role.
Removed static data, now fetching for DB.
Made userController not static.
Created the SOON TO BE BUILDER SoldierDataProvider.java