On Wed, 10 May 2006, Thomas Vatter wrote:
> Yes, the difference between psql command line and application is 6
> seconds to 40 seconds. It is exactly the step resultSet =
> excecuteQuery() that needs 40 seconds. I use next() as a cursor through
> the resultSet, but I fear this is not enough, do I have to use
> createStatement(resultSetType, resultSetConcurrency) respectively
> prepareStatement (resultSetType, resultSetConcurrency) to achieve the
> cursor behaviour?
http://jdbc.postgresql.org/documentation/81/query.html#query-with-cursor
Kris Jurka
