By default Jdeveloper works with Oracle databases.This article explains configuring Jdeveloper to work with MS SQL server
- Download MS SQL Server 2005 JDBC driver or suitable JDBC driver for your MS SQL server
- Extract this into your machine (assume program files). It should create folder called "Microsoft SQL Server 2005 JDBC Driver" or folder name be different based on your driver version.
- Search for sqljdbc.jar from above folder and copy this file into JDeveloper\JDBC\lib folder
- Close your Jdeveloper if it is opened
- Open JDeveloper/jdev/bin/jdev.conf file add following entry.
AddJavaLibPath C:/Program files/Microsoft SQL Server 2000 Driver for JDBC/lib.
Here path points to sqljdbc.jar file. If sqljdbc.jar is residing in other folder than above mentioned, then copy the correct folder path
- Open command prompt, go to JDEV_HOME/JDev/bin and execute following command
jdev -verbose (This will open JDeveloper) - Now go to JDeveloper > Connections > Database Connections > New Database Connection
- Select Third Party JDBC
- Specify MS Sql Server User Name, password and optional Role parameter
- In connection page specify following
- Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
- For class path browse to C:/Program files/Microsoft SQL Server 2000 Driver for JDBC/lib folder, select sqljdbc.jar add it as library. - Specify URL as following.
jdbc:sqlserver://DBHOSTNAME:;databaseName=MSSQLDBNAME
- Now test the connection
We need to set server CLASSPATH to include database driver jar file. This can be achieved in many ways.
- For standalone installation type, please make an entry into Oracle_Home/bpel/system/appserver/oc4j/j2ee/home/config/server.xml
- For middle tier installation type,please make an entry into Oracle_Home/j2ee/OC4J_BPEL/config/server.xml
Or - For standalone installation type, please drop jar file into Oracle_Home/bpel/system/appserver/oc4j/j2ee/home/applib
- For middle tier installation type,please drop jar file into
Oracle_Home/j2ee/OC4J_BPEL/applib
No comments:
Post a Comment