gpt4 book ai didi

java - Hibernate @OneToMany 来自更新 [0] 的意外行数;实际行数 : 0; expected: 1

转载 作者:行者123 更新时间:2023-11-28 23:49:59 25 4
gpt4 key购买 nike

我正在使用 JPA、Hibernate、Spring 和 MySQL

我试图通过命令拯救一个人。但只有这个人会出现在数据库中。为了解决这个问题,我将 cascade = CascadeType.ALL 添加到 @OneToMany导致这个错误

Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1

数据库脚本

CREATE TABLE IF NOT EXISTS `orders` (
`O_Id` int(11) NOT NULL,
`OrderNo` int(11) NOT NULL,
`P_Id` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `persons` (
`P_Id` int(11) NOT NULL,
`LastName` varchar(255) NOT NULL,
`FirstName` varchar(255) DEFAULT NULL,
`Address` varchar(255) DEFAULT NULL,
`City` varchar(255) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

ALTER TABLE `orders`
ADD PRIMARY KEY (`O_Id`),
ADD KEY `P_Id` (`P_Id`);

ALTER TABLE `persons`
ADD PRIMARY KEY (`P_Id`);

ALTER TABLE `orders`
ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`P_Id`) REFERENCES `persons` (`P_Id`);

订单和个人实体

@Entity
@Table(name = "orders", catalog = "db1", schema = "")
@XmlRootElement
@NamedQueries({
@NamedQuery(name = "Orders.findAll", query = "SELECT o FROM Orders o"),
@NamedQuery(name = "Orders.findByOId", query = "SELECT o FROM Orders o WHERE o.oId = :oId"),
@NamedQuery(name = "Orders.findByOrderNo", query = "SELECT o FROM Orders o WHERE o.orderNo = :orderNo")})
public class Orders implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Basic(optional = false)
@Column(name = "O_Id")
private Integer oId;
@Basic(optional = false)
@NotNull
@Column(name = "OrderNo")
private int orderNo;
@JoinColumn(name = "P_Id", referencedColumnName = "P_Id")
@ManyToOne
private Persons pId;

public Orders() {
}

public Orders(Integer oId) {
this.oId = oId;
}

public Orders(Integer oId, int orderNo) {
this.oId = oId;
this.orderNo = orderNo;
}

public Integer getOId() {
return oId;
}

public void setOId(Integer oId) {
this.oId = oId;
}

public int getOrderNo() {
return orderNo;
}

public void setOrderNo(int orderNo) {
this.orderNo = orderNo;
}

public Persons getPId() {
return pId;
}

public void setPId(Persons pId) {
this.pId = pId;
}

@Override
public int hashCode() {
int hash = 0;
hash += (oId != null ? oId.hashCode() : 0);
return hash;
}

@Override
public boolean equals(Object object) {
// TODO: Warning - this method won't work in the case the id fields are not set
if (!(object instanceof Orders)) {
return false;
}
Orders other = (Orders) object;
if ((this.oId == null && other.oId != null) || (this.oId != null && !this.oId.equals(other.oId))) {
return false;
}
return true;
}
}




