Re: 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(QueryExecutor.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
>
>