Using Jca Adapter With Osb 11
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 fileswere 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 changedslightly 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 itDBAdapters.
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 newdatabase 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. Inmy 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 aschema 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 BusConfiguration 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 theWSDL 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'...
Regístrate para leer el documento completo.