MetaSolv Solution - JDBC Connection Leak in the Service Request Search Window (Doc ID 2000127.1)

Last updated on JULY 21, 2016

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms

The Service Request Search window has a connection leak as it uses the MetaSolv.utilities.powerbuilder.Update framework to issue a SELECT statement instead of MetaSolv.utilities.powerbuilder.Populate.  There is no call to MetaSolv.utilities.powerbuilder.Commit within the process so the tbs.exe client holds a reference to the connection for reuse.

Below is an image of the tbs,exe client and its SQL Spy session showing usage of the MetaSolv.utilities.powerbuilder.Update framework.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms