URL of Oracle thin driver.
1 posts in topic
Flat View  Flat View

Posted By:   lakshman_prasad
Posted On:   Monday, June 4, 2001 04:19 AM

What are the components of the JDBC URL for Oracle's "thin" driver and how do I use them?

Re: URL of Oracle thin driver.

Posted By:   Luigi_Viggiano  
Posted On:   Monday, June 4, 2001 04:40 AM

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 wich database you want to connect.

example: jdbc:oracle:thin:@MyOracleHost:1521:MyDB
About | Sitemap | Contact