Can Java program establish JDBC Connection via Proxy Server

Question

I want to communicate to Oracle DB Server which sits outside my network via the proxy server. I can access the web application hosted on the same machine via Browser with proxy settings. Can a simple Java program establish JDBC Connection thru the proxy server?

*To provide an example will be better *

Regards.

Community · Accepted Answer · 2017-05-23 11:46:10Z

6

If the proxy is only a HTTP proxy, then no. But if the proxy transfers TCP/IP trafic, then you can.

How to do that, look at How do I set the proxy to be used by the JVM or http://docs.oracle.com/javase/6/docs/technotes/guides/net/proxies.html

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Sep 13, 2012 at 11:03

kovica

2,6234 gold badges22 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tagar · Accepted Answer · 2020-06-10 20:14:24Z

2

Oracle JDBC (and any other JDBC connections to that extent) are not HTTP-based protocols, so the proxying has to be done at TCP layer.

For this reason, you can't use Squid Proxy for example (which only does proxying at HTTP layer), but there are many other proxying services that can work at TCP layer:

nginx proxy
haproxy

On the former there is a nice step by step guide how to setup JDBC proxying using NGINX https://kwjrnl.wordpress.com/2015/07/27/tcp-proxy-with-nginx-for-jdbc-connection/

edited Jun 10, 2020 at 20:14

answered Jun 10, 2020 at 18:52

Tagar

15k7 gold badges102 silver badges116 bronze badges

Collectives™ on Stack Overflow

Can Java program establish JDBC Connection via Proxy Server

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related