原mysql数据库 迁移derby
配置后运行报错如下:
```
create connection SQLException, url: jdbc:derby:E:/rndmdb;create=true, errorCode 30000, state 42X01
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "<EOF>" at line 1, column 8.
```
逐项排查后
validationQuery mysql 默认值为“select 1”
derby 为“values 1”
DataBase validationQuery
hsqldb select 1 from INFORMATION_SCHEMA.SYSTEM_USERS
Oracle select 1 from dual
DB2 select 1 from sysibm.sysdummy1
MySql select 1
Microsoft SqlServer select 1
postgresql select version()
ingres select 1
derby values 1
H2 select 1