Write-Behind Caching Using An Oracle Database and Standard JDBC Batching (Doc ID 977633.1)

Last updated on MARCH 12, 2024

Applies to:

Goal

Coherence supports transparent read-write caching of any datasource, including databases, web services, packaged applications and filesystems; however, databases are the most common use case. In this example we will setup write behind cache config using standard JDBC batching which ensures we have portable code which can be used across other back end database rather then just Oracle.

For a more effective solution specific to a back end Oracle Database using PLSQL bulk binds see <Note 970104.1>

Solution

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