4.9 How do you Query the Published Content for Displaying on Websites?

Once the data has been published over to the target server, the applications need to query the published data (content files and their associated properties and attributes) for display on the website.

This is where Documentum JDBC Services, formerly known as eConnector for JDBC, comes into the picture. JDBC is a standard interface to access a database from Java-based applications.

4.9.1 Documentum JDBC Services

Documentum JDBC Services is a Documentum utility tool that supports most of the standard JDBC APIs and helps applications perform the following functions:

• Making connections to either Docbase or SCS repository.

• Issuing DQL queries in Docbase or SQL queries in SCS repository.

• Retrieving content files and associated metadata (attributes) from Docbase or SCS repository.

• Connecting to databases using logical names rather than their actual names through its support for JNDI (Java Naming and Directory Interface).

• Reusing existing...