To limit the read-ahead, the default is 1000.
I made the change you described in my jbosscmp-jdbc.xml as follows:
It did not seem to help...
Is there a way that I could override the sql using JBossQL or something like it in this file? I've seen people mention that the documentation for this is in the 'FULL DOCUMENTATION'. We purchased the electronic version of the JBoss Book 3.x and don't see any mention of JBossQL or the dynamic sql functionality that can be used in this file.