hibernate联合主键，使用insert select插入数据报错

最新推荐文章于 2021-02-23 18:24:51 发布

原创最新推荐文章于 2021-02-23 18:24:51 发布 · 591 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Hibernate hsql

在尝试使用 Hibernate 和 HSQL 数据库进行数据导入时，遇到一个错误：`org.hibernate.QueryException: could not resolve property: of: com.miextreme.chinas.entity.CasFinanceData`。该错误发生在尝试通过 INSERT INTO SELECT 语句从 CasFinanceDataTemp 导入数据到 CasFinanceData 的过程中，两个表的主键为 asCode 和 financeUpdateDate。报错表明 Hibernate 无法识别 CasFinanceData 实体中的某个属性。寻求解决方案。

语句如下：
INSERT INTO CasFinanceData (id.asCode,id.financeUpdateDate,asName) SELECT a.id.asCode,a.id.financeUpdateDate,a.asName FROM CasFinanceDataTemp a where a.id not in (SELECT id from CasFinanceData)
其中：CasFinanceData表结构与CasFinanceDataTemp一致，CasFinanceDataTemp作为临时表辅助进行数据导入操作。asCode、financeUpdateDate为联合主键。
报错信息如下：
Caused by: org.hibernate.QueryException: could not resolve property: of: com.miextreme.chinas.entity.CasFinanceData
at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:83)
at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:77)
at org.hibernate.persister.entity.AbstractEntityPersister.getSubclassPropertyTableNumber(AbstractEntityPersister.java:1995)
at org.hibernate.hql.internal.ast.tree.IntoClause.isSuperclassProperty(IntoClause.java:233)
at org.hibernate.hql.internal.ast.tree.IntoClause.visitPropertySpecNodes(IntoClause.java:175)
at org.hibernate.hql.internal.ast.tree.IntoClause.initializeColumns(IntoClause.java:157)
at org.hibernate.hql.internal.ast.tree.IntoClause.initialize(IntoClause.java:65)
at org.hibernate.hql.internal.ast.HqlSqlWalker.createIntoClause(HqlSqlWalker.java:1231)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.intoClause(HqlSqlBaseWalker.java:859)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.insertStatement(HqlSqlBaseWalker.java:499)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:273)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:278)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:206)
... 66 more

求高手解。