-
Result Set order (4 messages)
- Posted by: Sandeep sandeep
- Posted on: April 01 2007 12:37 EDT
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 advanceThreaded Messages (4)
- Re: Result Set order by yull ske on April 02 2007 05:25 EDT
- result set order by Sandeep sandeep on April 02 2007 09:01 EDT
- Re: result set order by Nicke G on April 02 2007 09:25 EDT
- result set order by Sandeep sandeep on April 02 2007 09:01 EDT
- result set order by Sandeep sandeep on April 02 2007 09:01 EDT
-
Re: Result Set order[ Go to top ]
- Posted by: yull ske
- Posted on: April 02 2007 05:25 EDT
- in response to Sandeep sandeep
it is probably not a firewall problem, but a structure problem. What kind of structure do you use? HashMap, List, Vector, ... regards -
result set order[ Go to top ]
- Posted by: Sandeep sandeep
- Posted on: April 02 2007 09:01 EDT
- in response to yull ske
This occured while iterating through the result set -
Re: result set order[ Go to top ]
- Posted by: Nicke G
- Posted on: April 02 2007 09:25 EDT
- in response to Sandeep sandeep
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 -
result set order[ Go to top ]
- Posted by: Sandeep sandeep
- Posted on: April 02 2007 09:01 EDT
- in response to yull ske
This occured while iterating through the result set