[Springframework-developer] Row limit in MappingSQLQueryWithParameters

[Luke T. <ne...@fr...>]

Hi all,

I'm doing some work with a client who I've persuaded to use Spring (they 
just ordered another 10 copies of Rod's book :) and I've found I'm 
writing a lot of search type queries - where the user enters search 
criteria and I build a query based on them. If the criteria are too 
vague, the amount of returned data could potentially be horrendous, so I 
want to be able to set a limit on the number of rows and throw an 
exception if the rowcount goes above it. It occurred to me that the 
checking could be added to the framework with a few minor changes. It 
would probably involve

1. Adding a maxRows parameter to MappingSQLQueryWithParameters 
(defaulting to infinite).

2. Adding a TooManyRowsException (or something).

3. Checking the rowcount here

http://monkeymachine.co.uk/spring/xref/org/springframework/jdbc/object/MappingSqlQueryWithParameters.html#112

and throwing the exception if it's exceeded. I could write my own 
subclass and ResultReader but just wanted to see if people thought it 
would be sufficiently generic to be worthwhile including in the 
framework classes.

Luke.

-- 
  Luke Taylor.                      Monkey Machine Ltd.
  PGP Key ID: 0x57E9523C            http://www.monkeymachine.ltd.uk