Creating a SOA-MDS connection in Jdeveloper is a fairly straight forward affair. You create a new database connection in Jdeveloper resource palette to the MDS repository using the correct user.
Next, create a new SOA-MDS connection in resource palette. Select Connection Type :-> DB Based MDS. Choose the previously create database connection to the MDS repository. Next, select the MDS partition.
Wait. No partitions are being displayed. Jdeveloper bug?
I remember while creating weblogic data source for the application database, I’ve selected a sql server driver from weblogic instead of adding the microsoft provided one to the classpath. Lets try using this driver to setup a database connection in Jdeveloper.
Create a new library in Jdeveloper for the WebLogic SqlServer driver. The weblogic sqlserver driver is located at /wlserver10.3/server/lib/wlsqlserver.jar. Make sure you enter the driver class as:
weblogic.jdbc.sqlserver.SQLServerDriver
Delete the previously created MDS repository connection. Create a new one using the weblogic driver library. Now try creating the SOA MDS connection
Voila !
- Fusion Applied Training Mobile Apps Released - August 26, 2018
- Using RPA vs API based Integration - June 7, 2018
- Chatbots with DialogFlow and AWS Rest Services - May 9, 2018