how to set the jdbc fetch size for a query in toplink essential?

Question

We have a legacy project in this using oracle essential with version 1.0.0 for persistence. Can you please provide how to give the hint to the query for increasing the JDBC fetch size and how we verify the fetch size in logs?

Answer 1

You can set the fetch size as query hint

query.setHint("toplink.jdbc.fetch-size", "100");