Re: jdbc cursor positioning - Mailing list pgsql-jdbc

Well, move works, it's just that it doesn't return anything usefull to
let you know where it moved to!

Dave
On Mon, 2002-10-07 at 13:15, G.Nagarajan wrote:
> I was trying to figure out a way to retrieve
> a particular set of rows from the cursor. If I have
> 10,000 rows and need to take only the records between
> 5600 and 5700, "MOVE" would have been ideal. Using "FETCH"
> would mean that the 5600 records have to be transferred
> from the server. so I guess the only option left is to
> use the offset and limit options in the query.
>
> Thanks,
> Nagarajan.
>
> > -----Original Message-----
> > From: pgsql-jdbc-owner@postgresql.org
> > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Dave Cramer
> > Sent: Monday, October 07, 2002 6:50 PM
> > To: G.Nagarajan
> > Cc: pgsql-jdbc@postgresql.org
> > Subject: Re: [JDBC] jdbc cursor positioning
> >
> >
> > Sorry,
> >
> > I should have taken the move lines out, there is no way to tell if they
> > succeed.
> >
> > Dave
> > On Mon, 2002-10-07 at 12:51, G.Nagarajan wrote:
> > > hi Dave,
> > >
> > > I get the following error when I execute the program
> > >
> > >  Caught Exception: Kann Anzahl der veränderten Zeilen nicht
> > ermitteln: MOVE
> > > Kann Anzahl der veränderten Zeilen nicht ermitteln: MOVE
> > >         at
> > >
> > org.postgresql.core.QueryExecutor.receiveCommandStatus(QueryExecut
> > or.java:18
> > > 2)
> > >         at
> > org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:80)
> > >         at org.postgresql.Connection.ExecSQL(Connection.java:398)
> > >         at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
> > >         at
> > org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
> > >         at fz.core.database.CursorTest.main(CursorTest.java:23)
> > >
> > > It tells that it cannot determine the number of modified rows.
> > >
> > > I am using Postgresql 7.1.3 and 7.2 jdbc driver. I will check
> > with the beta
> > > driver and see
> > > if the error goes away.
> > >
> > > Regards,
> > > Nagarajan.
> > >
> > > > -----Original Message-----
> > > > From: pgsql-jdbc-owner@postgresql.org
> > > > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Dave Cramer
> > > > Sent: Monday, October 07, 2002 3:43 PM
> > > > To: David Wall
> > > > Cc: pgsql-jdbc@postgresql.org
> > > > Subject: Re: [JDBC] jdbc cursor positioning
> > > >
> > > >
> > > > This is a sample program which uses cursors
> > > >
> > > >       con = getConnection();
> > > >       con.setAutoCommit( false );
> > > >       Statement stmt = con.createStatement();
> > > >
> > > >       int result = stmt.executeUpdate( "declare test cursor
> > for select *
> > > > from orders" );
> > > >       System.out.println( "Created cursor, result is " + result );
> > > >       result = stmt.executeUpdate( "move 0 in dave");
> > > >       result = stmt.executeUpdate( "move -"+result+"in dave");
> > > >
> > > >       for(;;)
> > > >       {
> > > >     rs = stmt.executeQuery("fetch forward 5 in test");
> > > >         if ( !rs.next() )
> > > >       break;
> > > >       }
> > > >
> > > >       while(rs.next()){
> > > >         System.out.println("Id -->" + rs.getObject(1).toString());
> > > >       }
> > > >       rs.close();
> > > >       con.commit();
> > > >       con.close();
> > > >
> > > >
> > > > Dave
> > > > On Sun, 2002-10-06 at 22:57, David Wall wrote:
> > > > > > No, postgres fully supports cursors, the problem must be
> > > > somewhere else.
> > > > >
> > > > > How do you make use of them from JDBC?
> > > > >
> > > > > David
> > > > >
> > > > > ---------------------------(end of
> > broadcast)---------------------------
> > > > > TIP 2: you can get off all lists at once with the unregister command
> > > > >     (send "unregister YourEmailAddressHere" to
> > majordomo@postgresql.org)
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ---------------------------(end of
> > broadcast)---------------------------
> > > > TIP 5: Have you checked our extensive FAQ?
> > > >
> > > > http://www.postgresql.org/users-lounge/docs/faq.html
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 4: Don't 'kill -9' the postmaster
> > >
> > >
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
>
>