Обсуждение: Function call very slow from JDBC/java but super fast from DBear

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, InitDataLoadEntity entity) {

          log.info("Initial data finished data migration for {}, starting transform for {}...", entity.getOrganizationOid(), proc);

          var schema = clientDbInfo.getSchema(entity.getOrganizationOid())[1].toUpperCase();

          var count = unifiedProfileJdbcTemplate.update("call commonhp." + proc + "(?, ?)", schema, entity.getOrganizationOid());

          log.info("Initial data finished data migration for {}, end transform for {}, result is {}", entity.getOrganizationOid(), proc, count);

     }

The server does show high CPU, the function has mainly just one insert command (batch insert), the target table has 3 FKs.

Please help.

Thanks

Andrew

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 get logs?

I tried to

Explain call …, but it said syntax error.

When the JDBC is running, I got the pid, is there any way for me to check what is it waiting for? There is no dead lock, but some relationship locks, all granted and no waiting, but why it never comes back?

Thanks

Andrew