[postgis-users] JDBC OutofMemoryError

[Gustavo Henrique Sberze Ribas]

Hello,

  A few things to try out:

    - Narrow down your search (use WHERE);
    - Limit the number of rows returned (use LIMIT);
    - Give Java more memory: java -Xmx512M MyProgram


--
Gustavo 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Akira Komo
Sent: Wednesday, August 03, 2005 5:28 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] JDBC OutofMemoryError


Dear all,  
I have two small tables arizona_geo and colorado_geo in PostGIS 
which were converted from two shapefiles. Each of them has only 
several hundreds records. When I tried to issue a very simple query via
JDBC connection, I always got an  OutOfMemoryError. One example
query is 
    select 1 from arizona_geo X, colorado_geo Y
 I tried different postgresql JDBC driver with postgis extension, basically
 I got the same error. I am very appreciated if somebody can give me an 
idea to solve this problem.
-- Kumo



-- 
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://www.mail.com/?sr=signup