error when using move, any suggestions?

Поиск
Список
Период
Сортировка
От Noel
Тема error when using move, any suggestions?
Дата
Msg-id 3E00080B.9090706@med.monash.edu.au
обсуждение исходный текст
Ответы Re: error when using move, any suggestions?  (Dave Cramer <Dave@micro-automation.net>)
Re: error when using move, any suggestions?  (Barry Lind <blind@xythos.com>)
Список 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


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Daniel Serodio
Дата:
Сообщение: Re: Strange behaviour of JDBC driver for PostgreSQL
Следующее
От: Anders Hermansen
Дата:
Сообщение: (forw) [bfl@florianbruckner.com: AW: Reversedb tool and getPrimaryKeys]