注册

Hibernate连接DM8使用hbm2ddl自动建表报错

2024/02/28 965 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:

DM Database Server 64 V8

【Hibernate版本】:

Hibernate ORM core version 5.6.14.Final
Hibernate Commons Annotations {5.1.2.Final}

【Hibernate配置】:

  jpa:
    hibernate:
      use-new-id-generator-mappings: true
      ddl-auto: none
      naming:
        physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
    properties:
      hibernate:
        dialect: org.hibernate.dialect.DmDialect
        hbm2ddl:
          auto: update
        connection:
          driver_class: dm.jdbc.driver.DmDriver
    show-sql: true

【Pom文件】*:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-dependencies</artifactId>
    <version>2.7.6</version>
    <type>pom</type>
    <scope>import</scope>
</dependency>
...
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
    <version>2.7.2</version>
</dependency>
...
<dependency>
    <groupId>com.dameng</groupId>
    <artifactId>DmDialect-for-hibernate5.6</artifactId>
    <version>8.1.3.62</version>
</dependency>
...
<dependency>
    <groupId>com.dameng</groupId>
    <artifactId>DmJdbcDriver18</artifactId>
    <version>8.1.3.62</version>
</dependency>

【问题描述】*:
项目启动创建表出现下面报错:

18:52:09.470 [schedule-pool-1] INFO  o.h.t.h.SchemaUpdate - [execute,74] - HHH000228: Running hbm2ddl schema update
Hibernate: create table S_MENUBUTTON (id varchar(255) identity, code varchar(100), name varchar(100), description varchar(100), menuid varchar(100), apipath varchar(100), ordernumber integer, creatoruser varchar(50), lastmodifieruser varchar(50), primary key (id))
18:52:10.107 [schedule-pool-1] ERROR c.a.d.f.s.StatFilter - [mergeSql,150] - merge sql error, dbType dm, druid-1.2.16, sql : create table S_MENUBUTTON (id varchar(255) identity, code varchar(100), name varchar(100), description varchar(100), menuid varchar(100), apipath varchar(100), ordernumber integer, creatoruser varchar(50), lastmodifieruser varchar(50), primary key (id))
com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'varchar(255) identity, code varchar(100), n', expect ), actual null, pos 51, line 1, column 44, token IDENTIFIER identity
	at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:857)
	at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:865)
	at com.alibaba.druid.sql.parser.SQLCreateTableParser.parseCreateTable(SQLCreateTableParser.java:141)
	at com.alibaba.druid.sql.parser.SQLCreateTableParser.parseCreateTable(SQLCreateTableParser.java:43)
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseCreate(SQLStatementParser.java:3418)
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:245)
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:101)
	at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:163)
	at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:134)
	at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:148)
	at com.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:
回答 0
暂无回答
扫一扫
联系客服