Re: jdbc cursor positioning

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(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Dave Cramer
> Sent: Monday, October 07, 2002 3:43 PM
> To: David Wall
> Cc: pgsql-jdbc(at)postgresql(dot)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(at)postgresql(dot)org)
> >
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html