try: "... AND rownum <= 20"
If you are ever unsure how to construct the xml files try the BeanDeployer tool included with jonas, simply un-jar the file it saves then examine META-INF/jonas-ejb-jar.xml. java.sql.Statement has a setMaxRows() that may be of use if you use bmp or session beans, alternatively you could have finder that returns all rows then just iterate through the first 20. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 28, 2001 10:53 PM Subject: jdbc-where-clause > I would like to limit the number of result set to 20 by putting "... AND rownum <= 20" but at compilation, it gives me > > jonas-ejb-jar.xml:87:75: Invalid XML: The content of elements must consist of well-formed character data or markup. > > could someone suggest how to fix this? or suggest other alternatives to limit the size of result set > > Thank you very much. > > > __________________________________________________________________ > Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ > > Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ > > ---- > To unsubscribe, send email to [EMAIL PROTECTED] and > include in the body of the message "unsubscribe jonas-users". > For general help, send email to [EMAIL PROTECTED] and > include in the body of the message "help". > ---- To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "unsubscribe jonas-users". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
