application.yaml (JPA Section)

[pwgit-create]

Let's break down each property in our application.yaml under the jpa: section to understand what
they do:

jpa:
  open-in-view: false
  database: postgresql
  hibernate:
    auto_quote_keyword: true
    ddl-auto: update
    jdbc:
      time_zone: UTC

Breakdown of each property

1. open-in-view: false

   • This setting configures the JPA persistence context. When set to false, it means that the EntityManager is
     not kept open across different requests. This can help avoid lazy loading exceptions but might lead to performance
     issues if many entities are loaded per request.
   • With true (the default in Spring), an EntityManager is kept open throughout a request and allows for lazy
     loading of collections/proxies.

2. database: postgresql

   • Specifies the type of database being used, which helps Hibernate to optimize SQL generation and dialect.

3. hibernate:

   • This section contains various configurations specifically for Hibernate.

4. auto_quote_keyword: true

   • Instructs Hibernate to quote column names in generated SQL statements that match SQL keywords (like user,
     group, etc.). This can prevent conflicts with database reserved words.

5. ddl-auto: update

   • Controls how Hibernate should handle the schema generation.
     • update: Automatically updates the schema without dropping existing tables. Can be dangerous in production
       as it might lead to unintended changes.
     • Other options include create, create-drop, validate, etc.

6. jdbc:

   • This section contains JDBC-related configurations for Hibernate.

7. time_zone: UTC

   • Sets the time zone for database connections to UTC, ensuring consistent timestamp handling regardless of the
     server's local time zone.

Please note

The Documentation post refers specifically to the File-Integrity-Scanner Spring App and not the database repository. The purpose of this was to show how JPA settings in a application.properties/yaml file affect a database such as the one in File-Integrity-Database.