Search in hibernate

[Nick15]

Hi!
I have a bean defined with the follow properties:

Code:

public class UserTopic implements java.io.Serializable {
private UserTopicId id;
private Topic topic;
private int personal = 0;
-------

UserTopicId is:

-----------
public class UserTopicId implements java.io.Serializable {
private String topicId;
private String userId;
-----------

Normally, to search topics for an user I did:
getHibernateTemplate().find(" from UserTopic where user_id = ?", user_id)

but I don't know how do I search with this key

Do you know?

thanks

[Alan]

hi


try this
getHibernateTemplate().find(" from UserTopic ut where ut.id.userId = ?",
user_id)

bye bye
alan

[Freddie]

If you have defined the id in the HBM you can do a load:

(key-many-to-one in hibernate 3).

session.load(UserTopic.class, new UserTopicId("id","user");

[goldhouse]

If you are looking for users starting with the given userID you can use the "Criterion" in hibernate .
Like this

Code:

List users = sess.createCriteria(User.class)
    .add( Restrictions.like("name", userID+"%") )
    .list();

[Nick15]

thanks you goldhouse! it works