RE: Request for CMP using Compound Key example

[Dale de los Reyes]

Ugh, my bad. I need to make a correction on the ejb home methods. They 
should be:

SomeCMP create(SomePrimaryKey key)
SomeCMP findByPrimaryKey(SomePrimaryKey key)
NOT

someBean create(SomePrimaryKey key)
someBean findByPrimaryKey(SomePrimaryKey key)

Apologies,
Dale


From: "Dale de los Reyes" <[EMAIL PROTECTED]>
Reply-To: user@geronimo.apache.org
To: user@geronimo.apache.org
Subject: Request for CMP using Compound Key example
Date: Mon, 06 Mar 2006 13:18:08 -0800

Hello,

If anyone knows an example CMP entity bean that uses a compound/primary key 
class, please point me in the right direction. Or if someone knows what I'm 
missing. I would appreciate the help.

Using Geronimo with Tomcat 1.0 and Derby bundled in same package:

I created a simple entity bean with the following methods in the home 
class:
(Note: full syntax omiited for brevity)
someBean create(SomePrimaryKey key)
someBean findByPrimaryKey(SomePrimaryKey key)
Collection findByAll()

public final class SomePrimaryKey
{
  public Integer id;
  public String desc;

  SomePrimaryKey() {}

  public boolean equals(Object other) {
     if (other instanceof SomePrimaryKey) {
        return (id.equals(((SomePrimaryKey)other).id));
     }
  }

  public int hashCode()
  {
     return id.hashCode();
  } // end hashCode
}

I know the above isn't using a compound key "per se", but GERONIMO-1361 
regarding compound keys with only 1 key is now closed, and should be 
working in Geronimo 1.0.

Anyway, I'm able to use this key class with BMP. However, when I switch the 
implementation to CMP, only the "create" and "findByAll" methods work. The 
"findByPrimaryKey" is unable to locate an existing entry in the database 
and instead returns an "ObjectNotFoundException".

When I convert the CMP to use a simple primary key (i.e. Integer 
primaryKey), all the CMP home methods work.

The examples I've seen so far (Product Line example in Mastering EJB 2nd ed 
and the examples bundled in the Geronimo docs), do not specify any EJB-QL 
code in the descriptors for the "findByPrimaryKey" method.

Here's a portion of my ejb-jar.xml descriptor
  <enterprise-beans>
     <entity>
        <ejb-name>SomeCMPEntityBean</ejb-name>
        <home>some.ejb.SomeCMPHome</home>
        <remote>some.ejb.SomeCMP</remote>
        <ejb-class>some.ejb.SomeCMPEntityBean</ejb-class>

        <persistence-type>Container</persistence-type>
        <!-- <prim-key-class>java.lang.Integer</prim-key-class> -->
        <prim-key-class>some.ejb.SomePrimaryKey</prim-key-class>
        <reentrant>False</reentrant>
        <cmp-version>2.x</cmp-version>
        <abstract-schema-name>SomeCMP</abstract-schema-name>

        <cmp-field>
           <field-name>id</field-name>
        </cmp-field>

        <cmp-field>
           <field-name>desc</field-name>
        </cmp-field>

        <!-- omitted when using compound key -->
        <!-- <primkey-field>id</primkey-field> -->

        <resource-ref>
           <description>DataSource for MachineShop Database</description>
           <res-ref-name>jdbc/MachineShopDataSource</res-ref-name>
           <res-type>javax.sql.DataSource</res-type>
           <res-auth>Container</res-auth>
        </resource-ref>

        <!-- No query tag needed for findByPrimaryKey? -->

        <query>
           <query-method>
              <method-name>findByAll</method-name>
              <method-params></method-params>
           </query-method>

           <ejb-ql>
           <![CDATA[select object(b) from SomeCMP as b]]>
           </ejb-ql>
        </query>
     </entity>
  <enterprise-beans>

Here's a portion of my openejb-jar.xml
<cmp-connection-factory>
  <resource-link>SomeDatabasePool</resource-link>
</cmp-connection-factory>

<enterprise-beans>
   <entity>
       <ejb-name>SomeCMPEntityBean</ejb-name>
       <jndi-name>SomeCMPRemoteEntity</jndi-name>

       <table-name>generic_table</table-name>
       <cmp-field-mapping>
          <cmp-field-name>id</cmp-field-name>
          <table-column>id</table-column>
       </cmp-field-mapping>

       <cmp-field-mapping>
          <cmp-field-name>desc</cmp-field-name>
          <table-column>description</table-column>
       </cmp-field-mapping>

       <resource-ref>
           <ref-name>jdbc/SomeDataSource</ref-name>
           <resource-link>SomeDatabasePool</resource-link>
       </resource-ref>
   </entity>
</enterprise-beans>

Again, any help is most appreciated.

Thanks,
Dale