File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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!