Neither is LIMIT supported by standard SQL, so it would reduce portability to use it in the generated SQL as well.
/Fredrik > You could either edit the orion-ejb-jar.xml. And change the generated > SQL, but this will be overwritten next time orion is started. Another > way is to specify a finder query in your EJBHome inteface like this: > > String findByRecipient_query = "Message.recipient = $1"; > > Collection findByRecipient(String recipient) > throws RemoteException, FinderException; > > And Orion will generate a SQLQuery for you. Here you can use the > 'LIMIT' attribute. Be aware that this way is Orion specific and will > reduce the portability of your code. > > As for the EJB2.0 spec and the EJBQL does not support the 'LIMIT' > attribute as far as I know. > > /Linus > > On Tuesday, February 12, 2002, at 01:05 PM, Toni Menzel wrote: > >> Hi all, >> >> Is there possibility to set a maximum row count for a resultset ? >> Something general for the SQL Attribure "LIMIT" ?! >> >> Thanks in advance, Toni >> >> -----Ursprüngliche Nachricht----- >> Von: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED]] Im Auftrag von prasanth >> sb Gesendet: Sonntag, 10. Februar 2002 12:16 >> An: Orion-Interest >> Betreff: Re: url.openConnection() doesn't allow to pass objects or >> attributes >> >> I used doPost only but still it doesn't. >> >> >>> From: "Kesav Kumar" <[EMAIL PROTECTED]> >>> Reply-To: Orion-Interest <[EMAIL PROTECTED]> >>> To: Orion-Interest <[EMAIL PROTECTED]> >>> Subject: Re: url.openConnection() doesn't allow to pass objects or >>> attributes >>> Date: Sun, 3 Feb 2002 08:23:09 -0800 >>> >>> I just noticed one more thing with your servlet. It seems that you >>> are using doGet method in your servlet. If you do a post request >>> through >> URL >>> you need to write doPost method in your servlet. >>> >>> -kesav kumar >>> [EMAIL PROTECTED] >>> >>> ----- Original Message ----- >>> From: "prasanth sb" <[EMAIL PROTECTED]> >>> To: "Orion-Interest" <[EMAIL PROTECTED]> >>> Sent: Sunday, February 03, 2002 2:51 AM >>> Subject: Re: url.openConnection() doesn't allow to pass objects or >>> attributes >>> >>> >>>> I set the doOuptut parameters ,but still in orion it is not working. >>>> Can you please help me in this? >>>> >>>> >>>> >>>>> From: "Kesav Kumar" <[EMAIL PROTECTED]> >>>>> Reply-To: Orion-Interest <[EMAIL PROTECTED]> >>>>> To: Orion-Interest <[EMAIL PROTECTED]> >>>>> Subject: Re: url.openConnection() doesn't allow to pass objects or >>>>> attributes >>>>> Date: Sat, 26 Jan 2002 08:12:31 -0800 >>>>> >>>>> For Posting data from through URLs you have to set doOutput to >> true. >>>>> con.setDoOutput(true); >>>>> con.setDoInput(true); >>>>> >>>>> Once you set the above you can get the OutputStream associated with >>>>> connection and send parameters. >>>>> >>>>> For more info read the article at JavaWorld >>>>> http://www.javaworld.com/javaworld/javatips/jw-javatip34.html >>>>> >>>>> -kesav kumar >>>>> >>>>> ----- Original Message ----- >>>>> From: "prasanth sb" <[EMAIL PROTECTED]> >>>>> To: "Orion-Interest" <[EMAIL PROTECTED]> >>>>> Sent: Saturday, January 26, 2002 1:27 AM >>>>> Subject: url.openConnection() doesn't allow to pass objects or >>> attributes >>>>> >>>>> >>>>> Hello dear friends, >>>>> Please help me with a strange problem happening >> with >>>>> orion. I am calling url.openConnection() to a servlet page.When I >> call >>>>> this, >>>>> the call goes to doGet method of the servlet. But it has to go to >> the >>>>> doPost >>>>> method. Second problem is I am able to read the values from the >> callee >>>>> servlet. But I am not able to pass the values to the callee >> servlet.I >>> am >>>>> trying to pass objects in a stream.I have seen this problem >> reported in >>> the >>>>> mailing list. Can anyone help me in this? >>>>> >>>>> Please find the sample code, >>>>> >>>>> Caller Servlet >>>>> >>>>> URLConncetion con >> =url.openConnection("http://ipname:port/Servlet1"); >>>>> ObjectOutputStream os = new >> ObjectOutputStream(con.getOutputStream()); >>>>> os.writeObject("string object"); >>>>> >>>>> Callee servlet(Servlet1.java) >>>>> >>>>> >>>>> public void doGet(HttpServletRequest req,HttpServletResponse res) { >>>>> ObjectInputStream ois = new >> ObjectInputStream(req.getInputStream()); >>>>> ois.readObject();//This line , it prints null.It wont print the >> string >>>>> //"string object".But if I return values from the servlet1, then >> Caller >>>>> servlet is able to read. >>>>> >>>>> Can some one throw some light on this. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> _________________________________________________________________ >>>>> Join the world's largest e-mail service with MSN Hotmail. >>>>> http://www.hotmail.com >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>> _________________________________________________________________ >>>> MSN Photos is the easiest way to share and print your photos: >>>> http://photos.msn.com/support/worldwide.aspx >>>> >>>> >>>> >>> >> >> >> _________________________________________________________________ Join >> the world’s largest e-mail service with MSN Hotmail. >> http://www.hotmail.com