Fourth approach: Exception: | 12:20:59,153 INFO [STDOUT] Hibernate: select auditsearc0_.TEMPLATE_ID as TEMPLATE1_23_0_, auditsearc0_.KEY as KEY23_0_ from UGIS1004.GIS_T_AUDIT_SEARCH_TEMPL auditsearc0_ where auditsearc0_.TEMPLATE_ID=? | 12:20:59,449 INFO [STDOUT] Hibernate: select auditsearc0_.templateId_TEMPLATE_ID as templateId6_2_, auditsearc0_.CRITERIA_ID as CRITERIA1_2_, auditsearc0_.TEMPLATE_ID as TEMPLATE2_2_, auditsearc0_.CRITERIA_ID as CRITERIA1_21_1_, auditsearc0_.TEMPLATE_ID as TEMPLATE2_21_1_, auditsearc0_.criteriaId_CRITERIA_ID as criteriaId5_21_1_, auditsearc0_.templateId_TEMPLATE_ID as templateId6_21_1_, auditsearc0_.CRITERIA_ORDER as CRITERIA3_21_1_, auditsearc0_.IS_SPECIFIC as IS4_21_1_, auditsearc1_.CRITERIA_ID as CRITERIA1_22_0_, auditsearc1_.KEY as KEY22_0_, auditsearc1_.TYPE as TYPE22_0_, auditsearc1_.IS_SPLITTED as IS4_22_0_ from UGIS1004.GIS_T_AUDIT_SEARCH_ASSIGN auditsearc0_ inner join UGIS1004.GIS_T_AUDIT_SEARCH_CRIT auditsearc1_ on auditsearc0_.criteriaId_CRITERIA_ID=auditsearc1_.CRITERIA_ID where auditsearc0_.templateId_TEMPLATE_ID=? | 12:20:59,496 WARN [JDBCExceptionReporter] SQL Error: 904, SQLState: 42000 | 12:20:59,496 ERROR [JDBCExceptionReporter] ORA-00904: "AUDITSEARC0_"."CRITERIAID_CRITERIA_ID": ungültiger Bezeichner | | 12:20:59,496 ERROR [STDERR] org.hibernate.exception.SQLGrammarException: could not initialize a collection: [gis.audit.entity.AuditSearchTemplateEntity.auditSearchAssignEntities#1] | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) | at org.hibernate.loader.Loader.loadCollection(Loader.java:1925) | [...] | | @Entity(name = "AuditSearchAssignEntity") | @Table(schema = "UGIS1004", name = "GIS_T_AUDIT_SEARCH_ASSIGN") | public class AuditSearchAssignEntity { | private AuditSearchAssignPK pk; | private BigInteger criteriaOrder; | private BigInteger isSpecific; | private AuditSearchCriteriaEntity criteriaId; | private AuditSearchTemplateEntity templateId; | | @EmbeddedId | public AuditSearchAssignPK getPk() { | return pk; | } | | public void setPk(AuditSearchAssignPK pk) { | this.pk = pk; | } | | @ManyToOne | @JoinColumn(referencedColumnName = "CRITERIA_ID", nullable = false) | public AuditSearchCriteriaEntity getCriteriaId() { | return criteriaId; | } | | public void setCriteriaId(AuditSearchCriteriaEntity criteriaId) { | this.criteriaId = criteriaId; | } | | @ManyToOne | @JoinColumn(referencedColumnName = "TEMPLATE_ID", nullable = false) | public AuditSearchTemplateEntity getTemplateId() { | return templateId; | } | | public void setTemplateId(AuditSearchTemplateEntity templateId) { | this.templateId = templateId; | } | | @Column(name = "CRITERIA_ORDER", nullable = false, length = 4) | public BigInteger getCriteriaOrder() { | return criteriaOrder; | } | | public void setCriteriaOrder(BigInteger criteriaOrder) { | this.criteriaOrder = criteriaOrder; | } | | @Column(name = "IS_SPECIFIC", nullable = false, length = 1) | public BigInteger getIsSpecific() { | return isSpecific; | } | | public void setIsSpecific(BigInteger specific) { | isSpecific = specific; | } | } | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4006786#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...