error when using move, any suggestions?

From: Noel <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: error when using move, any suggestions?
Date: 2002-12-18 05:30:51
Message-ID: 3E00080B.9090706@med.monash.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Anders Hermansen 2002-12-18 08:57:00 (forw) [bfl@florianbruckner.com: AW: Reversedb tool and getPrimaryKeys]
Previous Message Josh Berkus 2002-12-18 00:02:36 Re: [NOVICE] [JDBC] JDBC - Open Office