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.
UPDATE: WebSphere Adapter for JDBC: Superfluous RecordNotFound Exceptions
A while ago, I posted about the WebSphere Adapter for JDBC always writing an exception to the System.out when a record could not be found. At the time, we were being told that it was not something that would be fixed in the 6.x timeframe. Suddenly, there has been a change of heart from IBM […]
WebSphere Adapter for JDBC: SetObjectKeys NullPointer Exception
We had a WebSphere Adapter for JDBC export in our module, and it was throwing the following exception: [5/27/08 17:55:52:315 EDT] 0000006b NUXInResource I PollEventManagerWorker run() CWYBS0011I: Polling has started. UserAction=No action is required. [5/27/08 17:55:53:356 EDT] 0000006d NUXInResource E com.ibm.j2ca.extension.eventmanagement.internal.EventSender getObjectForEvent(Event) EventStore impl (com.ibm.j2ca.jdbc.inbound.JDBCEventStoreWithXid@6eec3b01) threw an unexpected and unchecked exception javax.resource.ResourceException: EventStore impl (com.ibm.j2ca.jdbc.inbound.JDBCEventStoreWithXid@6eec3b01) […]
WebSphere Adapter for JDBC: Superfluous RecordNotFound Exceptions
The WebSphere Adapter for JDBC has some weird behavior if are querying a table. Should your select statement return zero records, the adapter will write a RecordNotFound exception to the System.out log. I can then catch the error in my code and continue along my merry way. Doesn’t sound harmful does it? This about this […]
SCA, BPEL, Websphere Adapter for JDBC and Transactionality
Consider the following module: We have a Web Service Export connecting to a BPEL process which invokes the WebSphere Adapter for JDBC. The BPEL process has two invocations to insert two rows into the database. I have a business requirement that either both rows get inserted or no rows. Now in the success case, when […]
WebSphere Adapter for JDBC Export – ‘InvalidVerbException’
We had a WebSphere Adapter for JDBC Export that was throwing the following error when a row was written into the event table: [3/19/08 14:44:26:705 EDT] 00000099 MA_RMSEVentPo 2 com.ibm.j2ca.jdbc.inbound.JDBCEventStoreWithXid getRecordForEvent Entering method. [3/19/08 14:44:26:705 EDT] 00000099 MA_RMSEVentPo 1 com.ibm.j2ca.extension.eventmanagement.internal.EventManager getObjectForEvent(Event) Failed to retrieve event (477) from event store (com.ibm.j2ca.jdbc.inbound.JDBCEventStoreWithXid@4dd3f398) [3/19/08 14:44:26:705 EDT] 00000099 MA_RMSEVentPo […]
JDBC Adapter Export with events that comprise multiple rows
At my client, we had a unique situation occur when integrating a database and an export for the WebSphere Adapter for JDBC. In a ‘typical’ scenario, a single row is written into a staging table, an SQL trigger writes this single row into the adapter’s event table, the adapter polls, converts the data into a […]