org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement错误

来源:互联网 发布:如何禁止mac电脑上网 编辑:程序博客网 时间:2024/05/17 08:33

错误详情

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)    at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:440)    at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:424)    at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:315)    at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:166)    at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:135)    at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:121)    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:155)    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:309)    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:445)    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:710)    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:726)    at Main.main(Main.java:19)Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'type=MyISAM' at line 1    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)    at com.mysql.jdbc.Util.getInstance(Util.java:408)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2455)    at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839)    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739)    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)    ... 13 more

解决方案:
在本项目的.cfg.xml配置中加入:

<property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
阅读全文
0 0