可以给一个替代h2做单元测试的例子吗

[jerdbo]

No description provided.

[codefollower]

把 jdbc:h2:~/test 替换成 jdbc:lealone:embed:test

参考文档 通过嵌入模式使用Lealone数据库

[jerdbo]

这种模式下可以兼容mysql语法吗

[jerdbo]

url: jdbc:lealone:embed::pipeline_management;persistent=false;MODE=MYSQL
如果指定 mode 会报下面错误：
2024-11-28 11:04:07.247 WARN [,,,] 14922 --- [heduleService-0] c.l.db.scheduler.EmbeddedScheduler : Failed to run misc task: com.lealone.db.session.ServerSessionFactory$$Lambda$987/0x0000000800aeb028@583ac952

java.lang.NullPointerException: null
at com.lealone.db.auth.PasswordHash.validateUserPasswordHashMySQL(PasswordHash.java:102)
at com.lealone.db.auth.PasswordHash.validateUserPasswordHash(PasswordHash.java:68)
at com.lealone.db.auth.User.validateUserPasswordHash(User.java:243)
at com.lealone.db.session.ServerSessionFactory.validateUser(ServerSessionFactory.java:113)
at com.lealone.db.session.ServerSessionFactory.createServerSession(ServerSessionFactory.java:80)
at com.lealone.db.session.ServerSessionFactory.lambda$createSession$0(ServerSessionFactory.java:38)
at com.lealone.db.scheduler.SchedulerBase.runMiscTasks(SchedulerBase.java:216)
at com.lealone.db.scheduler.EmbeddedScheduler.runMiscTasks(EmbeddedScheduler.java:57)
at com.lealone.db.scheduler.EmbeddedScheduler.run(EmbeddedScheduler.java:63)
at java.lang.Thread.run(Thread.java:750)

[codefollower]

lealone-mysql 插件目前不支持嵌入模式，后续再看看怎么做合适。