Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
7 replies Latest Post - ‏2013-02-21T06:04:05Z by Tarunkumartarun
SystemAdmin
SystemAdmin
3556 Posts
ACCEPTED ANSWER

Pinned topic Jdbc Inbound adapter problem with Oracle database

‏2011-12-15T13:39:05Z |
I have configured the JDBC Inbound adapter, It was not picking the data from event table,It is throwing the below exception.
12/15/11 3:06:21:269 MST 00000049 JDBCRA001 E com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand retreiveBO CWYBS0497E: The Resource Bundle com.ibm.j2ca.jdbc.LogMessages using Locale en_US cannot be loaded.
12/15/11 3:06:21:279 MST 00000049 JDBCRA001 E com.ibm.j2ca.jdbc.JDBCRecord getNext Exception Occured When Event is not null.
com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

12/15/11 3:06:21:294 MST 00000049 ExceptionUtil E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "onNotification" on bean "BeanId(MWWR6ESB_PublishProductServiceApp#MWWR6ESB_PublishProductServiceEJB.jar#export.JDBCInboundPMMEventInterfaceEIS, null)". Exception data: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:130)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
Caused by: com.ibm.despi.exception.DESPIException: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:111)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
... 19 more
Caused by: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
... 20 more
Wrapped by:
com.ibm.websphere.sca.ServiceRuntimeException: commonj.connector.runtime.DataBindingException: Failed in population return object: caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:481)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
Caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:130)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
... 18 more
Caused by: com.ibm.despi.exception.DESPIException: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:111)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
... 19 more
Caused by: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
... 20 more
12/15/11 3:06:21:300 MST 00000049 JDBCRA001 E com.ibm.j2ca.extension.eventmanagement.internal.EventSender sendEvent() Caught SelectorException/DataBindingException exception while delivering event to endpoint: $Proxy64@c900c9
javax.resource.ResourceException: Caught SelectorException/DataBindingException exception while delivering event to endpoint: $Proxy64@c900c9
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:256)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
Caused by: com.ibm.ejs.container.UnknownLocalException: ; nested exception is: com.ibm.websphere.sca.ServiceRuntimeException: commonj.connector.runtime.DataBindingException: Failed in population return object: caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:481)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
... 10 more
Caused by: com.ibm.websphere.sca.ServiceRuntimeException: commonj.connector.runtime.DataBindingException: Failed in population return object: caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
... 19 more
Caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:130)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
... 18 more
Caused by: com.ibm.despi.exception.DESPIException: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:111)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
... 19 more
Caused by: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
... 20 more

javax.resource.ResourceException: Caught SelectorException/DataBindingException exception while delivering event to endpoint: $Proxy64@c900c9
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:256)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
Caused by: com.ibm.ejs.container.UnknownLocalException: ; nested exception is: com.ibm.websphere.sca.ServiceRuntimeException: commonj.connector.runtime.DataBindingException: Failed in population return object: caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:481)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
... 10 more
Caused by: com.ibm.websphere.sca.ServiceRuntimeException: commonj.connector.runtime.DataBindingException: Failed in population return object: caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
... 19 more
Caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:130)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
... 18 more
Caused by: com.ibm.despi.exception.DESPIException: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:111)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
... 19 more
Caused by: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
... 20 more

12/15/11 3:06:21:303 MST 00000049 JDBCRA001 A com.ibm.j2ca.extension.eventmanagement.internal.EventSender deliverEvent() CWYBS0504E: Failed to send event. Error: javax.resource.ResourceException: Caught SelectorException/DataBindingException exception while delivering event to endpoint: $Proxy64@c900c9 Explanation=The event list could not be sent to the endpoint. UserAction=Verify that the target application is online, and that the event exists in the enterprise information system (EIS).
12/15/11 3:06:35:229 MST 00000049 JDBCRA001 E com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand retreiveBO CWYBS0497E: The Resource Bundle com.ibm.j2ca.jdbc.LogMessages using Locale en_US cannot be loaded.
12/15/11 3:06:35:239 MST 00000049 JDBCRA001 E com.ibm.j2ca.jdbc.JDBCRecord getNext Exception Occured When Event is not null.
com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

Please help me resolving this issue.

Thanks in advance.
Updated on 2013-02-21T06:04:05Z at 2013-02-21T06:04:05Z by Tarunkumartarun
  • Tarunkumartarun
    Tarunkumartarun
    6 Posts
    ACCEPTED ANSWER

    Re: Jdbc Inbound adapter problem with Oracle database

    ‏2012-10-08T13:20:13Z  in response to SystemAdmin
    I also faced the same problem .
    • SystemAdmin
      SystemAdmin
      3556 Posts
      ACCEPTED ANSWER

      Re: Email outbound adapter problem

      ‏2012-10-29T07:44:36Z  in response to Tarunkumartarun
      I am also facing the same issue but with Email Adapter.Any clue if any one has resolve this issue...

      I am getting below exception:-
      10/28/12 4:51:57:370 CDT 00000062 EMARA001 I com.ibm.j2ca.email.EmailManagedConnection createManagedConnection CWYBS0497E: The Resource Bundle com.ibm.j2ca.email.LogMessages using Locale en_US cannot be loaded.
      10/28/12 4:51:57:531 CDT 00000062 EMARA001 I com.ibm.j2ca.email.EmailInteraction execute CWYBS0497E: The Resource Bundle com.ibm.j2ca.email.LogMessages using Loc
      ale en_US cannot be loaded.
      Thanks in advance
      • Tarunkumartarun
        Tarunkumartarun
        6 Posts
        ACCEPTED ANSWER

        Re: Email outbound adapter problem

        ‏2012-10-29T07:50:57Z  in response to SystemAdmin
        HI PSaxena

        Do u have any idea about XSL transformation.

        Thanks
        Tarun
        • SystemAdmin
          SystemAdmin
          3556 Posts
          ACCEPTED ANSWER

          Re: Email outbound adapter problem

          ‏2012-10-30T11:08:14Z  in response to Tarunkumartarun
          Hi Tarun,

          Yes,I have an idea of XSLT transformation.Please let me know how can I help you.
          • Tarunkumartarun
            Tarunkumartarun
            6 Posts
            ACCEPTED ANSWER

            Re: Email outbound adapter problem

            ‏2012-10-31T09:53:48Z  in response to SystemAdmin
            Hi PSaxena,

            Thank you very much for giving +ve response . I am sending one .rar file please find that . In this one pdf file is there and one .zip file .i followed the instruction given in pdf but i didnt find 'ProfileToCustomer_res_1-out.xml'file wherever it should be according to tutorial .

            This is the 2nd part of 5th chapter in given pdf . can u help me to find out why i m not getting this file.
            tarunbathla786@gmail.com is my id please add me there if u dont have nay problem so,we can share knowledge frequently

            Thank you
            Tarun
  • JayLopez
    JayLopez
    2 Posts
    ACCEPTED ANSWER

    Re: Jdbc Inbound adapter problem with Oracle database

    ‏2012-12-06T18:27:36Z  in response to SystemAdmin
    Having a similar issue with an oracle database. Did you resolve? If yes,how?
    • Tarunkumartarun
      Tarunkumartarun
      6 Posts
      ACCEPTED ANSWER

      Re: Jdbc Inbound adapter problem with Oracle database

      ‏2013-02-21T06:04:05Z  in response to JayLopez
      HI Experts,

      Can you please send me the steps for retriving data from db2 threw Process Designer (lombardi)

      Thanks