> Hi all, > > I'm running a SQL statement on a MySQL database that generates a report in > an HTML browser. As long as the rows or columns returned are low in > number (ie: less than 3000), the servlet operates fine. But once the > database contains more than 3000 records, the browser displays a > StackOverflow:java.lang.OutOfMemory error and generates a log that looks > like: > > 10/10 07:36.38: ----------------------------------------------- > Exception Message: Error during query: Unexpected Exception: > java.sql.SQLException message given: General error: The table > 'SQL1a310c_0' is full > Details: > > Stack Trace: > > java.sql.SQLException: Error during query: Unexpected Exception: > java.sql.SQLException message given: General error: The table > 'SQL1a310c_0' is full > at org.gjt.mm.mysql.Connection.execSQL(Connection.java, Compiled Code) > at org.gjt.mm.mysql.Connection.execSQL(Connection.java, Compiled Code) > at org.gjt.mm.mysql.Statement.executeQuery(Statement.java, Compiled Code) > at > com.iteach.adminsrv.UserSessionReport.openReport(UserSessionReport.java, > Compiled Code) > at com.iteach.adminsrv.UserSessionReport.service(UserSessionReport.java, > Compiled Code) > at javax.servlet.http.HttpServlet.service(HttpServlet.java, Compiled Code) > at com.livesoftware.jrun.JRun.runServlet(JRun.java, Compiled Code) > at com.livesoftware.jrun.JRunGeneric.handleConnection(JRunGeneric.java, > Compiled Code) > at > com.livesoftware.jrun.service.proxy.JRunProxyServiceHandler.handleRequest( > JRunProxyServiceHandler.java, Compiled Code) > at > com.livesoftware.jrun.service.ThreadConfigHandler.run(ThreadConfigHandler. > java, Compiled Code) > > We've increased the JVM memory as suggested in the Jrun-interest archives, > but that only solves the problem temporarily. Another thousand records > and the servlet crashes again. It's not the database, since the SQL > statement runs fine from the Command Line, and only crashes when displayed > in the browser. > > Any ideas? > > Thanks, Kat Luna > Java Developer, bluespark > [EMAIL PROTECTED] ------------------------------------------------------------------------------ Archives: http://www.egroups.com/group/jrun-interest/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
