Hi! I just did a QueryBySQL and after a little work I got to the following conclusion.
All non-primary-key fields MUST be returned by the query. Primay-key fields may be returned but it not a requirerment. I guess that it is a design-choice to force the developer to use as complete objects as possible. You should not get objects where most fields are null unless they are that in the database. Regards Roland Carlsson ----- Original Message ----- From: "Sng Wee Jim" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 28, 2003 5:37 PM Subject: QueryBySQL for ojb rc4 > > Hi, > > > > Anyone encountered problem with using the query type: QueryBySQL? > > > > I am doing something like > > QueryBySQL query1 = QueryFactory.newQuery(java.lang.Class, sql) ; > > Iterator itr = broker.getIteratorByQuery(query1); > > > > however the while iterating through the resultset, the object returned > > by the iterator are all null. > > > > I tried the same query with > > Collection clt = broker.getCollectionByQuery(query1); > > but the size of the return collection is zero. > > > > The resultset of the SQL is not empty. (I ran the SQL in MySQL). > > Is it a bug, or do I need to set some properties? > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]