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

PSQLException: Too many update results were returned.

From: Albert Laszlo-Robert <albert_laszlorobert(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: PSQLException: Too many update results were returned.
Date: 2007-08-03 23:33:42
Message-ID: (view raw or whole thread)
Lists: pgsql-jdbc

i have a big problem. 

task: i need to execute multiple queries form some files. each file contains at about 50-100 query. the queries are from create table to create function ... almost everything. this batches should run on more than 600 databases.

my problem is: 

i used the Statement.addBatch() to add the batch to the statement, and i execute batch with the Statement.executeBatch() method. the execution failes with the following error:

org.postgresql.util.PSQLException: Too many update results were returned.
    at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleCommandStatus(
    at org.postgresql.core.v3.QueryExecutorImpl.interpretCommandStatus(
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(
    at org.postgresql.core.v3.QueryExecutorImpl.execute(
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(
    at com.taylor.zeus.patcher.db.DatabaseSelector.upgradeDatabases(

i goggled  all over the web to find out what is the source of this exception, but i don't find anything. 

can someone explain to me what should i do. or at least what is the problem with this.

platform: linux with 2.6.20-16-generic kernel
db: PostgreSQL 8.1.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-13)
jdbc: 8.1 jdbc3  (i don't know what build number is)


Laszlo-Robert, Albert

Building a website is a piece of cake. 
Yahoo! Small Business gives you all the tools to get online.


pgsql-jdbc by date

Next:From: Oliver JowettDate: 2007-08-04 00:43:12
Subject: Re: PSQLException: Too many update results were returned.
Previous:From: Oliver JowettDate: 2007-08-03 23:09:04
Subject: Re: statement caching patch from Laszlo Hornyak for review

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