Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.0.4

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

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

Debug level Hibernate log excerpt:

Can I map between two tables (one-to-many on one side and many-to-one on the other) when the columns mapped are of differrent types? One side has a numeric value and the other is a string with 0's prepending the save value. Any examples posted anywhere to help me with this?

Are UserTypes the way to go with this?

Thanks.

Just want to bring this up one more time. I went through the documentation and Hibernate in Action book. No example on how to associate two table on columsn of different types. I have come up with solutions, but they are ugly. Anything elegant that I can just do using mapping files and UserTypes?

Thanks.