Username & Password in JDBC Connection URL

Question

I was using a SQuirrel SQL Client to connect & browse my oracle database servers. I have given the credentials in the connection URL itself. But it still prompts for the username and password. Does it really required to provide additional username/password while establishing connection. Won't it take it from the connection URL?

jdbc:oracle:thin:username/[email protected]:1521:DBName

Answer 1

Thin driver Oracle's JDBC Thin driver uses Java sockets to connect directly to Oracle. It provides its own TCP/IP version of Oracle's SQL*Net protocol. Because it is 100% Java, this driver is platform independent and can also run from a Web Browser (applets). There are 2 URL syntax, old syntax which will only work with SID and the new one with Oracle service name.

Old syntax

jdbc:oracle:thin:@[HOST][:PORT]:SID

New syntax

jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE

On new syntax SERVICE may be a oracle service name or a SID.

There are also some drivers that support a URL syntax which allow to put Oracle user id and password in URL.

jdbc:oracle:thin:[USER/PASSWORD]@[HOST][:PORT]:SID

jdbc:oracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE

source: http://www.orafaq.com/wiki/JDBC

Answer 2

Refer to this link, it will help you.

https://jdbc.postgresql.org/documentation/80/connect.html

For example, if you want to include username & password in the Postgres connection string.

jdbc:postgresql://postgres-10.4.cluster:5432/default?user=postgres&password=postgres