Format of database URLs
The format of a database URL is determined by whether you are connecting from a client or on the database server.
Note: Starting OneDB JDBC Driver version 8.1.1.3, the use of LDAP to retrieve OneDB server
connectivity information from a stored SQLHost files inside of an LDAP server has been
removed.
For connections from a client, use the following format:
- hostname
- This required parameter specifies the host name of the computer that is running the HCL OneDB™ database server.
- portnum
- This required parameter specifies the port number of the HCL OneDB database server.
- 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.
- USER=userid
- This optional parameter specifies the user ID that is used in connections to the HCL OneDB database server.
- PASSWORD=password
- This optional parameter specifies the password for the specified user ID.
- name=value
- This optional parameter specifies the name-value pair that specifies a value for the HCL OneDB properties 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.
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 HCL OneDB sqlhosts file.
In the following example, the connection syntax for a client-side connection is shown:
jdbc:onedb://123.45.67.89:1533/testDB; user=rdtest;password=test