Edc tables not created while using postgresql

[kss682]

I am trying to set up an EDC with a postgresql connection.
Following are the my configurations

plugins {
    `java-library`
    id("application")
    alias(libs.plugins.shadow)
}

dependencies {
    implementation(libs.edc.control.api.configuration)
    implementation(libs.edc.control.plane.api.client)
    implementation(libs.edc.control.plane.api)
    implementation(libs.edc.control.plane.core)
    implementation(libs.edc.control.plane.sql)

    implementation(libs.edc.dsp)
    implementation(libs.edc.configuration.filesystem)
    implementation(libs.edc.iam.mock)
	implementation(libs.edc.sql.apache.commons)
	implementation(libs.postgresql)
	implementation(libs.edc.transaction.local)
	implementation(libs.edc.transaction.datasource.spi)

    implementation(libs.edc.management.api)
    implementation(libs.edc.transfer.data.plane.signaling)
    implementation(libs.edc.transfer.pull.http.receiver)
    implementation(libs.edc.validator.data.address.http.data)
    
    implementation(libs.edc.edr.cache.api)
    implementation(libs.edc.edr.store.core)
    implementation(libs.edc.edr.store.receiver)

    implementation(libs.edc.data.plane.selector.api)
    implementation(libs.edc.data.plane.selector.core)
    
    implementation(libs.edc.data.plane.self.registration)
    implementation(libs.edc.data.plane.control.api)
    implementation(libs.edc.data.plane.public.api)
    implementation(libs.edc.data.plane.core)
    implementation(libs.edc.data.plane.http)
}

application {
    mainClass.set("org.eclipse.edc.boot.system.runtime.BaseRuntime")
}

var distTar = tasks.getByName("distTar")
var distZip = tasks.getByName("distZip")

tasks.withType<com.github.jengelman.gradle.plugins.shadow.tasks.ShadowJar> {
    mergeServiceFiles()
    archiveFileName.set("connector.jar")
    dependsOn(distTar, distZip)
}

database config

edc.datasource.default.user=
edc.datasource.default.password=
edc.datasource.default.url=jdbc:postgresql://localhost:5433/provider

edc.datasource.asset.name=asset
edc.datasource.asset.url=jdbc:postgresql://localhost:5433/asset
edc.datasource.asset.user=
edc.datasource.asset.password=

edc.datasource.contractdefinition.name=contractdefinition
edc.datasource.contractdefinition.url=jdbc:postgresql://localhost:5433/provider
edc.datasource.contractdefinition.user=-
edc.datasource.contractdefinition.password=

edc.datasource.transferprocess.name=transferprocess
edc.datasource.transferprocess.url=jdbc:postgresql://localhost:5433/provider
edc.datasource.transferprocess.user=
edc.datasource.transferprocess.password=

edc.datasource.policy.name=policy
edc.datasource.policy.user=
edc.datasource.policy.password=
edc.datasource.policy.url=jdbc:postgresql://localhost:5433/provider

Even though connection is established from the connector to DB, I don't see any tables created and that which results in table not found error when TransferProcessManager tries to query.

SEVERE 2024-07-03T12:49:16.360887702 StateMachineManager [TransferProcessManagerImpl] error caught
org.eclipse.edc.spi.persistence.EdcPersistenceException: org.postgresql.util.PSQLException: ERROR: relation "edc_transfer_process" does not exist

Connections from edc to db for while querying

Can you please help me understand what I could have missed ?

[paullatzelsperger]

EDC doesn't create tables automatically, you'll have to do that yourself. in the code base you'll find schema.sql files, which contain all the necessary table structures.

another way would be to use a tool like flyway or liquibase or something similar.