How to configure a PostgreSQL datasource in Spring

[fschon]

Can someone please help in explaining how to configure a PostgreSQL datasource using Springboot.
I have checked the documentaiton page at https://docs.eclipsestore.io/manual/storage/storage-targets/sql-databases/postgresql.html
but this does not really cover how this is done in SpringBoot.

Thanks for the assistance.

[fschon]

I made some progress. All the properties needed to be prefixed with "org.eclipse.store."
So they become:

org.eclipse.store.storage-filesystem.sql.postgres.data-source-provider=com.sample.MyDataSourceProvider
org.eclipse.store.storage-filesystem.sql.postgres.catalog=mycatalog
org.eclipse.store.storage-filesystem.sql.postgres.schema=myschema
org.eclipse.store.storage-filesystem.sql.postgres.url=jdbc:postgresql://localhost:5432/mydb
org.eclipse.store.storage-filesystem.sql.postgres.user=username
org.eclipse.store.storage-filesystem.sql.postgres.password=secret

Now the database is created, but I get an exception:

Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.eclipse.store.storage.embedded.types.EmbeddedStorageManager]: Factory method 'embeddedStorageManager' threw exception with message: Active storage for org.eclipse.store.storage.types.Database$Default@64bbc1db "Eclipse Serializer@storage" already exists.
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:171) ~[spring-beans-6.0.13.jar:6.0.13]
at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:650) ~[spring-beans-6.0.13.jar:6.0.13]
... 36 common frames omitted
Caused by: org.eclipse.store.storage.exceptions.StorageExceptionInitialization: Active storage for org.eclipse.store.storage.types.Database$Default@64bbc1db "Eclipse Serializer@storage" already exists.
at org.eclipse.store.storage.types.Database$Default.guaranteeNoActiveStorage(Database.java:105) ~[storage-1.2.0.jar:na]
at org.eclipse.store.storage.types.Databases$Default.ensureStoragelessDatabase(Databases.java:87) ~[storage-1.2.0.jar:na]
at org.eclipse.store.storage.embedded.types.EmbeddedStorageFoundation$Default.ensureDatabase(EmbeddedStorageFoundation.java:752) ~[storage-embedded-1.2.0.jar:na]
at org.eclipse.store.storage.embedded.types.EmbeddedStorageFoundation$Default.createEmbeddedStorageManager(EmbeddedStorageFoundation.java:780) ~[storage-embedded-1.2.0.jar:na]
at org.eclipse.store.storage.embedded.types.EmbeddedStorageFoundation.createEmbeddedStorageManager(EmbeddedStorageFoundation.java:171) ~[storage-embedded-1.2.0.jar:na]
at org.eclipse.store.integrations.spring.boot.types.EclipseStoreProviderImpl.createStorage(EclipseStoreProviderImpl.java:56) ~[integrations-spring-boot3-1.2.0.jar:na]
at org.eclipse.store.integrations.spring.boot.types.EclipseStoreProviderImpl.createStorage(EclipseStoreProviderImpl.java:50) ~[integrations-spring-boot3-1.2.0.jar:na]
at org.eclipse.store.integrations.spring.boot.types.EclipseStoreBeanFactory.embeddedStorageManager(EclipseStoreBeanFactory.java:59) ~[integrations-spring-boot3-1.2.0.jar:na]
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) ~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:580) ~[na:na]
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:139) ~[spring-beans-6.0.13.jar:6.0.13]
... 37 common frames omitted

Do I need to somehow supress the default filesystem datasource?

[zdenek-jonas]

Please provide repo with code. I can help then. The new Spring Integration will be released soon.

[fschon]

Thanks. I unfortunately cannot release the repo code as it is proprietary. I will wait for the next spring integration.

[fschon]

Circling back to this, I upgraded to 1.3.1 and the same exception occurs. Is there a skeleton SpringBoot example project that is known to work that uses SQL datastores available? Would be great for S3 as well as I also cannot get that to work.