A Frequently Asked Questions

While starting the adapter, I get the following message. What could be the reason?

Error Message:

Error happened when reading wsdl at "Datatypes_Read.wsdl", because "WSDLExceptio
n: faultCode=PARSER_ERROR: Error reading file at: file:/C:/Oracle/MidHome/integr
ation/interconnect/adapters/JCAAPP/Datatypes_Read.wsdl: C:\Oracle\MidHome\integr
ation\interconnect\adapters\JCAAPP\Datatypes_Read.wsdl (The system cannot find t
he file specified)".
Make sure wsdl exists at that URL and is valid.
        at com.collaxa.cube.ws.wsdl.WSDLUtils.readWSDL(WSDLUtils.java:164)
        at oracle.oai.agent.adapter.service.ServiceBridge.start(ServiceBridge.ja
va:210)
        at oracle.oai.agent.proxy.AgentProxy.go(AgentProxy.java:672)
        at oracle.oai.agent.proxy.AgentProxy.start(AgentProxy.java:706)
        at oracle.oai.agent.proxy.AgentProxy.<init>(AgentProxy.java:415)
        at oracle.oai.agent.service.AgentService.run(AgentService.java:43)
        at java.lang.Thread.run(Thread.java:534)
Service started successfully.

Solution

In iStudio, you imported the WSDL while defining the application view in the publish, subscribe, invoke, and implement wizard. The imported WSDl file should be present in the home directory of the adapter. If the WSDL file is not present in the home directory of the adapter, you get this error message.

Adapter gives the Address Location Exception. What could be the reason?

The value of the jca:address location parameter in the WSDL file and value of the connection1_name parameter in the adapter.ini file is not same. These values should be same. For example:

WSDL File

<service name="Datatypes_Read">
  <port name="Datatypes_Read_pt" binding="tns:Datatypes_Read_binding">
    <jca:address location="eis/DB/DB" UIConnectionName="DB"
     ManagedConnectionFactory="oracle.tip.adapter.db.DBManagedConnectionFactory"
     mcf.DriverClassName="oracle.jdbc.driver.OracleDriver"
     mcf.PlatformClassName="oracle.toplink.internal.databaseaccess.      
     DatabasePlatform"
     mcf.ConnectionString="jdbc:oracle:thin:@localhost:1521:orcl"
     mcf.UserName="dbapp"
     mcf.Password="7347B141D0FBCEA0B136BF4D7C3600BC"
    />
  </port>
</service>

Adapter.ini File

connection1_name=eis/DB/DB
connection1_mcf_class=oracle.tip.adapter.db.DBManagedConnectionFactory
connection1_mcf_params={ConnectionString=jdbc:oracle:thin:@localhost:1521:orcl, DriverClassName=oracle.jdbc.driver.OracleDriver, UserName=scott, Password=tiger}

Adapter fails while processing messages after I changed input part name (or output part name or operation name) in the WSDL file.

If you modify the values of input part, output part, operation name or the xsd in the WSDL file, then you have to re-define the design time by importing the edited WSDL again.

How do I know the JCA adapter started properly?

View the log.xml file located in the time-stamped subdirectory of the JCA adapter logs directory.

The JCA adapter did not start properly: what is wrong?

View the exceptions in the adapter log file (log.xml). The exceptions should provide information about what went wrong. It is possible that the JCA adapter is unable to connect to the repository. Ensure the repository is started properly. The JCA adapter will connect to the repository once it is started properly. You do not need to restart the Adapter.

Is it possible to edit the JCA adapter configuration settings created during installation?

Yes, edit the parameters in the adapter.ini file in the following directory:

When I change an element in iStudio, such as mappings, it seems like the JCA adapter uses old information. What is happening?

The JCA adapter caches information from iStudio. The information is stored in the repository locally. If you change something in iStudio and want to view the change in the runtime, then you need to stop the JCA adapter, delete the JCA adapter cache files, and restart the JCA adapter.

The JCA adapter has a persistence directory which is located in the JCA adapter directory. Deleting this directory when the JCA adapter has been stopped should make it obtain the new metadata from the repository when started.

How do I secure my passwords?

OracleAS Integration InterConnect uses Oracle Wallet Manager to maintain system passwords. When you install OracleAS Integration InterConnect, Oracle Wallet Manager is also installed and a password store is created. All passwords used by OracleAS Integration InterConnect components are stored in the password store. The password is stored in the Oracle Wallet in the following format:

ApplicationName/password

The ApplicationName is the name of the application, which is extracted from the adapter.ini file of the corresponding adapter. In the adapter.ini file, the application parameter specifies the ApplicationName to which this adapter connects. The password for the application is also retrieved from the adapter.ini file.

The number of entries is dependent on the type of adapter. For example, DB Adapter needs two entries whereas AQ Adapter needs only one entry. The following table lists the entries that will be created for each adapter:

You can create, update, and delete passwords using the oraclewallet command. When you run the command, it prompts you for the admin password.

You can use the following commands to manage your passwords:

• List all passwords in the store

  oraclewallet -listsecrets
  
  

• Create a password

  oraclewallet -createsecret passwordname
  
  

  For example, to create a password for the hub schema:

  oraclewallet -createsecret hub_password
  
  

• View a password

  oraclewallet -viewsecret passwordname
  
  

  For example, to view the password for the hub schema:

  oraclewallet -viewsecret hub_password
  
  

• Update a password

  oraclewallet -updatesecret passwordname
  
  

  For example, to update the password for the hub schema:

  oraclewallet -updatesecret hub_password
  
  

• Delete a password

  oraclewallet -deletesecret passwordname
  
  

  For example, to delete the password for the hub schema:

  oraclewallet -deletesecret hub_password