cope属性带来的问题

分手后的思念是犯贱 2022-03-11 07:24 180阅读 0赞

org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL \[n/a\]; constraint \[null\]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement

at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:296)  
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:253)  
    at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:536)  
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)  
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)  
    at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:533)  
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:304)  
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)  
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)  
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)  
    at com.imooc.sell.serviceImpl.OrderServiceImpl$$EnhancerBySpringCGLIB$$3f65cf17.createOrder(<generated>)  
    at com.imooc.sell.serviceImpl.OrderServiceImplTest.createOrder(OrderServiceImplTest.java:47)  
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
    at java.lang.reflect.Method.invoke(Method.java:498)  
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)  
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)  
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)  
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)  
    at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)  
    at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)  
    at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)  
    at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)  
    at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)  
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)  
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)  
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)  
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)  
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)  
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)  
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)  
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)  
    at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)  
    at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)  
    at org.junit.runners.ParentRunner.run(ParentRunner.java:363)  
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)  
    at org.junit.runner.JUnitCore.run(JUnitCore.java:137)  
    at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)  
    at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)  
    at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)  
    at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)  
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement  
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59)  
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)  
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)  
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)  
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178)  
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3171)  
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3686)  
    at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:90)  
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)  
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478)  
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356)  
    at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)  
    at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1454)  
    at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:511)  
    at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3283)  
    at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2479)  
    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)  
    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178)  
    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39)  
    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271)  
    at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:98)  
    at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:532)  
    ... 39 more  
**Caused by: java.sql.SQLIntegrityConstraintViolationException: Column 'order\_status' cannot be null**  
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)  
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)  
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)  
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)  
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109)  
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1057)  
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1377)  
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1042)  
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)  
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)  
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)  
    ... 56 more

这里我们可以看到我们的是 order\_status cannot be null;

dataobiect  OrderMaster

*/
    @Entity
    @Data
    @DynamicUpdate
    public class OrderMaster {
    
        @Id
        /*订单id*/
        private String orderId;
    
        /*买家名称*/
        private String buyName;
    
        /*买家电话*/
        private String buyPhone;
    
        /*买家地址*/
        private String buyAdress;
    
        /*买家的微信openid*/
        private String buyOpenid;
    
        /*订单总金额*/
        private BigDecimal orderAmount;
    
        /*订单状态 默认0 新下单 */
        private Integer orderStatus = OrderStatusEnum.NEW.getCode();
    
        /*支付状态 默认0 未支付*/
        private Integer payStatus = OrderPayStatusEnum.WAITPAY.getCode();
    
        /*创建时间*/
        private Date createTime;
    
        /*修改时间*/
        private Date updateTime;
    
    }

@Data
    public class OrderMasterDTO {
    
        /*订单id*/
        private String orderId;
    
        /*买家名称*/
        private String buyName;
    
        /*买家电话*/
        private String buyPhone;
    
        /*买家地址*/
        private String buyAdress;
    
        /*买家的微信openid*/
        private String buyOpenid;
    
        /*订单总金额*/
        private BigDecimal orderAmount;
    
        /*订单状态 默认0 新下单 */
        private Integer orderStatus ;
    
        /*支付状态 默认0 未支付*/
        private Integer payStatus;
    
        /*创建时间*/
        private Date createTime;
    
        /*修改时间*/
        private Date updateTime;
    
        /*订单详情列表*/
        private List<OrderDetailsDTO> orderDetailsDTOList;
    
    
    }

**在orderMasterDTO中默认不会有orderId,orderStatus,payStatus,createTime,updateTime 的值**，

看一下逻辑代码

//5.保存ordermaster
            OrderMaster orderMaster = new OrderMaster();
            BeanUtils.copyProperties(orderMasterDTO, orderMaster);
            orderMaster.setOrderId(orderId);
            orderMaster.setOrderAmount(orderAmount);
            masterRepository.save(orderMaster);

在这里，我们在设置的时候是有默认值得，但是在cope后就没有值了，所以就是cope出了问题，

我们在cope的时候要把其余属性值设置在后边，就会正确的填写值了