Eclipse Community Forums: EclipseLink » How to set JDBC fetch size on JPA query?

Home » Eclipse Projects » EclipseLink » How to set JDBC fetch size on JPA query?

How to set JDBC fetch size on JPA query? [message #501317]

Tue, 01 December 2009 15:32

Eclipse User

Is it possible to modify the JDBC fetch size on a JPA query?

I'm considering a current piece of code that uses JDBC to process a resultset from a query that theoretically returns hundreds of thousands of rows, but my service only runs for a few minutes, only processing the records it can process in a time limit. The next time it runs, it runs a similar query and gets the rows that haven't been eliminated in the meantime. In this piece of code, I can tune the performance by changing the JDBC fetch size.

Could I do something similar with JPA, or perhaps a custom JPA extension to EclipseLink?

Re: How to set JDBC fetch size on JPA query? [message #501723 is a reply to message #501317]

Thu, 03 December 2009 10:31

Eclipse User

There is a Query hint for this in EclipseLink, "eclipselink.jdbc.fetch-size"

http://www.eclipse.org/eclipselink/api/1.2/org/eclipse/persi stence/config/QueryHints.html#JDBC_FETCH_SIZE

Previous Topic:	Virtual columns (@Formula of Hibernate)
Next Topic:	CACHE_TYPE_DEFAULT

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 26 02:20:39 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter