Hi, Add -Xmx256m to your java runtime options. (This is done via the CATALINA_OPTS or JAVA_OPTS variable in tomcat, depending which tomcat version you have). If 256 is still not enough, keep increasing until you don't get the error anymore. For more documentation, look here: http://java.sun.com/docs/hotspot/VMOptions.html
Yoav Shapira Millennium ChemInformatics >-----Original Message----- >From: sangita watve [mailto:[EMAIL PROTECTED]] >Sent: Thursday, July 18, 2002 2:14 AM >To: [EMAIL PROTECTED] >Subject: Help please Urgent.. > >hI! > >I HAVE A QUERY WHICH RETURNS RECORDS IN LAKHS . >i am using xsql for this. > >i am getting error as > >Oracle XSQL Servlet Page Processor 9.0.1.1.0A (Production) >XSQL-017: Unexpected Error Occurred >java.lang.OutOfMemoryError > > >if i give max-rows in xsql it displays set of records specified >i want all the records to be displayed. >how do i rectify this. > >hoping for ur reply ASAP > >thanks >regards >sangita > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
