Hello Steven,
Friday, May 26, 2000, 4:52:00 AM, you wrote:
example:
Write folowing in yours Home interface or ( deployment orion ejb-jar.xml (full: not
included)
public static final String findByID_STORE_AND_ID_GRP_ORDER_BY_NAME_query= "full:SELECT
PL.Id_Pricelist, PL.Datestart, PL.Datestop, PL.Discount, PL.Id_Product, PL.Id_Status,
PL.Itemcomment, PL.Oldprice, PL.Price, PL.Quantity FROM PriceList PL, Product P WHERE
PL.ID_PRODUCT=P.ID_PRODUCT AND PL.ID_STATUS<>'0' AND PL.ID_STATUS IS NOT NULL AND
P.ID_STORE=$1 AND P.ID_GRP=$2 ORDER BY P.PRODUCTNAME"
public static final String findByID_INVITEM_query= "Id_Value in ( select Id_Value from
OrderedValues where Id_InvItem=$1 )";
SP> Dear EJB Community:
SP> Entity java beans pretty much represent a row of data
SP> in a database table.
SP> If one has:
SP> Table X Table Y
SP> -------------- --------------
SP> A B C D D E F G
SP> One commonly executes a SQL command like:
SP> select A from X join Y on X.D=Y.D where Y.G ="Bill Clinton"
SP> How would one do the equivalent task in an elegant
SP> "Enterprise Java Bean" like manner? That is, other
SP> than simply writing some member function that performs
SP> a JDBC select command like above.