Register Postgres database as DataSource

[cossey50]

Hi everyone,

I have been trying to set up a connector that uses a local Postgres database for storing asset, policy, contract definitions etc.
Right now I use this dependency in my build file:

implementation("org.eclipse.edc:control-plane-sql:0.0.1-milestone-8")

and these properties which I derived from this page.

edc.datasource.asset.name=asset
edc.datasource.asset.url=jdbc:postgresql://localhost:5432/asset
edc.datasource.asset.user=<user>
edc.datasource.asset.password=<password>

edc.datasource.contractdefinition.name=contractdefinition
edc.datasource.contractdefinition.url=jdbc:postgresql://localhost:5432/contractdefinition
edc.datasource.contractdefinition.user=<user>
edc.datasource.contractdefinition.password=<password>

edc.datasource.contractnegotiation.name=contractnegotiation
edc.datasource.contractnegotiation.url=jdbc:postgresql://localhost:5432/contractnegotiation
edc.datasource.contractnegotiation.user=<user>
edc.datasource.contractnegotiation.password=<password>

edc.datasource.policy.name=policy
edc.datasource.policy.url=jdbc:postgresql://localhost:5432/policy
edc.datasource.policy.user=<user>
edc.datasource.policy.password=<password>

edc.datasource.transferprocess.name=transferprocess
edc.datasource.transferprocess.url=jdbc:postgresql://ocalhost:5432/transferprocess
edc.datasource.transferprocess.user=<user>
edc.datasource.transferprocess.password=<password>

I am pretty sure that I need to add another extension that is able to make connection to the postgres database via the 'DataSource' object. Right now the DefaultDataSource is used but datasources are never registered and thus cannot be resolved.
It looks to me like I need the 'transaction-local' extension but I can't seem to find it on Maven Central.
Is there an extension available that allows me to do this?

Any help would be greatly appreciated.
Thank you very much in advance

Willem

[florianrusch-zf]

Hi @cossey50 as your request is about a mechanism of the EDC itself (and not about any extension or deployment mechanism provided by this repo) I would like to refer you to the upstream repository (https://github.com/eclipse-edc/connector). Also please be aware, that the product-edc repository was deprecated and will be archived soon. If you have any questions related to product-edc I would like to refer you to the new tractusx-edc (https://github.com/eclipse-tractusx/tractusx-edc/) repository.