What are the components of the JDBC URL for Oracle's "thin" driver and how do I use them?
Luigi Viggiano Briefly: jdbc:oracle:thin:@hostname:port:oracle-sid
- in green the Oracle sub-protocol (can be oracle:oci7:@, oracle:oci8:@, racle:thin:@, etc...) is related on the driver you are unsign and the protocol to communicate with server.
- in red the network machine name, or its ip address, to locate the server where oracle is running.
- in blue the port (it is complementary to the address to select the specific oracle service)
- in magenta the sid, select on which database you want to connect.
jdbc:oracle:thin:@MyOracleHost:1521:MyDBI've found sometime user/password encoded in the URL. I never used this form, but here's an example:
jdbc:oracle:thin:scott/tiger@MyOracleHost:1521:MyDBwhere user=scott and pass=tiger.