[JBoss-user] RE: Custom finders with JBoss and SQL Server ??

[Kevin Meldorf (NBK)]

I am using custom finders with MS SQL Server 2000 using the the Inet Opta

jdbc driver. For a custom finder with cmp you just need to include the finder in

your home stub and then define it in your jaws file:

 

Here's an example:

 

home stub:

 

 // more finders
   Enumeration findByPoItemNumber (String poItemNumber)
   throws RemoteException, FinderException;

 

jaws snippet:

 

<entity>
         <ejb-name>OrderItemBean</ejb-name>
         <table-name>ORDER_ITEM</table-name>
      <cmp-field>
         <field-name>orderItemId</field-name>
         <column-name>order_item_id</column-name>
      </cmp-field>
      <cmp-field>
         <field-name>poId</field-name>
         <column-name>po_id</column-name>
      </cmp-field>
      <cmp-field>
         <field-name>poItemNumber</field-name>
         <column-name>po_item_number</column-name>
      </cmp-field>
      <cmp-field>
         <field-name>quantity</field-name>
         <column-name>quantity</column-name>
      </cmp-field>
      <cmp-field>
         <field-name>description</field-name>
         <column-name>description</column-name>
      </cmp-field>
      <cmp-field>
         <field-name>unitPrice</field-name>
         <column-name>unit_price</column-name>
      </cmp-field>
      <finder>
         <name>findByPoItemNumber</name>
         <query>po_item_number = {0}</query>
         <order/>
      </finder>
      </entity>

 

 

 

Kevin Meldorf
Systems Analyst
WorldTravel BTI
400 Skokie Blvd
Northbrook, IL 60062
Phone: (847) 480-8340
[EMAIL PROTECTED]