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");
or:
Connection conn = DriverManager.getConnection
("jdbc racle ci8:@(description=(address=(host= myhost)
(protocol=tcp)(port=1521))(connect_data=(sid=orcl)))","scott", "tiger");
------------------
Benjamin l�onard
www.evisor.com [This message has been edited by Benjamin Leonard (edited May 25, 2001).]
