Format of database URLs

1 jdbc:informix-sqli://hostname:portnum /database_name:? USER=userid;PASSWORD=password? INFORMIXSERVER=servername;? CSM=(SSO=database_server@realm,ENC=true)}+ ;;name=value

1 jdbc:informix-direct://database_name:;?user=userid;password=password?+ ;;name=value

hostname

This required parameter specifies the host name of the computer that is running the HCL OneDB™ database server.

This parameter is required for client-side JDBC, unless the SQLH_TYPE property is defined or the IFXHOST property is used. This parameter is optional for server-side JDBC.

portnum

This required parameter specifies the port number of the HCL OneDB database server. The value of the port number and server name is listed in the /etc/services file.

This parameter is required for client-side JDBC unless the SQLH_TYPE property is defined. This parameter is optional for server-side JDBC.

database_name

This required parameter specifies the name of the HCL OneDB database to connect to. If you do not specify the name of a database, a connection is made to the HCL OneDB database server.

This parameter is not required except for connections from web applications running in the database server.

INFORMIXSERVER=servername

This optional parameter specifies the name of the database server to connect to. For example, INFORMIXSERVER=lo_informix1210.

USER=userid

This optional parameter specifies the user ID that is used in connections to the HCL OneDB database server.

This parameter is optional, however, if you specify userid then you must also specify the PASSWORD. If you do not specify the USER and PASSWORD, the driver calls System.getProperty() to obtain the name of the user currently running the application, and the client is assumed to be trusted.

For SSO, you must specify the user and password or the CSM setting.

PASSWORD=password

This optional parameter specifies the password for the specified user ID.

This parameter is optional, however, if you specify password then you must also specify the USER. If you do not specify the USER and PASSWORD, the driver calls System.getProperty() to obtain the name of the user currently running the application, and the client is assumed to be trusted.

SSO=database_server@realm

This required parameter specifies the service principle for (SSO) access control. For more information, see ids_jdbc_069.html#ids_jdbc_069.

name=value

This optional parameter specifies the name-value pair that specifies a value for the HCL OneDB environment variable that is contained in the name variable, which is recognized by either HCL OneDB JDBC Driver or by HCL OneDB database servers. The name variable is not case-sensitive.

For more information, see Specify properties and environment variables with the HCL OneDB JDBC Driver.

If an LDAP server or sqlhosts file provides the IP address, host name, or port number through the SQLH_TYPE property, you do not have to specify them in the database URL. For more information, see Dynamically reading the sqlhosts file.