Result Set FORWARD_ONLY

From: Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Result Set FORWARD_ONLY
Date: 2005-09-23 01:34:57
Message-ID: 7EAC0D28-F7CC-4924-8244-CF8AD2874314@visualdistortion.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I'm having trouble setting the result set to anything but FORWARD_ONLY.

If I do this:

pstmt = conn.prepareStatement("select name, name from
amz.product_detail_items order by name");
rs = pstmt.executeQuery();
rs.setFetchDirection(ResultSet.TYPE_SCROLL_INSENSITIVE);

I get:

org.postgresql.util.PSQLException: Invalid fetch direction constant:
1,004.

I get the same error if I set it on the pstmt object before executing
the query.

Using version 311 of the JDBC driver and 8.0.2.

Thanks,
Jeff

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2005-09-23 02:04:45 Re: Result Set FORWARD_ONLY
Previous Message Peter Cook 2005-09-23 00:27:17 Connecting to postgreSQL