procedure COUNTCOFFEE does not exist

Akhil Nagpal <[email protected]> Thu, 20 Feb 2003 19:39:19 +0900
Newsgroups gmane.comp.java.sun.connector
Message-ID <002501c2d8cc$52b55a20$3e340746@egodesk>
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