Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
Hi Team,
I am using driver - mariadb-java-client-3.5.2.jar
I want to fetch records from DB in batches
What I tried:
1. setFetchSize() -> I set a positive number > 1
2. Used useServerPrepStmts=true&useCursorFetch=true in JDBC URL
3. Used TYPE_FORWARD_ONLY, CONCUR_READ_ONLY for resultSet
But all the records are getting fetched in one go. How to make the batching work?