The following example URL connects to an Informix server running on a host on IP address 192.168.0.100, port 1533, database name ADDM_IMPORT, INFORMIXSERVER ADDMserver, user fred, and password password. jdbc:informix-sqli://192.168.0.100:1533/ADDM_IMPORT:INFOMIXSERVER=ADDMserver; user=fred;password=password
The following example URL connects to a MySQL server running on a host on IP address 192.168.0.100, port 3306, database name ADDM_IMPORT, user fred, and password password. jdbc:mysql://192.168.0.100:3306/ADDM_IMPORT?user=fred&password=password
The following example URL connects to a Postgres server running on a host on IP address 192.168.0.100, port 5432, and database name ADDMdatabase. jdbc:postgresql://192.168.0.100:5432/ADDMdatabase
The following example URL connects, using a thin driver, to an Oracle server running on a host on IP address 192.168.0.100, port 1521, and service ADDM_DB. jdbc:oracle:thin:@//192.168.0.100:1521/ADDM_DB
Connection using SID
jdbc:oracle:<drivertype>:@host[:port]:SID
The following example URL connects, using a thin driver, to an Oracle server running on a host on IP address 192.168.0.100, port 1521, and SID ADDM100. jdbc:oracle:thin:[username/password]@192.168.0.100:1521:ADDM100
The following example URL connects to an Ingres server running on a host on IP address 192.168.0.100, port mnemonic II7, database name ADDMdatabase, user fred, and password password. jdbc:ingres://192.168.0.100:II7/ADDMdatabase;user=fred;password=password
The following example URL connects to a Sybase server running on a host on IP address 192.168.0.100, port 6689, and database name ADDM_DB. jdbc:sybase:Tds:192.168.0.100:6689/ADDM_DB
The following example URL connects to an instance of MS SQL server called TDA running on a host on IP address 192.168.0.100, port 1433, user fred, and password password. The username and password correspond to a user configured on the database rather than a Windows AD user. See this Microsoft article for more information. jdbc:sqlserver://192.168.0.100\TDA:1433;User=fred;Password=password
The following example URL connects using JTDS to an MS SQL server server running on a host on IP address 192.168.0.100, port 1433, database name ADDM_IMPORT, instance TDA, user fred, and password password. jdbc:jtds:sqlserver://192.168.0.100:1433/ADDM_IMPORT; instance=TDA;user=fred;password=password
When using a domain credential (Windows Authentication) of the form DOMAINNAME\username enter the username in the URL described, and the domain information in the Additional JDBC parameters dialog box in the following form: domain="DOMAINNAME". Also, if the domain controller requires NTLM v2 add the parameter: useNTLMv2=true
The following example URL connects using JTDS to an MS SQL server server running on a host on IP address 192.168.0.100, port 1433, database name ADDM_IMPORT, instance TDA, Windows user fred in the domain DOM1, and password password. jdbc:jtds:sqlserver://192.168.0.100:1433/ADDM_IMPORT; instance=TDA;domain=DOM1;useNTLMv2=true;user=fred;password=password