ERROR: "A semicolon is needed after property value ERRORCODE=-4461" OM Web Viewer 12.1

Products

• Output Management Web Viewer

Issue/Introduction

When configuring the database with the ConfigTool for IBM Db2 JDBC driver, continually get error:

"A semicolon is needed after property value ;. ERRORCODE=-4461, SQLSTATE=42815 Error Code: -4461"

However, all property values have a semicolon after them.

Sometimes after running the ConfigTool, will get PERSISTENCE.JDBCJarPath=<CAOMWV12_HOME>/config/JDBC/db2jcc4.jar
and other times configutil will give a null value PERSISTENCE.JDBCJarPath=

Environment

• IBM Db2
• Red Hat
• Output Management Web Viewer 12.1
  
  

Cause

Configuration

Resolution

This is the correct format:

jdbc:db2://hostName:port/database_name:currentSchema=SCHEMA_NAME;

See the IBM documentation for diagrams:

URL format for IBM Data Server Driver for JDBC and SQLJ type 4 connectivity