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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s