db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "GBT (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TORQUE-141) Adding a way to set JDBC Driver fetchSize on statement
Date Mon, 05 Mar 2012 07:57:09 GMT

    [ https://issues.apache.org/jira/browse/TORQUE-141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13222207#comment-13222207

GBT commented on TORQUE-141:

It's possible to set the default fetchsize either by JDBC Driver, either by datasource properties.
But, it's a default value, that means all my connections will use this default settings.

If for one particular request, i need to fetch with an other value, i can't do it.
That's why i need to change this value for specific stattements.
> 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

View raw message