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

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Hi,

I have my own user defined types that that get mapped to multiple columns. Example
<property name="myProp" type="MyCustomType">
<column name="FIRST_COLUMN"/>
<column name="SECOND_COLUMN"/>

In a HQL query how can I specify to which column I am referring to, without specifying the column name. Is there a syntax that will allow me to specify which column I am referring to. For example myFeature.myProp[0]

Thanks,

I assume that your user type implements CompositeUserType. Look at the getPropertyNames() method - it returns the logical names of "sub-properties" inside your custom type. Use these names to refer to the elements of the composite type. For example, if your custom type returns {"myField1", "myField2"}, and you map it like you said in your post, then you refer to them as myProp.myField1 and myProp.myField2 in HQL.

I hope this helps.