Good day,
What tecniques are used when developing GUI applications with JDBC connect to remote database if some clients will be behind HTTP Proxy servers?
Any recomendations how to build such apps?
Thanks in advance.
Here are a couple of my thoughts.
When you say GUI I'm making the assumption that you are talking about a single tier / rich client application written using Swing.
It is impractical to develop a single tier GUI application with JDBC to connect to a public database server on the Internet. The architecture is simply to difficult to implement because of the wide variety of security mechanisms in place on the Internet. Worse yet, attempting to make it work will open up security holes on the users computer.
A more common approach would be to use a web server / application server to manage the database access (sometimes called 2 tier or multi-tier). This would of course require you to write a web based interface for user interaction.
If you require a single tier GUI application with JDBC to connect to a private database server through (not on) the Internet that can often be done using a Virtual Private Network (VPN).
There might be other options (there are actually) but it depends on what your are hoping to accomplish. The single sentence from your post probably isn't enough to discuss a full blown architecture.
