Added res-sharing-scope entry... Setting as unshareable...
Change case of sql keywords to uppercase
Moved SQL statements constants to methods where they're used
Moved @Context HttpServletRequest into AbstractWebService class