JDBC-Question - Mailing list pgsql-general

From Erwin Ambrosch
Subject JDBC-Question
Date
Msg-id 200203140912.g2E9CiF08888@email.ebutec.at
Whole thread Raw
Responses Last Inserted row.
List pgsql-general
Hi,

I wonder what happens if an application performs the following.

Lets say I have a table named user with 1000 rows.  The application executest
the following.

Connection con = getConnterion();
Statement stmt = con.createStatement();
ResultSet rset = stmt.executesQuery("SELECT * FORM users");

Do I have all the data (1000 rows) in memory or dose the driver fetch the
data as needed (while iterating over the rset instance) from my postgresql
backend.

Thanks in advance
Erwin

pgsql-general by date:

Previous
From: Karel Zak
Date:
Subject: Re: Converting/formatting timestamp arithmetic
Next
From: Devrim GUNDUZ
Date:
Subject: Re: Distributed databases