Skip site navigation (1) Skip section navigation (2)

Re: error when using move, any suggestions?

From: Noel Faux <Noel(dot)Faux(at)med(dot)monash(dot)edu(dot)au>
To: Dave Cramer <Dave(at)micro-automation(dot)net>
Cc: Noel <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au>,"pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: error when using move, any suggestions?
Date: 2002-12-19 01:51:06
Message-ID: 4d14ec4d0b95.4d0b954d14ec@mail1.monash.edu.au (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
Hi Dave,

It works fine in psql:
blast=# begin;
BEGIN
blast=# declare test cursor for select id from region where
protein_database = 1;
SELECT
blast=# move forward 99 in test;
MOVE
blast=# fetch forward 2 in test;
   id
--------
 486175
 481881
(2 rows)

Is this a driver error?
Thanks for your reply
Cheers
Noel

Noel Faux
Department of Biochemistry and Molecluar Biology
Monash University
Clayton 3168
Victoria
Australia

----- Original Message -----
From: Dave Cramer <Dave(at)micro-automation(dot)net>
Date: Wednesday, December 18, 2002 9:43 pm
Subject: Re: [JDBC] error when using move, any suggestions?

> 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(at)micro-automation(dot)net>
> 
> 
> ---------------------------(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)


Responses

pgsql-hackers by date

Next:From: Joe ConwayDate: 2002-12-19 02:02:56
Subject: Re: user defined settings (aka user defined guc variables)
Previous:From: Gavin SherryDate: 2002-12-19 01:36:09
Subject: Re: user defined settings (aka user defined guc variables)

pgsql-jdbc by date

Next:From: Dave CramerDate: 2002-12-19 03:17:46
Subject: Re: error when using move, any suggestions?
Previous:From: Scott RoystonDate: 2002-12-19 00:33:28
Subject: getObject returns wrong type for SMALLINT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group