SELECT OBJECT(s) FROM Customer AS s WHERE s.lastName=?1

<?xml version="1.0"?>

<!DOCTYPE EJB-jar PUBLIC '-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN' 
 'http://java.sun.com/dtd/ejb-jar_2_0.dtd'>

<ejb-jar>
  <enterprise-beans>
     <entity>
        <ejb-name>CustomerCMPBean</ejb-name>
        <home>MyCustomerEJB.CustomerHome</home>
        <remote>MyCustomerEJB.Customer</remote>
        <ejb-class>MyCustomerEJB.CustomerBean</ejb-class>
        <persistence-type>Container</persistence-type>
        <prim-key-class>java.lang.String</prim-key-class>
        <reentrant>False</reentrant>
        <cmp-version>2.x</cmp-version>
        <abstract-schema-name>CustomerCMPBean</abstract-schema-name>

        <cmp-field>
           <field-name>ssn</field-name>
        </cmp-field>
        <cmp-field>
           <field-name>name</field-name>
        </cmp-field>
        <cmp-field>
           <field-name>password</field-name>
        </cmp-field>

        <primkey-field>ssn</primkey-field>

        <query>
           <description>finds customers in a given name</description>
           <query-method>
               <method-name>findByName</method-name>
               <method-params>
                   <method-param>java.lang.String</method-param>
               </method-params>
           </query-method>
           <ejb-ql>
              <![CDATA[SELECT OBJECT(s) FROM CustomerCMPBean AS s WHERE s.name=?1]]>
           </ejb-ql>
        </query>
     </entity>
  </enterprise-beans>

<assembly-descriptor>
   <container-transaction>
      <method>
          <ejb-name>CustomerCMPBean</ejb-name>
          <method-name>*</method-name>
      </method>
      <trans-attribute>Required</trans-attribute>
   </container-transaction>
</assembly-descriptor>

</ejb-jar>

<?xml version="1.0"?>

<!DOCTYPE weblogic-rdbms-jar PUBLIC 
 '-//BEA Systems, Inc.//DTD WebLogic 6.0.0 EJB RDBMS Persistence//EN'
 'http://www.bea.com/servers/wls600/dtd/weblogic-rdbms20-persistence-600.dtd'>

<weblogic-rdbms-jar>
  <weblogic-rdbms-bean>
    <ejb-name>CustomerCMPBean</ejb-name>
    <data-source-name>CustomerDB</data-source-name>
    <table-name>customer</table-name>
    <field-map>
      <cmp-field>ssn</cmp-field>
      <dbms-column>SSN</dbms-column>
    </field-map>
    <field-map>
      <cmp-field>name</cmp-field>
      <dbms-column>NAME</dbms-column>
    </field-map>
    <field-map>
      <cmp-field>password</cmp-field>
      <dbms-column>PASSWORD</dbms-column>
    </field-map>
</weblogic-rdbms-bean>
</weblogic-rdbms-jar>