Write-Behind Caching Using an Oracle Database and PLSQL Bulk Binds
(Doc ID 970104.1)
Last updated on OCTOBER 17, 2023
Applies to:
Oracle Coherence - Version 3.7.1 and laterOracle Database - Enterprise Edition - Version 11.1.0.6 and later
Oracle Database - Standard Edition - Version 11.1.0.6 and later
Oracle Database - Personal Edition - Version 11.1.0.6 and later
JDBC - Version 11.1.0.6 and later
Information in this document applies to any platform.
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 |