1.

What Are The Components Of The Jdbc Url For Oracle's "thin" Driver And How Do I Use Them?

Answer»

Briefly: jdbc:oracle:THIN:@hostname:port:oracle-sid

  1. 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.
  2. in red the network machine name, or its ip ADDRESS, to locate the server where oracle is running.
  3. in blue the port (it is complementary to the address to select the specific oracle service)
  4. in magenta the sid, select on which database you want to CONNECT.
example:
jdbc:oracle:thin:@MyOracleHost:1521:MyDB
Here's an example:
jdbc:oracle:thin:scott/tiger@MyOracleHost:1521:MyDB
where user=scott and pass=tiger.

Briefly: jdbc:oracle:thin:@hostname:port:oracle-sid


Discussion

No Comment Found

Related InterviewSolutions