File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle d.b URL explanation please" Watch "Oracle d.b URL explanation please" New topic

Oracle d.b URL explanation please

m.indira mandapati

Joined: Feb 08, 2003
Posts: 6
Driver class name
oracle:jdbc river racleDriver
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.
I agree. Here's the link:
subject: Oracle d.b URL explanation please
It's not a secret anymore!