You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "Thomas Fox (Commented) (JIRA)" <ji...@apache.org> on 2012/03/04 14:27:59 UTC
[jira] [Commented] (TORQUE-141) Adding a way to set JDBC Driver
fetchSize on statement
[ https://issues.apache.org/jira/browse/TORQUE-141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13221884#comment-13221884 ]
Thomas Fox commented on TORQUE-141:
-----------------------------------
It seems that the default prefetch size can be set on the database connection (http://docs.oracle.com/cd/B10500_01/java.920/a96654/oraperf.htm#1002425). This should be possible by passing connection properties to the pool, see the commons-dbcp docs (http://commons.apache.org/dbcp/configuration.html). Any reason why this does not suffice ?
> Adding a way to set JDBC Driver fetchSize on statement
> ------------------------------------------------------
>
> Key: TORQUE-141
> URL: https://issues.apache.org/jira/browse/TORQUE-141
> Project: Torque
> Issue Type: Improvement
> Components: Runtime, Village
> Affects Versions: 3.3
> Environment: All
> Reporter: GBT
> Attachments: fetchSize.patch
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> With the current version, it's not possible to set the fetchsize on statements (see method setFetchSize on Statement) in order to optimize the roundtrips with the database. The default value is set by the JDBC Driver, for Oracle the value is 10.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org