Re: jdbc cursor positioning - Mailing list pgsql-jdbc

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