This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Oracle d.b URL explanation please Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle d.b URL explanation please" Watch "Oracle d.b URL explanation please" New topic
Author

Oracle d.b URL explanation please

m.indira mandapati
Greenhorn

Joined: Feb 08, 2003
Posts: 6
Driver class name
oracle:jdbc river racleDriver
Connection
URL is jdbc racle ci8@connect_string active1ORCL

active1ORCL is {host=active1;port=1521; service=ORCL}
Please explain each part of URL.
As per my understanding
jdbc is the protocol
oracle is the database driver
oci8@connect_string active1ORCL represents how to connect to database server.where oci8 is oracle calling interface library inside the client machine. active1ORCL is the address of database server.
In that host = active1 '?' how do we find this (is it a server name)
port=1521 for oracle server port is always this ( am i right)
service =ORCL '?' is this an instance of server ,where can we find it?
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

How to Connect to Oracle. Just choose the OCI or thin driver for the URL explanation.
Jamie
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Oracle d.b URL explanation please
 
Similar Threads
Accessing Database
problems in setting SID/HOST/PORT
TNSAddress.SOException
Problem when developing EJB using WSAD to config Oracle DataSource
excepttion in thread "main" java.sql.SQLException: Io exception: The Network Adapter