Method updatePassword

src/main/java/dbProcs/Setter.java:626–650

@param ApplicationRoot The current running context of the application @param userName User name of the user @param currentPassword User's current password @param newPassword New password to use in update @return ResultSet that contains error details if not successful

(String ApplicationRoot, String userName, String currentPassword, String newPassword)

	 * @return ResultSet that contains error details if not successful
	 */
	public static boolean updatePassword (String ApplicationRoot, String userName, String currentPassword, String newPassword)
	{
		log.debug("*** Setter.updatePassword ***");
		
		boolean result = false;
		Connection conn = Database.getCoreConnection(ApplicationRoot);
		try
		{
			log.debug("Preparing userPasswordChange call");
			CallableStatement callstmnt = conn.prepareCall("call userPasswordChange(?, ?, ?)");
			callstmnt.setString(1, userName);
			callstmnt.setString(2, currentPassword);
			callstmnt.setString(3, newPassword);
			log.debug("Executing userPasswordChange");
			callstmnt.execute();
			result = true;
		}
		catch(SQLException e)
		{
			log.error("updatePassword Failure: " + e.toString());
		}
		Database.closeConnection(conn);
		log.debug("*** END updatePassword ***");
		return result;
	}
	
	/**
	 * Updates a player's password without needing the current password