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