Using JCA Adapter with OSB 11.1.1.3

In OSB 10g to use the JCA adapters you were required to use JDeveloper to create the necessary WSDLs and XSDs etc using the associated adapter wizard. These files were imported into Oracle Workshop (Eclipse) and used to create the business service as you would any other web service. In 11g unfortunately JDeveloper is still required. The process has changed slightly as described below. As an example I have used the JCA DB adapter as an example.

1. Start JDeveloper 11.1.1.3
2. Create a new SOA Application
3. Create a new SOA Project and call it DBAdapters.
   
   
4. Choose the Empty Composite Template
   
   
5. Drag a Database Adapter Component to the External References panel on the composite. Provide a service name.
   
   
6. Create a new database connection, or use an existing one
   
   
7. Take note of the JNDI Name, e.g.
   
   eis/DB/MyConnection
   
   This will be used to configure the DB connection in the WebLogic Console.
8. In my example I use a stored procedure, but you can use what ever operation you require. Please refer to the following link for other options: User's Guide for Technology Adapters
   
   
9. Select a schema and stored procedure
   
   
10. Once the procedure has been selected, accept the defaults and finish.
11. Startup your OEPE version of Eclipse.
12. Create a new Oracle Service Bus Configuration Project (you can use an existing project if you have one)
13. Create a new Oracle Service Bus Project in the configuration project created above.
14. Instead of importing the WSDL and XSD files you import the jca file created in JDeveloper. In Eclipse right click the Oracle Service Bus Project and select Import -> Import
    
      
15. Choose File System
    
    
16. Browse to the directory where JDeveloper stores its project
    
    
17. Select the jca, wsdl, and xsd files based on the service you created in step 5. Also check the 'Create selected folders only' radio button.
    
    
18. When you import you may have a little red x indicating the files are invalid. This is due to the location of the files. Open the invalid files and fix the path in relation to where you store your files in the OSB project.
    
     
19. Once you have the files all valid, Right-Click the jca file and select Oracle Service Bus -> Generate Service. This will create a new Business Service.
    
    
20. In the WebLogic Console configure the JNDI name defined in step 7.
21. You can now deploy your project and test