My main question is: is there a way to use the JDBC plugin for Oracle just replacing the default serializer for a JSON serializer?
I have found some content in the official documentation of Akka Persistence and in the GitHub repository of the JDBC plugin but it seems that there is something missing yet to clue all the parts.
The documentation says:
Serialization is NOT handled automatically by Akka Persistence itself. Instead, it only provides the above described serializers, and in case a
AsyncWriteJournalplugin implementation chooses to use them directly, the above serialization scheme will be used. Please refer to your write journal’s documentation to learn more about how it handles serialization!
So, I went to documentation of Akka Persistence JDBC. The repository was migrated from https://github.com/dnvriend to Akka Github account.
Even so, I was able to find a pretty close example that I need here showing how create a custom serializer for JSON and use it in the JDBC pluging.
However, it uses PostgreSQL and it uses a journal-converter = “journal.JsonJournalSerializer” setting in JDBC plug settings. But, there is no reference to journal-converter parameter in the newest version of the JDBC plugin code.
That said, I am not sure if the current version of JDBC plugin still supports a custom serializer. Or, if should I try the path of write a completely custom Dao for this purpose.
Many thanks in advance,