On 7/23/20 6:30 AM, Christophe combet wrote:
>
> Thank you for pointing the link between auto commit an buffering.
>
> autocommit=false: same exception.
>
> We try fetchSize.
>
> Thanks.
> Le jeudi 23 juillet 2020 à 13:47:14 UTC+2, Vladimir Sitnikov
> <sitnikov(dot)vladimir(at)gmail(dot)com> a écrit :
>
>
> >can you try switching to autocommit=false?
>
> + you probably need to configure fetchSize as well.
>
> Vladimir
>
You set the 8G limit on the java process but did you tell up the
available RAM? This query would require that about 3G be available to
hold all the data. Can you use jConsole to establish how much memory is
available at the time of issuing the query?