aspose file tools*
The moose likes JDBC and the fly likes need help in conecting to host Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "need help in conecting to host" Watch "need help in conecting to host" New topic
Author

need help in conecting to host

kumar polisetty
Greenhorn

Joined: Mar 20, 2007
Posts: 1
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: need help in conecting to host