# LDAP JDBC Driver

October 11, 2006

### 1.0 LDAP JDBC Driver

The LDAP JDBC* Driver is a Java* database connectivity driver that enables Java programs to execute SQL (Structured Query Language) statements to access Novell® eDirectoryTM. JDBC is similar to ODBC, but it has been designed to work specifically with Java programs.

### 2.0 What’s New

In this release, support for referral is available.

### 3.0 Installation

The default install location of this component is c:\novell\ndk\ndssdk folder, which might require an update to your CLASSPATH statement.

### 4.0 Dependencies

The LDAP JDBC Driver has the following dependencies.

- Basic Functionality: LDAP Service Provider for JNDI. The standard controls are included in JDK 1.2 and above. Novell-specific controls and extensions are included in the LDAP Controls and Extensions for JNDI component and can be downloaded from the NDK at: (http://developer.novell.com/ndk/ldapjndi.htm).
- Basic Functionality: The driver requires a connection to an LDAP v2 or v3 compliant directory.
- Secure Connection: LDAP Service Provider for JNDI must be configured for SSL connections.
- Effective Rights table: requires eDirectory 8.5 or above, and LDAP Extensions and Controls for JNDI: (http://developer.novell.com/ndk/ldapjndi.htm).

### 5.0 Performance Tuning

When the JDBC driver fetches large amount of data from LDAP and processes it to client, the data builds up and the exceeds the default virtual memory limit. The java.lang.OutOfMemory exception is thrown. The possible solution for this situation is, increase the virtual memory of the JVM*. Increasing the available JVM heap size is simply done with the -Xmx parameter to the JVM.For example:

    java -Xmx256m

IMPORTANT:You should not increase the virtual memory more than the physical memory of your machine.

### 6.0 Limitations

The following list details the limitations of the LDAP JDBC Driver:

- A nested sub-query with the same objectClass (Table name) is not supported.
- This driver is a read-only type, that supports only select queries.
- With Crystal Reports* XI, queries that contain NDS_Context, NDS_FullName, or NDS_Name in a Where clause do not give complete results.

  As a workaround, append a comma (,) to the end of the value field. For example, select CN,SN from inetOrgPerson where NDS_Context='ou=tc1,o=TestCycle1,'.

### 7.0 Documentation Conventions

In this documentation, a greater-than symbol (>) is used to separate actions within a step and items in a cross-reference path.

A trademark symbol (® , TM, etc.) denotes a Novell trademark; an asterisk (*) denotes a third-party trademark.

### 8.0 Legal Notices

Novell, Inc. makes no representations or warranties with respect to the contents or use of this documentation, and specifically disclaims any express or implied warranties of merchantability or fitness for any particular purpose. Further, Novell, Inc. reserves the right to revise this publication and to make changes to its content, at any time, without obligation to notify any person or entity of such revisions or changes.

Further, Novell, Inc. makes no representations or warranties with respect to any software, and specifically disclaims any express or implied warranties of merchantability or fitness for any particular purpose. Further, Novell, Inc. reserves the right to make changes to any and all parts of Novell software, at any time, without any obligation to notify any person or entity of such changes.

Any products or technical information provided under this Agreement may be subject to U.S. export controls and the trade laws of other countries. You agree to comply with all export control regulations and to obtain any required licenses or classification to export, re-export, or import deliverables. You agree not to export or re-export to entities on the current U.S. export exclusion lists or to any embargoed or terrorist countries as specified in the U.S. export laws. You agree to not use deliverables for prohibited nuclear, missile, or chemical biological weaponry end uses. Please refer to www.novell.com/info/exports/ for more information on exporting Novell software. Novell assumes no responsibility for your failure to obtain any necessary export approvals.

Copyright © 2006 Novell, Inc. All rights reserved. No part of this publication may be reproduced, photocopied, stored on a retrieval system, or transmitted without the express written consent of the publisher

For Novell trademarks, see Novell Trademark and Service Mark list (http://www.novell.com/company/legal/trademarks/tmlist.html)

All third-party products are the property of their respective owners.