Verify application.yaml Configuration

[pwgit-create]

Database Configuration

Make sure your database configuration in application.yaml is correct. Here's an example based on the project status of 2025-07-07 of that file with extra clarity parameter of the driver class name :

spring:
  datasource:
    url: jdbc:postgresql://localhost:26556/integrity_hash
    username: ${INTEGRITY_HASH_DB_USER}
    password: ${INTEGRITY_HASH_DB_PASSWORD}
    driver-class-name: org.postgresql.Driver # Optional, but can help with clarity

  jpa:
    database: postgresql
    hibernate:
      ddl-auto: update

Check Environment Variables

Ensure that the environment variables INTEGRITY_HASH_DB_USER and INTEGRITY_HASH_DB_PASSWORD are set correctly.
You can print them to check if they're available:

echo $INTEGRITY_HASH_DB_USER
echo $INTEGRITY_HASH_DB_PASSWORD

Test the Connection

Before running your application, you might want to test connecting to your PostgreSQL database using a
command-line tool like psql or any other database client to ensure that the credentials and connection details
are correct.

Linux

psql -h localhost -p 26556 -U $INTEGRITY_HASH_DB_USER -d integrity_hash

Windows

try{
$DBConnectionString = "Driver={PostgreSQL UNICODE};Server=localhost;Port=26556;Database=integrity_hash;Uid=$env:INTEGRITY_HASH_DB_USER;Pwd=$env:INTEGRITY_HASH_DB_PASSWORD;"
$DBConn = New-Object System.Data.Odbc.OdbcConnection;
$DBConn.ConnectionString = $DBConnectionString;
$DBConn.Open();
Write-Host "OK - Connection to integrity_hash is succesful" -ForegroundColor green
}
catch{Write-Host "Failed to connect to the database" -ForegroundColor red}

Save the Powershell-script in a file as: test_connection_to_integrity_db.ps1

Finally : Restart Your Application

After making any changes to your application.yaml file, restart your Spring Boot application. If everything is set up correctly, it should now
be able to configure the data source and connect to your PostgreSQL database.

[pwgit-create]

Tools used for handling the database

Windows

pgAdmin 4
SQL Shell (psql)

Linux

psql