Hibernate version: 2.1.6

I've seen the DoubleString type, as an example of a UserType implementation which deals with more than one column. What I don't understand is how to communicate which of the columns each name relates to. This is important if I have two columns of different types.

Is the order of the names guaranteed to be the order they appear in the passed array of column names? Is that how to do this?

Essentially I have an Integer and a String which I would like to fetch within the same implementation of UserType. Suggestions?

Thanks,
Phill

The property names returned by getPropertyNames() are just for querying in an HQL query. They have no relation to the column names passed to the nullSafeGet() method, which come from the mapping.

That's okay. My question is about the 'names' array passed to nullSafeGet. If I expect two values in that array, and one should reference an Integer column, and one should reference a String column... how do I know which is which?

I suppose for some people, the order of even two String columns might be important. One might be english and one might be spanish (an awful approach to localization, but you get my point :))

The DoubleString example doesn't care about this stuff because both strings mean the same thing, essentially. They're interchangeable.

So is there a solution to this? Should I depend on the order in which the properties were defined in the mapping to be retained in the names[] array?

Am I making sense?

Thanks for your help, Michael.

Phill

It's the same order as in the getPropertyType() array you return

Okay. That makes sense to me now. I think the main reason this has been so confusing is because the types of the individual properties of my returnedClass() aren't both basic hibernate types. Now I'm a bit confused as to how to implement getPropertyValue() and setPropertyValue().

I'm trying to create a CompositeUserType that handles the persistence of the following class:



The getType() method on this class returns an Enum class (which serializes to an integer). My CompositeUserType stuff seems fairly straight forward except for the getPropertyValue() and setPropertyValue() implementations. For the Type property, should I return an integer or the Enum value? Right now I'm returning the type Hibernate.INTEGER for that column, is that correct or do I need yet another UserType implementation for this?

I have a similar issue with my getData() property also. I'm storing it as a string in the database.

What are setPropertyValue() and getPropertyValue() used for?

Thanks
Phill