implementation of Statement.executeQuery()
От | Jonathan Gold |
---|---|
Тема | implementation of Statement.executeQuery() |
Дата | |
Msg-id | Pine.NEB.4.58.0401191936200.19988@panix3.panix.com обсуждение исходный текст |
Ответы |
Re: implementation of Statement.executeQuery()
Re: implementation of Statement.executeQuery() |
Список | pgsql-jdbc |
i know there has been large discussion in the last year or two about the fact that the code ResultSet rs = someStatement.executeQuery( queryString ) causes an OutOfMemoryException for large result sets, as the backend returns the entire result set at once, and so it must be stored in memory while the result set exists. the current accepted solution seems to be the use of a result set in combination with two prepared statements -- one to create a cursor, the other to fetch from it. there was some comment in these threads that it would be nice if that could be fixed, and to have this functionality added to the jdbc implementation for postgres. what is the state of this? do people still want to do it? if so, is anyone working on it yet? jon
В списке pgsql-jdbc по дате отправления: