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?

score 1 · Accepted Answer · answered Feb 27 '18 at 15:06

1

You can set the fetch size as query hint

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

answered Feb 27 '18 at 15:06

Simon Martinelli

34,053
5
48
82

1

Thanks @simon for the response. is there is a way to verify the JDBC fetch size in toplink essential? – Ramesh Feb 27 '18 at 15:22
1

you should turn on logging then you get some information. – Simon Martinelli Feb 27 '18 at 17:16

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

1 Answers1