Re: Help with JDBC connection to Oracle RDB database...

A typical is :-
url = jdbc:oracle:thin:_at_xxx.xxx.xxx.xx:1521:sid

or for jdbc2.0 try

private OracleConnectionPoolDataSource ocpds;

   ocpds = new OracleConnectionPoolDataSource();

   ocpds.setServerName(ip);

   ocpds.setDatabaseName(sid);

   ocpds.setDriverType("thin");

   ocpds.setPortNumber(portNo);

   ocpds.setNetworkProtocol("tcp");

   where the sid etc are the ones that you use Hope this helps
Bill

"bob brown" <bobrown_at_start.com.au> wrote in message news:afe84a4.0205200040.484c0443_at_posting.google.com...
> Hi,
>
> I have a java program that wants to connect to the Oracle RDB database
> from Solaris using the JDBC thick (OCI8) driver.
>
> Situation is
> The Oracle RDB database resides on a VMS server.
> The Web application resides on Solaris box.
>
> I tried to connect to the Oracle RDB database using the following
> connection parameters but without success (no results)
>
> connections=10
> driver=oracle.jdbc.driver.OracleDriver
>
database=jdbc:oracle:oci8:_at_(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP )(PORT=1527)(HOST=aotcsrv)))(CONNECT_DATA=(SID=siddev)))
> username=devdb
> password=devpass
>
> If you have success in this area, can anyone help me please....
>
> Thanks in advance
> BOB
>
> (Sorry I post in three NG because it covers the three main topics).
Received on Mon May 20 2002 - 20:59:42 CEST