Re: procedure COUNTCOFFEE does not exist

Hi Akhil,

For Oracle you have to set the catalog to the schema (user in case of oracle) so
that it sees the functions defined in the schema of oracle.

-Jignesh


|  Delivered-To: [email protected]
|  X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
|  X-Priority: 3
|  X-MSMail-priority: Normal
|  Date: Thu, 20 Feb 2003 19:39:19 +0900
|  From: Akhil Nagpal <[email protected]>
|  Subject: procedure COUNTCOFFEE does not exist
|  To: [email protected]
|
|  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

===========================================================================
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff CONNECTOR-INTEREST".  For general help, send email to
[email protected] and include in the body of the message "help".