gpt4 book ai didi

java - 运行 SynchronizeMappings 时出现 PersistenceException

转载 作者:行者123 更新时间:2023-11-29 03:44:56 28 4
gpt4 key购买 nike

<分区>

我有一个使用 apache openJPA 的 eclipse java 项目。 eclipse 是否需要清理某种缓存?

我有一个类,UsaState ...映射到 USA_STATE 表。我已经从数据库、persistence.xml、项目、映射中的引用中删除了它……没有其他引用的项目,我有这个错误:

Exception in thread "main"  org.apache.openjpa.persistence.PersistenceException:    You have an error in your SQL syntax; check the manual that    corresponds to your MySQL server version for the right syntax to use    near 'TYPE = innodb' at line 1 {stmnt 7860099        CREATE TABLE USA_STATE (            ID BIGINT NOT NULL AUTO_INCREMENT,            NAME VARCHAR(255),            ADDRESS BIGINT,            PRIMARY KEY (ID)        ) TYPE = innodb    } [code=1064, state=42000]    at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)    at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)    at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)    at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119)    at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189)    at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:142)    at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:192)    at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:145)    at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:56)    at TestMain.main(TestMain.java:18)Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: You have    an error in your SQL syntax; check the manual that corresponds to    your MySQL server version for the right syntax to use near 'TYPE =    innodb' at line 1 {stmnt 7860099        CREATE TABLE USA_STATE (            ID BIGINT NOT NULL AUTO_INCREMENT,            NAME VARCHAR(255),            ADDRESS BIGINT,            PRIMARY KEY (ID)        ) TYPE = innodb    } [code=1064, state=42000]    at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)    at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)    at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:762)    at org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:114)    at org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1191)    at org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:949)    at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:526)    at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:344)    at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:321)    at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:501)    ... 9 more

问题出在哪里?持久性以何种方式记住该表或实体?需要一些干净的吗?我已经清理了项目几次...

谢谢

28 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com