Configuration — ConformaESG Integration Service

Datasource

Property	Type	Default	Description
`quarkus.datasource.db-kind`	string	`postgresql`	Use `h2` for testing
`quarkus.datasource.username`	string	—	PostgreSQL username
`quarkus.datasource.password`	string	—	PostgreSQL password
`quarkus.datasource.jdbc.url`	string	—	JDBC connection URL

Hibernate ORM

Property	Type	Default	Description
`quarkus.hibernate-orm.database.generation`	string	`validate`	`none`, `validate`, `update`, `drop-and-create`
`quarkus.hibernate-orm.log.sql`	boolean	`false`	Log SQL to console

Traceability Emission Factors

Configurable in the traceability module's application.properties:

Property	Default	Description
`traceability.emission.factor.truck`	96	g CO₂ per tonne·km for truck
`traceability.emission.factor.ship`	11	g CO₂ per tonne·km for ship
`traceability.emission.factor.train`	28	g CO₂ per tonne·km for train
`traceability.emission.factor.plane`	602	g CO₂ per tonne·km for plane

Example `app/src/main/resources/application.properties`

Properties
1%prod.quarkus.datasource.db-kind=postgresql
2%prod.quarkus.datasource.username=${DB_USER}
3%prod.quarkus.datasource.password=${DB_PASSWORD}
4%prod.quarkus.datasource.jdbc.url=jdbc:postgresql://${DB_HOST:localhost}:5432/${DB_NAME:conformaesg}
5%prod.quarkus.hibernate-orm.database.generation=validate
6
7quarkus.datasource.devservices.image-name=postgres:16-alpine
8%dev.quarkus.hibernate-orm.database.generation=update
9
10quarkus.swagger-ui.always-include=true
11quarkus.smallrye-openapi.info-title=ConformaESG Integration Service API
12quarkus.smallrye-openapi.info-version=1.2.0

Build Profiles

Profile	Database	Schema Generation	Usage
`dev`	PostgreSQL (Dev Services / Docker)	`update`	Local development
`test`	H2 in-memory	`drop-and-create`	Unit/integration tests
`prod`	PostgreSQL (external)	`validate`	Production deployment

Warning

Always back up your database before deploying schema changes in production.

Datasource

Hibernate ORM

Traceability Emission Factors

Example app/src/main/resources/application.properties

Build Profiles

Example `app/src/main/resources/application.properties`