Hibernate version:
Hibernate 2.0.3

Mapping documents:
N/A

Code between sessionFactory.openSession() and session.close():
N/A

Full stack trace of any exception that occurs:
N/A

Name and version of the database you are using:
Sybase ASE 12.0

The generated SQL (show_sql=true):
N/A

Debug level Hibernate log excerpt:
N/A

So, my problem is this: the schema I am working with has a one-to-many relationship between users and username/password combos in order to support multiple websites. Call it future-proofing. For any given website, however, there is only one row in the u/p table which is relevant, and from an object-modeling perspective I would like to represent the relationship as one-to-one. I saw the section of the docs for named SQL queries but it wasn't clear how that could be used for achieving what I want to do.

If there is a section in the documentation which explains this (and which I obviously have not found!) then please point me in that direction. Otherwise, I need to know if what I want to do is possible.

Thanks,
Ken Flagg