skip to main content
About the Driver : Using the Driver : Connecting from an Application : Connecting Using the JDBC Driver Manager : Passing the Connection URL
  
Passing the Connection URL
After registering the driver, the required connection information must be passed in the form of a connection URL.

Syntax

jdbc:datadirect:redshift://servername:[port][;property=value[;...]]
where:
servername
specifies the name or the IP address of the server to which you want to connect.
port
specifies the port number of the server listener. The default is 5439.
property=value
specifies connection property settings. Multiple properties are separated by a semi-colon. For more information on connection properties, see Using Connection Properties.
The install_dir/samples directory, where install_dir is your product installation directory, contains a sample application that illustrates the steps of connecting to an Amazon Redshift database.
This example shows how to establish a connection to an Amazon Redshift database with user ID/password authentication:
Connection conn = DriverManager.getConnection
("jdbc:datadirect:redshift://Server3:5439;
DatabaseName=Test;User=admin;Password=adminpass");