That sounds like an interesting solution. I'll try that. Thanks. -Ara-
-----Original Message----- From: Thierry Hanot [mailto:[EMAIL PROTECTED] Sent: Friday, December 26, 2003 7:20 AM To: 'OJB Users List' Subject: RE: Newbie OQL select question - can I selectively retrieve fields? May be you could try to split the mapping of the table on 2 objects One containing the names and the id , and the other one the id and the data . And you 'll load the second class only when you need the data. B.R Thierry -----Original Message----- From: Ara Juljulian [mailto:[EMAIL PROTECTED] Sent: Friday, December 26, 2003 4:14 PM To: [EMAIL PROTECTED] Subject: Newbie OQL select question - can I selectively retrieve fields? Is it possible to retrieve only certain fields of a table through OJB OQL? Something similar to the SQL: select id, video_id from VIDEO_DATA where id=5. Doing things like select id, videoId from " + VideoData.class.getName() + " where id = " + videoDataId doesn't seem to work. It continues retrieving the entire table row. What I'm trying to do is avoid loading a huge BLOB unless absolutely necessary. I know I could re-design the application to move the BLOB to its own table or something like that, but I don't have that option at this point. Thanks a lot, -Ara- --------------------------------------------------------------------- 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]