RE: Re: Postgresql JDBC driver - Support for Scrollable Re sult Sets - Mailing list pgsql-jdbc

From Michael Stephenson
Subject RE: Re: Postgresql JDBC driver - Support for Scrollable Re sult Sets
Date
Msg-id Pine.LNX.4.30.0101251023180.20707-100000@tirin.openworld.co.uk
Whole thread Raw
In response to RE: Re: Postgresql JDBC driver - Support for Scrollable Re sult Sets  ("Ramachandra K.B.S" <ram@meritsystems.com>)
List pgsql-jdbc
> I was trying
>
> createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
> ResultSet.CONCUR_READ_ONLY);
>
> Go the 'Method Not Implemented' error.

Yes createStatement(int, int) will always fail in 7.0.3 (which is the most
recent version I have here).

createStatement(), with no parameters, will return a ResultSet of the type
you requested above.

> Hence I jumped to the conclusion that scrollable result sets (sensitive
> or insensitive) were not supported.

Understandably.

Michael Stephenson      mstephenson@openworld.co.uk
Developer   -    Web Applications    -   Open World
Tel: +44 1225 444 950         Fax: +44 1225 336 738


pgsql-jdbc by date:

Previous
From: "Ramachandra K.B.S"
Date:
Subject: RE: Re: Postgresql JDBC driver - Support for Scrollable Re sult Sets
Next
From: Peter T Mount
Date:
Subject: Re: Re: [BUGS] JDBC PreparedStatement.setMaxRows() affects other objects instantiated from this class and it's parent class