为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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: