2 Replies Latest reply: Apr 23, 2009 3:05 PM by hbuelow RSS

    Error in Database Adapter Insert Or Update (Merge) Operation

    668200
      I have a simple SOA composite which reads XML files and posts data to a database table using a database adapter. I would like to perform a merge operation but I keep getting this error in the log -

      SEVERE: JCABinding=> XML2DB:WriteInvToDB [ WriteInvToDB_ptt::merge(InventoryCollection) ] Could not invoke operation 'merge' against the 'Database Adapter' due to:
      BINDING.JCA-11616
      DBWriteInteractionSpec Execute Failed Exception.
      merge failed. Descriptor name: [WriteInvToDB.Inventory].
      Caused by java.lang.NullPointerException.

      Here is the complete log:
      SEVERE: JCABinding=> XML2DB:WriteInvToDB [ WriteInvToDB_ptt::merge(InventoryCollection) ] Could not invoke operation 'merge' against the 'Database Adapter' due to:
      BINDING.JCA-11616
      DBWriteInteractionSpec Execute Failed Exception.
      merge failed. Descriptor name: [WriteInvToDB.Inventory].
      Caused by java.lang.NullPointerException.
      Please see the logs for the full DBAdapter logging output prior to this exception.

      Jan 3, 2009 10:58:06 AM oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl log
      SEVERE: JCABinding=> [default/XML2DB!1.0*2008-12-23_13-27-06_078.WriteInvToDB]:merge One-way interaction failed
      Jan 3, 2009 10:58:06 AM oracle.tip.mediator.serviceEngine.MediatorServiceEngine post2Mesh
      SEVERE: Post 2 messah failed
      oracle.fabric.common.FabricInvocationException: BINDING.JCA-12563
      Exception occured when binding was invoked.
      Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'merge' failed due to: DBWriteInteractionSpec Execute Failed Exception.
      merge failed. Descriptor name: [WriteInvToDB.Inventory].
      Caused by java.lang.NullPointerException.
      ".
      The invoked JCA adapter raised a resource exception.
      Please examine the above error message carefully to determine a resolution.

           at oracle.integration.platform.blocks.adapter.fw.jca.cci.EndpointInteractionException.getFabricInvocationException(EndpointInteractionException.java:74)
           at oracle.integration.platform.blocks.adapter.AdapterReference.post(AdapterReference.java:226)
           at oracle.integration.platform.blocks.mesh.AsynchronousMessageHandler.doPost(AsynchronousMessageHandler.java:153)
           at oracle.integration.platform.blocks.mesh.MessageRouter.post(MessageRouter.java:152)
           at oracle.integration.platform.blocks.mesh.MeshImpl.post(MeshImpl.java:159)
           at sun.reflect.GeneratedMethodAccessor253.invoke(Unknown Source)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:585)

      Caused by: BINDING.JCA-12563
      Exception occured when binding was invoked.
      Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'merge' failed due to: DBWriteInteractionSpec Execute Failed Exception.
      merge failed. Descriptor name: [WriteInvToDB.Inventory].
      Caused by java.lang.NullPointerException.
      ".
      The invoked JCA adapter raised a resource exception.
      Please examine the above error message carefully to determine a resolution.

           at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.executeJcaInteraction(JCAInteractionInvoker.java:428)
           at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeJcaReference(JCAInteractionInvoker.java:509)
           at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeAsyncJcaReference(JCAInteractionInvoker.java:493)
           at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAEndpointInteraction.performAsynchronousInteraction(JCAEndpointInteraction.java:429)
           at oracle.integration.platform.blocks.adapter.AdapterReference.post(AdapterReference.java:193)
           ... 49 more
      Caused by: BINDING.JCA-11616
      DBWriteInteractionSpec Execute Failed Exception.
      merge failed. Descriptor name: [WriteInvToDB.Inventory].
      Caused by java.lang.NullPointerException.
      Please see the logs for the full DBAdapter logging output prior to this exception.

           at oracle.tip.adapter.db.exceptions.DBResourceException.createEISException(DBResourceException.java:488)
           at oracle.tip.adapter.db.exceptions.DBResourceException.outboundWriteException(DBResourceException.java:529)
           at oracle.tip.adapter.db.transaction.DBTransaction.commit(DBTransaction.java:287)
           at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.executeJcaInteraction(JCAInteractionInvoker.java:311)
           ... 53 more
      Caused by: java.lang.NullPointerException
           at oracle.toplink.descriptors.DescriptorQueryManager.putCachedUpdateCalls(DescriptorQueryManager.java:1605)
           at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.prepareUpdateObject(ExpressionQueryMechanism.java:1608)
           at oracle.toplink.internal.queryframework.StatementQueryMechanism.updateObject(StatementQueryMechanism.java:405)
           at oracle.toplink.internal.queryframework.DatabaseQueryMechanism.updateObjectForWriteWithChangeSet(DatabaseQueryMechanism.java:1136)
           at oracle.toplink.queryframework.UpdateObjectQuery.executeCommitWithChangeSet(UpdateObjectQuery.java:69)
           at oracle.toplink.internal.queryframework.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:279)
           at oracle.toplink.queryframework.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:47)

      Jan 3, 2009 10:58:06 AM oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl log
      WARNING: JCABinding=> ReadXML ReadXMLonReject: The resource adapter 'File Adapter' requested handling of a malformed inbound message. However, the following Service property has not been defined: 'rejectedMessageHandlers'. Please define it and redeploy the module. Will use the default Rejection Directory file://jca\ReadXML\rejectedMessages for now.
      Jan 3, 2009 10:58:06 AM oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl log
      WARNING: JCABinding=> ReadXML ReadXMLonReject: Sending invalid inbound message to Exception Handler:
      Jan 3, 2009 10:58:06 AM oracle.tip.mediator.common.error.ErrorMessageEnqueuer$EnqueuerThread run
      SEVERE: Failed to enqueue error message
      javax.jms.TransactionInProgressException: Cannot call commit on a XA capable JMS session.
           at oracle.j2ee.ra.jms.generic.RAUtils.make(RAUtils.java:595)
           at oracle.j2ee.ra.jms.generic.RAUtils.toTransactionInProgressException(RAUtils.java:846)
           at oracle.j2ee.ra.jms.generic.RAUtils.toTransactionInProgressException(RAUtils.java:840)
           at oracle.j2ee.ra.jms.generic.SessionWrapper.commit(SessionWrapper.java:197)
           at oracle.tip.mediator.common.error.ErrorMessageEnqueuer$EnqueuerThread.run(ErrorMessageEnqueuer.java:187)
           at java.lang.Thread.run(Thread.java:595)


      Any help is greatly appreciated.

      The INSERT operation works fine with the database adapter, but I cannot get MERGE and UPDATE operations to work as expected!

      Thanks.
        • 1. Re: Error in Database Adapter Insert Or Update (Merge) Operation
          njain78
          hi Sudeep,

          We are at first hand struggling with DB adapter problem getting down everytime. Don't know the reason why.

          DB adapter is in down state and when trying to make it up gives below error:

          "weblogic.application.ModuleException: weblogic.connector.exception.RAException: Jndi Name is null or empty."

          I just created a simple sync process using DB adapter (custom select) and deplyed successfully. I hope jndi name is not to be configured in weblogic-ra.xml file.

          This is the first time we are using this JNDI name (eis/DB/calvindb).

          Any inputs will be appreciated.

          Thanks,
          Nikhil
          • 2. Re: Error in Database Adapter Insert Or Update (Merge) Operation
            hbuelow
            Sudeep,

            This message says your inbound message is malformed.

            The resource adapter 'File Adapter' requested handling of a malformed inbound message. However, the following Service property has not been defined: 'rejectedMessageHandlers'.

            This is Tech Preview 4?

            Heidi.