Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 23 2015
Added on Feb 20 2015
4 comments
10,966 views