我希望从我的代码中使用JPA运行这个查询,但它没有工作。
请帮忙。
SET IDENTITY_INSERT "+tableName+" ON
更新
这行代码如下:
Query query = entityManager.createNativeQuery("SET IDENTITY_INSERT [tableName] ON");
int updated = query.executeUpdate();
当更新后,它会返回0。在此行执行时不会出现任何错误。但是在此之后尝试插入时,会出现约束违规异常,如下所示。
2015-03-09 15:46:52,922 WARN org.hibernate.util.JDBCExceptionReporter.logExceptions:233 - SQL Error: 544, SQLState: 23000
2015-03-09 15:46:52,923 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - Cannot insert explicit value for identity column in table 'table_name' when IDENTITY_INSERT is set to OFF.
2015-03-09 15:46:52,924 ERROR org.hibernate.event.def.AbstractFlushingEventListener.performExecutions:324 - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [com.entities.EntityName]
em.createNativeQuery()
吗? - Predrag Maric