Re: error when using move, any suggestions? - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: error when using move, any suggestions?
Date
Msg-id 1040208182.14875.303.camel@inspiron.cramers
Whole thread Raw
In response to error when using move, any suggestions?  (Noel <noel.faux@med.monash.edu.au>)
List pgsql-jdbc
Noel,

What do you get from the server when you try the same commands in psql?

I just tried it and it works fine?

test=# begin;
BEGIN
test=# declare test cursor for select id from address ;
DECLARE CURSOR
test=# move forward 99 in test;
MOVE 1
test=# fetch forward 2000 in test;
 id
----
(0 rows)

Dave

On Wed, 2002-12-18 at 00:30, Noel wrote:
> Hi all,
> I'm new to postgreSQL.
> I wrote a little test program to learn how to use fetch and move in
> postgreSQL.
>
> import blastDb.*;
> import java.sql.*;
> import java.io.*;
> import java.util.*;
> import java.lang.*;
>
> public class TestFetchSize
> {
>     public static void main(String[] args)
>     {
>         try
>         {
>             BlastDB db = new BlastDB();
>
>             Statement stmt =db.connection.createStatement();
>             int counte = 0;
>             stmt.execute("begin work");
>             stmt.execute("declare test cursor for select id from region where
> protein_database = 1");
>             ResultSet rs;
>             stmt.execute("move forward 99 in test");
>             while(stmt.execute("fetch forward 2000 in test"))
>             {
>                 rs = stmt.getResultSet();
>                 if (rs.next())
>                 {
>                     ++counte;
>                     while (rs.next())
>                     {
>                         ++counte;
>                     }
>                 }
>                 else
>                     break;
>
>             }
>             System.out.println(counte);
>             stmt.execute("end work");
>         }
>         catch (Exception e)
>         {
>             e.printStackTrace();
>             System.out.println(e.getMessage());
>         }
>     }
> }
>
> It compiles ok, however when run i get this message:
> Unable to fathom update count MOVE
> at
> org.postgresql.core.QueryExecutor.receiveCommandStatus(QueryExecutor.java:182)
> 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 TestFetchSize.main(TestFetchSize.java:25)
> Unable to fathom update count MOVE
>
> I've search the web and the archives, and the only thing close is the
> thread about a sim problem with INSERT:
> "Basically the driver was storing the oid in an int.  The value you have
> is overflowing the value allowed for a signed int.
>
> thanks,
> --Barry "
>
> Is this the same problem ?
> Using  7.4 divers with JDBC3 support.
>
> Cheers
> Noel
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Dave Cramer <Dave@micro-automation.net>


pgsql-jdbc by date:

Previous
From: Anders Hermansen
Date:
Subject: (forw) [bfl@florianbruckner.com: AW: Reversedb tool and getPrimaryKeys]
Next
From: Dave Cramer
Date:
Subject: Re: (forw) [bfl@florianbruckner.com: AW: Reversedb tool and