Ask Questions and Find Answers

Hi,

I followed this and got a weird error, i din't found it anywhere before :

2019-03-15 08:52:20.145 ERROR [http-nio-8080-exec-8][JSONWebServiceServiceAction:116] Found interface com.liferay.portal.dao.orm.custom.sql.CustomSQL, but class was expected

I tried all i found about CustomSQL on the net, when i replace CustomSQL with CustomSQLUtil i have an error returning : 
​​​​​​​

2019-03-15 08:50:31.324 ERROR [http-nio-8080-exec-4][JSONWebServiceServiceAction:116] com/liferay/portal/dao/orm/custom/sql/CustomSQLUtil

I realy don't know what to do, the package is in my dependencies' folder, i can open the CustomSQL* classes but i can't use any of their methods

Help ! 

here is the part of my code wich don't work : 

    public static final String FIND_BY_ROLES_ID_AND_PORTLET_ID_AND_ENTITY =
            PermissionFinder.class.getName() +
                ".findByRolesIdAndPortletIdAndEntity";

    @ServiceReference(type=CustomSQL.class)
    private CustomSQL _customSQL;
    
    public List<Permission> findByRolesIdAndPortletIdAndEntity(long[] roleIds, String portletId, String entity){
        Session session = null;
        try {
            session = openSession();
            
            //System.out.println(CustomSQLUtil.class);
            String sql = _customSQL.get(getClass(), FIND_BY_ROLES_ID_AND_PORTLET_ID_AND_ENTITY);
            System.out.println("La Requete : "+sql);
            SQLQuery q = session.createSQLQuery(sql);
            q.setCacheable(false);
            q.addEntity("agiirpermission", PermissionImpl.class);
            System.out.println("La SQL Query : "+q);
            QueryPos qPos = QueryPos.getInstance(q);
            qPos.add(roleIds);
            qPos.add(portletId);
            qPos.add(entity);
            return (List<Permission>) QueryUtil.list(q, getDialect(), 0, 0);
        }
        catch (Exception e) {
            try {
                throw new SystemException(e);
            }
            catch (SystemException se) {
                se.printStackTrace();
            }
        }
        finally {
            closeSession(session);
        }
        return new ArrayList<Permission>();
    }