From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | Wim Ceulemans <wim(dot)ceulemans(at)pophost(dot)eunet(dot)be> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: [INTERFACES] java.lang.OutOfMemoryError |
Date: | 1998-07-09 16:58:44 |
Message-ID: | Pine.LNX.3.96.980709175545.1647B-100000@maidast.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Thu, 9 Jul 1998, Wim Ceulemans wrote:
> Hi
>
> I'm using RedHat 4.2 and postgres 6.3.2
> I connect to the postgres database using the latest JDBC driver (that comes
> with 6.3.2) and the latest JDK (Steve Byrne's 1.1.6v2).
I haven't tested it against 1.1.6 on linux yet but it should be ok.
> When I run my application I get after a while the following Exception:
>
> Exception occurred during event dispatching:
> java.lang.OutOfMemoryError:
> at postgresql.PG_Stream.ReceiveString(PG_Stream.java:240)
> at postgresql.Connection.ExecSQL(Connection.java:712)
> at postgresql.Statement.execute(Statement.java:259)
> at postgresql.Statement.executeQuery(Statement.java:46)
>
> The application I am running imports an ASCII file into a number of
> postgresql tables by repeatedly issuing executeQuery statements. At startup
> I create a Connection and a Statement object which I never close (except
> when stopping the application). I think after about 300 query's I get the
> out of memory error.
It sounds like something is not being freed by the Garbage Collector. It
would help to see some of the code that is causing the problem.
I have something here which does a similar thing to yours, and it loads
80,000 rows without any problems, so there may be something simple being
missed here.
--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 1998-07-09 17:04:52 | Re: [INTERFACES] a JDBC applet |
Previous Message | Andrew R. Jackson | 1998-07-09 15:25:17 | Re: [INTERFACES] a JDBC applet |