Re: Memory exeception

----- Original Message -----
From: "Peter Wasem" <peter.wasem@itag.ch>
To: <pgsql-jdbc@postgresql.org>
Sent: Wednesday, November 07, 2001 11:18 AM
Subject: [JDBC] Memory exeception


> Hi
>
> I have a problem in processing large numbers of rows in ResultSets.
> Here's the code fragment where the problem occurs:
>
> ...
>     ResultSet rset = stmt.executeQuery( "select ... from ... where ...
> order by ..." ) ;
>     while(rset.next() )
>     { // Process the row }
> ...
>
> The query addresses some 100'000 rows. When stmt.executeQuery() is
> executed suddenly an exception occurs.
> The same program works fine with other JDBC drivers.

You haven´t been clear on what exact exception is thrown,
but a wild guess is that executeQuery throws an exception due to the fact
that
the SQL of the query is illigal for postgresql.
Of course, without having seen your query, and the exception , this is all
speculation.
Could you post it?
Regards
Per-Olof Norén