Re: procedure COUNTCOFFEE does not exist

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