Re: Function call very slow from JDBC/java but super fast from DBear

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,

Re: Function call very slow from JDBC/java but super fast from DBear

Hi Dave: Thanks for helping me out. However, I am not sure what do you mean unnamed statement. Which one is using unnamed statement ?(Dbeaver or JDBC), and if the named statement is good, how can I do it from JDBC? The server is in AWS RDS, I don’t see any log, should I reconfig the server to g

Re: Function call very slow from JDBC/java but super fast from DBear

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