Hi ,
I am trying to connect to oracle database which exisits in a different firewall. For connecting to that databse i need to go through a socks5 proxy server.
i need code snippet/reference which can help me in getting through a proxy server and then connect me to the databse in question to extract the data.
i have set the properties like..
Properties systemSettings = System.getProperties();
systemSettings.put("http.proxyHost", "Socks-server.xxx.xx.com");
systemSettings.put("http.proxyPort", "1080");
System.setProperties(systemSettings);
conn="jdbc:oracle:thin:@<host>:port:sid";
connection = DriverManager.getConnection(conn,"<userId>" ,"<passwrd>");
any particular API to connect through/by pass the socket% proxy server
shoukd we use SSL and then open the
JDBC connetion.
curently i get a msg
"Exception raised java.sql.SQLException: Io exception: The Network Adapter could not establish the connection" this is due to the socket5 proxy not bypassd. not aware how to bypass it.
kindly assist me.
regards
kiran