Possible causes for Java functions not responding for an extended period of time are described below. Take the corresponding corrective action accordingly.
A Java application is attempting to update a record that has already been updated by the source calling the Java function
The source calling the Java function and the Java application are handled as separate transactions. Therefore, if the Java application attempts to update a record that has already been updated by the Java function, the lock processing will never be processed. This kind of situation can be checked using the pg_locks view (refer to "Viewing Locks" in "Monitoring Database Activity" under "Server Administration" in the PostgreSQL Documentation for details).
The Java application processing includes a process that is taking a long time
Use the jstack command to collect a full thread dump for the process ID listed in the file below, and check the content of the process being executed (refer to "F.2 Notes on Using jstack" for information on the jstack command).
domainRoot\domains\domain1\config\pid