First of all you will need the sqljdbc.jar. You can download it from the Microsoft site. sqljdbc.jar is available across different versions SQL Server 2000, SQL Server 2005, etc. I'm connecting to SQL Server 2K here using JDeveloper 10133.
Once downloaded, we need to add it to the JDeveloper Libraries. I have listed here the steps to create a user library from JDeveloper Help:
- From the main menu, choose Tools Manage Libraries.
- In the Manage Libraries dialog, select the Libraries tab, then select the User node, and click New.
- In the Create Library dialog, enter a library name, select the Source Path node, and click Add Entry .
- In the Select Path Entry dialog, browse to the location of the drivers for the database you are connecting to. Select the driver files, and click Select.
- In the Create Library dialog, click OK, and in the Manage Libraries dialog, click OK .
We can add this library while creation of databse also, but adding first using Manage Libraries is a good practice.
Now in JDeveloper, go to Connection Navigator, Right-Click on Database and select "New Database Connection" from the context menu. Follow the wizard as displayed below:
Select the last option "Thid Party JDBC Driver" from the drop-down.
On the next page, provide valid UserID and Password.
On step 3
For Driver Class, name is com.microsoft.sqlserver.jdbc.SQLServerDriver, and select the library sqljdbc.jar from Manage Libraries as we have added above.
Define the URL as below
Click Next and Test the connection.
Let me know if you are facing any issues.
Note : Before deploying BPEL process, we need to deploy sqljdbc.jar file to two different locations on the server: soa_home/bpel/lib and soa_home/j2ee/home/applib. For more info..., refer to http://forums.oracle.com/forums/thread.jspa?threadID=978304&tstart=0