0 Replies Latest reply on Mar 4, 2004 5:22 AM by ebende

    DeploymentException for CMP2.0 EJB with compound PK

    ebende

      key words: compound, multiple, primary keys, PK, CMP2.0, EJB.


      Hi everybody,

      I have question concerning compound primary keys in CMP2.0 EJBs.
      I've got a deployment error: "Generation only supported with single PK field" from Jboss 3.2.2 (See below).
      From other threads it appears that other people manage to deploy CMP EJBs with compound keys.
      How do they do it?
      Do I need to configure someting in JBoss in addition?
      For CMP EJBs with single PKs everything works fine.
      My codes and xml-pieces for a vey simple test-bean ("A") with corresponding DB table ("a") are listed below.
      I appreciate any help.

      Thanks,

      Evert Bende

      PS:
      The PK-class was generated by Borland JBuilderX.
      My table is stored in a MySQL database.
      None of the pks in table "a" are auto-incremented.
      I also tried it with a create statement with a single argument, like ejbCreate(APK apk){...}
      //////////////////////////////////////////
      Deployment Error from JBOSS-3.2.2
      //////////////////////////////////////////
      2004-03-04 11:37:08,501 ERROR [org.jboss.ejb.EntityContainer] Starting failed
      org.jboss.deployment.DeploymentException: Generation only supported with single PK field
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.getGeneratedPKField(JDBCAbstractCreateCommand.java:171)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCIdentityColumnCreateCommand.initGeneratedFields(JDBCIdentityColumnCreateCommand.java:46)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.init(JDBCAbstractCreateCommand.java:91)
      at org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCMySQLCreateCommand.init(JDBCMySQLCreateCommand.java:40)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createCreateEntityCommand(JDBCCommandFactory.java:128)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:427)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:351)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
      at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:343)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
      at sun.reflect.GeneratedMethodAccessor133.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      //////////////////////////////////////////
      ABean
      //////////////////////////////////////////
      package com.wattabout.wattsbest.ejb.cmp;
      import javax.ejb.EntityBean;
      import javax.ejb.EntityContext;
      import javax.ejb.CreateException;
      import javax.ejb.RemoveException;
      public abstract class ABean
      implements EntityBean {
      EntityContext entityContext;
      public APK ejbCreate(Integer apk1, Integer apk2) throws CreateException {
      setApk1(apk1);
      setApk2(apk2);
      return null;
      }
      public void ejbPostCreate(Integer apk1, Integer apk2) throws CreateException { }
      public void ejbRemove() throws RemoveException { }
      public abstract void setAfld(String afld);
      public abstract void setApk1(Integer apk1);
      public abstract void setApk2(Integer apk2);
      public abstract String getAfld();
      public abstract Integer getApk1();
      public abstract Integer getApk2();
      public void ejbLoad() { }
      public void ejbStore() { }
      public void ejbActivate() { }
      public void ejbPassivate() { }
      public void setEntityContext(EntityContext entityContext) { this.entityContext = entityContext; }
      public void unsetEntityContext() { this.entityContext = null; }
      }
      //////////////////////////////////////////
      A
      //////////////////////////////////////////
      package com.wattabout.wattsbest.ejb.cmp;
      import javax.ejb.EJBLocalObject;
      public interface A extends EJBLocalObject {
      public void setAfld(String afld);
      public String getAfld();
      public Integer getApk1();
      public Integer getApk2();
      }
      //////////////////////////////////////////
      AHome
      //////////////////////////////////////////
      package com.wattabout.wattsbest.ejb.cmp;
      import javax.ejb.EJBLocalHome;
      import javax.ejb.CreateException;
      import javax.ejb.FinderException;
      public interface AHome extends EJBLocalHome {
      public A create(Integer apk1, Integer apk2) throws CreateException;
      public A findByPrimaryKey(APK pk) throws FinderException;
      }
      //////////////////////////////////////////
      APK
      //////////////////////////////////////////
      package com.wattabout.wattsbest.ejb.cmp;
      import java.io.Serializable;
      public class APK
      implements Serializable {
      public Integer apk1;
      public Integer apk2;
      public APK() {
      }
      public APK(Integer apk1, Integer apk2) {
      this.apk1 = apk1;
      this.apk2 = apk2;
      }
      public boolean equals(Object obj) {
      if (this == obj) {
      return true;
      }
      if (! (obj instanceof APK)) {
      return false;
      }
      APK that = (APK) obj;
      if (! (that.apk1 == null ? this.apk1 == null : that.apk1.equals(this.apk1))) {
      return false;
      }
      if (! (that.apk2 == null ? this.apk2 == null : that.apk2.equals(this.apk2))) {
      return false;
      }
      return true;
      }
      public int hashCode() {
      int result = 17;
      result = 37 * result + this.apk1.hashCode();
      result = 37 * result + this.apk2.hashCode();
      return result;
      }
      }
      //////////////////////////////////////////
      ejb-jar.xml
      //////////////////////////////////////////

      <display-name>A</display-name>
      <ejb-name>A</ejb-name>
      <local-home>com.wattabout.wattsbest.ejb.cmp.AHome</local-home>
      com.wattabout.wattsbest.ejb.cmp.A
      <ejb-class>com.wattabout.wattsbest.ejb.cmp.ABean</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>com.wattabout.wattsbest.ejb.cmp.APK</prim-key-class>
      False
      <cmp-version>2.x</cmp-version>
      <abstract-schema-name>A</abstract-schema-name>
      <cmp-field>
      <field-name>afld</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>apk1</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>apk2</field-name>
      </cmp-field>

      //////////////////////////////////////////
      jbosscmp-jdbc.xml
      //////////////////////////////////////////

      <ejb-name>A</ejb-name>
      <table-name>a</table-name>
      <cmp-field>
      <field-name>afld</field-name>
      <column-name>afld</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>apk1</field-name>
      <column-name>apk1</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>apk2</field-name>
      <column-name>apk2</column-name>
      </cmp-field>