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:1 
> 25)
>         at  
> com.sun.connector.cciblackbox.CciInteraction.execute(CciInteraction.jav 
> a: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
>