Topic
  • 2 replies
  • Latest Post - ‏2012-02-23T22:19:18Z by SMAR-t
SystemAdmin
SystemAdmin
289 Posts

Pinned topic Problem with JDBC Inbound adapter

‏2012-01-02T15:35:43Z |
Hi,
I configured the the JDBC Inbound adapter, it was not picking the data from staging table, it was throwing below exception.
I am using the oracle database and WESB version 6.2.0.2.
1/2/12 3:14:35:870 MST 00000041 JDBCRA001 E com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand retreiveBO CWYDB0805E: The Retrieve operation found no matches in the database for the top-level business object, PmmsandSdivalmst, with the given key value or values. Explanation=The adapter expects one row to be returned from the database for the given criteria of key values in the business object. If no row exists in the database, the adapter logs this error. UserAction=Analyze the data in the database tables and ensure that there is a row for the given key value or values.
1/2/12 3:14:35:875 MST 00000041 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)

1/2/12 3:14:35:892 MST 00000041 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)
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)

1/2/12 3:14:35:904 MST 00000041 JDBCRA001 E com.ibm.j2ca.extension.eventmanagement.internal.EventSender sendEvent() Caught SelectorException/DataBindingException exception while delivering event to endpoint: $Proxy33@7f3c7f3c
javax.resource.ResourceException: Caught SelectorException/DataBindingException exception while delivering event to endpoint: $Proxy33@7f3c7f3c
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:256)

1/2/12 3:14:35:907 MST 00000041 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: $Proxy33@7f3c7f3c 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).

Please help me for resolving this issue.
Thanks in advance
Updated on 2012-02-23T22:19:18Z at 2012-02-23T22:19:18Z by SMAR-t
  • mmalc
    mmalc
    74 Posts

    Re: Problem with JDBC Inbound adapter

    ‏2012-01-04T07:07:08Z  
    Have you investigated the first fewlines in the error log and seen if that is the problem?

    "1/2/12 3:14:35:870 MST 00000041 JDBCRA001 E com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand retreiveBO CWYDB0805E: The Retrieve operation found no matches in the database for the top-level business object, PmmsandSdivalmst, with the given key value or values. Explanation=The adapter expects one row to be returned from the database for the given criteria of key values in the business object. If no row exists in the database, the adapter logs this error. UserAction=Analyze the data in the database tables and ensure that there is a row for the given key value or values."
  • SMAR-t
    SMAR-t
    1 Post

    Re: Problem with JDBC Inbound adapter

    ‏2012-02-23T22:19:18Z  
    When the adapter tries to retrieve data from a database and there is no entry for the requested keys, then the adapter throws the following recordNotFoundException. To avoid exceptions being thrown when no records are returned during a retrieve operation, set the ErrorOnEmptyResultSet property to False. This is a connection factory level setting.