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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
