Java EE (Java Enterprise Edition) General Discussion

Hello

I am working with EJB3 on JBoss 4.2.2 GA. In one of the SessionBeans there is a query (sql) which i am running using the createNativeQuery method of the EntityManager.

The query is supposed to return 20 Ids of an Entity. The query returns all 20 Ids. Now if i want to use paging (see only the last 10 records) through the setFirstResult and setMaxResults method of Query, i do this:

query = em.createNativeQuery(strQuery.toString());
query.setFirstResult(10);
query.setMaxResults(10);

then:

ArrayList ids = (ArrayList) query.getResultList();
         System.out.println("no of users found: "+ids.size());      

                if(ids  != null && !ids .isEmpty()){
                         for (Iterator it = ids.iterator(); it.hasNext();) {
                            BigDecimal userId= (BigDecimal)it.next();
                            System.out.println("userid: "+userId);
                        }
                }

In this case the query finds 10 records as the ids.size method gives 10 but then in the loop it gives this exception i.e.

03:09:47,451 ERROR [STDERR] java.lang.ClassCastException: [Ljava.lang.Object;
03:09:47,451 ERROR [STDERR]     at com.server.servicefacades.UserSessionBean.searchUser(UserSessionBean.java:802)
03:09:47,451 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

I suppose the ids ArrayList contains Object arrays instead of containing the userId somehow but i donot understand why. Help please?