Another thing that can be done with OJB is to create multiple Object mappings to the same row. For example, I store web page content in a database and like you said, it would be slow to pull down all that clob content.
PageHeader[6 cols pk, header fields] PageContent[2 cols pk, clob fields] PageHeader 1:1 PageContent set as a proxy reference Or PageHeader[5 cols] (pageHeader.getContent()->PageContent) PageContent[10 cols where PageHeader (PageContent)] Both map to the same table, but each selects different data and use the tbl_page's primary key. -Jacob | -----Original Message----- | From: Ron Gallagher [mailto:[EMAIL PROTECTED] | Sent: Wednesday, April 02, 2003 10:31 AM | To: [EMAIL PROTECTED] | Subject: Re: select column criteria | | Cory -- | | Check out org.apache.ojb.broker.query.ReportQueryByCriteria | | Ron Gallagher | Atlanta, GA | [EMAIL PROTECTED] | | > | > From: "Cory L Hubert" <[EMAIL PROTECTED]> | > Date: 2003/04/02 Wed AM 10:30:35 EST | > To: "OJB Users List" <[EMAIL PROTECTED]> | > Subject: select column criteria | > | > | > Hey I am trying to limit the columns returned in a select query. | > | > Instead of doing a "select * from table" I'd like to do a "select id | from | > table" the reason is that the table is HUGE. And returning all the | rows | > would probably kill the VM. | > | > Anyone know how? | > | > | > --------------------------------------------------------------------- | > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
