Skip to content
A new version of the good old tool 'DQL Tester'
HTML Java CSS
Branch: master
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.idea <F9> should be disabled if no connection! Sep 5, 2019
src User help and short-cut reference links Oct 15, 2019
.gitignore settings.properties should be in the /config folder! Jul 8, 2019
CONTRIBUTING.md
Color palette by Paletton.com.html First root styling is done. Aug 19, 2019
DQL Tester FX.iml Rename of the project and preparation to get opensource on github Oct 22, 2018
LICENSE Initial commit Oct 23, 2018
README.md Update in the minimal required dependencies Jul 30, 2019
pom.xml User help and short-cut reference links Oct 15, 2019

README.md

Quality gate

DQL Tester FX

With new technologies, new tools will be created!

This slogan made me start this project where we want to create a new version of the good old 'DQL Tester' tool.

'DQL Tester' supports the administration tasks on a Documentum environment. With this project a new version of 'DQL Tester' is under construction and made available for everyone who wants to join our development team.

The 'FX' postfix in the title makes it clear we use the new JavaFX technology to create standalone applications.

Feature list

  • Execute DQL queries with the result in a table view
  • Browse the repository
  • Dump and modify properties
  • Administration tasks
    • Running jobs
    • User/Group management
    • Updates in security
  • Execute API and DQL scripts

Requirements for this application

  • A Java Runtime Environment (JRE) (e.g. OpenJDK Runtime Environment 18.9 (build 11.0.1+13))
  • JavaFX libraries (as they are not included in OpenJDK!). Downloadable fom JavaFX SDK
  • A runnable OpenText Documentum environment that can be pinged by hostname or IP-address from the machine where this application will be executed
  • DFC and BPM/PE libraries. These can be downloaded from OpenText My Support

How to run the application:

  1. Download the latest release to the local drive from
  2. In the download directory create a sub directory named: lib
  3. Copy the following DFC jar files in this lib directory
    • aspectjrt.jar
    • certj.jar
    • commons-lang-2.4.jar
    • cryptoj.jar
    • dfc.jar
    • log4j.jar
    • bpm_infra.jar (BPM / Process Engine)
  4. Copy the following jar files in this lib directory from the download locations
  5. In the download directory create a sub directory named: config
  6. Create a new file called dfc.properties in the config directory with this content
    dfc.docbroker.host[0]=<host; hostname or ip-address>
    dfc.docbroker.port[0]=<port; default 1489>
    dfc.globalregistry.repository=<repository_name>
    dfc.globalregistry.password=<dm_bof_registry (encrypted) password>
    dfc.globalregistry.username=dm_bof_registry
    dfc.session.secure_connect_default=native
    dfc.date_format=dd/mm/yyyy hh:mi:ss
    
  7. Create a new file called log4j.properties with this content in the config directory
    log4j.rootCategory=INFO, A1, F1
    log4j.category.MUTE=OFF
    log4j.additivity.tracing=false
    
    #------------------- CONSOLE --------------------------
    log4j.appender.A1=org.apache.log4j.ConsoleAppender
    log4j.appender.A1.threshold=ERROR
    log4j.appender.A1.layout=org.apache.log4j.PatternLayout
    log4j.appender.A1.layout.ConversionPattern=%d{ABSOLUTE} %5p [%t] %c - %m%n
    
    #------------------- FILE --------------------------
    log4j.appender.F1=org.apache.log4j.RollingFileAppender
    log4j.appender.F1.File=C\:/Documentum/logs/log4j.log
    log4j.appender.F1.MaxFileSize=10MB
    log4j.appender.F1.layout=org.apache.log4j.PatternLayout
    log4j.appender.F1.layout.ConversionPattern=%d{ABSOLUTE} %5p [%t] %c - %m%n
    
  8. Start a CMD prompt and give these commands (point to your own path as these are samples)
  • cd "c:\DQL Tester FX"

It's the location of the downloaded DQLTesterFX-xxx.jar and just created lib and config directory

  • set PATH_TO_FX="c:\javafx-sdk-11.0.1\lib"

Sets the path to the extracted JavaFX runtime libraries

  • "c:\jdk-11.0.1\bin\java.exe" --module-path %PATH_TO_FX% --add-modules=javafx.controls,javafx.fxml -cp DQLTesterFX-xxx.jar;lib\*;config nl.bos.Main

For a direct login, pass 3 parameters:

  • "c:\jdk-11.0.1\bin\java.exe" --module-path %PATH_TO_FX% --add-modules=javafx.controls,javafx.fxml -cp DQLTesterFX-xxx.jar;lib\*;config nl.bos.Main <REPOSITORY_NAME> <USERNAME> <PASSWORD>
You can’t perform that action at this time.