Setting up Eclipse Store to point to the Spring DataSource

[tschuehly]

I want to configure EclipseStore to use the configured Spring HikariDataSource.

I have the following config:

@Configuration
@Lazy
public class EclipseStoreConfiguration {

  private static final Logger log = LoggerFactory.getLogger(EclipseStoreConfiguration.class);

  @Bean
  @Qualifier(DEFAULT_QUALIFIER)
  @Lazy
  public EmbeddedStorageFoundationSupplier<EmbeddedStorageFoundation<?>> defaultStorageFoundationSupplier(
      EclipseStoreProperties eclipseStoreProperties,
      EmbeddedStorageFoundationFactory foundationFactory,
      HikariDataSource dataSourceProperties
  ) {

    SqlFileSystem storageFilesystem = createDatabaseStorageFileSystem(dataSourceProperties);
    StorageConfiguration configuration = Storage.Configuration(
        Storage.FileProvider(storageFilesystem.ensureDirectoryPath("storage"))
    );
    return () -> foundationFactory.createStorageFoundation(eclipseStoreProperties)
        .setConfiguration(configuration)
        .onConnectionFoundation(executor -> {
          executor.setReferenceFieldEagerEvaluator(new EagerStoringFieldEvaluator());
          BinaryHandlersJDK17.registerJDK17TypeHandlers(executor);
        });
  }

  private static @NotNull SqlFileSystem createDatabaseStorageFileSystem(HikariDataSource dataSource) {
    var isOracle = dataSource.getDriverClassName().contains("oracle");
    SqlProvider database;
    if (isOracle) {
      database = SqlProviderOracle.New(dataSource);
    } else {
      database = SqlProviderPostgres.New(dataSource);
    }
    return SqlFileSystem.New(
        SqlConnector.Caching(
            database
        )
    );
  }
}

But it creates a folder with "storage". How can I tell the foundationfactory to use the configured SqlFileSystem?
@zdenek-jonas

[hg-ms]

The configuration problem is most likely caused by two conflicting configurations.
The ‘EmbeddedStorageFoundationFactory’ internally creates a configuration based on the config properties that is used to initialize the storage foundation. Setting second configuration later has no effect.
Combining the Spring boot property based config with second config is not supported.
To solve that you must not use the `EmbeddedStorageFoundationFactory’ of the spring boot integration. Create the foundation manually instead:

StorageConfiguration configuration = Storage.Configuration(Storage.FileProvider(storageFilesystem.ensureDirectoryPath("storage")));
return EmbeddedStorageFoundation.New().setConfiguration(configuration);