Top "Scrollableresults" questions

Using Hibernate's ScrollableResults to slowly read 90 million records

I simply need to read each row in a table in my MySQL database using Hibernate and write a file …

java mysql hibernate large-data-volumes scrollableresults

Count of the result of a Hibernate Criteria group by - total grouped records returned

I have a Criteria-based query with the following grouping: Projections.projectionList() .add(Property.forName("xyz").group())); The SQL generated is (…

hibernate count group-by criteria scrollableresults

can not use resultSet.setFetchDirection(ResultSet.TYPE_SCROLL_SENSITIVE) with spring jdbc DaoSupport with Oracle

I want to use scrollable resultset, so when I use two lines of code: rs.setFetchDirection(ResultSet.TYPE_SCROLL_SENSITIVE); …

java oracle resultset spring-jdbc scrollableresults

Query results as a Stream with Hibernate 5.2

Since Hibernate 5.2, we are able to use the stream() method instead of scroll() if we want to fetch large amount …

java hibernate jpa stream scrollableresults