axonserver-migration tool with JDBC Axon schema

Imported from Google Groups
1

I did some experiments with migration to axon server based on https://docs.axoniq.io/reference-guide/operations-guide/setting-up-axon-server/tuning#migration

By default the AxonServer migration tool uses JPA entities. Therefore it requires proper schema structure with “snake_case” naming strategy, OID type etc. So we cannot simply use this tool for our project because we use JDBC and postgresql and our schema structure is different (naming and types). The error is quite obvious:
2020-06-26 15:42:04.187 ERROR 50902 — [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: relation “domain_event_entry” does not exist
(we have domainevententry)

Is it possible to configure the migration tool work with JDBC Axon schema? Do you have any ready-made solution for such case?

Thanks for any help,
Maciej

2

Hi Maciej,
You can create an orm.xml file which maps the expected names to the names you have in your environment. You should store this orm.xml file in the libs/META-INF directory below the directory where the migration tool is located.

Sample content for the orm.xml file:

<?xml version="1.0" encoding="UTF-8"?>

io.axoniq.axonserver.migration.jpa

I hope this helps.

Regards,
Marc