Connecting to Ingres Using JDBC
JDBC Connection URL
JDBC Connection URL has the following format:
jdbc:ingres://<hostname>:<port>/<database>;UID=<user>;PWD=<password>
where:
jdbc:ingres://
Connects using the JDBC driver
hostname
localhost or the name of the computer you are connecting to
port
The port to connect to (three characters: the Ingres instance ID and the digit 7, for example: II7)
database
The name of the database you want to access
user
The user name to connect as
Note: User ID and password are optional when connecting to a local Data Access Server and the current operating system logged-in user is also a valid Ingres user.
password
The password
Example JDBC connection strings:
Local installation: jdbc:ingres://localhost:II7/testdb
Remote installation: jdbc:ingres://<hostname>:II7/testdb;UID=userid;PWD=password
For details, see DriverManager.getConnection method in the Connectivity Guide.