I am using the latest version of Hibernate as of about 12/09, and every time I try to map a collection as a List, I get an error like this:

Hibernate: select luoutcomes0_.ACT_ID as ACT2_1_, luoutcomes0_.OUTC_ID as OUTC1_1_, luoutcomes0_.idx as idx1_, luoutcomes0_.OUTC_ID as OUTC1_15_0_, luoutcomes0_.ACT_ID as ACT2_15_0_, luoutcomes0_.OUTC_NAME as OUTC3_15_0_, luoutcomes0_.OUTC_DESC as OUTC4_15_0_, luoutcomes0_.OUTC_ENABLED as OUTC5_15_0_, luoutcomes0_.DESCRIPTION as DESCRIPT6_15_0_ from WEBPT.PI_LU_OUTCOME luoutcomes0_ where luoutcomes0_.ACT_ID=?

Jan 29, 2010 8:33:47 AM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 904, SQLState: 42000
Jan 29, 2010 8:33:47 AM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: ORA-00904: "LUOUTCOMES0_"."IDX": invalid identifier


This is a very simple one-to-many mapping, mapped as a List:

<class name="....LuAction" table="PI_LU_ACTION" schema="..." lazy="false">
:
<list name="luOutcomes" table="PI_LU_OUTCOME">
<key>
<column name="ACT_ID" precision="22" scale="0" not-null="true" />
</key>
<list-index base="0" />
<one-to-many class="....LuOutcome" />
</list>


But we see the same error on every mapping involving a List.


Finally, despite the lazy="false", it insists on lazy loading the collection. I guess I have to put lazy="false" on every collection?


Thanks. If we can't get this resolved, we'll have to use EclipseLink, which doesn't seem to suffer from these issues.

John K.