使用 Spring + JPA (Repositories) + Hibernate 更新表中的現(xiàn)有記錄時(shí)出現(xiàn)此錯(cuò)誤。2019-07-01 17:47:47.526 WARN o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 8114, SQLState: 370002019-07-01 17:47:47.527 ERROR o.h.engine.jdbc.spi.SqlExceptionHelper : Error converting data type nvarchar to numeric.2019-07-01 17:47:47.527 ERROR o.h.i.ExceptionMapperStandardImpl : HHH000346: Error during managed flush[org.hibernate.exception.SQLGrammarException: could not execute statement]2019-07-01 17:47:47.562 ERROR c.a.p.controller.AdminClaimController : July 1, 2019 5:47:47 PM PDTorg.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception isorg.hibernate.exception.SQLGrammarException: could not execute statement此更新操作最近有效,但現(xiàn)在無效。Stackoverflow 問題在這里我怎么知道這個(gè)問題與哪個(gè)列或數(shù)據(jù)值相關(guān)?被問到的 Stackoverflow 問題結(jié)束不幸的是,該表有 145 列。調(diào)用時(shí)出現(xiàn)錯(cuò)誤CrudRepository.save(Object myObject))因?yàn)槲掖_信我會(huì)同意他們的觀點(diǎn),所以請(qǐng)將您關(guān)于如何設(shè)計(jì)表格的評(píng)論放在其他地方的討論論壇中,因?yàn)檫@顯然不是我的問題所在 - 謝謝您,我保證我稍后會(huì)閱讀它們!:D
休眠:哪一列???將數(shù)據(jù)類型 nvarchar 轉(zhuǎn)換為數(shù)字時(shí)出錯(cuò)
幕布斯7119047
2023-03-02 16:16:39
