SV: Using Postgres jdbc driver with Oracle SQL Developer

Sorry, "way to provide a default username" should have been "way to provide a default databasename"

Fra: Niels Jespersen <NJN(at)dst(dot)dk>
Sendt: 6. juli 2020 13:20
Til: pgsql-general(at)lists(dot)postgresql(dot)org
Emne: Using Postgres jdbc driver with Oracle SQL Developer

Hello all

Oracle SQL Developer allows you to add what they call a Third Party JDBC Driver. With that you can connect and use SQL Developer against Postgres. So far, so good. But when you connect, there is a button "Choose database" that fills a dropdown box with databasenames available on the cluster. This works great if you connect with the user named postgres, as it will connect to the database named postgres and check for available databases. However, if you try to connect using for instance username "user1" it will try to connect to a database named "user1" This mostly fails, since you most often does not have a database named exactly like your username.

I think this is a bug in Oracles call of Postgres jdbc, because it does not send a databasename, and the driver defaults to a database named as the username.

I may file a service request with Oracle to have this fixed down the road sometime.

In the meantime, is there a way to provide a default username to Postgres jdbc out-of-band from the actual calls from Oracle to Poostgres jdbc?

In the documentation https://jdbc.postgresql.org/documentation/head/connect.html#connection-parameters is says "If a property is specified both in URL and in Properties object, the value from Properties object is ignored." How can I inject a property object into the gap between Oracle and Postgres jdbc?

Regards Niels Jespersen