Using PeppolReportStorageSQL

[RohiNof]

Hello,
There is some code that currently saves reports like this:

// TODO eventually change to a different storage form
final IPeppolReportStorage aReportingStorage =
    new PeppolReportStorageFileXML(
        new File(AS4Configuration.getDataPath(), "peppol-reports"),
        IPeppolReportStorageFilenameProvider.DEFAULT
    );
final PeppolReportingSupport aPRS = new PeppolReportingSupport(aReportingStorage);

How can I use PeppolReportStorageSQL instead of PeppolReportStorageFileXML?

[phax]

Use this block instead:

   try (final PeppolReportSQLHandler aHdl = new PeppolReportSQLHandler (APConfig.getConfig ()))
    {
      final PeppolReportStorageSQL aReportingStorage = new PeppolReportStorageSQL (aHdl, aHdl.getTableNamePrefix ());
      final PeppolReportingSupport aPRS = new PeppolReportingSupport(aReportingStorage);

[RohiNof]

Thanks!

[RohiNof]

I get the following error when saving a report:

org.postgresql.util.PSQLException: ERROR: relation "peppol_report" does not exist
java.lang.IllegalStateException: Failed to create new SQL DB entry (-1)
java.lang.IllegalStateException: Failed to insert Peppol Report into SQL DB

Did I miss a configuration step, or do I need to manually create the database tables?

[phax]

I am not a Postgres expert - most likely you need to create the database manually and assign the appropriate user to it.
If you want Flyway to create the schema (if it is not the default value public), you must also set jdbc.schema-create=true in your configuration

[RohiNof]

Thank you. I had used the same database to save both peppol_reporting_item and peppol_sending_report, but by using separate schemas for each, the problem was resolved.
Also, your projects are awesome!

[phax]

Thanks - glad you were able to solve it. The projects always appreciate a star :)