partial resultset in java

Поиск
Список
Период
Сортировка
От surabhi.ahuja
Тема partial resultset in java
Дата
Msg-id 8626C1B7EB748940BCDD7596134632BE398666@jal.iiitb.ac.in
обсуждение исходный текст
Список pgsql-general
hi,
i have a small question
I have a table, with one of the fields called x (x is not the primary key, here)
 
now i have to make a query like this:
select * from table where x = 1;
 
the number of rows retrieved from the above query is of the order of 20,000 or more.
 
the result is contained in a resultset.
 
i have copy pasted the code as follows:
 ResultSet rs = stmt.executeQuery(qString);   //qstring is " select * from table where x = some_value;"
   ResultSetMetaData rsmd = rs.getMetaData();
   int colCount = rsmd.getColumnCount();
   int k = 0;
   while (rs.next()) {
    vals = new HashMap();
    for (int j = 0; j < colCount; j++) {
     vals.put(rsmd.getColumnName(j + 1), rs.getObject(j + 1));
    }
    objList.add(k++, new DBObject(qLevel, vals, this));
}
 
as u can say i take each of the rows and do some processing, to form some objects from that row. And then i add those object to the objList.
 
the above peice of code is executed when the user select some particular value of x,
 
and if the number of rows is as large as 20k, its taking a lot of time.
 since it takes time to get all the 20k objects a busy cursor comes.(in the front end)
 
What the user is expectiing here is that, if he/she realizes that they selected the wrong x, they want to cancel that query here, and proceed by selecting some other x(in the front end).
 
My question is that, how can i do it? is there any way of cancelling the query in between?
 
or is it  possible to get partial results so that it may be cancelled or something.
 
Any info in this regard will be valuable.
 
Thanks,
regards
Surabhi

В списке pgsql-general по дате отправления:

Предыдущее
От: "Aftab Alam"
Дата:
Сообщение: Re: ambuild parameters
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PANIC: heap_update_redo: no block