My Oracle Support Banner

How To Limit The Connections Used By WebCenter Portal While Navigating Around WebCenter Pages (Doc ID 1460583.1)

Last updated on JULY 27, 2023

Applies to:

Oracle WebCenter Portal - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Symptoms

In an 11.1.1.5 WebCenter Portal installation, it is possible to create a page containing a Mashup task flow.
If a link is created back to the current page, using the Hyperlink component, then the number of connections used is increased by one every time the link is used.
Creating a link via the 'Links component' doesn't have the same effect.

Steps to reproduce
1. Login as weblogic user
2. Click on Adminstration
3. Resources
4. Created a Mashup data sources connecting to DEV_ACTIVITIES data source with the following SQL

SELECT name_, path_ FROM
asdim_wc_documen_0 WHERE objecttype_=:object AND CONTEXT_ is not NULL
AND lastmodified between SYSDATE-5 and SYSDATE+1 and rownum < 6
order by lastmodified DESC


Bind parameter : object=DOCUMENT

5. Make all data sources available using the SHOW link
6. Create a Mashup taskflow from the Resources Menu - Test1TaskFlow
7. Edit it and added Test1 data source in TABLE format.
8. Created a new page and give access to PUBLIC to view
9. Added Test1TaskFlow to page.
10. Page URL is http://<HOST>:<WCP_PORT>/webcenter/spaces/page/PageWithTaskFlow
11. Opened console http://<HOST>:<WLS_PORT>/console
12. Selected Environment-->Servers-->WC_Spaces--> Monitoring-->JDBC--> and note the number of connections.

13 Edit the page
a) Add a the Links component, and add a page link and select the current page
b) Add a HyperLink component, and edit it to go to http://<HOST>:<WCP_PORT>/webcenter/spaces/page/PageWithTaskFlow

After clicking on link from step a) the connection count did not increase.
After clicking on the link from step b) the connection count did increase on each click.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.