scrollable ResultSet advise

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема scrollable ResultSet advise
Дата
Msg-id 200805121147.13613.achill@matrix.gatewaynet.com
обсуждение исходный текст
Ответы Re: scrollable ResultSet advise  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
Hi, i am just migrating from 7.4 to 8.3, and i have this issue:
In the old 7.4 days i wrote a simple function to get the size of a ResultSet.
public static int FS(ResultSet rs) throws SQLException{    /* fetch size */
        rs.last();
        int cnt = rs.getRow();
        rs.beforeFirst();
        return cnt;
}

However, in plain connnection.prepareStatement(String sql) calls, ResultSet type defaults to FORWARD_ONLY,
making the above code broken.

I am wandering if there is a quick way to solve this problem, without touching the huge number of PreparedStatements
in the code.
Has anyone solved this problem using some kind of a wrapper, e.g. using wrapper classes from jboss?
--
Achilleas Mantzios

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

Предыдущее
От: tivvpgsqljdbc@gtech-ua.com
Дата:
Сообщение: Re: Correct getScale() behavior?
Следующее
От: sangeetha
Дата:
Сообщение: Re: 25P02, current transaction is aborted, commands ignored