SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue connecting to PostgreSQL with Oracle SQL Developer

user2277610Feb 20 2015 — edited Feb 23 2015

I'm trying to connect to a PostgreSQL 9 database using Oracle SQL Developer 4.1.0.17_29, but I'm not having any success so far.

I added my Third Party JDBC drivers for PostgreSQL, the tab shows up.

However, after I fill in the Username/Pwd and Hostname/Port and then select Choose Database - I get:

Failure -FATAL: database "user1" does not exist

After some researches, it seems that SQLDevelopper is not able to connect a Postgre DB with a different "user name" and "database name". It works only of both are same.

Is it a bug or is it a known limitation ?

The JDBC driver I am using is postgresql-9.4-1200.jdbc41.jar (also tried with postgresql-9.3-1103.jdbc3.jar).

Thanks for your help,

Elise.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2015

Added on Feb 20 2015

#sql-developer, #sqldeveloper

4 comments

11,586 views