Specify where LDAP lookup occurs

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.

When used with other LDAP keywords, the SQLH_LOC keyword indicates where an LDAP lookup occurs.

SQLH_LOC can have a value of either CLIENT or PROXY. If the value is CLIENT, the driver performs the LDAP lookup on the client side. If the value is PROXY, the proxy performs the lookup on the server side. If no value is specified, the driver uses CLIENT as the default value.

Here is the format for an applet or application URL with LDAP keywords that specifies a server-side LDAP lookup:

jdbc:informix-sqli:ONEDB_SERVER=informix-server-name;
PROXY=proxy-hostname-or-ip-address:proxy-port-no?
PROXYTIMEOUT=60;SQLH_TYPE=LDAP;LDAP_URL=ldap:
//ldap-hostname-or-ip-address:ldap-port-no;LDAP_IFXBASE=dc=mydomain,dc=com;
SQLH_LOC=PROXY;

This example obtains the database server host name and port from an LDAP server:

jdbc:informix-sqli:ONEDB_SERVER=samsara;SQLH_TYPE=LDAP;
LDAP_URL=ldap://davinci:329;LDAP_IFXBASE=cn=informix,
o=kmart,c=US;LDAP_USER=abcd;LDAP_PASSWD=secret;SQLH_LOC=PROXY;
PROXY=webserver:1462

For a complete example of using an LDAP server with the proxy, see the proxy applet and application in the demo directory where your JDBC driver is installed.