Hi folks

I am trying to retrieve all the URLs for a given username.
I have three tables.
(1) url_links having (username, url_link) as a composite key
username is the foreign key to the register table.
(2) register where username is the primary key
What is a correct way of finding all the urls with given username?
My code below returns a null list.

Please provide a code snippet.

Thanks.

Yogi

Hibernate version: 2.1

Mapping documents:
<hibernate-mapping package="mydomain.persistence">
<class name="UrlLinks" table="url_links">
<composite-id class="UrlLinksPK" name="id">
<key-property
column="url_location"
name="urlLocation"
type="string"
/>
<key-many-to-one
class="Register"
column="username"
name="username"
/>
</composite-id>
<property
column="date_modified"
length="19"
name="dateModified"
not-null="false"
type="timestamp"
/>
-----
</hibernate-mapping >


Code between sessionFactory.openSession() and session.close():
sess = HibernateSession.currentSession();
Register r = new Register();
r.setUsername(username);
UrlLinksPK ulpk = new UrlLinksPK("", r);
UrlLinks ul = new UrlLinks();
ul.setId(ulpk);
List results = sess.createCriteria(UrlLinks.class)
.add( Example.create(ul) )
.list();
System.out.println(results.size());

Full stack trace of any exception that occurs:

Name and version of the database you are using:
MySQL 4.1

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

From the reference manual chapter 12.6. Example queries:
Version properties, identifiers and associations are ignored.

HTH
Ernst

AFAIK yes.
Since identifiers are ignored for example queries it shouldn't matter what kind of primary key you're using.

HTH
Ernst