Hi 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? Thanks
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@"); or: 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");
Yes, that's right! But I need to load the driver first using: Class.forName("sun.jdbc.odbc.OracleDriver"); 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?! Thanks