Home
A plugin for Open Integration Engine that provides fast in-memory lookups against external databases using Google Guava LoadingCache.
The plugin does not own the data — external databases are the source of truth. The cache makes lookups fast.
Running OIE 4.5.2? Use v1.0.2. This release (v1.1.0+) targets OIE 4.6.0.
- An administrator defines a cache: name, JDBC connection, parameterized SQL query, key/value columns
- Channel code calls
$g('cache-name').lookup(key) - On the first call for a given key, the plugin runs the SQL query against the external database and stores the result in memory
- Subsequent calls for the same key return instantly from the cache — no database round-trip
- Entries are evicted automatically based on max size and inactivity timeout
- Administrators can explicitly refresh the cache to pick up data changes without restarting the server
- Lazy per-key loading — only fetches what's actually looked up
- HikariCP connection pooling — configurable pool size per cache to prevent connection storms
- Admin UI — create, edit, duplicate, delete, enable/disable cache definitions from the Settings tab
- Cache Inspector — view live statistics and browse cached entries
- REST API — full programmatic access for automation
- Password encryption — JDBC credentials encrypted at rest in the OIE database
- Event logging — mutating operations logged to the OIE Event Log for audit