Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

need help in conecting to host

 
kumar polisetty
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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="jdbcracle: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
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!