Re: MyBatis Batch Update Leads to PSQLException "Too many update results were returned"

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

On 4 March 2018 at 09:34, Chris Dole <chris(dot)dole(at)sas(dot)com> wrote:

> Hi Dave,
>
> I am certainly willing to follow up on that, and will do so. I can turn on
> debugging with MyBatis and perhaps capture the query pattern that is being
> generated.
>
> However, it would help to get some background on the PSQLException that is
> being thrown.
>
> * What is the nature of the error?
>
> * What does Postgres or its JDBC driver imply about the query for the
> message of "... too many updates ..."
>
> * Can you give me an indication of what logic is being tripped over that
> leads to this error condition?
>

I'd have to do some more investigation but start here.

https://github.com/pgjdbc/pgjdbc/blob/e6a1eccb148c3c59e8cf122e98ad01afc5bb555a/pgjdbc/src/main/java/org/postgresql/jdbc/BatchResultHandler.java#L92

>
> Thanks,
> Chris
>
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-jdbc-f2168246.html
>
>