I don't know what do about my problem with my ejb-ql finder method! it giving me back a collection according to only one parameter and not according to both of them. plz look at the attached file and tell if if u can find a problem with the ejb-ql finder method with the two parameters. 10x ahead, netanel
<?xml version="1.0"?> <!DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 1.1//EN" "http://java.sun.com/j2ee/dtds/ejb-jar_1_1.dtd"> <ejb-jar> <enterprise-beans> <entity> <ejb-name>CustomersBean</ejb-name> <home>Companies.Customers.CustomersHome</home> <remote>Companies.Customers.Customers</remote> <ejb-class>Companies.Customers.CustomersBean</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>Customers</abstract-schema-name> <cmp-field> <field-name>code</field-name> </cmp-field> <cmp-field> <field-name>namecompany</field-name> </cmp-field> <cmp-field> <field-name>ws</field-name> </cmp-field> <cmp-field> <field-name>status</field-name> </cmp-field> <cmp-field> <field-name>address</field-name> </cmp-field> <cmp-field> <field-name>bldg</field-name> </cmp-field> <cmp-field> <field-name>location</field-name> </cmp-field> <cmp-field> <field-name>city</field-name> </cmp-field> <cmp-field> <field-name>country</field-name> </cmp-field> <cmp-field> <field-name>pobox</field-name> </cmp-field> <cmp-field> <field-name>operationfrom</field-name> </cmp-field> <cmp-field> <field-name>operationto</field-name> </cmp-field> <cmp-field> <field-name>floor</field-name> </cmp-field> <cmp-field> <field-name>rm</field-name> </cmp-field> <cmp-field> <field-name>name</field-name> </cmp-field> <cmp-field> <field-name>state</field-name> </cmp-field> <cmp-field> <field-name>zip</field-name> </cmp-field> <cmp-field> <field-name>pozip</field-name> </cmp-field> <cmp-field> <field-name>idnumber</field-name> </cmp-field> <cmp-field> <field-name>ouraccountno</field-name> </cmp-field> <cmp-field> <field-name>vatnumber</field-name> </cmp-field> <cmp-field> <field-name>securityno</field-name> </cmp-field> <cmp-field> <field-name>exportercode</field-name> </cmp-field> <cmp-field> <field-name>chargefrequency</field-name> </cmp-field> <cmp-field> <field-name>dollarexchangetype</field-name> </cmp-field> <cmp-field> <field-name>internalpo</field-name> </cmp-field> <cmp-field> <field-name>termofpayments</field-name> </cmp-field> <cmp-field> <field-name>deliverylimit</field-name> </cmp-field> <cmp-field> <field-name>dutieslimit</field-name> </cmp-field> <primkey-field>code</primkey-field> <query> <query-method> <method-name>findAll</method-name> <method-params> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT a.code FROM Customers AS a ]]> </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity> <entity> <ejb-name>DepartmentBean</ejb-name> <home>Companies.Department.DepartmentHome</home> <remote>Companies.Department.Department</remote> <ejb-class>Companies.Department.DepartmentBean</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>Companies.Department.DepartmentPK</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Department</abstract-schema-name> <cmp-field> <field-name>companycode</field-name> </cmp-field> <cmp-field> <field-name>departmentname</field-name> </cmp-field> <cmp-field> <field-name>chargefrequency</field-name> </cmp-field> <cmp-field> <field-name>webpassword</field-name> </cmp-field> <query> <query-method> <method-name>findByCompanycode</method-name> <method-params> <method-param>java.lang.String</method-param> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT OBJECT(a) FROM Department AS a WHERE a.companycode = ?1]]> </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity>
<entity> <ejb-name>SupplierBean</ejb-name> <home>Companies.Supplier.SupplierHome</home> <remote>Companies.Supplier.Supplier</remote> <ejb-class>Companies.Supplier.SupplierBean</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>Companies.Supplier.SupplierPK</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Supplier</abstract-schema-name> <cmp-field> <field-name>companycode</field-name> </cmp-field> <cmp-field> <field-name>suppliertype</field-name> </cmp-field> <cmp-field> <field-name>supplier</field-name> </cmp-field> <cmp-field> <field-name>ws</field-name> </cmp-field> <cmp-field> <field-name>isdef</field-name> </cmp-field> <query> <query-method> <method-name>findByCompanycode</method-name> <method-params> <method-param>java.lang.String</method-param> <method-param>java.lang.String</method-param> </method-params> </query-method> <ejb-ql> SELECT OBJECT(a) FROM Supplier a WHERE a.companycode = ?1 AND a.suppliertype = ?2 </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity> <entity> <ejb-name>PartBean</ejb-name> <home>Companies.Part.PartHome</home> <remote>Companies.Part.Part</remote> <ejb-class>Companies.Part.PartBean</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>Companies.Part.PartPK</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Part</abstract-schema-name> <cmp-field> <field-name>companycode</field-name> </cmp-field> <cmp-field> <field-name>partnumber</field-name> </cmp-field> <cmp-field> <field-name>partdescription</field-name> </cmp-field> <cmp-field> <field-name>isdef</field-name> </cmp-field> <query> <query-method> <method-name>findByCompanycode</method-name> <method-params> <method-param>java.lang.String</method-param> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT OBJECT(a) FROM Part AS a WHERE a.companycode = ?1]]> </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity> <entity> <ejb-name>RelationswholesaleBean</ejb-name> <home>Companies.Relationswholesale.RelationswholesaleHome</home> <remote>Companies.Relationswholesale.Relationswholesale</remote> <ejb-class>Companies.Relationswholesale.RelationswholesaleBean</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>Companies.Relationswholesale.RelationswholesalePK</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Relationswholesale</abstract-schema-name> <cmp-field> <field-name>companycode</field-name> </cmp-field> <cmp-field> <field-name>wholesalename</field-name> </cmp-field> <cmp-field> <field-name>isdef</field-name> </cmp-field> <query> <query-method> <method-name>findByCompanycode</method-name> <method-params> <method-param>java.lang.String</method-param> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT OBJECT(a) FROM Relationswholesale AS a WHERE a.companycode = ?1]]> </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity> <entity> <ejb-name>RelationsnameBean</ejb-name> <home>Companies.Relationsname.RelationsnameHome</home> <remote>Companies.Relationsname.Relationsname</remote> <ejb-class>Companies.Relationsname.RelationsnameBean</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>Companies.Relationsname.RelationsnamePK</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Relationsname</abstract-schema-name> <cmp-field> <field-name>companycode</field-name> </cmp-field> <cmp-field> <field-name>name</field-name> </cmp-field> <cmp-field> <field-name>isdef</field-name> </cmp-field> <query> <query-method> <method-name>findByCompanycode</method-name> <method-params> <method-param>java.lang.String</method-param> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT OBJECT(a) FROM Relationsname AS a WHERE a.companycode = ?1]]> </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity> <entity> <ejb-name>RelationsthirdpartyBean</ejb-name> <home>Companies.Relationsthirdparty.RelationsthirdpartyHome</home> <remote>Companies.Relationsthirdparty.Relationsthirdparty</remote> <ejb-class>Companies.Relationsthirdparty.RelationsthirdpartyBean</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>Companies.Relationsthirdparty.RelationsthirdpartyPK</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Relationsthirdparty</abstract-schema-name> <cmp-field> <field-name>companycode</field-name> </cmp-field> <cmp-field> <field-name>ws</field-name> </cmp-field> <cmp-field> <field-name>thirdparty</field-name> </cmp-field> <cmp-field> <field-name>isdef</field-name> </cmp-field> <query> <query-method> <method-name>findByCompanycode</method-name> <method-params> <method-param>java.lang.String</method-param> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT OBJECT(a) FROM Relationsthirdparty AS a WHERE a.companycode = ?1]]> </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity> <entity> <ejb-name>ContactsBean</ejb-name> <home>Companies.Contacts.ContactsHome</home> <remote>Companies.Contacts.Contacts</remote> <ejb-class>Companies.Contacts.ContactsBean</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>Companies.Contacts.ContactsPK</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Contacts</abstract-schema-name> <cmp-field> <field-name>companycode</field-name> </cmp-field> <cmp-field> <field-name>name</field-name> </cmp-field> <cmp-field> <field-name>title</field-name> </cmp-field> <cmp-field> <field-name>notes</field-name> </cmp-field> <query> <query-method> <method-name>findByCompanycode</method-name> <method-params> <method-param>java.lang.String</method-param> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT OBJECT(a) FROM Contacts AS a WHERE a.companycode = ?1]]> </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity> <entity> <ejb-name>ContactspbBean</ejb-name> <home>Companies.Contactspb.ContactspbHome</home> <remote>Companies.Contactspb.Contactspb</remote> <ejb-class>Companies.Contactspb.ContactspbBean</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>Companies.Contactspb.ContactspbPK</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Contactspb</abstract-schema-name> <cmp-field> <field-name>companycode</field-name> </cmp-field> <cmp-field> <field-name>name</field-name> </cmp-field> <cmp-field> <field-name>number</field-name> </cmp-field> <cmp-field> <field-name>type</field-name> </cmp-field> <cmp-field> <field-name>ext</field-name> </cmp-field> <cmp-field> <field-name>notes</field-name> </cmp-field> <query> <query-method> <method-name>findByCompanycode</method-name> <method-params> <method-param>java.lang.String</method-param> <method-param>java.lang.String</method-param> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT OBJECT(x) FROM Contactspb AS x WHERE (x.companycode = ?1) AND (x.name = ?2)]]> </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity> <entity> <ejb-name>DiscountsBean</ejb-name> <home>Companies.Discounts.DiscountsHome</home> <remote>Companies.Discounts.Discounts</remote> <ejb-class>Companies.Discounts.DiscountsBean</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>Companies.Discounts.DiscountsPK</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Discounts</abstract-schema-name> <cmp-field> <field-name>companycode</field-name> </cmp-field> <cmp-field> <field-name>fromtotal</field-name> </cmp-field> <cmp-field> <field-name>tototal</field-name> </cmp-field> <cmp-field> <field-name>discount</field-name> </cmp-field> <query> <query-method> <method-name>findByCompanycode</method-name> <method-params> <method-param>java.lang.String</method-param> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT OBJECT(a) FROM Discounts AS a WHERE a.companycode = ?1]]> </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity> <entity> <ejb-name>OtherwsBean</ejb-name> <home>Companies.Otherws.OtherwsHome</home> <remote>Companies.Otherws.Otherws</remote> <ejb-class>Companies.Otherws.OtherwsBean</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>Companies.Otherws.OtherwsPK</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Otherws</abstract-schema-name> <cmp-field> <field-name>companycode</field-name> </cmp-field> <cmp-field> <field-name>ws</field-name> </cmp-field> <cmp-field> <field-name>otherwstextcode</field-name> </cmp-field> <query> <query-method> <method-name>findByCompanycode</method-name> <method-params> <method-param>java.lang.String</method-param> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT OBJECT(a) FROM Otherws AS a WHERE a.companycode = ?1]]> </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity> <entity> <ejb-name>MessagesBean</ejb-name> <home>Companies.Messages.MessagesHome</home> <remote>Companies.Messages.Messages</remote> <ejb-class>Companies.Messages.MessagesBean</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>Companies.Messages.MessagesPK</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Messages</abstract-schema-name> <cmp-field> <field-name>companycode</field-name> </cmp-field> <cmp-field> <field-name>datemsg</field-name> </cmp-field> <cmp-field> <field-name>timemsg</field-name> </cmp-field> <cmp-field> <field-name>ws</field-name> </cmp-field> <cmp-field> <field-name>user</field-name> </cmp-field> <cmp-field> <field-name>message</field-name> </cmp-field> <query> <query-method> <method-name>findByCompanycode</method-name> <method-params> <method-param>java.lang.String</method-param> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT OBJECT(a) FROM Messages AS a WHERE a.companycode = ?1]]> </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity> <entity> <ejb-name>WholesalesBean</ejb-name> <home>Companies.Wholesales.WholesalesHome</home> <remote>Companies.Wholesales.Wholesales</remote> <ejb-class>Companies.Wholesales.WholesalesBean</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>Wholesales</abstract-schema-name> <cmp-field> <field-name>code</field-name> </cmp-field> <cmp-field> <field-name>namecompany</field-name> </cmp-field> <cmp-field> <field-name>status</field-name> </cmp-field> <cmp-field> <field-name>address</field-name> </cmp-field> <cmp-field> <field-name>bldg</field-name> </cmp-field> <cmp-field> <field-name>location</field-name> </cmp-field> <cmp-field> <field-name>city</field-name> </cmp-field> <cmp-field> <field-name>country</field-name> </cmp-field> <cmp-field> <field-name>pobox</field-name> </cmp-field> <cmp-field> <field-name>operationfrom</field-name> </cmp-field> <cmp-field> <field-name>operationto</field-name> </cmp-field> <cmp-field> <field-name>floor</field-name> </cmp-field> <cmp-field> <field-name>rm</field-name> </cmp-field> <cmp-field> <field-name>name</field-name> </cmp-field> <cmp-field> <field-name>state</field-name> </cmp-field> <cmp-field> <field-name>zip</field-name> </cmp-field> <cmp-field> <field-name>pozip</field-name> </cmp-field> <cmp-field> <field-name>awbprefix</field-name> </cmp-field> <cmp-field> <field-name>weightunits</field-name> </cmp-field> <cmp-field> <field-name>lastexport</field-name> </cmp-field> <cmp-field> <field-name>lastimport</field-name> </cmp-field> <cmp-field> <field-name>dunentry</field-name> </cmp-field> <cmp-field> <field-name>currencytocharge</field-name> </cmp-field> <primkey-field>code</primkey-field> <query> <query-method> <method-name>findAll</method-name> <method-params> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT a.code FROM Wholesales AS a ]]> </ejb-ql> </query> <query> <query-method> <method-name>findAllAwbprefix</method-name> <method-params> </method-params> </query-method> <ejb-ql> <![CDATA[SELECT a.awbfrefix FROM Wholesales AS a ]]> </ejb-ql> </query> <resource-ref> <res-ref-name>jdbc/mySQL</res-ref-name> <jndi-name>java:/MySqlDS</jndi-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </entity> <session> <ejb-name>CompaniesBean</ejb-name> <home>Companies.CompaniesHome</home> <remote>Companies.Companies</remote> <ejb-class>Companies.CompaniesBean</ejb-class> <session-type>Stateless</session-type> <transaction-type>Container</transaction-type> </session> </enterprise-beans> <assembly-descriptor> <container-transaction> <method> <ejb-name>CustomersBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>DepartmentBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>SupplierBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>PartBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>RelationswholesaleBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>RelationsnameBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>RelationsthirdpartyBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>ContactsBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>ContactspbBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>DiscountsBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>OtherwsBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>MessagesBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>WholesalesBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Supports</trans-attribute> </container-transaction> <container-transaction> <method> <ejb-name>CompaniesBean</ejb-name> <method-name>*</method-name> </method> <trans-attribute>Required</trans-attribute> </container-transaction> </assembly-descriptor> </ejb-jar>