I'm trying to use a very simple key/value table, where both the key and the
value are byte arrays. The key is limited to 64 bytes length, the value can
be a lot bigger (I'm using a blob for that).
I've read documentation and googled for two days now but I haven't found a
working solution that is working on Oracle (Oracle 18c xe, ojdbc8). I've got
something working on Postgres, but I cannot get this working on Oracle.
What is the recommended data type in Oracle and how do I tell OpenJPA what
the data type in Oracle is, e.g. what annotations/properties do I have to
The error that I'm getting is "Caused by:
org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00932: inconsistent
datatypes: expected - got BLOB"