I have an EJB that manages cities in the US. Examining the debug logs yielded the following SQL
SELECT state_abbr, county, city,alt_county_descr, state_name FROM city_names WHERE (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?) OR (state_abbr=? AND county=? AND city=?)