One of my EJB requires two columns as the primary key. So I created a custom class with the two fields and use DVC to populate it as two columns in the database table. Anyway my finders require comparison to one of the field in the DVC class, so what is the syntax for that in jboss-ql?
<dependent-value-classes>
<dependent-value-class>
<description>BidKey</description>
<class>AuctionWeb.Bids.BidKey</class>
<property>
<property-name>orderId</property-name>
<column-name>OrderId</column-name>
</property>
<property>
<property-name>companyId</property-name>
<column-name>CompanyId</column-name>
</property>
</dependent-value-class>
</dependent-value-classes>
<entity>
<ejb-name>BidEJB</ejb-name>
<table-name>Bid</table-name>
<cmp-field>
<field-name>bidKey</field-name>
<property>
<property-name>orderId</property-name>
<column-name>OrderId</column-name>
</property>
<property>
<property-name>companyId</property-name>
<column-name>CompanyId</column-name>
</property>
<not-null/>
</cmp-field>
<cmp-field>
<field-name>price</field-name>
<column-name>Price</column-name>
</cmp-field>
<cmp-field>
<field-name>bidTime</field-name>
<column-name>BidTime</column-name>
</cmp-field>
<cmp-field>
<field-name>comments</field-name>
<column-name>Comments</column-name>
</cmp-field>
<query>
<query-method>
<method-name>findByCompany</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<jboss-ql>
<![CDATA[
SELECT OBJECT(bd)
FROM Bid bd
WHERE bd.bidKey.companyId = ?1
]]>
</jboss-ql>
</query>
<query>
<query-method>
<method-name>findByOrder</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<jboss-ql>
<![CDATA[
SELECT OBJECT(bd)
FROM Bid bd
WHERE bd.bidKey.orderId = ?1
]]>
</jboss-ql>
</query>
</entity>