Modify your db url and set/specify selectMethod=cursor;

Delete all statement  and just test one;

Test your code in a place out of EJB container (like Servlets);

Check user permissions (in DB side) to ensure the user has SELECT permission!