public class SQLServiceImpl extends RemoteServiceServlet implements SQLService {
    private final static String user = "n";
    private final static String password = хххх";
    private final static String httpURI = "http://хххххххх";
    private final static String iiopURI = "iiop://хххххх";
    private final static String objectStoreName= "OS1";
    @Override
    public List<String> getQuery(String sqlQuery) {
        String url = iiopURI;
        return search(user,password, url, objectStoreName, sqlQuery);
    }

    private static List<String> search(String user,String password, String url, String objectStoreName, String sqlQuery) {
        String port = url.substring(0,4);
        Connection connection;
        if (port.equalsIgnoreCase("iiop")
        {
              connection = Factory.Connection.getConnection(url);
//            Subject subject = UserContext.createSubject(connection, user, password, stanza);
//            com.filenet.api.util.UserContext uc = com.filenet.api.util.UserContext.get();
//            uc.pushSubject(subject);
        }
        else
        {
            connection = Factory.Connection.getConnection(url);
            com.filenet.api.util.UserContext uc = com.filenet.api.util.UserContext.get();
            uc.pushSubject(com.filenet.api.util.UserContext.createSubject(connection, user, password, null));
        }
        Domain domain = Factory.Domain.getInstance(connection, null);

        try {
            ObjectStore objectStore = Factory.ObjectStore.getInstance(domain, objectStoreName);
           // String sql = "Select * from Document";
            SearchSQL sqlObject = new SearchSQL(sqlQuery);
            SearchScope searchScope = new SearchScope(objectStore);
            IndependentObjectSet independentObjectSet = searchScope.fetchObjects(sqlObject, null, null, true);
            Iterator iterator = independentObjectSet.iterator();
            List<String> objectsNames = new LinkedList<String>();
            while (iterator.hasNext()) {

                objectsNames.add(iterator.next().toString());
            }
            return objectsNames;
           } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
        return null;