Meaningless Drivel is fun!
The moose likes Beginning Java and the fly likes Accessing Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "Accessing Database" Watch "Accessing Database" New topic

Accessing Database

Sita Yo

Joined: May 17, 2001
Posts: 12
I need to retrieve data from an Oracle database(on a unix machine) from another linux machine in the same network? Can anyone give me some ideas how I can do it? Using ordinary Java programs can do?
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
here you find the Oracle doc describing the way to create a connection.
In the getconnection "Myhos"t can be all oracle servers on your network. you can either set the ip address for this field!

Specifying a Database URL, User Name, and Password
The following signature takes the URL, user name, and password as separate parameters:
getConnection(String URL, String user, String password);

Where the URL is of the form:
jdbc racle:<drivertype>:@<database>

The following example connects user scott with password tiger to a database with SID orcl through port 1521 of host myhost, using the Thin driver.
Connection conn = DriverManager.getConnection
("jdbc racle:thin:@myhost:1521 rcl", "scott", "tiger");

If you want to use the default connection for an OCI driver, specify either:
Connection conn = DriverManager.getConnection
("jdbc racle ci8:scott/tiger@");
Connection conn = DriverManager.getConnection
("jdbc racle ci8:@", "scott", "tiger");

For all JDBC drivers, you can also specify the database with a Net8 keyword-value pair. The Net8 keyword-value pair substitutes for the TNSNAMES entry. The following example uses the same parameters as the preceding example, but in the keyword-value format:
Connection conn = DriverManager.getConnection
(jdbc racle ci8:@MyHostString","scott","tiger");

Connection conn = DriverManager.getConnection
("jdbc racle ci8:@(description=(address=(host= myhost)
(protocol=tcp)(port=1521))(connect_data=(sid=orcl)))","scott", "tiger");

Benjamin l´┐Żonard
[This message has been edited by Benjamin Leonard (edited May 25, 2001).]
Sita Yo

Joined: May 17, 2001
Posts: 12
Yes, that's right! But I need to load the driver first using:
However it got another message:
java.lang.ClassNotFoundException: sun/jdbc/odbc/OracleDriver
I think I don't have the Oracle drive in my machine. How can I install the Oracle driver in the linux machine??
Can anyone help me?!
Cindy Glass
"The Hood"

Joined: Sep 29, 2000
Posts: 8521
Get the Oracle cd from Oracle. When you load Oracle the driver comes with it. You need a license to use it.

"JavaRanch, where the deer and the Certified play" - David O'Meara
I agree. Here's the link:
subject: Accessing Database
It's not a secret anymore!