On Tuesday, August 8, 2023, An, Hongguo (CORP) wrote:
> Hi:
>
> I have a function, if I call it from DBeaver, it returns within a minute.
>
> *call* commonhp.run_unified_profile_load_script_work_assignment_details(
> 'BACDHP', 'G3XPM6YE2JHMSQA2');
>
> but if I called it from spring jdbc template,
Cramer
Date: Wednesday, August 9, 2023 at 6:30 AM
To: An, Hongguo (CORP)
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Function call very slow from JDBC/java but super fast from DBear
WARNING: Do not click links or open attachments unless you recognize the source
of the email and know
On Tue, 8 Aug 2023 at 17:07, An, Hongguo (CORP) wrote:
> Hi:
>
> I have a function, if I call it from DBeaver, it returns within a minute.
>
>
>
> *call* commonhp.run_unified_profile_load_script_work_assignment_details(
> 'BACDHP', 'G3XPM6YE2JHMSQA2');
>
>
>
>
>
> but if I called it from spring j
Hi:
I have a function, if I call it from DBeaver, it returns within a minute.
call commonhp.run_unified_profile_load_script_work_assignment_details('BACDHP',
'G3XPM6YE2JHMSQA2');
but if I called it from spring jdbc template, it never comes back:
public void runTransform(String proc, Init