1 Reply Latest reply on Sep 3, 2002 11:15 AM by Dain Sundstrom

    endless ORs in generated SQL querries

    Matthias Menz Newbie

      Hello,
      looking at the logs of jboss 3.0.1 running with a informix datatbase I found the following statement:
      SELECT nr,msgNr, art, text FROM message WHERE (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?)

      It doesn't lead to any errors but I think it will definitely cost performance. Any ideas what or where I forgot to configure?? Thanks in advance

      Matt