CODEWITHSUNDEEP
javaneo4jcypher
Vartika
Vartika

Reputation: 1095

CYPHER QUERY :-Change Arrayreturned by collect(n.name) in cypher query to Arraylist (util)

Neo4j cypher query collect() return Array in result. In order to iterate it we need it to add in arrayList. The previous process we used is not helping us and throwing an exception.

PREVIOUS CODE:-

public  String GettingCurrentDate() {

    Connection connect = null;
    String query=null;
    try {
        connect = graphdbConnect();
        Statement stmt = connect.createStatement();

                query="match(n:learner) "
                        + " return collect(n.name) as ids";
                System.out.println(query);

                ResultSet rs = stmt.executeQuery(query.toLowerCase());

                while(rs.next()){

                    Array idsList=rs.getArray("ids");

                        System.out.println("idsList :: "+idsList);

                        ArrayList<String> userIds = new ArrayList<>();

                        String[] userIdsArray = (String[])rs.getArray("ids").getArray();

                        for(String id : userIdsArray) {
                            userIds.add(id);
                            System.out.println(userIds+"------userId");
                        }
                }
    }
    catch(Exception e) {
        e.printStackTrace();
    } finally {
        if(connect!=null) {
            try {
                connect.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
    return "sucess";
}

This code is getting exception java.sql.SQLFeatureNotSupportedException: get array

Question:- HOW WILL WE GET THE DATA FROM COLLECT() function and iterate it

Upvotes: 0

Views: 139

Answers (2)

Vartika
Vartika

Reputation: 1095

Cast Object to ArrayList

                    Object idsList=rs.getObject("ids");
                    System.out.println("idsList :: "+idsList);
                    ArrayList<String> userIds = (ArrayList<String>) idsList;
                    System.out.println("List2 Value: "+userIds);

Upvotes: 0

InverseFalcon
InverseFalcon

Reputation: 30397

Have you checked to see the actual object returned by 

resultSet.getObject("ids")

If it's like user defined procedures, collections in Cypher get returned as ArrayLists, so try casting the returned object to an ArrayList and see if that works for you.

Upvotes: 1

Related Questions