java.lang.OutOfMemoryError
| От | Paul Cullum |
|---|---|
| Тема | java.lang.OutOfMemoryError |
| Дата | |
| Msg-id | 3E3E8394.2050908@n-able.com обсуждение исходный текст |
| Ответы |
Re: java.lang.OutOfMemoryError
Re: java.lang.OutOfMemoryError |
| Список | pgsql-jdbc |
I'm querying a table that has nearly 3 million records in it and when I call executeQuery() I get an a java.lang.OutOfMemoryError message. My immediate thought was that it was strange that a safe fetch size wasn't used automatically so I then I decided to explicitly the fetch size by calling the Connection classes setFetchSize() method. Apparently this is not implemented in the pg73jdbc3.jar driver. I am surprised that the default fetch size is so great as to cause an OutOfMemoryError. What is the proper method for using JDBC to query result sets which are potentially large? Thanks, Paul
В списке pgsql-jdbc по дате отправления: