0 Replies Latest reply on Jun 29, 2004 4:57 PM by jgkenned

    Generated SQL for calling methods on remote objects

    jgkenned Newbie

      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=?)


      Why does JBOSS general so many redundant elements in its prepared SQL. The above seems inefficient.