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
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 |