Database Table vs Record Locking

I’m running IS 6.5 with the JDBC Adapter 6.5 Fix 4 connected to MS SQL2000.

We’re presently using the implicit transaction management (based on the life of the top level service) and are finding that when one service is running (e.g. PO outbound) that other services (e.g. PO Ack inbound) block until it finishes.

This tells me that we are locking the tables rather than records. Is there a way to enable record locking for better throughput? This also means that we can’t run multiple copies of a service to parallel process documents.

We will likely switch to explicit transaction management to allow more granular definitions of transaction scope, but the table locking will still be an issue.

Are others experiencing this behavior?

Thanks for your help.

Howard Neuwirth-Hirsch

What types of JDBC services are you using that are experiencing this?

群发|群发软件|信息群发软件|吉林龙兴网络从事群发|群发软件|信息群发软件.信息群发、群发软件、群发软件公司、SEO软件、正版群发软件,也欢迎大家参观洽谈。www.138009818.com/ - 37k - 网页快照 - 类似网页

We’re using JDBC Adapters: SelectSQL and InsertSQL.

This thread appears to be covering the same topic. Perhaps it covers what you need?
http://wmusers.com/forum/showthread.php?t=15324