Why does statement.execute hang when executing a query (long-term insert or update), although all data is successfully saved on the server?

Question

PostgreSQL

Good afternoon! Faced such a situation, there is a java + jdbc service that performs data transfer between two tables of different databases using the postgres_fdw library. The initial table is about 2 GB, the transfer time is just over 10 minutes. Well, the process on the service hangs when executing statement.execute, although in fact, judging by the monitoring of postgres requests, the data was successfully transferred and the process on the server was also successfully completed.
I would like to understand what could be the problem?

Answer 1

The question is removed, in order that the connection would not fall off, you need to set the jdbc driver property cancelSignalTimeout = 10000