1 Reply Latest reply on Dec 22, 2004 6:45 PM by 279007

    Please help with Oracle InterConnect

    277235
      I'm trying to get Oracle Interconnect (4.1 or 9.0.4) to work and have been unsuccessful in my attempts. I have followed the user's guide to the letter but the AQ or DB adapters do not work.

      I have setup an AQ app and DB app from iStudio. The event is a createCustomer with id, FirstName and LastName. Nothing fancy at this point. All I want is to get the customer data inserted into the DBAPP schema's customer table.

      I have had no luck between 2 DB apps either.

      WIth OAI 4.1, when I start the aqapp adapter, I get the following error:
      ===================
      The Adapter service is starting..
      Registering your application (AQAPP(1))..
      java.lang.ClassFormatError: Bad interface index
      at Oracle.jms.AQjmsFactory.getTopicConnectionFactory(Compiled Code)
      at oracle.oai.agent.common.jms.JMSManager.setConnectionFactoriesUsingOJM
      S(JMSManager.java:717)
      ========================


      With OAI 9.0.4, when I start the DB application, I get the following error message:
      ====================
      Wed Dec 08 18:52:18 CST 2004: Adding message destination: "{oai_hub_queue=[DBAPP2]}"
      Wed Dec 08 18:52:18 CST 2004: Messenger: topic connection started.
      Wed Dec 08 18:52:18 CST 2004: Messenger: publish topic session created.
      Wed Dec 08 18:52:18 CST 2004: Messenger: created publisher: oai_hub_queue
      Wed Dec 08 18:52:18 CST 2004: Messenger_sendToQueueFailed
      oracle.jms.AQjmsException: ORA-06550: line 1, column 7:
      PLS-00306: wrong number or types of arguments in call to 'AQ$_JMS_ENQUEUE_BYTES_MESSAGE'
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored

           at oracle.jms.AQjmsProducer.enqueue(AQjmsProducer.java:1156)
           at oracle.jms.AQjmsProducer.publish(AQjmsProducer.java:1366)
           at oracle.jms.AQjmsProducer.publish(AQjmsProducer.java:1400)
           at oracle.oai.agent.common.jms.Publisher.send(Publisher.java:131)
           at oracle.oai.agent.common.jms.JMSManager.send(JMSManager.java:484)
           at oracle.oai.agent.server.messenger.mercury.MercuryMessenger.publish(MercuryMessenger.java:261)
           at oracle.oai.agent.server.OutMessageSender.processObject(OutMessageSender.java:106)
           at oracle.oai.agent.common.QueueAgentComponent.run(QueueAgentComponent.java:110)
           at java.lang.Thread.run(Thread.java:534)

      ========================
      Any help is appreciated.

      Thanks,
      Manoj