Troubleshooting
Problem
The setting defaultRowPrefetch is used to help increase the performance of queries to Oracle databases and we sometimes find customers who want to enable this feature for Oracle database connections to increase the prefetched rows. Oracle JDBC drivers have a feature built in as an extension that allows you to set the number of rows that are prefetched while the full result set is being formulated. This is to reduce the number of trips back and forth to the database.
Symptom
If defaultRowPrefetch is set as a custom property on the datasource, this will not work as the defaultRowPrefetch is not a datasource property but a property on the connection itself .
Log InLog in to view more of this document
Was this topic helpful?
Document Information
More support for:
WebSphere Application Server
Software version:
9.0, 8.5.5, 8.0, 7.0
Operating system(s):
AIX, HP-UX, IBM i, Linux, Solaris, Windows
Document number:
398117
Modified date:
03 March 2025
UID
swg21417765