OutOfMemoryError
| От | rstepha1@nycap.rr.com |
|---|---|
| Тема | OutOfMemoryError |
| Дата | |
| Msg-id | 1803896180418d.180418d1803896@nyroc.rr.com обсуждение исходный текст |
| Ответы |
Re: OutOfMemoryError
|
| Список | pgsql-jdbc |
I am having a problem with performing large selects and getting a java.lang.OutOfMemoryError. Database: 8.0.1 JVM: 1.5 Driver: 8.0-311 JDBC 3 Using a simple select: SELECT col1, col2 FROM schm.tab1 WHERE col2 BETWEEN 30000 AND 31000 It seems that the ResultSet is containing the entire selected set of data and not using a cursor within the database engine. I have tried setting the resultSetType and resultSetConcurrency to TYPE_FORWARD_ONLY and CONCUR_READ_ONLY respectively to hopefully force the cursor management to be server oriented, without success. It is possible to work around by increasing the heap size or lowering the selection criteria, but ... How do you get the driver to not retrieve all of the data into the ResultSet? Is there a setting either within the JDBC driver, or at the database that would determine caching X number of rows returned at a time? Richard
В списке pgsql-jdbc по дате отправления: