Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[eclipselink-users] scrollablecursor.hasnext issue

it causes ora17075. when using with forward only query hint.
the code is:
ScrollableCursor  c = em.createNativeQuery(...)
  .setHint(QueryHints.RESULT_SET_TYPE, ResultsetType.ForwardOnly).setHint("eclipselink.cursor.scrollable",true).getSingleResult();
while(c.hasnext) {
c.next();
}
...
when scroll to last row, it throwed out this sqlexception:
ora 17075:invalid operation foe forwardonly resultset:last

any idea?


Back to the top