I can't retrieve a scrollable ResultSet from CallableStatement - Mailing list pgsql-jdbc

From student23
Subject I can't retrieve a scrollable ResultSet from CallableStatement
Date
Msg-id 1bb1c4b7.3cc5f391.44e9699e.c7fbf@o2.pl
Whole thread Raw
Responses Re: I can't retrieve a scrollable ResultSet fr  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Hi,

I'm using posgresql 7.4 and I'm trying to receive a scrollable and updatable ResulSet with jdbc. But when I when I
checkthe type of the ResultSet I've retrieved its always FORWARD_ONLY. I use jdbc3 driver. 

the code:

       CallableStatement call = con.prepareCall("{ ? = call getRefcursor () }", ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);

        call.registerOutParameter(1, Types.OTHER);
        call.execute();
        ResultSet rs = (ResultSet) call.getObject(1);

        rs.last();   //this line throws the Exception

What do I need to do, to make it work!

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Small problem with special characters
Next
From: "Jon Horsman"
Date:
Subject: Permission denied for sequece...