Hi again, > <snip> > > when i do this i get a class cast exception and when i check > to see if the > result.next() object is an instance of Person it says false.
please see: http://jakarta.apache.org/ojb/apidocs/org/apache/ojb/broker/PersistenceBroke r.html#getReportQueryIteratorByQuery(org.apache.ojb.broker.query.Query) The ReportQuery Iterator iterates Object[] calling the .next() method. The Elements returned come from a SELECT ... WHERE sqlStatement. It *does not* produce fully materialized persistent entities. > However the > iterator contains the proper amount of objects from the > database that have > the last name Smith. Where did I go wrong and why is it not > casting to the > Person object from the generic object. Followin is the exception: > > StandardWrapperValve[TestServlet]: Servlet.service() for > servlet TestServlet > threw exception > java.lang.ClassCastException: [Ljava.lang.Object; > at TestServlet.writeReportTable(TestServlet.java:149) > at TestServlet.doGet(TestServlet.java:93) > 39 more lines. These are all that matter.... > > Brandon Goodin > Phase Web and Multimedia > P (406) 862-2245 > F (406) 862-0354 > [EMAIL PROTECTED] > http://www.phase.ws > > > > -----Original Message----- > > From: Jakob Braeuchi [mailto:[EMAIL PROTECTED]] > > Sent: Monday, September 02, 2002 12:24 PM > > To: OJB Users List > > Subject: Re: SELECT statements and OJB > > > > > > 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]> > > > > > > > -- > 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]>
