Proxy server
- Last Updated: October 31, 2023
- 1 minute read
- DataDirect Connectors
- JDBC
- Documentation
This string includes the properties you may need to connect through a proxy server with user ID/password authentication.
jdbc:datadirect:greenplum://servername:port;ProxyHost=proxy_host;
ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;
AuthenticationMethod=userIdPassword;User=userID;
Password=password;[property=value[;...]];
where:
- servername
-
is the IP address or name of the server to which you are connecting.
- port
-
is the number of the TCP/IP port.
- proxy_host
- specifies the proxy server to use for the first connection.
- proxy_password
- specifies the password needed to connect to a proxy server for the first connection.
- proxy_port
- specifies the port number where the proxy server is listening for
requests for the first connection. The default is
0.
- proxy_user
- specifies the user name needed to connect to a proxy server for the first connection.
- userID
-
specifies the user ID that is used to connect to the Greenplum database.
- password
- specifies a password that is used to connect to your Greenplum database.
- property=value
- specifies connection property settings. Multiple properties are separated by a semi-colon.
The following example connection string includes the properties required for using a proxy server with user ID/password authentication.
Connection conn = DriverManager.getConnection
("jdbc:datadirect:greenplum://server1:5432;ProxyHost=pserver;
ProxyPassword=secret;ProxyPort=808;ProxyUser=jsmith;
AuthenticationMethod=userIdPassword;User=test;Password=secret;");