Caused by: com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Out of memory (Needed 8385840 bytes)
at com.jfinal.plugin.activerecord.DbPro.doPaginate(DbPro.java:509)
at com.jfinal.plugin.activerecord.DbPro.paginate(DbPro.java:1253)
at com.jfinal.plugin.activerecord.Db.paginate(Db.java:656)
at com.ofsoft.cms.front.template.directive.HouseDirective.onRender(HouseDirective.java:76)
at com.ofsoft.cms.front.template.freemarker.TagBase.execute(TagBase.java:36)
at freemarker.core.Environment.visit(Environment.java:333)
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:100)
at freemarker.core.Environment.visit(Environment.java:257)
at freemarker.core.MixedContent.accept(MixedContent.java:57)
at freemarker.core.Environment.visit(Environment.java:257)
at freemarker.core.Environment.process(Environment.java:235)
at freemarker.template.Template.process(Template.java:262)
at com.jfinal.render.FreeMarkerRender.render(FreeMarkerRender.java:158)
... 30 more
Caused by: java.sql.SQLException: Out of memory (Needed 8385840 bytes)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2118)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1992)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3403)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:471)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3115)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2344)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2739)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227)
at com.jfinal.plugin.activerecord.DbPro.query(DbPro.java:80)
at com.jfinal.plugin.activerecord.DbPro.doPaginateByFullSql(DbPro.java:523)
at com.jfinal.plugin.activerecord.DbPro.doPaginate(DbPro.java:507)
... 42 more
Out of memory
注意在 sql 语句中用好 where 子句,限定数据量的大小,还要注意 select 中一般不要用 "select *" , 而是用到多少字段就 select 什么字段