Teiid does not retrive results one row at a time, it has default fetch size of 512. I am not sure how this was different from JDBC API's fetch size property. Can you explain the difference? The link also has
"Do not mix the JDBC 2.0 fetch size application programming interface (API) and the Oracle row-prefetching API in your application. You can use one or the other, but not both."
Thank you for your reply Ramesh.
Oracle supports its own pre-fetch as well as standard jdbc prefetch, so i was asking if there is something similar with Teiid.
But as you already mentioned there is always a way to control it with standard jdbc api.