Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the components of the JDBC URL for Oracles “thin” driver and how do I use them?

April 26, 2017components driver JDBC Oracle URL

0

Posted

What are the components of the JDBC URL for Oracles “thin” driver and how do I use them?

1 Answer

0

Posted

Location: http://www.jguru.com/faq/view.jsp?EID=444466 Created: Jun 24, 2001 Author: Luigi Viggiano (http://www.jguru.com/guru/viewbio.jsp?EID=101985) Question originally posed by lakshman prasad (http://www.jguru.com/guru/viewbio.jsp?EID=423825 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. example: jdbc:oracle:thin:@MyOracleHost:1521:MyDB I’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:MyDB where user=scott and pass=tiger.