@Entity
@Table(name = "persons", catalog = "db1", schema = "")
@XmlRootElement
@NamedQueries({
@NamedQuery(name = "Persons.findAll", query = "SELECT p FROM Persons p"),
@NamedQuery(name = "Persons.findByPId", query = "SELECT p FROM Persons p WHERE p.pId = :pId"),
@NamedQuery(name = "Persons.findByLastName", query = "SELECT p FROM Persons p WHERE p.lastName = :lastName"),
@NamedQuery(name = "Persons.findByFirstName", query = "SELECT p FROM Persons p WHERE p.firstName = :firstName"),
@NamedQuery(name = "Persons.findByAddress", query = "SELECT p FROM Persons p WHERE p.address = :address"),
@NamedQuery(name = "Persons.findByCity", query = "SELECT p FROM Persons p WHERE p.city = :city")})
@Component("aPerson") // I do not how else to get it
public class Persons implements Serializable {

private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Basic(optional = false)
@Column(name = "P_Id")
private Integer pId;
@Basic(optional = false)
@NotNull
@Size(min = 1, max = 255)
@Column(name = "LastName")
private String lastName;
@Size(max = 255)
@Column(name = "FirstName")
private String firstName;
@Size(max = 255)
@Column(name = "Address")
private String address;
@Size(max = 255)
@Column(name = "City")
private String city;
@OneToMany(mappedBy = "pId", cascade = CascadeType.ALL)
private Collection<Orders> ordersCollection;

@Autowired
@Transient
SessionFactory sessionFactory;

@Transactional
public void add(Persons person) {
sessionFactory.getCurrentSession().saveOrUpdate(person);
}

public Persons() {
}

public Persons(Integer pId) {
this.pId = pId;
}

public Persons(Integer pId, String lastName) {
this.pId = pId;
this.lastName = lastName;
}

public Integer getPId() {
return pId;
}

public void setPId(Integer pId) {
this.pId = pId;
}

public String getLastName() {
return lastName;
}

public void setLastName(String lastName) {
this.lastName = lastName;
}

public String getFirstName() {
return firstName;
}

public void setFirstName(String firstName) {
this.firstName = firstName;
}

public String getAddress() {
return address;
}

public void setAddress(String address) {
this.address = address;
}

public String getCity() {
return city;
}

public void setCity(String city) {
this.city = city;
}

@XmlTransient
public Collection<Orders> getOrdersCollection() {
return ordersCollection;
}

public void setOrdersCollection(Collection<Orders> ordersCollection) {
this.ordersCollection = ordersCollection;
}

@Override
public int hashCode() {
int hash = 0;
hash += (pId != null ? pId.hashCode() : 0);
return hash;
}

@Override
public boolean equals(Object object) {
// TODO: Warning - this method won't work in the case the id fields are not set
if (!(object instanceof Persons)) {
return false;
}
Persons other = (Persons) object;
if ((this.pId == null && other.pId != null) || (this.pId != null && !this.pId.equals(other.pId))) {
return false;
}
return true;
}

}

我如何尝试保存对象。

       @Controller
public class HelloController {

@Autowired
SessionFactory sessionFactory;

@Autowired
private ApplicationContext applicationContext;



@RequestMapping("hi")
@ResponseBody
// @Transactional
public String hi() {

Persons personContext = (Persons) applicationContext.getBean("aPerson");

Persons person = new Persons();

person.setFirstName("jan");
person.setAddress("jan");
person.setCity("Eindhoven");
person.setLastName("jansen");

Orders order = new Orders(12, 12);

Collection<Orders> orderses = new HashSet<Orders>();
orderses.add(order);
order.setPId(person);
person.setOrdersCollection(orderses);

//sessionFactory.getCurrentSession().persist(person);
// sessionFactory.getCurrentSession().saveOrUpdate(person);


personContext.add(person);

return "ok";
}
}

堆栈跟踪

type Exception report

message Request processing failed; nested exception is org.springframework.orm.hibernate4.HibernateOptimisticLockingFailureException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.orm.hibernate4.HibernateOptimisticLockingFailureException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
root cause

org.springframework.orm.hibernate4.HibernateOptimisticLockingFailureException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:205)
org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:730)
org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:592)
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757)
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726)
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:521)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
com.springcookbook.dao.Persons$$EnhancerBySpringCGLIB$$4ce50ac7.add(<generated>)
com.springcookbook.controller.HelloController.hi(HelloController.java:68)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:497)
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
root cause

org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:81)
org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:73)
org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:63)
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3281)
org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3183)
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3525)
org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:159)
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222)
org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:425)
org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:177)
org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:584)
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757)
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726)
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:521)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
com.springcookbook.dao.Persons$$EnhancerBySpringCGLIB$$4ce50ac7.add(<generated>)
com.springcookbook.controller.HelloController.hi(HelloController.java:68)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:497)
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)

最佳答案

您永远不会设置订单的人,并且它不能为空,因为您对 p_id 有非空约束。

此外,无关紧要,但是使用 @Component@Transactional 注释实体完全没有意义。您应该删除这些注释。

编辑:

另一个问题是您正在创建一个带有指定 ID (12) 的订单,尽管您告诉 Hibernate 该 ID 应该是自动生成的。结果,当“保存或更新”订单时,Hibernate 必须决定是否必须保存它或更新它。它是如何做到的?通过检查实体是否已有 ID。由于它有一个 (12),它决定更新而不是保存。结果失败了,因为数据库中没有 ID 为 12 的订单。

关于java - Hibernate @OneToMany 来自更新 [0] 的意外行数;实际行数 : 0; expected: 1,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/32798828/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com