Hibernate get Object by non ID , unique identifier

2019-07-20 04:43发布

问题:

I have the following object:

    @Id
    @GeneratedValue
    private long id;
    @Column(name = "uniqueId", unique=true)
    private String uniqueId;

is it possible to get an object from the DB that has object.uniqueId == "some_unique_id"??

thanks.

回答1:

String hql = "select foo from Foo foo where foo.uniqueId = :uniqueId";
return (Foo) session.createQuery(hql)
                    .setString("uniqueId", theUniqueId)
                    .uniqueResult();