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.
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 […]
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) […]
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 […]
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 […]
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 […]
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 […]