我有一个PostgreSQL数据库,我想用Hibernate获取一些数据。我有一个类似的实体;
@Entity
public class User {
@Id
@Type(type = "uuid-binary")
@GenericGenerator(name = "user-generator", strategy = "uuid2")
@GeneratedValue(generator = "user-generator")
@Column(name = "user_id", length = 16, unique = true, nullable = false)
private UUID userId;
....
}当我尝试用Hibernate获取所有的用户值时,没有问题。Hibernate映射UUID字段。但是,当我尝试使用UUID获取特定用户时,它会返回空结果。如何获取具有userId值的单个用户?
List<User> users = userDao.getAll(); //I can get all users with non-empty userId fields
userDao.getWithId(users.get(0).getUserId()) // returns null.
users.get(0).getUserId() //returns java.util.UUID instance like "33333-3333..."编辑:
public User getWithId(UUID Id) {
EntityManager em = emFactory.createEntityManager();
try {
CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
CriteriaQuery<User> criteriaQuery = criteriaBuilder.createQuery(User.class);
Root<User> typeRoot = criteriaQuery.from(User.class);
criteriaQuery.select(typeRoot).where(criteriaBuilder.equal(typeRoot.get("userId"), Id));
final Query query = em.createQuery(criteriaQuery);
return (User) JPAHelpers.getSingleResultOrNull(query);
} catch (Exception e) {
throw e;
} finally {
em.close();
}
}发布于 2020-01-06 06:28:44
尽管,您没有共享getWithId()方法的实现。我假设您使用的是JPA存储库方法。尝试用以下方式对UUID字段进行注释:
@Type(type="org.hibernate.type.UUIDBinaryType")或
@Type(type="org.hibernate.type.UUIDCharType") // if column is VARCHAR或者尝试在columnDefinition注释中定义@Column参数:
@Column(name = "user_id", columnDefinition = "BINARY(16)", unique = true, nullable = false)https://stackoverflow.com/questions/59607408
复制相似问题