Improving Performance with Paging feature of Web sphere Adapter for JDBCv7.5

In this post just I want share the new feature which I observed while working with JDBC outbound Adapter (Retrieve All operation) in BPMv7.5.

Some times we need to retrieve the specific records per page While working with JDBC outbound Adapter (Retrieve All operation).

For example ,Lower memory and bandwidth requirement,as the JDBC adapter just need to read the specific records per page.

We can achieve this by using simple paging technique of JDBC Adapter. If you observe below figure1.

We have two options here

1)Start index to return records.

2)Number of records per page.

Start index to return records ,indicates that the starting index to return the records for retrieve all Operation.

Note :-index starts with 0

Number of records per page,indicates how many records you want to retrieve per page.

 figure1:

Here I done the simple application for demonstration .This Application aim to retrieve specified no of records per page. If you observe figure2. I configured the Retrieve All operation with below values

Start index to return records to 4

Number of records per page to 10

So it retrieves the 10 records per page starting from 5 record in the database.

You can download this sample Application from the below link:-

Download JDBC_Paging_Test _APP

figure2: