我正在尝试使用JpaRepository通过ID从数据库中获取对象,并且遇到了一些麻烦。这是具有EmbeddedId的实体。
我试图通过两种不同的方式来获取对象:
使用命名查询(findById)
使用SowServiceImpl中的方法
我尝试使用命名方法获取它时遇到的异常是:
@Override
public SowDocument getById(int i) {
SowDocument wow = sowRepository.findById(i);
if (wow == null) {
System.out.println("NULLLLLLLLLLLLLLLL");
return null;
} else {
return wow;
}
}
HTTP Status 500 - Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: Parameter with that position [1] did not exist; nested exception is java.lang.IllegalArgumentException: Parameter with that position [1] did not exist
...
...
at com.sun.proxy.$Proxy791.findById(Unknown Source)
at com.**.pricing.web.services.impl.SowServiceImpl.getById(SowServiceImpl.java:61)
at com.**.pricing.web.controllers.UserController.getSowById(UserController.java:99)
当我尝试使用EmbeddedId获取它时,我得到了NullPointerException:
@Override
public SowDocument getById(int i) {
SowDocumentPK peek = new SowDocumentPK();
peek.setId(i);
SowDocument wow = sowRepository.findOne(peek);
if (wow == null) {
System.out.println("NULLLLLLLLLLLLLLLL");
return null;
} else {
return wow;
}
}
这是对象:
@Entity
@Table(name = "SowDocument", uniqueConstraints = {
@UniqueConstraint(columnNames = {"id"})})
@XmlRootElement
@NamedQueries({
@NamedQuery(name = "SowDocument.findAll", query = "SELECT s FROM SowDocument s"),
@NamedQuery(name = "SowDocument.findById", query = "SELECT s FROM SowDocument s WHERE s.sowDocumentPK.id = :id"),
@NamedQuery(name = "SowDocument.findByClientName", query = "SELECT s FROM SowDocument s WHERE s.clientName = :clientName"),
@NamedQuery(name = "SowDocument.findByCreationDate", query = "SELECT s FROM SowDocument s WHERE s.creationDate = :creationDate"),
@NamedQuery(name = "SowDocument.findByDocumentCreator", query = "SELECT s FROM SowDocument s WHERE s.sowDocumentPK.documentCreator = :documentCreator"),
@NamedQuery(name = "SowDocument.findBySowType", query = "SELECT s FROM SowDocument s WHERE s.sowType = :sowType")})
public class SowDocument implements Serializable {
private static final long serialVersionUID = 1L;
@EmbeddedId
protected SowDocumentPK sowDocumentPK;
@Size(max = 50)
@Column(name = "clientName", length = 50)
private String clientName;
@Size(max = 45)
@Column(name = "creationDate", length = 45)
private String creationDate;
@Lob
@Column(name = "data")
private byte[] data;
@Size(max = 45)
@Column(name = "sowType", length = 45)
private String sowType;
@JoinColumn(name = "documentCreator", referencedColumnName = "id", nullable = false, insertable = false, updatable = false)
@ManyToOne(optional = false)
private User user;
public SowDocument() {
}
public SowDocument(SowDocumentPK sowDocumentPK) {
this.sowDocumentPK = sowDocumentPK;
}
public SowDocument(int id, int documentCreator) {
this.sowDocumentPK = new SowDocumentPK(id, documentCreator);
}
public SowDocumentPK getSowDocumentPK() {
return sowDocumentPK;
}
public void setSowDocumentPK(SowDocumentPK sowDocumentPK) {
this.sowDocumentPK = sowDocumentPK;
}
public String getClientName() {
return clientName;
}
public void setClientName(String clientName) {
this.clientName = clientName;
}
public String getCreationDate() {
return creationDate;
}
public void setCreationDate(String creationDate) {
this.creationDate = creationDate;
}
public byte[] getData() {
return data;
}
public void setData(byte[] data) {
this.data = data;
}
public String getSowType() {
return sowType;
}
public void setSowType(String sowType) {
this.sowType = sowType;
}
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
@Override
public int hashCode() {
int hash = 0;
hash += (sowDocumentPK != null ? sowDocumentPK.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 SowDocument)) {
return false;
}
SowDocument other = (SowDocument) object;
if ((this.sowDocumentPK == null && other.sowDocumentPK != null) || (this.sowDocumentPK != null && !this.sowDocumentPK.equals(other.sowDocumentPK))) {
return false;
}
return true;
}
}
这是其嵌入式ID:
@Embeddable
public class SowDocumentPK implements Serializable {
@Basic(optional = false)
@Column(name = "id", nullable = false)
private int id;
@Basic(optional = false)
@NotNull
@Column(name = "documentCreator", nullable = false)
private int documentCreator;
public SowDocumentPK() {
}
public SowDocumentPK(int id, int documentCreator) {
this.id = id;
this.documentCreator = documentCreator;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getDocumentCreator() {
return documentCreator;
}
public void setDocumentCreator(int documentCreator) {
this.documentCreator = documentCreator;
}
@Override
public int hashCode() {
int hash = 0;
hash += (int) id;
hash += (int) documentCreator;
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 SowDocumentPK)) {
return false;
}
SowDocumentPK other = (SowDocumentPK) object;
if (this.id != other.id) {
return false;
}
return this.documentCreator == other.documentCreator;
}
}
这是SowRepository的代码:
public interface SowRepository extends JpaRepository<SowDocument, Serializable> {
SowDocument findById(int i);
}
这是SowService的代码:
@Service
public class SowServiceImpl implements SowService {
@Autowired
private SowRepository sowRepository;
@Override
public void save(SowDocument sow) {
sowRepository.save(sow);
}
@Override
public Collection<SowDocument> getAll() {
return sowRepository.findAll();
}
@Override
public SowDocument getById(int i) {
SowDocumentPK peek = new SowDocumentPK();
peek.setId(i);
return sowRepository.findOne(i);
}
}
我的猜测是我以某种方式在SowDocument / SowDocumentPK之间存在错误的映射,或者误解了如何使用JpaRepository。
最佳答案
我猜您正在使用SpringData JPA。如果正确,请查看如何定义CrudRepository
接口(JpaRepostory
接口的超级类型):
public interface CrudRepository<T, ID extends Serializable> extends Repository<T, ID> {
...
T findOne(ID id);
...
}
并且您将这个接口扩展为(顺便说一句,您也应该发布了实现):
public interface SowRepository extends JpaRepository<SowDocument, Serializable> {
SowDocument findById(int i);
}
findById(int i)
方法未在JpaRepository
类型层次结构的任何接口中定义,这意味着它是您自己的扩展。另一方面,您没有ID为
int
类型的实体。您实体的ID类型定义为ShowDocumentPK
类型,该类型由两个字段组成。因此,您的存储库定义应如下所示:
public interface SowRepository extends JpaRepository<SowDocument, ShowDocumentPK> {
SowDocument findById(ShowDocumentPK id);
}
并自行实现方法
findById()
(或使用JpaRepository
的官方实现类,即SimpleJpaRepository
)。然后,您应该创建
ShowDocumentPK
的实例并将其传递给findById()
方法,例如:SowDocumentPK peek = new SowDocumentPK();
peek.setId(1);
peek.setDocumentCreator(100);
SowDocument wow = sowRepository.findById(peek);
结论:您的ID并非
int
类型,并且findById(int)
不是您的情况下实现方式。希望这可以为您提供一个如何正确实施的想法。