[GitHub] [dolphinscheduler] kezhenxu94 commented on issue #7554: [Bug] [Standlone] H2 in standalone server will auto restart after several minutes

[GitBox <gi...@apache.org>]

kezhenxu94 commented on issue #7554:
URL: https://github.com/apache/dolphinscheduler/issues/7554#issuecomment-999565276


   > This is due to the connection url. Each times we create a new connection, will run the init script. In the script will drop the exist table.
   > 
   > ```
   > url: jdbc:h2:mem:dolphinscheduler;MODE=MySQL;DB_CLOSE_DELAY=-1;DATABASE_TO_LOWER=true;INIT=runscript from 'classpath:sql/dolphinscheduler_h2.sql'
   > ```
   > 
   > This solution is to remove the init script from url
   
   We need put the initialization elsewhere, this is a good candidate👇
   
   
   ```yaml
   spring:
     sql:
       init:
         schema-locations: classpath:sql/dolphinscheduler_h2.sql
   ```


-- 
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@dolphinscheduler.apache.org

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