h2建表异常2.1.210

Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'tokenService': Unsatisfied dependency expressed through field 'redisCache'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'redisConfig' defined in file [D:\IdeaProjects\ruoyi-vue-nutz\ruoyi-framework\target\classes\com\ruoyi\framework\config\RedisConfig.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.nutz.spring.boot.dao.NutzDatabaseInitializer': Invocation of init method failed; nested exception is org.nutz.dao.DaoException: !Nutz SQL Error: 'ALTER TABLE sys_config DROP INDEX PUBLIC'
PreparedStatement: 
'ALTER TABLE sys_config DROP INDEX PUBLIC'
CaseMessage=Column "INDEX" not found; SQL statement:
ALTER TABLE sys_config DROP INDEX PUBLIC [42122-210]

不知道为啥日志好像也输出不全
是不是 h2 升级导致的不兼容

wendal

1楼•905天前

字段名用关键字index了吧

Hamming(tonyyule)

2楼•905天前

没有

@Table("sys_config")
public class SysConfig extends BaseModel {
    private static final long serialVersionUID = 1L;

    /** 参数主键 */
    @Id
    @ColDefine(type = ColType.INT, width = 10)
    @Column("config_id")
    @Comment("参数主键")
    private Long configId;

    /** 参数名称 */
    @Column("config_name")
    @Comment("参数名称")
    @Excel(name = "参数名称")
    private String configName;

    /** 参数键名 */
    @Column("config_key")
    @Comment("参数键名")
    @Excel(name = "参数键名")
    private String configKey;

    /** 参数键值 */
    @Column("config_value")
    @Comment("参数键值")
    @Excel(name = "参数键值")
    private String configValue;

    /** 系统内置（Y是 N否） */
    @Column("config_type")
    @Comment("系统内置（Y是 N否）")
    @Excel(name = "系统内置", readConverterExp = "Y=是,N=否")
    private String configType;

wendal

3楼•902天前

我觉得还是merge的问题

wx_clnoi3iokl8ofq086cum 4楼•853天前

h2-2.1.214,也遇到相同的问题

请先登陆