Oracle Sql Developer is a powerful tool for accessing Oracle databases.
The developers who are familiar with Sql Server Management Studio will certaily like this tool.
The steps given below is for developers having difficulty in using SQL Developer on Windows 64 bit OS.
Ensure that, you have latest version of JDK installed in your system.
You can get the JDK from the location given below,
While downloading JDK, select the operating system as Windows 64 bit
Download SQL Developer (for Windows 64 bit) from the following location,
Extract the zip file. Locate the sqldeveloper.exe and double click it.
It will ask you to locate the java.exe file.
Now, browse to the location where the JDK is installed and locate the java.exe file.
Usually, it will be like,
Set the TNS names correctly in the tnsnames.ora file. The file is usually located in a location as shown below,
Now, launch the SQL Developer.exe.
Provide the database details you wish to connect to.
One of my team member was complaining to me that, the application works good at his development system but, when deployed to QC, the particular page throws a null exception.
I found that, the code ‘HttpContext.Current.Session[Constant.SortDirection]’ is causing the error and the Current is null.
Inorder to fix this issue, the Session state should be set properly for the application in IIS.
Earlier, Session state was disabled because of which, the Current object is null. After setting the Session state, it worked correctly.