Re: executeQuery

Fernando:
is the LIMIT qualifier part of the SQL standard or a Postgres extension?
Also, I tried the statement.setFetchSize() and got a "method not
implemented" error. Can you send me a code fragment that illustrates what
you mean?
Thanks, Brad

-----Original Message-----
From: Fernando Nasser [mailto:fnasser(at)redhat(dot)com]
Sent: Thursday, August 07, 2003 12:47 PM
To: Lufkin, Brad
Cc: 'postgres'
Subject: Re: [JDBC] executeQuery

Lufkin, Brad wrote:
> I'm executing an SQL query using the following code:
>
> Connection connection =
> DriverManager.getConnection(url,user,password);
> Statement statement = connection.createStatement();
> ResultSet resultSet = statement.executeQuery("SELECT * FROM
> someTable");
>
> This works except that the third statement doesn't return until the query
is
> complete. This contrasts with the behavior of other databases (such as
> Informix) where the query returns immediately, thus allowing the result
set
> metadata to be analyzed before the result set is.
> Is there any way to force the executeQuery to return immediately?
> If not, is there some way to limit the results of the query to the first n
> rows, where n is some reasonable number?
>

You can either use LIMIT <n> in the SELECT statement itself or use the
setFetchSize() inside a transaction or with server-side prepared statements.

--
Fernando Nasser
Red Hat Canada Ltd. E-Mail: fnasser(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster