I'm looking for info on how Websphere handles db locking - the application is using DBSelect beans running on Websphere Express connecting to SQL Server. It seems to handling the locking internally b/c specific row locking values are not set in the code, but we are having issues with db level locks being set (instead of just table to row level) and causing a major decrease in performance - so i'm wondering how to proceed to correct this.
any help would be appreciated!!
any help would be appreciated!!