I recently came across a requirement to create a DB Adapter for doing some CRUD on MSSQL Server DB from OSB. There were a few problems that I faced and would like to share the details of what I followed for the same.
To create a DB Adapter in OSB 11g we would have to create the Adapter WSDL and EIS xml files in JDeveloper.
Here is a sequence of steps that can be followed to create a DB Adapter for MSSQL in OSB.
Add Oracle’s SQL JDBC driver (Present in Weblogic home/Server/lib) to JDeveloper. Files to copy would be weblogic.jar, wlclient.jar and wlsqlserver.jar.
Add these files to the JDeveloper classpath. Start JDeveloper 11g and create a new SOA Application. (Remember to add the SOA composite plugin for JDeveloper before this)
Now create a project in the application with any desired name.
Select project type as “Empty Composite”.
View original post 364 more words