Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 6 down vote favorite
2

I am developing a client-server software, where the client connects to the database server as follows.

...
try
{
   Class.forName("com.mysql.jdbc.Driver");
   Connection conexion = DriverManager.getConnection("jdbc:mysql://localhost/agenda", "root", "LA_PASSWORD");
}catch....
...

Both applications are always on the same local network. The problem I have is when the local network uses a proxy, in this case the MySQL connection fails.

How I can make a connection with the Java programming language, a MySQL database when a proxy on the local network?.

Thanks for the help. Greetings!

share|improve this question
3  
What do you mean "the local network uses a proxy" ? Do you mean an HTTP proxy? MySQL uses a binary protocol not HTTP. Is the connection being blocked by a firewall? – artbristol Jul 1 '11 at 8:20
Yes, i mean an HTTP PROXY. Thanks. – Lobo Jul 14 '11 at 16:27
@Lobo your proxy required authentification by user & psw ??? – mKorbel Jul 14 '11 at 17:57
@mKorbel yes, is required. – Lobo Jul 16 '11 at 13:05

1 Answer

up vote 7 down vote accepted
+50

Try using socksProxyHost and socksProxyPort system properties. Look here at chapter "2.4) SOCKS" and here. (The http.proxyHost will not work with JDBC.) Here is description of use proxy with JDBC (Oracle for example): Connect outside internet Oracle Database from inside intranet through JDBC. You may want to use properties: socksProxySet, socksProxyPort, socksProxyHost, java.net.socks.username, java.net.socks.password. Here is description how to set version, username and password. And ofc you need socks proxy, not HTTP.

If you only have HTTP proxy you can try to tunnel JDBC through HTTP. There are few solutions. For example here is free solution http://sourceforge.net/projects/sqlgateway/ and here commercial http://www.idssoftware.com/jdbcdrv.html

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.