Board index Database Programming

Connecting to Oracle Remote Server through a proxy/firewall Linux using JDBC driver

Connecting to Oracle Remote Server through a proxy/firewall Linux using JDBC driver

Post by Rockfie » Wed, 14 May 2003 06:06:03



I would really appreciate your help if you know how to connect to an
Oracle Remote Server when your LAN has a proxy/firewall Linux in the
middle.

I'm trying with the following method:


    "(description="+
    "(address_list="+
    "(address=(protocol=tcp)(port="+ port +")(host="+ proxy +"))"+
    "(address=(protocol=tcp)(port=1521)(host="+ host +")))"+
    "(connect_data=(sid=MyOwnSID))(source_route=yes))";

  Connection oracle = DriverManager.getConnection(url,login,password);

But I get this exception:
java.sql.SQLException: Excepcin de E/S: Got minus one from a read
call

Does anybody know something I should do or I'm doing wrong???

Thanks

Raymond Rockfield

 
 
 
Top

1. Problem connecting an oracle client behind Wingate proxy server to an oracle server not behind proxy

I have installed an oracle client (Forms Runtime) behind Wingate proxy
server. When I tried to connect to the server that is not behind any
proxy server I couldnt reach preferable IP (server IP). Somehow I
cant connect to destination IP.

I put in tnsnames.ora the following lines:

PROD.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = 1521))
    (CONNECT_DATA = (SID = PROD))
  )

Client machine can connect to Internet while surfing over the Internet
with Internet Explorer but only via proxy server. Is there anything I
should put that client will first connect to proxy and to server:

Network 1 (CLIENT->PROXY)------->Netvork 2 (SERVER)

Any help is appreciated, Boris

Sent via Deja.com http://www.deja.com/
Before you buy.

2. dBase IV landscape printing

3. using Informix JDBC HTTP proxy servlet from an applet that sits behind a network proxy

4. D2: Programatically copying TTables (Paradox)?

5. Proxy table - can't connect to remote server

6. How can I get DTS Send Mail and text file capture of status messages to work with DTSrun

7. Oracle 8 and a Proxy Server or Firewall Product

8. [ADMIN] v7.1b4 bad performance

9. Accessing Oracle server from client which is behind firewall/proxy on intranet

10. How to connect remote SQL 2000 Server Behind firewall

11. connecting to a remote server using vb+sql server using ADO

12. Connecting to remote MSAccess from linux via JDBC:ODBC bridge

13. connecting to a remote server using vb+sql server using ADO


All times are UTC
Board index