[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Invalid identifier upon saving of an entity with Composite k

[j2ee4cxw]

I have following entity which has composite primary keys:

@Entity
@Table(name="TM_X_CD_X_TYPE", schema="APPL_DEV")
@IdClass(TemplateXPCodeXTypePK.class)
public class TemplateXPCodeXType implements Serializable {
        @Id
        @Column(name="TEMPLATE_ID")
        private long templateId;
        
        @Id
        @Column(name="PP_CODE_ID")      
        private long ppCodeId;
        
        @Id
        @Column(name="PT_CODE") 
        private String planTypeCode;
        public TemplateXPCodeXType(){}

        public TemplateXPCodeXType(long templateId, long ppCodeId,String 
planTypeCode)
        {
                this.ppCodeId = ppCodeId;
                this.planTypeCode = planTypeCode;               
                this.templateId = templateId;
        }

                //getters and setters
}

Here is the Id class:

public class TemplateXPCodeXTypePK implements Serializable {
        
        private long templateId;
        private long ppCodeId;
        private String planTypeCode;
        
        public TemplateXPCodeXTypePK(){}
        
        public TemplateXPCodeXTypePK(long templateId,long ppCodeId,String 
planTypeCode)
        {
                this.templateId = templateId;
                this.ppCodeId   = ppCodeId;
                this.planTypeCode= planTypeCode;
        }
        public boolean equals(Object obj)
        {
                if(obj == null) return false;
                if(obj == this) return true;
                if(!(obj instanceof TemplateXPCodeXTypePK)) return false;
                
                TemplateXPCodeXTypePK pk = (TemplateXPCodeXTypePK)obj;
                if(templateId !=pk.getTemplateId()) return false;
                if(ppCodeId != pk.getPpCodeId()) return false;
                if(!planTypeCode.equals(pk.getPlanTypeCode())) return false;
                return true;
        }
        
        public int hashCode()
        {
                return (int)templateId + (int)ppCodeId + 
planTypeCode.hashCode();
        }

                //getters and setters
}

Upon saving of TemplateXPCodeXType entity bean, I always get the following 
Invalid Identifier error:

Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC 
batch update
        at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at 
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at 
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
        at 
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at 
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:515)
        ... 171 more
Caused by: java.sql.BatchUpdateException: ORA-00904: "PLANTYPECODE": invalid 
identifier

        at 
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
        at 
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10720)
        at 
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:519)
        at 
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
        at 
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)

Any help is greatly appreciated. Thanks.

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4172288#4172288

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4172288
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user