Hikari pool: maximum-pool-size=2, connection-timeout=500 ms rows in the table, via count(): 5 two streamAll() calls left open, then one ordinary count(): -> CannotGetJdbcConnectionException after about 500 ms root cause: HikariPool-N - Connection is not available, request timed out after 500ms (...) after closing both streams, count() works again: 5 try-with-resources: names of rows 1..2: [Mechanical Keyboard, Wireless Mouse] and the connection is back: count() = 5