Let us discuss how to configure JDeveloper in our system, we are here discussing in Windows environment stepwise.
Step 1: First step is we need to set the Jdev environment variables for windows. Go to environment variable in windows properties. Right Click on Computer/My Computer select properties. The same scenario is shown in the below figure.
Select Advanced System Settings after choosing the Properties of Computer, the same scenario is shown in the below figure:
Now in the top User Variables select New Button for adding a New User variable as shown in the below figure:
Note that you must give the Variable name as “JDEV_USER_HOME”, and Variable Value is the path of the jdevhome\jdev. Let us consider as an example I downloaded the patch and extracted it to Bharath\Softwares in D: drive now my path for Variable value is:
The same thing is shown in the below figure:
Step 2: After setting Variable name and Variable value we need to select DBC file into from Oracle Apps fnd top, copy DBC file and paste it in JDeveloper patch.
To know where exactly the DBC file is located in Oracle Apps go to About this Page and select Java System Properties tab then in the list we can find a System Property called DBC FILE, in the Value behind to DBC FILE is the path where exactly the DBC file located in the Oracle Apps.
The same scenario is shown in the below figure:
Step 3: After finding where exactly the DBC file located go to that particular path and copy the DBC file (note that don’t delete the dbc file and also don’t cut it).
Here we are using WinScp which connects to the server from our desktop system, we can also use putty to connect to the server or any other tool which works similarly like WinScp or Putty connection manager.
Install WinScp, and the following figure shows the icon how it looks like:
While giving path name directly don’t give /naora1.dbc, according to the above figure give the path as
After giving path you will find DBC file just copy it, the same scenario is shown in the below figure:
After copying in your desktop system go to the jdevhome folder, then jdev, next dbc_files, and then next secure, here we will not find any files or documents the folder is empty now we need to paste the DBC file which we copied from the Oracle Apps Instance Server.
The following figures show the same scenario:
Step 4: After pasting the DBC file now open the JDeveloper and create the Data Base Connection. After opening the file, it will ask for Configure File Type Associations, on checkbox check all the available types to associate with JDeveloper. The below figure shows how the opening page looks like:
Step 5: Create a database connection, go to Connections tab after that Right Click on Data Base folder and then select New Database Connection…, the same scenario is shown in the below figure:
After selecting New Database Connection… Welcome to the create Data Base connection window opens simply click on Next button. After that give the Connection Name here in the below figure if we observe the connection name is NewtonApples, and the Connection Type must be Oracle (JDBC)
Click on next button after giving Connection Name, in the next window it asks for username and password give Toad/Oracle SQL Developer tool connection name. The same scenario is shown in the below figure:-
After giving Username and Password click on the Next button, now you need to give connection details all the connection details we even can find in DBC file, to check those detail open the DBC file with notepad there you can find Host Name, JDBC Port, and Service Name. Give appropriate names and note that Driver type is thin.
Now after giving proper names click on the Next button, we can find Test Connection button click on the Test Connection button to check the connection is success or not.
Click Next button and then click Finish button.
Step 6: This is the last step in JDeveloper configuration, set the JDeveloper default Project Properties. Go to Tools à Default Project Properties. The same scenario is shown in the below figure:
After selecting Default Project Properties… from Tools menu, in the highlighted Project Properties extract Oracle Applications and select Run time Connection.
The same scenario is shown in the below figure:
Now give the following details:
DBC File Name: Give the path where exactly the DBC File is stored which we copied from server to our desktop system.
User Name: The username is Oracle Apps instance User Name
Password: Password is Oracle Apps instance Password.
Application Short Name: Any application short name which user got access permit and also note that whatever the application short name we are giving it must contain at least one OAF page, and also that must be attached to the responsibility of the User Name which we are giving.
Responsibility Key: Responsibility key of the Application Short Name.
The below figure shows the example showing DBC file path, User Name, Password, Application Short Name, Responsibility Key. Just have a look at the picture.
Finally click on OK button, so that we finished our JDeveloper Configuration process.
Check out our Popular Trainings