Shiva this is currently not an option with Castor to limit the number of columns to be returned. As Castor is (mainly) an object relational mapping tool (data binding), even when using a CALL SQL statement, you will have to return all the columns as specified in your mapping (and in the correct sequence as well).
There's, of course, nothing that prevents you from specifying that certain fields are 'transient' or 'read-only', thus instructing Castor JDO to not include these fields in the SQL generated internally. I hope this helps. Werner Shiva P. Kodityala wrote: > Thank you, Ralf. > > In this case, I may do it. No issue. The problem is when you have so many > fields in a table and you just want a few of them. Is there any other way to > do it? Or shall I use plain jdbc? Performance is important when you are > dealing with huge number of rows. > > > > > > > -----Original Message----- > From: Ralf Joachim [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 16, 2005 1:31 PM > To: [email protected] > Subject: Re: [castor-user] Select Query > > > Hi Shiva, > > why not only returning 'p' which holds the properties 'a', 'b' and 'd'. > Your OQL for this should be: > > SELECT p FROM com.scif.test.Table1 p WHERE p.a=$1 > > Having said that castor's OQL not supports to return multiple values at > the moment. > > Regards > Ralf > > > Shiva P. Kodityala schrieb: > > >>"SELECT p.a , p.b , p.d FROM com.scif.test.Table1 p WHERE a=$1" >> >>Is there anything wrong with the query? >> >>Getting error: >>org.exolab.castor.jdo.oql.OQLSyntaxException: An incorrect token type was >>found >>near , (found COMMA, but expected KEYWORD_FROM) >> >>Can I not select more than one value? Is there any other way to doit? >> >>Thanks >> >>------------------------------------------------- >>If you wish to unsubscribe from this list, please >>send an empty message to the following address: >> >>[EMAIL PROTECTED] >>------------------------------------------------- >> >> >> > > > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > > ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
