Using JCA Adapter with OSB 126.96.36.199
By James Taylor on May 27, 2010
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.
- Start JDeveloper 188.8.131.52
- Create a new SOA Application
- Create a new SOA Project and call it DBAdapters.
- Choose the Empty Composite Template
- Drag a Database Adapter Component to the External References panel on the composite. Provide a service name.
- Create a new database connection, or use an existing one
- Take note of the JNDI Name, e.g.
This will be used to configure the DB connection in the WebLogic Console.
- 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
- Select a schema and stored procedure
- Once the procedure has been selected, accept the defaults and finish.
- Startup your OEPE version of Eclipse.
- Create a new Oracle Service Bus Configuration Project (you can use an existing project if you have one)
- Create a new Oracle Service Bus Project in the configuration project created above.
- 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
- Choose File System
- Browse to the directory where JDeveloper stores its project
- 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.
- 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.
- 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.
- In the WebLogic Console configure the JNDI name defined in step 7.
- You can now deploy your project and test