A review of Lotus Domino/notes toolkits (v) lddj

5 Lotus Domino Driver for Java

5.1 Function Introduction
LDDJ is a type 2 jdbc Driver that conforms to the JDBC1.0 specification and is developed under the jdk1.1.8 environment. It allows developers to access the Domino/notes database like a relational database through a Java program.
The following table is a control relationship between objects in the Notes database and objects in the relational database.
SQL Object Domino/notes Object tableform or Universal relationcolumnform field or view Columnindexviewviewview

Compared to relational databases, it has the following limitations:

The maximum string length is 15360
Table name is 64 characters long
Column name, index name, view name is 32 characters long
Rollback and two-phase commits are not supported
Bit,tinyint,bigint not supported
Binary,varbinary is not supported, that is, access to large objects is not supported
Primary Key,foreign Key,unique not supported
Stored procedures are not supported

At the same time, provide the following special features:

Column values are allowed to be multi-valued (text), accessible, but cannot be created by JDBC
For INSERT statements, the default value for the field, input conversion, and input checksum are still valid
Delete table, no data is deleted
Provides some built-in domains, such as Notesid, Notesform, lastmodified, etc.
Reader domain control of reading scope is still valid

In contrast to the notes data processing in other ways, there are the following differences:

You cannot insert a field that is not in the form definition
There are multiple fields with the same name in the document, only the first one (in order of creation)
If the view name and table Single-name are the same, only the Table object can be accessed and the View object cannot be accessed
For rich text fields, you can only work with the contents of a literal, not the attachment
Single domain content up to 15360 bytes
Support Platform
Windows 98,nt 4.0,2000,XP

Latest Version
v1.5, published in 2002.10.11

5.2 Development and use

Use environment
LDDJ v1.5 supports the R5 version above, can directly connect to remote Domino servers, requires local installation of domino/notes, and the current user has at least reader access to remote data.