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] -------------------------------------------------
