[jboss-user] [EJB 3.0] - Re: ERM to Entity relationship problem

[te-bachi]

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#4006786

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4006786