Result Set order

Discussions

General J2EE: Result Set order

  1. Result Set order (4 messages)

    When i runing a query i am getting the resultset in the correct order(as specified in the ORDER BY clause) But when i am trying to run the same in my application using websphere my result set order is not maintained. My system is having some tight firewall settings When i truncated the particular table and inserted the rows again then it worked fine. Can anybody help me . What could be the reason for this behaviour? Thanks in advance

    Threaded Messages (4)

  2. Re: Result Set order[ Go to top ]

    it is probably not a firewall problem, but a structure problem. What kind of structure do you use? HashMap, List, Vector, ... regards
  3. result set order[ Go to top ]

    This occured while iterating through the result set
  4. Re: result set order[ Go to top ]

    You most certanly are querying the db with a query not using an Order By clause, if your ResultSet returns a non ordererd data set. Double check the sql that is passed to the db. Regards Niklas
  5. result set order[ Go to top ]

    This occured while iterating through the result set