JDBC-Question

From: Erwin Ambrosch <ambre(at)ebutec(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: JDBC-Question
Date: 2002-03-14 09:08:13
Message-ID: 200203140912.g2E9CiF08888@email.ebutec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2002-03-14 09:24:16 Re: Distributed databases
Previous Message Karel Zak 2002-03-14 08:32:21 Re: Converting/formatting timestamp arithmetic

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Zawadka 2002-03-14 09:50:28 Last Inserted row.
Previous Message Auri Mason 2002-03-14 08:20:01 Re: problems with Tomcat and postgres