Re: procedure COUNTCOFFEE does not exist

thanks David,
 This will surely help me..


Regards,
Akhil Nagpal
  ----- Original Message -----
  From: David Jencks
  To: [email protected]
  Sent: Friday, February 21, 2003 11:19 AM
  Subject: Re: procedure COUNTCOFFEE does not exist


  You might take a look at the jboss jms adapter, which is used in jboss with the jbossmq jms implementation. I believe it has also been used with other jms implementations (Sonic??). So far it is a jca 1.0 adapter, using the jca features only for sending messages: message delivery to mdbs uses a somewhat similar architecture to that described by jca 1.5, but none of the interfaces.

  It's located in the connector module in the org.jboss.resource.adapter.jms package.

  david jencks

  On Thursday, February 20, 2003, at 08:43 PM, Akhil Nagpal wrote:


    HI All,
      i think i need to explain a bit more...what i am eager to know is like this..As per the JCA specification,  A resource Adapter is factory of connections and these connection canbe of database connections,JMS connections and SAP/R3 connections etc. So i want to know the scenario when a resource adapter will work as a factory for JMS connections.

    Thanks & Regards
    Akhil Nagpal

    ----- Original Message -----
    From: Akhil Nagpal
    To: [email protected]
    Sent: Thursday, February 20, 2003 7:39 PM
    Subject: procedure COUNTCOFFEE does not exist

    HI,
      I am trying to deploy the cciblackbox-tx sample connector implementation on weblogic7.0 with Oracle as database.
     I am able to get the connection object. then i create the CciInteractionSpec object and set the catalog,function name and schema as below.
       CciInteractionSpec iSpec = new CciInteractionSpec();
                iSpec.setSchema(user);  //user is username to database say this is = scott
                iSpec.setCatalog(null);
                iSpec.setFunctionName("COUNTCOFFEE"); // name of the function ihave created using the oracle.sql.

    The i create an object of record factory and indexRecord as below
                 RecordFactory rf = cf.getRecordFactory();
                IndexedRecord iRec = rf.createIndexedRecord("InputRecord");

    then i pass these two object to execute method of Interaction Object.

    It throws the exception on my app server.
    javax.resource.ResourceException: Cannot find procedure COUNTCOFFEE. Please check catalog, schema and function name.
            at com.sun.connector.cciblackbox.CciInteraction.exec(CciInteraction.java:125)
            at com.sun.connector.cciblackbox.CciInteraction.execute(CciInteraction.java:268)
            at examples.jconnector.cci.CoffeeEJB.getCoffeeCount(CoffeeEJB.java:59)


    I am not able to understand the cause behind it.

    This is my database information.
    username = scott
    password = tiger
    database instance name = test3
    i have the function in my database instance.

    i think i am passing some wrong information to the InteractionSpec object. Can any body please guide me what is wrong and how to make it perfect.

    Thanks & Regards
    Akhil Nagpal