@NamedQuery(name = "Abonent.findByFIO", query = "select a from Abonent a where  a.firstName like '%:x%'")

    public List<Abonent> getAbonentFindByFIO(String x) {
        return em.createNamedQuery("Abonent.findByFIO", Abonent.class).setParameter("x", x).getResultList();

    }

        List<Abonent> a = sel.getAbonentFindByFIO("ov");
        for (Abonent ab : a) {
            System.out.println(ab.getLastName() + " " + ab.getFirstName() + " " + ab.getSurName());
        }

javax.ejb.EJBException: EJB Exception: : java.lang.IllegalArgumentException: You have attempted to set a 
parameter value using a name of x that does not exist in the query string 
select a from Abonent a where  a.firstName like '%#x%'.

select * from ABONENT where FIRST_NAME || LAST_NAME  like '%ulla%' 
or FIRST_NAME || LAST_NAME  like '%ur%' 

SELECT a from Abonent a INNER JOIN FETCH Kabinet k ON k.idKabinet = a.kabinet.idKabinet INNER JOIN FETCH Otdel o ON o.idOtdel = k.otdel.idOtdel INNER JOIN FETCH Telefon t ON t.idTelefon = a.telefon1.idTelefon WHERE LOWER(CONCAT(a.firstName,' ', a.lastName, ' ', a.surName, ' ' , o.otdelName, ' ', t.nomerTelefon)) LIKE :q and LOWER(CONCAT(a.firstName,' ', a.lastName, ' ', a.surName, ' ' , o.otdelName, ' ', t.nomerTelefon)) LIKE :w and LOWER(CONCAT(a.firstName,' ', a.lastName, ' ', a.surName, ' ' , o.otdelName, ' ', t.nomerTelefon)) LIKE :e and LOWER(CONCAT(a.firstName,' ', a.lastName, ' ', a.surName, ' ' , o.otdelName, ' ', t.nomerTelefon)) LIKE :r and LOWER(CONCAT(a.firstName,' ', a.lastName, ' ', a.surName, ' ' , o.otdelName, ' ', t.nomerTelefon)) LIKE :t

SELECT * FROM ABONENT 
INNER JOIN KABINET ON KABINET.ID_KABINET = ABONENT.ID_KABINET INNER JOIN OTDEL 
ON OTDEL.ID_OTDEL = KABINET.ID_OTDEL INNER JOIN TELEFON ON TELEFON.ID_TELEFON = ABONENT.ID_TELEFON 
where lower(ABONENT.FIRST_NAME || ' ' || ABONENT.LAST_NAME || ' ' || ABONENT.SUR_NAME || ' ' || OTDEL.OTDEL_NAME || ' ' || TELEFON.NOMER_TELEFON) like ?
and lower(ABONENT.FIRST_NAME || ' ' || ABONENT.LAST_NAME || ' ' || ABONENT.SUR_NAME || ' ' || OTDEL.OTDEL_NAME || ' ' || TELEFON.NOMER_TELEFON) like ?
and lower(ABONENT.FIRST_NAME || ' ' || ABONENT.LAST_NAME || ' ' || ABONENT.SUR_NAME || ' ' || OTDEL.OTDEL_NAME || ' ' || TELEFON.NOMER_TELEFON) like ?
and lower(ABONENT.FIRST_NAME || ' ' || ABONENT.LAST_NAME || ' ' || ABONENT.SUR_NAME || ' ' || OTDEL.OTDEL_NAME || ' ' || TELEFON.NOMER_TELEFON) like ?
and lower(ABONENT.FIRST_NAME || ' ' || ABONENT.LAST_NAME || ' ' || ABONENT.SUR_NAME || ' ' || OTDEL.OTDEL_NAME || ' ' || TELEFON.NOMER_TELEFON) like ?

SELECT a from Abonent a INNER JOIN FETCH Kabinet k ON k.idKabinet = a.kabinet.idKabinet 
INNER JOIN FETCH Otdel o ON o.idOtdel = k.otdel.idOtdel 
INNER JOIN FETCH Telefon t ON t.idTelefon = a.telefon1.idTelefon WHERE 
LOWER(CONCAT(a.firstName,' ', a.lastName, ' ', a.surName, ' ' , o.otdelName, ' ', t.nomerTelefon)) LIKE :q and 
LOWER(CONCAT(a.firstName,' ', a.lastName, ' ', a.surName, ' ' , o.otdelName, ' ', t.nomerTelefon)) LIKE :w and 
LOWER(CONCAT(a.firstName,' ', a.lastName, ' ', a.surName, ' ' , o.otdelName, ' ', t.nomerTelefon)) LIKE :e and 
LOWER(CONCAT(a.firstName,' ', a.lastName, ' ', a.surName, ' ' , o.otdelName, ' ', t.nomerTelefon)) LIKE :r and 
LOWER(CONCAT(a.firstName,' ', a.lastName, ' ', a.surName, ' ' , o.otdelName, ' ', t.nomerTelefon)) LIKE :t