ERROR: null value in column "purchasing_item_flag" violates not-null constraint
详细：Failing row contains (601609119, 189, 英文FE/STM-1 Optical Transmission Materials, AT20250215153632, null, null, null, 英文FE/STM-1 Optical Transmission Materials, null, N, Y, N, N, N, N, N, Y, Y, N, N, N, N, Y, N, N, N, N, N, N, N, N, N, N, N, N, N, N, Active, 1, N, Y, 4, 2025-09-12 12:03:52, 174022309561388, 2025-02-15 15:36:42, -1, N, 73BC2092597B4A5089CB14B9E8D5E112, 2025-09-12 12:17:41.776326, 601609119, 189). Call getNextException to see other errors in the batch.
at org.postgresql.jdbc.BatchResultHandler.handleCompletion(BatchResultHandler.java:186) ~[postgresql-42.7.2.jar:42.7.2]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:590) ~[postgresql-42.7.2.jar:42.7.2]
at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:912) ~[postgresql-42.7.2.jar:42.7.2]
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:936) ~[postgresql-42.7.2.jar:42.7.2]
at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1733) ~[postgresql-42.7.2.jar:42.7.2]
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:230) ~[commons-dbcp2-2.12.0.jar:2.12.0]
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:230) ~[commons-dbcp2-2.12.0.jar:2.12.0]
at sun.reflect.GeneratedMethodAccessor322.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:78) ~[mybatis-3.5.13.jar:3.5.13]
at com.sun.proxy.$Proxy737.executeBatch(Unknown Source) ~[?:?]
at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:126) ~[mybatis-3.5.13.jar:3.5.13]
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:129) ~[mybatis-3.5.13.jar:3.5.13]
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:122) ~[mybatis-3.5.13.jar:3.5.13]
at org.apache.ibatis.executor.CachingExecutor.flushStatements(CachingExecutor.java:115) ~[mybatis-3.5.13.jar:3.5.13]
at sun.reflect.GeneratedMethodAccessor316.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.13.jar:3.5.13]
at com.sun.proxy.$Proxy733.flushStatements(Unknown Source) ~[?:?]
at sun.reflect.GeneratedMethodAccessor316.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.13.jar:3.5.13]
at com.sun.proxy.$Proxy733.flushStatements(Unknown Source) ~[?:?]
at sun.reflect.GeneratedMethodAccessor316.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.13.jar:3.5.13]
at com.sun.proxy.$Proxy733.flushStatements(Unknown Source) ~[?:?]
at sun.reflect.GeneratedMethodAccessor316.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.13.jar:3.5.13]
at com.sun.proxy.$Proxy733.flushStatements(Unknown Source) ~[?:?]
at sun.reflect.GeneratedMethodAccessor316.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.13.jar:3.5.13]
at com.sun.proxy.$Proxy733.flushStatements(Unknown Source) ~[?:?]
at org.apache.ibatis.session*****#*#*****Session*****#*#*****aultSqlSession*****#*#*****-3.5.13.jar:3.5.13]
... 11 more
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "purchasing_item_flag" violates not-null constraint
详细：Failing row contains (601609119, 189, 英文FE/STM-1 Optical Transmission Materials, AT20250215153632, null, null, null, 英文FE/STM-1 Optical Transmission Materials, null, N, Y, N, N, N, N, N, Y, Y, N, N, N, N, Y, N, N, N, N, N, N, N, N, N, N, N, N, N, N, Active, 1, N, Y, 4, 2025-09-12 12:03:52, 174022309561388, 2025-02-15 15:36:42, -1, N, 73BC2092597B4A5089CB14B9E8D5E112, 2025-09-12 12:17:41.776326, 601609119, 189).
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725) ~[postgresql-42.7.2.jar:42.7.2]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412) ~[postgresql-42.7.2.jar:42.7.2]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:579) ~[postgresql-42.7.2.jar:42.7.2]
at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:912) ~[postgresql-42.7.2.jar:42.7.2]
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:936) ~[postgresql-42.7.2.jar:42.7.2]
at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1733) ~[postgresql-42.7.2.jar:42.7.2]
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:230) ~[commons-dbcp2-2.12.0.jar:2.12.0]
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:230) ~[commons-dbcp2-2.12.0.jar:2.12.0]
at sun.reflect.GeneratedMethodAccessor322.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:78) ~[mybatis-3.5.13.jar:3.5.13]
at com.sun.proxy.$Proxy737.executeBatch(Unknown Source) ~[?:?]
at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:126) ~[mybatis-3.5.13.jar:3.5.13]
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:129) ~[mybatis-3.5.13.jar:3.5.13]
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:122) ~[mybatis-3.5.13.jar:3.5.13]
at org.apache.ibatis.executor.CachingExecutor.flushStatements(CachingExecutor.java:115) ~[mybatis-3.5.13.jar:3.5.13]
at sun.reflect.GeneratedMethodAccessor316.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.13.jar:3.5.13]
at com.sun.proxy.$Proxy733.flushStatements(Unknown Source) ~[?:?]
at sun.reflect.GeneratedMethodAccessor316.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.13.jar:3.5.13]
at com.sun.proxy.$Proxy733.flushStatements(Unknown Source) ~[?:?]
at sun.reflect.GeneratedMethodAccessor316.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.13.jar:3.5.13]
at com.sun.proxy.$Proxy733.flushStatements(Unknown Source) ~[?:?]
at sun.reflect.GeneratedMethodAccessor316.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.13.jar:3.5.13]
at com.sun.proxy.$Proxy733.flushStatements(Unknown Source) ~[?:?]
at sun.reflect.GeneratedMethodAccessor316.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.13.jar:3.5.13]
at com.sun.proxy.$Proxy733.flushStatements(Unknown Source) ~[?:?]
at org.apache.ibatis.session*****#*#*****Session*****#*#*****aultSqlSession*****#*#*****-3.5.13.jar:3.5.13]
... 11 more
最新发布
本文详细解析了nullvalueincolumn“id”violatesnot-nullconstraint错误的原因，通常由插入语句中的主键Id为空引起，并提供了检查和修复的方法。
扫一扫
1199
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
