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

Re: PSQLException: Too many update results were returned.

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: albertlaszlorobert(at)gmail(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: PSQLException: Too many update results were returned.
Date: 2007-08-04 01:24:00
Message-ID: 46B3D530.3060409@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Albert László-Róbert wrote:
> Oliver Jowett wrote:
>> Albert László-Róbert wrote:
>>
>>> i wish i can do that. the files that contains those statements are up to
>>> 500k ... and the majority of the code contain function implementations.
>> Err ok if you're just reading from a file and giving it to the driver
>> without any (or little) parsing, why exactly are you using batch
>> updates in the first place? Can't you just use plain execute()?
>>
>> -O
>>
> i tryed, but there i got syntax error.

If you're getting a syntax error on execute() then using executeBatch() 
is not going to help you since executeBatch() is really just an 
optimized special case of execute() .. I think you should be 
investigating this syntax error first of all.

-O

In response to

Responses

pgsql-jdbc by date

Next:From: Albert László-RóbertDate: 2007-08-04 01:28:33
Subject: Re: PSQLException: Too many update results were returned.
Previous:From: Albert László-RóbertDate: 2007-08-04 01:20:52
Subject: Re: PSQLException: Too many update results were returned.

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