PostgreSQL with SQL Developer Issue

Question

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 

Anyone else having this issue?

The JDBC driver I am using is postgresql-8.4-701.jdbc4.jar.

Answer 1

If you have a different user and db name, SQLDevelopper 4.1 works with this workarround:

username: testuser password: mypass Host: 127.0.0.1:1234/testdb? Port: 1234 

Don't forget the "?" character. Then Select Database becomes available and connection works.

Thanks to Piperopoulos who helped me in this post: Oracle SQL Developer and PostgreSQL

Note that schema and tables are not listed by SQLDevelopper. You can use this request to list them manually:

select * from pg_catalog.pg_tables;