JDev/ADF sample - Fix for View Criteria Search Results with DB Pooling Enabled

• Fix for View Criteria Search Results with DB Pooling Enabled. In order to minimize DB connections usage and optimize ADF runtime performance I often prefer to enable DB pooling and keep data between requests in memory (jbo.doconnectionpooling = true and jbo.txn.disconnect_level = 1). Read more in this post - Stress Testing Oracle ADF BC Applications - Do Connection Pooling and TXN Disconnect Level. There is one bug related to the View Criteria search results - rows are not always displayed correctly. I will describe the fix.

Download - SearchRefreshDBPoolApp.zip

JDev/ADF sample - Stress Testing Oracle ADF BC Applications - Do Connection Pooling and TXN Disconnect Level

• Stress Testing Oracle ADF BC Applications - Do Connection Pooling and TXN Disconnect Level. Today I will describe how jbo.doconnectionpooling = true and jbo.txn.disconnect_level = 1 properties affect ADF application performance. Read more about these properties - ADF BC Tuning with Do Connection Pooling and TXN Disconnect Level. Previous posts related to ADF BC application stress testing - Stress Testing Oracle ADF BC Applications - Internal Connections

Download - stresstest_v3.zip

JDev/ADF sample - Stress Testing Oracle ADF BC Applications - Internal Connections

• Stress Testing Oracle ADF BC Applications - Internal Connections. We had productive discussion with Chris Muir for my previous post - Stress Testing Oracle ADF BC Applications - Passivation and Activation (see post comments). Two questions were discussed:
  
  1. Importance of AM Maximum Pool Size
  2. Higher than expected DB connection usage during stress test
  
  I did additional stress tests (download JMeter config file - AMTest.jmx) and was able to get more information from test results - I would like to share with you. Download test case application updated for this post - stresstest_v2.zip.

JDev/ADF sample - Stress Testing Oracle ADF BC Applications - Passivation and Activation

• Stress Testing Oracle ADF BC Applications - Passivation and Activation. When we are talking with customers about Oracle ADF performance, very often we can hear such question - "Hey, ADF works well when there are few concurrent users, how it behaves when there is more serious load?". In order to answer this question I will publish series of posts, where we will study different parameters for AM pool tuning and test AM pool configuration under stress loads. Today we will see how stable is AM pool passivation/activation mechanism.

Download - stresstest_v1.zip and AMTest.jmx