Creating a DBAdapter for MSSQL Server in OSB 11g

Oracle Technologies Primer

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”.

Now add…

View original post 364 more words

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.