I faced the same problem which is having the deadlocks problem in target client SQL Server.
- The locks were happened in target client SQL Server which there are many processes are locked by webMethods request SQL statement.
- No. The JDBC adapter service is not hanging but due to the locks in SQL server, it slow down the SQL Server performance.
- The JDBC Connection minimum pool size is 0 and maximum pool size is 100
- It does not happen to each call to SQL Server.
- 6.5 Integration Server
- Windows 2000
- Java Version 1.4.2
May you please give me some guidance on why there are a lot of Processes are being locks by webMethods requested sql statement? And how to solve this problem? Is there any batch or fixed for this issue?