Eclipse Community Forums: EclipseLink » [Solved] How can I set the defaultRowPrefetch size on the datasource?

Home » Eclipse Projects » EclipseLink » [Solved] How can I set the defaultRowPrefetch size on the datasource?(Default fetch size for Eclipselink and Oracle)

[Solved] How can I set the defaultRowPrefetch size on the datasource? [message #718892]

Thu, 25 August 2011 11:06

Eclipse User

My project's dba has asked that we try changing the defaultRowPrefetch size as an attempt to improve performance. No method I've tried to set this on the data source changes the number of rows loaded per fetch from 10. Of course I can set the fetch size per query but either deciding which queries actually need it or setting it on each one is an arduous task for a test.

I had a peak at eclipselink's source and as far as I can tell the default fetch size is hard coded to 0 which presumably makes it use the oracle default.

If possible our preference is to find a configuration change to set the default so we can deploy the change to production without requiring a new build of our application.

The two ways that I tried to set this were:
- In Tomcat's configuration as an attribute on the JNDI resource element. eg connectionProperties="defaultRowPrefetch=500"
- While setting up the Mapping Project I grab the DatabaseLogin and set the property there. I've tried both an Integer and a String. eg project.getLogin().setProperty("defaultRowPrefetch", 666);

Either way though I am looking for a way to set a default fetch size for eclipselink running on Oracle 11g. We are using Eclipselink 1.1.3 in production and 2.2.0 in development.

Thank you,
David

[Updated on: Thu, 25 August 2011 18:49] by Moderator

Re: How can I set the defaultRowPrefetch size on the datasource? [message #719057 is a reply to message #718892]

Thu, 25 August 2011 18:49

Eclipse User

It turns out that my datasource factory was being overridden in an application specific configuration file. The tomcat configuration method I listed above works for us.

(no subject) [message #719071 is a reply to message #718892]

Thu, 25 August 2011 18:49

Eclipse User

It turns out that my datasource factory was being overridden in an application specific configuration file. The tomcat configuration method I listed above works for us.

Previous Topic:	2 hibernate machines against one database machine
Next Topic:	Incorrect OSGI versioning on milestone builds?

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 17:50:06 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter