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. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3840355#3840355 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3840355 ------------------------------------------------------- This SF.Net email sponsored by Black Hat Briefings & Training. Attend Black Hat Briefings & Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
