hi brandon, ojb does not support partial loading of business objects. if you only need ID, FIRSTNAME, LASTNAME you can either use a ReportQuery, or you define your special ListPerson class.
hth jakob ----- Original Message ----- From: "Phase Web and Multimedia" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Monday, September 02, 2002 7:23 AM Subject: SELECT statements and OJB > I am extremely new to OJB. But something I was wondering regarding using the > PB API is whether or not you can select the particular field (attribute) you > want returned. For example, i have a sql statement like such SELECT ID, > FIRSTNAME, LASTNAME FROM PEOPLE WHERE ID=2. The PEOPLE table actually > contains the following fields: ID, FIRSTNAME, LASTNAME, ADDRESS, CITY, > STATE, ZIP, NOTES. In OJB PB it seems that all i can do is the equivalent of > SELECT * FROM PEOPLE WHERE... I don't want to select all (*) the fields > everytime. In the afformentioned sql statement i want to just produce a list > of People objects that have only the id, firstname and lastname variables > populated. Am i missing something or is this just not possible apart from > using a sql statement call from the PB API's QuerBySQL (if that would even > work cuz i haven't tested it). If i can't be selective about the data that > populates my People object then I will produce a lot of unecessary data > collection and population from the database to my objects. Especially if the > NOTES field can contain 250k of data (an exaggeration of course but the > point is there). The thing that attracted me to OJB was how easy it is to > code to a database with OO patterns. I hope the solution isn't something > that requires me to write some kind of extra class each time i want to limit > what is populated in my People class or require me to create a whole new > class to handle just the listing of the basic people info. > > Thanks, > Brandon Goodin > Phase Web and Multimedia > P (406) 862-2245 > F (406) 862-0354 > [EMAIL PROTECTED] > http://www.phase.ws > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
