My Oracle Support Banner

Write-Behind Caching Using an Oracle Database and PLSQL Bulk Binds (Doc ID 970104.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Personal Edition - Version 11.1.0.6 and later
Oracle Coherence - Version 3.7.1 and later
Universal Connection Pool - Version 11.1.0.7.0 and later
JDBC - Version 11.1.0.6 and later
Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Apr-2013***

Goal

Coherence supports transparent read-write caching of any datasource, including databases, web services, packaged applications and file systems; however, databases are the most common use case. In this example we show an effective way to use write-behind cache store which inserts cache entries using Oracle JDBC driver with PLSQL bulk binds. In this document, the cache entries are inserted from a Data Access Object (DAO) using PLSQL bulk binds.

Solution

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
Goal
Solution
 1. Database Setup
 2. Cache Server Setup
 3. Load Messages ANT Client demo
 Implementation Details
 More Information

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