Wednesday 23 March 2016

How to download JDK on linux command line?

If you try to download JDK using wget your command might fail with a 302 error. You need to set some options as mentioned below to download the JDK.


wget --no-check-certificate --no-cookies --header "Cookie: oraclelicense=accept-securebackup-cookie" http://download.oracle.com/otn-pub/java/jdk/8u73-b02/jdk-8u73-linux-x64.tar.gz


Wednesday 11 March 2015

How to connect Oracle SQL Developer to PostgreSQL database?


As Oracle users many of us are familiar with Oracle SQL Developer. But when we move to PostgreSQL we use PgAdmin as a GUI client to connect to PostgreSQL database.
If our use case is simple, soon we will start missing SQL Developer as it was better compared to PgAdmin. Good news is with SQL Developer 4.0.1.14 we can connect to PostgreSQL database.
Though it will not give you complete Oracle kind of experience it is worth giving a try if you are used to SQL Developer.

Following are the steps to configure Oracle SQL Developer with PostgreSQL Server.

1. Download PostgreSQL JDBC driver from the following link.

https://jdbc.postgresql.org/download.html

2. Open Oracle SQL Developer.

3. Goto Tools->Preferences as shown below.



4. Goto Database->Third Party JDBC Drivers as shown below.



5. Click on Add Entry and Navigate to the folder where you have downloaded the JDBC driver as part of step #1.

6. Click OK.

7. Now you will be able to create connections to PostgreSQL database using the new tab shown in the connection window as shown below.