WebSphere Adapter for JDBC Export and SQL Server 2000: Table Locking while Polling | danzrobok.com

Home Blog Archives About Contact

Best Of DZ.com
Topics
- Articles & Reviews (116)
  - DeveloperWorks (54)
  - Impact 2008 (23)
  - Reviews (21)
  - Syndication (21)
  - WebSphere Community (31)
  - WebSphere News (18)
  - WebSphere Services Technical Conference (2)
- Best Of DZ.com (22)
- Business Integration (246)
  - DataPower (39)
  - ITCAM for SOA (2)
  - Oracle BPEL (6)
  - Oracle Fusion (1)
  - Other Business Integration Products (4)
  - Project Zero (4)
  - Spring (5)
  - WebSphere Application Server (31)
  - WebSphere Business Events (2)
  - WebSphere Business Services Fabric (10)
  - WebSphere Enterprise Service Bus (45)
  - WebSphere Integration Developer (73)
  - WebSphere Message Broker (5)
  - WebSphere Process Server (133)
  - WebSphere Service Registry and Repository (8)
  - WebSphere Transformation Extender (1)
- Business Integration Tips (31)
- Linux / Ubuntu (2)
- Personal (43)
  - Certification (10)
  - Dan Zrobok (28)
  - Humor (10)
  - Perficient (3)
- Service Oriented Architecture (18)
  - Design Decisions (9)
- Uncategorized (4)
DZ.com NewsFeed

Subscribe by RSS
Subscribe by Email
IBM
- IBM developerWorks : WebSphere
- IBM Redbooks | WebSphere
IBM Consultants
Non-IBM Practitioners
- Albin Joseph
Service Oriented Architecture
- Eric Roch
- Jack van Hoof
Twitter
- DanZrobok’s Twitter-roll
WebSphere News
- WebSphere Today

I'm not really this menacing in real life.
Disclaimer

DZ.com is the musing of a solitary man with a solitary plan. The views expressed here are my own and not those of my employer, colleagues, friends, dentists or poodles.
WebSphere News

WebSphereToday.com
Recent Comments
- Sadhana on Web services with SOAP/JMS in IBM WebSphere Process Server
- Sadhana on Adding JMS or MQ/JMS Custom Header Attributes
- Arnold on I’m now an Independent Consultant looking for Contracts
Relevant Books
Related Links

WebSphere Adapter for JDBC Export and SQL Server 2000: Table Locking while Polling

June 24th, 2008 dan Posted in Business Integration Tips, WebSphere Enterprise Service Bus, WebSphere Process Server | No Comments »

A technote was published for customers who use the WebSphere Adapter for JDBC for inbound processing of an SQL Server 2000 database. Apparently, the adapter will lock the entire event table (bad!).

The ‘fix’ aka workaround is to use a view to the event table and then set a custom property inside the adapter.

Related Posts

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

« Passed Certification Test 284: IBM WebSphere DataPower SOA Appliances Firmware V3.6.0

My Next Opportunity: Oracle Fusion »