there is single JUnit here org.khl.dbbench.DbBenchTest, 
which utilizes embedded derby for pulling many rows by two
different ways SELECT * FROM table ORDER BY ID - pullOneByOne()
and paginated 
SELECT * from FIRSTTABLE where id in (?,?,?,?..) - pullByBatches()
it proceeds 10000 rows by default in 100 rows batches. 
To scale data higher specify -Dtests.nightly=true.
pls find one-mln-embedded.png with embedded server results.


one-mln-via-loopback.png shows the same 1Mln test for network server 
at the same laptop. to reproduce: run ./startNetworkServer from Derby
distribution and specify endpoint via -Dderby=//localhost/ 
Pls check derby doc and test source for further details.