-
Bug
-
Resolution: Done
-
Major
-
5.1.5.FINAL
-
None
-
Workaround Exists
-
I've configured a JdbcStringBasedCacheStore with a VARCHAR(4000) key column and a BLOB value column. If I try to store a BLOB value of less than 4000 bytes, everything works fine. If the value is greater, the cache store fails with ORA-24816. This occurs because the BLOB column is not the last one in the PreparedStatement SQL as the Oracle driver requires. My current, sad workaround is to clone the JdbcStringBasedCacheStore implementation and write my own insert/update SQL in storeLockSafe(). This works fine, but obviously isn't ideal from an upgrade point of view. Simply overriding storeLockSafe() isn't an option due to all the private fields.
- is related to
-
ISPN-701 New JDBC CacheStore implementation w/ more flexible vendor-specific extension and binary key column support
- Closed