[I] Fix process-compact-architecture example to avoid embedded H2 shutting down after some idle time in dev mode [incubator-kie-issues]

["pefernan (via GitHub)" <gi...@apache.org>]

pefernan opened a new issue, #2115:
URL: https://github.com/apache/incubator-kie-issues/issues/2115

   Running the process-compact-architecture example in dev mode, H2 Database is refreshed from time to time with the following error:
   
   ```
   2025-09-03 15:22:13,863 WARN  [org.hib.eng.jdb.spi.SqlExceptionHelper] (Jobs-2) SQL Error: 42104, SQLState: 42S04
   2025-09-03 15:22:13,885 ERROR [org.hib.eng.jdb.spi.SqlExceptionHelper] (Jobs-2) Table "JOB_DETAILS" not found (this database is empty); SQL statement:
   select jde1_0.id,jde1_0.correlation_id,jde1_0.created,jde1_0.execution_counter,jde1_0.execution_timeout,jde1_0.execution_timeout_unit,jde1_0.fire_time,jde1_0.last_update,jde1_0.priority,jde1_0.recipient,jde1_0.retries,jde1_0.scheduled_id,jde1_0.status,jde1_0.trigger from job_details jde1_0 where jde1_0.status in (?,?) and jde1_0.fire_time<=? [42104-232]
   ```
   
   These errors happen in 10-minute intervals (default job sync interval).
   
   Note this is specific to H2, which shuts down after being idle for some time.
   
   Possible workarounds:
   
   - Append DB_CLOSE_DELAY=-1 to the connection string: %dev.quarkus.datasource.jdbc.url=jdbc:h2:mem:default;NON_KEYWORDS=VALUE,KEY;DB_CLOSE_DELAY=-1
   - Increase the idle removal interval of the datasource: %dev.quarkus.datasource.jdbc.idle-removal-interval=60M
   - Keep at least one connection in the datasource pool: %dev.quarkus.datasource.jdbc.min-size=1


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@kie.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@kie.apache.org
For additional commands, e-mail: commits-help@kie.apache.org