Currently the Total cache SqlBeanDataLoader and MRU
cache SqlBeanMapMRUDataLoader utilize sql queries to
retrieve data from database. The two files attached
provide extended versions of these two data loaders,
where stored procedures can be used instead of sql
queries.
- The stored procedure configured with
StoredProcBeanDataLoader takes only one parameter
which is of type out and provides the cursor containing
the required details.
- The stored procedure configured with
StoredProcBeanMapMRUDataLoader takes two
parameters in the specified order. Output as the cursor
containing the data and input as the key for which data
is to be populated.
The two files are attached with this request.
Zip containing the two java files